294 ? Assignment #5
Question 1 (11 marks)
Rigot Ltd. manufactures landscaping equipment known for durability. The unionized workforce
renews its contract every five years, with the most recent agreement signed last year which
provided for a 2% salary increase per year. The following is the budget for 2012 based on the
production of 20,000 units.
Direct Materials
Direct Labor
Variable Overhead
Fixed Overhead
Total
Average Cost per unit
Budget
$ 3,080,000
2,500,000
700,000
900,000
$ 7,180,000
$ 359
Information available for standards utilized for 2012:
Direct materials
$11 per KG
Direct labor
$25 per hour
The Year 2012 in Review:
During 2012 the actual production was 20,000 units. At the start of 2012 the senior
management decided to buy materials from a new supplier for $15 per KG. Management was
excited when they found out that the actual labor hours per unit was three less than the
standard. In addition, since overhead is driven primarily by labor the variable overhead
decreased by $180,000 and the fixed overhead was reduced by $60,000.
Actual material used per unit was 18 KG and the actual average labor rate was $30 per hour.
The company implemented a just-in-time inventory system in 2011.
REQUIRED:
a) Calculate the material price variance. (2 marks)
b) Calculate the material quantity variance. (2 marks)
c) Calculate the labor rate variance. (2 marks)
d) Calculate the labor efficiency variance. (2 marks)
e) Analyze the 2012 results- specifically, the variances. Do you support the decision to
change suppliers? Explain with supporting calculations. (3 marks)
1
Question 2 (18 marks)
Cosmo Corp. manufactures two electronic parts: K100 and K200. The company operates in a
very competitive industry and their products compete directly with several other products. The
CEO has played an active role in pricing the products and in decisions to add or drop product
lines. The CEO is quite concerned with the decreasing sales of the K100 and is convinced
that action must be taken to remedy the problem.
Sales of K100 dropped significantly in 2012 while the sales of the K200 have increased. At the
end of 2011, the marketing department persuaded the CEO to pursue an advertising campaign
to raise the sales of the K100. The subsequent 1,000 unit annual drop in sales of K100
(compared to 2011) has left the CEO furious. The production manager has assured the CEO
that the quality of the product has remained constant.
The CEO is considering:
1) Firing the sales staff and sales/administrative manager of K100
2) Dropping the K100
Total Units (produced/sold)
Manufacturing Overhead Costs
2012
22,000
$3,860,000
2011
15,000
$3,300,000
Product Information for 2012: K200
Sales Price/Unit
$ 210
Unit Sales
10,000 units
K100
$ 260
12,000 units
Direct materials per unit
Direct labor per unit
$29.17
$25.00
$80.00
$20.00
Other information:
The variable overhead cost per unit for the K100 and K200 is the same. Each product has a
sales/administrative manager who is paid $72,000. The K100 leases factory equipment at
$50,000 per annum while the K200 uses fully amortized/depreciated equipment that has a
market value of $93,000. The company is not operating at full capacity.
REQUIRED:
a. Prepare a segmented income statement for 2012 to “evaluate” the products. (10 marks)
b. Should Cosmo drop the K100 product? (2 marks)
c. Respond to the CEO’s intention to fire personnel. Should they be fired? Provide reasons
for why they should or should not be fired? Based on the segmented income statement,
what recommendations do you have for the company re: the two products? (2 marks)
d. The K300, a new product, is being considered with expected sales of 5,000 units at $135
each for the first year. K300’s sales growth per annum for the next three years is projected
at 3%. Direct material, direct labor and VOH total $120 per unit. The K300 would require a
specially trained manager at a cost of $80,000 per year. Should the company add the
K300? Provide calculations with explanations for your analysis/conclusion where
appropriate. (4 marks)
2
Question 3 (22 marks)
The YAK Ventures specializes in producing and distributing organic fudge throughout Canada.
The company operates three autonomous and decentralized divisions: Western, Central and
Eastern. The company’s cost of capital is only 3% and each division is expected to earn a
return of at least this amount.
Sales data for the year ended 2012 for the divisions:
Sales Volume
Sales Price
Central
405,000
$8.08
Western
325,000
$7.80
Eastern
395,000
$8.20
Western
$4,125,000
Eastern
$3,912,000
Average Invested assets for each division:
Invested Assets
Central
$4,256,000
Total Fixed costs for the Company:
Amortization & Lease
Advertising
Salaries
Legal and Audit
Other General and Administrative
Total
$633,000
$546,000
$1,283,000
$120,000
$135,000
$2,717,000
•
The variable cost to produce the fudge for Western and Eastern was $3 per bottle.
Central’s variable cost to produce the fudge was 1/3 higher than the other divisions’.
•
•
All divisions incur $1.50 per unit to package the bottles after they are produced.
The divisions hire sales representatives to sell the product within their territory. The
commissions are 10% of sales except for Eastern whose representatives get 15%.
•
Amortization expense was $155,000 $135,000 and $128,000 for Central, Western and
Eastern, respectively. This amortization calculation was based on units of production.
•
Head office leases equipment for the divisions. The Central and Western division each had
lease expense equal to ½ of the $70,000 lease expense for the Eastern Division. The
remaining amortization expense was for a computer system used by all divisions that is
located at the Head office (Vancouver).
•
Advertising costs for divisional radio and newspaper ad campaigns directed by the divisions
were:
Central
Western
Eastern
$ 101,250
$ 81,250
$ 98,750
•
There was also a national T.V. campaign to promote YAK for which the advertising agency
directly billed YAK. $240,000 was billed by a national advertising agency which worked
equally and separately on all three divisions.
•
Central, Western and Eastern had $155,000, $195,000 and $225,000 in divisional office
salaries, respectively. In addition, each division also has a controller hired by Head
Office at $105,000 per year. The CEO was paid $200,000 and managed the sales forces
for Central and Western Divisions. Eastern had its own sales manager hired at $150,000
per year by the Head Office. Remaining salaried employees worked at the Head Office.
3
•
The auditors are appointed by the company’s board of directors. It is not possible to
specifically differentiate what audit expenses were incurred for each of the divisions, except
for $45,000 that was billed for the total of 60 hours which were equally spent auditing at
each division.
•
The company’s invested asset base at the end of the year was $12,651,048, a 6% increase
over the previous year.
Required:
a) The Manager of Central has been bragging that he has the highest sales level and
therefore he expects to achieve the highest bonus this year. Prepare segmented
information to show the performance of the divisions and the performance of the managers.
(14 marks)
b) Based on your analysis above, calculate the performance of the divisions using return on
investment (ROI). Which division outperformed the other divisions this year? (3 marks)
c) Calculate the Residual Income for Western. (1 mark)
d) Holly, the manager of the Western has been contacted by a soy sauce manufacture to sell
organic soy sauce under a Yak-Soy brand name. The sales manager for Western has
calculated that this will increase income by $150,000 for the division. An analysis of the
soy fermenting process indicates that they will need to spend $75,000 on the necessary
equipment.
Would Holly be likely to accept this offer from the Soy manufacturer? (2 marks)
Identify and thoughtfully explain two other issues that the manager should consider before
making this decision. (2 marks)
ONLY SUBMIT THE PAGES THAT START WITH “NAME” (pages 5?10).
4
294 – ASSIGNMENT #5
NAME (Last, First): _______________________________
Student number:_________________
Q1 Grade _______ Q2 Grade _______ Q3 Grade _______ Total = _______ [out of 51]
Question 1 (11 marks)
a) Calculate the material price variance.
b)
Calculate the material quantity variance.
c)
Calculate the labor rate variance.
d)
Calculate the labor efficiency variance.
e)
Analyze the 2012 results- specifically, the variances. Do you support the decision to
change suppliers? Explain with supporting calculations.
5
Question 2 (18 marks)
a) Prepare a segmented income statement for 2012.:
K200
b) Should Cosmo drop the K100 product?
6
K100
Total
c) Provide reasons for why they should or should not be fired? Based on the segmented
income statement, what recommendations do you have for the company re: the two
products?
d) Should the company add the K300? Provide calculations with explanations where
appropriate.
7
Question 3 (22 marks)
a) Prepare segmented information to show the performance of the divisions and the
performance of the managers.
TOTAL
Central
Western
Eastern
8
b) Based on your analysis above, calculate the performance of the divisions using return on
investment. Which division outperformed the other divisions this year?
ROI (Central):
ROI (Western):
ROI (Eastern):
c) Calculate the Residual Income (EVA) for Western.
d) Would Holly be likely to accept this offer from the Soy manufacturer? Show your
calculations and provided explanations where appropriate. Additionally, identify and
thoughtfully explain two other issues (qualitative) that the manager should consider before
making this decision.
9
Qualitative #1
Qualitative #2
10
