Help Save & Exit Submit , Astigning Indirect costs to products or services using activity based costing Excel DATA H FILE HOME INSERT PAGE LAYOUT FORMULAS HEVIEW VIEW Formula Bar Split View Side by Side Hide Normal Page Break Page Custom Gridines Headings Synchronous scrolling Zoom 100% Zoom to New Arrange Freeze Switch Preview Layout Views Selection Window All Paries Orhideese Window Position Macros Windows Workbook Show Zoom Window Macro A1 f Sundial Co, has assigned $710.000 in total overhead cost to four different activity cost pools. The activity requirements for its two pro B Sundial Co, has assigned $710.000 in total overhead cost to four different activity cost pools. The activity requirements for its two products lines, Economy and Deluxe, are sho 2 Input formulas to solve for the various unknowns in the table below. The formulas may vary for each cost pool depending on what items are known and unknown. Activity Requirements by Product Line Activity Activity Cost Pool Overhead Cou Activity Cost Driver Deluxe Proportion Activity Rate Activity Material Handling Economy Model Proportion (5) $ Model (5. 300,000 3.000 Material moves per move 2000 Machine Set-Ups 3.000 210.000 Set-ups 7 Engineering Support per setup 300 900 Engineering hours $12.50 per hour 2. Power and Space 20% 20.000 square feet Total overhead cost per sq. ft. 50% $ 710.000 10 al Use formulas to assign overhead to each product using both activity rates and activity proportions (56). Create it then statements to verify that the two methods produce the same results. 1 13 Overhead Assigned Using Activity Rates Overhead Assigned Using Activity Proportions (5) Activity Cost Pool Economy Deluxe Verification: statements to dete methods produce ic indicating "po Economy Del Total Economy Deluxe Total