(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