Sundial Company 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 shown below. 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. 1 Assign indirect costs to products or services using activity based costing. Note: Use cell A2 from the given information to complete this question. Activity Requirements by Product Line Activity Cost Economy Activity Cost Pool Overhead Cost Driver Material Handling $ 300,000 5,000 Machine Set-Ups $ 210,000 1,200 Material moves Set-ups Activity Rate $60.00 $175.00 Model Activity Proportion (%) Deluxe Model Activity Proportion (%) per move 2,000 40% 3,000 60% per set-up 300 25% 900 0.75 Engineering Support $125,000 10,000 Power and Space $75,000 Engineering hours 20,000 square feet. $ 12.50 per hour 2,000 20% 8,000 80% $3.75 per square feet 10,000 50% 10,000 50% Total overhead cost $ 710,000 Use formulas to assign overhead to each product using both activity rates and activity proportions (%). Create if/then statements to verify that the two methods produce the same results. Note: Use cell A2 from the given information to complete this question. Overhead Assigned Using Activity Rates Activity Cost Pool Economy Deluxe Total Economy Total Overhead Assigned Using Activity Proportions (%) Deluxe Verification: Create if/then statements to determine if the two methods produce identical results by indicating "pass" or "fail" Economy Deluxe Total Material Handling $120,000 $180,000 $300,000 $120,000 $180,000 $300,000 pass pass pass Machine Set-Ups $52,500 $157,500 $210,000 $52,500 $157,500 $210,000 pass pass pass Engineering Support $25,000 $100,000 $125,000 $25,000 $100,000 $125,000 pass pass passi Power and Space $37,500 $37,500 $75,000 Total Overhead Cost $235,000 $475,000 $710,000 $37,500 $235,000 $37,500 $475,000 $75,000 pass pass pass $710,000 pass pass pass