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.