Reference no: EM131719938

Question -

Browns Electronics Company is a manufacturer of small screen television models. The company produces three models called High definition (HD) televisions, LED-LCD televisions and Smart curved televisions. The company uses a job costing system with manufacturing overhead applied on the basis of direct labour hours. The system has been in place with not much change for the past 10 years.

Brown Electronics Company's product costs and annual sales data are as follows:

High-definition model		LED-LCD model		Smart-curved model
Annual sales (units)	30 000		1 500		15 000
Product costs:
Raw material	$15.00		$37.50		$63.00
Direct labour	$15.00 (0.5hour @ $30)		$30.00 (1 hour @ $30)		$30.00 (1 hour @ $30)
Manufacturing overhead *	$127.50		$255.00		$255.00
Total product cost	$157.50		$322.50		$348.00

*Calculation of predetermined overhead rate:

Manufacturing overhead budget: Depreciation, machinery	$ 2 220 000
Maintenance, machinery	180 000
Depreciation, taxes and insurance for factory	450 000
Engineering	525 000
Purchasing, receiving and shipping	375 000
Inspection and repair of defects	562 500
Material handling	600 000
Miscellaneous manufacturing overhead costs	442 500
Total	$ 5 355 000

Predetermined overhead rate:

Budgeted overhead = $ 5 355 000 = $255 per hour

Budgeted direct labour hours 21 000 hours

For the past 10 years, Brown Electronics Company's pricing formula has been to set each product's budgeted prices at 115 percent of its full product cost. Lately, however, the high-definition model has come under increasing price pressure from overseas competitors. As a result of this increased competition, the price on the High-definition model has been lowered to $175.00.

Brown Electronics Company's CEO recently asked the financial controller, 'Why can't we compete with these other companies? They are selling their high definition televisions for $165.00. That is only a few dollars more than our production cost. Are we really that inefficient?'

The financial controller responded by saying, 'I think this is owing to an outdated product costing system. As you may remember, I raised a red flag about our existing product costing system last year. In my opinion, our product costing system is distorting and misrepresenting our product costs. Let me run a few numbers to demonstrate what I mean.'

After getting the approval of the CEO, the financial controller compiled the basic data needed to implement an activity based costing system.

These data are displayed in the following table. The percentages given are the proportion of each activity driver consumed by each product line

Product lines
Activity	Activity driver	High definition (HD) model	LED-LCD model	Smart curved model
Depreciation, machinery Maintenance, machinery	Machine time	40%	13%	47%
Engineering Inspection and repair of defects	Engineering hours	47%	6%	47%
Purchasing, receiving and shipping Material handling	Number of material orders	47%	8%	45%
Depreciation, taxes and insurance for factory Miscellaneous manufacturing    overhead costs	Factory space usage	42%	15%	43%

Required:

1. Calculate the budgeted prices for the three models, based on the traditional product costing system.

2. Construct an excel spreadsheet showing new product costs for the three models, based on the new data collected by the financial controller. Round to the nearest cent.

3. Calculate a new budgeted price for the three products, based on the activity based costing system. Compare the new budgeted target price with the current actual selling price for the High-definition model.

4. Refer to the product costs developed in requirement 2 above. Prepare a table showing how Browns Electronics Company's traditional product costing system distorts the product costs of the three television models.