M27 Open recovered workbooks? Your recent changes were saved. Do you want to continue work xv fx A C D 3 Enter a formula into each of the cells marked with? Below 4 Review Problem: Aditivty-Based Costing Data 2 Annual Sales in units Direct Materials per unit 10 Direct labor-hours per unit 11 12 Direct labor rate 33 14 15 16 Activities and Activty Measures 17 Labor-Related (direct labor-hours) 18 Machine setups (setups) 19 Production orders (orders) 20 General factory (machine-hours) 21 22 23 Compute the predetermined overhead rote 24 Estimated total manufacturing overhead (a) Deluxe Tourist 2,000 10,000 $25 $17 2 4 512 Per DUH Estimated Overhead Cost Deluxe Tourist Total $80,000 4000 40000 $44,000 150000 3000 70000 100 2000 300 55,000 $400 250000 12000 28,000 $40,000 $550,000 $550,000 25 Estimated total amount of the allocation base (b) 2 26 Predetermined overhead rate (a)+(b) 17 27 28 Compute the manufacturing overhead applied Deluxe 29 Direct labor-hours per unit(a) ? DUES 2 DUHS per DUH Tourist DLH'S 30 Predetermined overhead rate (b) P per DUH 2 per DUH 31 Manufacturing overhead applied per unit (a)(b) 7 32 33 Compute traditional unit product costs Deluxe Tourist 34 Direct materials 7 P 35 Direct labor 2 12 36 Manufacturing overhead applied 2 2 12 7 37 Traditional unit product cost 38 39 Compute activity rates 40 41 Activites 42 Labor-Related 43 Machine setups 44 Production orders 45 General Factory 46 47 Compute the ABC overhead cost per unit 48 49 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) 57 58 Compute the ABC unit product cost 59 Direct Materials 60 Direct Labor 61 ABC overhead cost per unit (see above) 62 ABC unit product cost 63 Estimated Overhead Cost Total Expected Activity 7 DLH'S 2 Activity Rate per DUH P F setups 2 per setup 2 2 orders 7 per order 7 12 MH'S ? per MH Delue Tourist Expected Expected Activity Rate Activity Amount Activity Amount 7 P 7 2 P P ? ? ? 7 ? ? 7 2 7 7 ? ? ? 7 7 2 7 Deluxe Tourist 7 7 7 7 7 7 P