a Which of the following statements are true concerning the

(a) Which of the following statements are true concerning the predetemined overhead rate when the direct labor-hour requirement for the Deluxe model dropped from 5 hours to 2 hours? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer.) The predetermined overhead rate decreases because the total estmated overhead cost The predetermined overhead rate decreased because the total direct labor-hours dropped The predetermined overhead rate increased because the total direct labor-hours dropped E] The predetermined overhead rate increased because the total estimated overhead cost increased. (b) Which of the following statements are true concerning the unit product costs for the Tourist model when the direct labor-hour requirement for the Deluxe model drops from 5 hours to 2 hours? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer.) Economically, the fact that the Deluxe model\'s direct labor-hour requirement changed should have little or no impact on the cost of the Tourist model The traditional unit product cost of the Tourist model ncreases when te Deue moder\'s direct 2 2 The ABC unit product cost of the Tourist model increases when the Delaxe model\'s direct labor- hour requirement decreases, but by not by as much as the traditional unit product cost Change the direct labor-hour requirement for the Deluxe model back to 5 hours in cell B10. Assume that the production orders change so that the Deluxe model Will have 200 orders in cell C19 and the Tourist model will have 300 orders in cell D19. The Data area should now look like this 1 Chapter 3: Applying Excel Enter a formula into each of the cels marked with a ? 6 Data Deluxe Tounist 8 Annual sales in units 9 Direct materials per unit 10 Direct labor-hours per unit 2.000 10,000 $25 $17 $12 per DLH 12 Direct labor rate 13 14 15 16 Activities and Activity Measures 17 Labor related (direct labor-hours) $ 80,000 10,000 40000 18 Machine selups (setups) 19 Production orders (orders) Cost Deluxe Touris Total 50,000 50.000 3,000 2.000 5000 0,000 200 300 500 250.000 12.000 28.000 40000 21 $550.000

Solution

Requirement 1 a) Option C is Correct Data Deluxe Tourist Annual sales in units 2000 10000 Direct materials per unit $25.00 $17.00 Direct labor-hours per unit 2 4 Direct labor rate $12.00 per DLH Estimated Overhead Expected Activity Activities and Activity Measures Cost Deluxe Tourist Total Labor related (direct labor-hours) $80,000.00 4000 40000 44000 Machine setups (setups) $150,000.00 3000 2000 5000 Production orders (orders) $70,000.00 200 300 500 General factory (machine-hours) $250,000.00 12000 28000 40000 $550,000.00 Compute the predetermined overhead rate Estimated total manufacturing overhead (a) $550,000.00 Estimated total amount of the allocation base (b) 44000 DLHs Dropped Predetermined overhead rate (a) ÷ (b $12.50 per DLH Increased b) Option C is correct Requirement 2 Original a) Deluxe Tourist Compute the manufacturing overhead applied Direct labor-hours per unit (a) 5 4 Predetermined overhead rate (b) $11.00 $11.00 Manufacturing overhead applied per unit (a) × (b) $55.00 $44.00 Compute traditional unit product costs Deluxe Tourist Direct materials $25.00 $17.00 Direct labours $60.00 $48.00 Manufacturing overhead applied $55.00 $44.00 Traditonal unit product cost $140.00 $109.00 After change Deluxe Tourist Compute the manufacturing overhead applied Direct labor-hours per unit (a) 2 4 Predetermined overhead rate (b) $12.50 $12.50 Manufacturing overhead applied per unit (a) × (b) $25.00 $50.00 Compute traditional unit product costs Deluxe Tourist Direct materials $25.00 $17.00 Direct labours $24.00 $48.00 Manufacturing overhead applied $25.00 $50.00 Traditonal unit product cost $74.00 $115.00 b) Compute activity rates Activities Estimated Overhead Cost Total Expected Activity Activity Rate Labor related $80,000.00 50000 DLHs $1.60 Per Dlh Machine setups $150,000.00 5000 Setups $30.00 per set up Production orders $70,000.00 500 Orders $140.00 per order General factory $250,000.00 40000 MH $6.25 per MH Compute the ABC overhead cost per unit Deluxe Tourist Activity Rate Expected Activity Amount Expected Activity Amount Labor related $1.60 10000 $16,000.00 40000 $64,000.00 Machine setups $30.00 3000 $90,000.00 2000 $60,000.00 Production orders $140.00 200 $28,000.00 300 $42,000.00 General factory $6.25 12000 $75,000.00 28000 $175,000.00 Total overhead cost assigned (a) $209,000.00 $341,000.00 Number of units produced (b) 2000 10000 ABC overhead cost per unit (a) ÷ (b) $104.50 $34.10 after change Compute activity rates Activities Estimated Overhead Cost Total Expected Activity Activity Rate Labor related $80,000.00 44000 DLHs $1.82 Per Dlh Machine setups $150,000.00 5000 Setups $30.00 per set up Production orders $70,000.00 500 Orders $140.00 per order General factory $250,000.00 40000 MH $6.25 per MH Compute the ABC overhead cost per unit Deluxe Tourist Activity Rate Expected Activity Amount Expected Activity Amount Labor related $1.82 4000 $7,272.73 40000 $72,727.27 Machine setups $30.00 3000 $90,000.00 2000 $60,000.00 Production orders $140.00 200 $28,000.00 300 $42,000.00 General factory $6.25 12000 $75,000.00 28000 $175,000.00 Total overhead cost assigned (a) $200,272.73 $349,727.27 Number of units produced (b) 2000 10000 ABC overhead cost per unit (a) ÷ (b) $100.14 $34.97