1 Chapter 4: Applying Excel 3 Enter a formula into each of the cells marked with a ? below 4 Review Problem: Activity-Based Costing 6 Data 8 Annual sales in units 9 Direct materials per unit 10 Direct labor-hours per unit Deluxe 2,000 $25 Tourist 10,000 $17 4 12 Direct labor rate $12 per DLH Total 16 Activities and Activity Measures 17 Labor related direct labor-hours) 18 Machine setups (setups) 19 Production orders (orders) 20 General factory (machine-hours) Estimated Overhead Cost $ 80,000 150,000 70,000 250,000 Expected Activity Deluxe Tourist ? 3,000 2,000 100 300 12,000 28,000 23 Compute the predetermined overhead rate 24 Estimated total manufacturing overhead (a) 25 Estimated total amount of the allocation base (b) 26 Predetermined over head rate (a) = (b) ? DLHs ? per DLH 28 Compute the manufacturing overhead applied 29 Direct labor-hours per unit (a) 30 Predetermined over head rate (b) 31 Manufacturing overhead applied per unit (a) (b) Deluxe ? DLHS ? per DLH Tourist ? DLHS ? per DLH Deluxe Tourist 33 Compute traditional unit product costs 34 Direct materials 35 Direct labor 36 Manufacturing overhead applied 37 Traditonal unit product cost ? 2 27 ? 39 Compute activity rates 0 Estimated Overhead Cost 21 Activities 2 Labor related 23 Machine setups 14 Production orders 5 General factory Total Expected Activity ? DLHS 7 setups ? orders ? MHS Activity Rate ? per DLH ? per setup ? per order ? per MH ? 7 Compute the ABC overhead cost per unit Activity Rate Deluxe Expected Activity Amount Tourist Expected Activity Amount 29 Activities 50 Labor related 51 Machine setups 52 Production orders 53 General factory 54 Total overhead cost assigned (a) 55 Number of units produced (b) 56 ABC overhead cost per unit (a) (b) ? ? ? ? ? ? ? Deluxe Tourist 58 Compute the ABC unit product costs 59 Direct materials 50 Direct labor 51 ABC overhead cost per unit (see above) 52 ABC unit product cost Requirement 1: (a). Which of the following statements are true concerning the predetermined 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. Any boxes left with a question mark will be automatically graded as incorrect.) O The predetermined overhead rate increased because the total estimated overhead cost increased. The predetermined overhead rate decreased because the total direct labor-hours dropped. The predetermined overhead rate decreases because the total estimated overhead cost increased. The predetermined overhead rate increased because the total direct labor-hours dropped. (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. Any boxes left with a question mark will be automatically graded as incorrect.) 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. U The ABC unit product cost of the Tourist model increases when the Deluxe model's direct labor- hour requirement decreases, but by not by as much as the traditional unit product cost. U The traditional unit product cost of the Tourist model increases when the Deluxe model's direct labor-hour requirement decreases. -). Which of the following statements are true? (You may select more than one answer. Single ick the box with the question mark to produce a check mark for a correct answer and double ick the box with the question mark to empty the box for a wrong answer. Any boxes left with question mark will be automatically graded as incorrect.) The traditional unit product costs for the two models have been changed by the change in production orders because traditional overhead allocations based on direct labor-hours ignore other cost drivers such as production orders. U The traditional unit product costs for the two models are unchanged by the change in production orders because traditional overhead allocations based on direct labor-hours ignore other cost drivers such as production orders. U The traditional unit product costs for the two models are unchanged by the change in production orders because neither the total estimated overhead cost nor the total direct labor-hours were affected. (d). Which of the following statements are true concerning the effects of the change in production orders on the ABC unit product costs? (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. Any boxes left with a question mark will be automatically graded as incorrect.) The ABC unit product cost of the Deluxe model has increased and the ABC unit product cost of the Tourist model has decreased because a lower proportion of the production orders are now attributable to the Deluxe model. U The ABC unit product cost of the Deluxe model has increased and the ABC unit product cost of the Tourist model has decreased because a higher proportion of the production orders are now attributable to the Deluxe model. o The ABC unit product cost of the Deluxe model has decreased and the ABC unit product cost of the Tourist model has increased because a lower proportion of the production orders are now attributable to the Deluxe model. U The ABC unit product cost of the Deluxe model has decreased and the ABC unit product cost of the Tourist model has increased because a higher proportion of the production orders are now attributable to the Deluxe model