1. Assign indirect costs to products or services using activity based costing. 27 B5.. Assigning direct contato products or serving activity based costing Excel 7 - PE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 11 AA 2. rWrap Text Garan Puiste AF Merge & Center $.. Conditional Format Cell Insert Delte format Sort & Find Formatting Table Styles Cear Select For Aliga Sym Col Borg X Sundial Co. has assigned 5710,000 in total overhead cost to four different activity cost pool. The activity requirements for its two products lines, Economy D E G H . 1 Sundial Co. has algod 5710.000 in total overhead cost to four different selvity cost pools. The activity requirements for los two products.le, Hiconomy and Delute, are shown below. 2 Input formulas to solve for the various unknowns in the table below. The formulas may vary for each co pool depending on what items are known and unknown Activity Requirements by Product Line Activity 4 Activity Deluxe Proportion Activity Cest Pool Overhead Cost Activity Cort Driver Activity Economy Model Proton (5) 5 Material Handling s 300.000 3.000 Materials perve 2.000 3.000 6 Machine Set Up 5 210.000 Setups per setup 300 500 7 Engineering Support Engineering hos 12.50 per hour 2.000 20% Power and Space 20,000 square feet per 50% 9 Total overhead costs 710.000 10 11 Use formules to assiga overhead to each product using both activity rates and activity proportions (8) 12 Create the statements to verify that the two methode produce the same results 14 Overhead Assigned Using Activity Rates Overhead Agdig Activity Proportions () Verification: Create ifthen Matements to determine if the methods produce identical resby indicating oral Economy Deluxe Economy Deluxe Economy Deline Total 15 Activity Control 16 Material Handling 11 Machine Set-Ups 15 Begineering Support 19 Power and Space Sheets + READY