Reference no: EM132132378
Assignment - Essendon Electronics: Regal or Monarch?
Essendon Electronics, a division of Elgin Ltd, manufactures a diverse range of electrical products. Its range includes two LCD screen television models: the Monarch, which has been produced since 20XX and sells for $900, and the Regal, a newer model introduced in early 20X0, that sells for $1140. Based on the following income statement for the year ended 30 November 20X1, senior management at Elgin Ltd have decided to concentrate Essendon Electronics' marketing resources on the Regal model and to begin to phase out the Monarch model.
Essendon Electronics Income Statement for the financial year ended 30 November 20X1
|
|
Monarch
|
Regal
|
Total
|
Revenues
|
$19 800 000
|
$4 560 000
|
$24 360 000
|
Cost of goods sold
|
1 2540 000
|
3 192 000
|
15 732 000
|
Gross margin
|
7 260 000
|
1 368 000
|
8 628 000
|
Selling and administrative expense
|
5 830 000
|
978 000
|
6 808 000
|
Operating profit
|
$1 430 000
|
$390 000
|
$1 820 000
|
Units produced and sold
|
22 000
|
4 000
|
|
Net income per unit sold
|
$65.00
|
$97.50
|
|
Unit costs for Monarch and Regal are as follows:
|
Monarch
|
Regal
|
Direct materials
|
$208
|
$584
|
Direct manufacturing labour Monarch (1.5 hours x $12) Regal (3.5 hours x $12)
|
18
|
48
|
Machine costs* Monarch (8 hours x $18) Regal (4 hours x $18)
|
144
|
72
|
Manufacturing overhead other than machine costs**
|
200
|
100
|
Total cost
|
$570
|
$798
|
*Machine costs include lease cost of the machine, repairs and maintenance. **Manufacturing overhead was allocated to products based on machine-hours at the rate of $25 per hour.
|
You have just joined Essendon Electronics as a graduate trainee accountant. You have reviewed the company's existing costing system. You have found that: dramatic changes had occurred within the business environment and the company's manufacturing process over the past 20 years. However, the company's costing system had remained the same since its inception 20 years ago. You believe Activity-based costing (ABC) and activity-based management could help in overcoming the deficiencies in the existing costing system. You have conducted detailed activity analysis, and one-on-one staff interviews. You have noticed that many employees are not happy with the idea of implementing ABC.
You have gathered the following information about the company's manufacturing overhead costs for the year ended 30 November 20X1.
|
Units of the cost-allocation base
|
Activity centre (cost-allocation base)
|
Total activity costs
|
Monarch
|
Regal
|
Total
|
Soldering (number of solder points)
|
$942 000
|
1 185 000
|
385 000
|
1 570 000
|
Shipments (number of shipments: batches)
|
860 000
|
16 200
|
3 800
|
20 000
|
Quality control (number of inspections)
|
1 240 000
|
56 200
|
21 300
|
77 500
|
Purchase orders (number of orders: batches)
|
950 400
|
80 100
|
109 980
|
190 080
|
Machine power (machine hours)
|
57 600
|
176 000
|
16 000
|
192 000
|
Machine set-ups (number of set-ups: batches)
|
750 000
|
16 000
|
14 000
|
30 000
|
Total manufacturing overhead
|
$4 800 000
|
|
|
|
You have discussed your analysis and shown the results to Tom Lockett, Essendon Electronics' divisional manager. Mr Lockett does not seem to be pleased. His comments are: "If you show headquarters this analysis, they are going to ask us to phase out the Regal line, which we have just introduced. This whole costing stuff has been a major problem for us. First Monarch was not profitable and now Regal.
'Looking at the ABC analysis, I see two problems. First, we do many more activities than the ones you have listed. If you had included all activities, maybe your conclusions would be different. Second, you used number of set-ups and number of inspections as cost-allocation bases. The numbers would be different, had you used set-up hours and inspection-hours instead. I know that measurement problems precluded you from using these other cost-allocation bases, but I believe you ought to make some adjustments to our current numbers to compensate for these issues. I know you can do better. We can't afford to phase out either product. "
You are aware that a sizable portion of the divisional manager's bonus is based on division revenues. Phasing out either product would adversely affect his bonus. After discussing the issue with Mr Lockett, you feel some pressure to do something about the results.
Required: Prepare a report for the senior management accountant at Essendon Electronics. Your report should include:
a. Calculation of the profitability of the Regal and Monarch models, using ABC.
b. A brief explanation regarding why these numbers differ from the profitability of the Regal and Monarch models calculated using Essendon Electronics' existing costing system.
c. Your response to Mr Lockett's comments and your recommendations on using ABC at Essendon Electronics.
d. The benefits, costs and limitations of adopting ABC.