Essendon Electronics: Regal or Monarch? Assignment Help

Click here to order this assignment @Essaywriting.us.No Plagiarism.Written from scratch by professional writers.

· BUACC 2613

· Semester 2, 2018

· Group 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:

  1. Calculation of the profitability of the Regal and Monarch models, using ABC.
  1. 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.

  1. The benefits, costs and limitations of adopting ABC.