Assign indirect costs to products or services using activity based costing.

Font OH 5. Assigning direct costs to products or services using activity based costing - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calor - Er Wap Tot ww Autosum Paste Blu- CA + Merge Center 5% Conditional Format Call Insert Delete Format Formatting Table Styles Car Clipboard Aliment Number Cals A1 X Sundial Co. has assigned 5710/00 in total overhead cost to four different activity cost pools. The activity requirements for its two product F 0 H Sundial Co, has sind 5710,000 in total overhead cost to four different activity cont pools. The activity requirements for its two products lines, Fconomy and Deluxe, are shown to 2 Input formulas to solve for the various unknown in the table below. The formulas may vary for each cost pool depending on what items are known and unknown 3 Activity Requirements by Product Line Activity Activity Deluxe Proportion Activity Cost Pool Overhead Cost Activity Cost Driver Activity Rate Economy Model Proportion (5) Model Material Handling $ 300.00 5000 Material moves per move 2.000 6 Machine Set Up S 210.000 Setup per up 300 2 Engineering Support Engineering hours 12.50 per hour 2.000 20 Power and Space 20,000 square feet pers 50 9 Total overhead cost 5 710,000 10 11 Une formules to assign overhead to each product using both activity rates and activity proportions (6) 12 Create if the statements to verify that the two methods produce the same results 13 3.000 200 Overhead Assigned Using Activity Rates Overhead Assigned Using Activity Proportions (6) Verification: Creat statements to determin methods produce identi indicating "passic Economy Deluxe Economy Deluxe Total Economy Deluxe Total 5 Activity Cost Pool 6 Material Handling 7 Machine Set-Up! & Engineering Support Power and Space Total Overhead Cost 1