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. (6 Marks)

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. (10 marks)

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. (8 marks)

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. (6 marks)

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 LED-LCD model Smart-curved model Company's product costs and annual sales data are as follows: High-definition model Annual sales 30 000 1 500 15 000 (units) Product costs: Raw material $15.00 $37.50 $63.00 Direct labour $15.00 (0.5hour $30.00 (1 hour $30.00 (1 hour @ $30) @ $30) @ $30) Manufacturing $127.50 $255.00 $255.00 overhead * Total product $157.50 $322.50 $348.00 cost *Calculation of predetermined overhead rate: Manufacturing overhead budget: Depreciation, machinery Maintenance, machinery Depreciation, taxes and insurance for factory Engineering Purchasing, receiving and shipping Inspection and repair of defects Material handling Miscellaneous manufacturing overhead costs Total 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 $ 2 220 000 180 000 450 000 525 000 375 000 562 500 600 000 442 500 $ 5 355 000 Activity Depreciation , machinery Maintenance , machinery Engineering Inspection and repair of defects Purchasing, receiving and shipping Material handling Depreciation , taxes and insurance for factory Miscellaneous manufacturi ng overhead costs Activity driver High definition (HD) model 40% LED-LCD model 13% Smart curved model 47% Engineering hours 47% 6% 47% Number of material orders 47% 8% 45% Factory space usage 42% 15% 43% Machine time Required: 1. Calculate the budgeted prices for the three models, based on the traditional product costing system. (6 Marks) 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. (10 marks) 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. (8 marks) 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. (6 marks)