Buacc 2613 assignment - essendon electronics regal or


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

12,540,000

1,192,000

15,731,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)

18

 

Regal (3.5 hours x $12)

 

48

Machine costs*

 

 

Monarch (8 hours x $18)

144

 

Regal (4 hours x 18)

 

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.

Activity centre (cost-allocation base)

Units of the cost-allocation base

Total activity costs

Monarch

Regal

Total

Soldering (number of solder points)

 

$948,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.

e. 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.

Request for Solution File

Ask an Expert for Answer!!
Managerial Accounting: Buacc 2613 assignment - essendon electronics regal or
Reference No:- TGS02901183

Expected delivery within 24 Hours