PLEASE GIVE ANSWER IN EXCEL FORMULAS! NOT NUMBERS

Number Font 1 Chapter 3: Applying Excel 3 Enter a formula into each of the cells marked with a ? below 4 Review Problem: Activity Based Costing 6 Data Deluxe Tourist 8 Annual sales in units 9 Direct materials per unit 10 Direct labor-hours per unit 2,000 $25 10,000 $17 $12 per DLH 12 Direct labor rate 13 Estimated Expected Activity 15 16 Activities and Activity Measures 17 Labor related (direct labor-hours) 18 Machine setups (setups) 19 Production orders (orders) 20 General factory (machine-hours) Deluxe Tourist Total Cost S 80,000 2,000 150,0003,000 100 70,000 300 250000 12,000 28,000 3 Compute the predetermined overhead rate 24 Estimated total manufacturing overhead (a) 25 Estimated total amount of the allocation base (b) 26 Predetermined overhead rate (a)+(b) DLHs ? per DLH Deluxe Tourist 28 Compute the manufacturing overhead applied 29 Direct labor-hours per unit (a) 30 Predetermined overhead rate (b) ?DLHs ? per DLH ? DLHs ? per DLH Manufacturing overhead applied per unit (a)x(b) unit product costs Deluxe Tourist 33 Compute traditional 34 Direct materials 35 Direct labor 36 Manufacturing overhead applied 37 Traditonal unit product cost 38 39 Compute activity rates Estimated Cost Total Expected Activity 41 Activities 42 Labor related 43 Machine setups 44 Production orders 4S General factory Activity Rate ? DLHs ? setups ? orders ? MHs ? per DLH ? per setup ? per order 2per MH Chapter 3 Form Sheet1 Sheet2 Q O Type here to search 0