Please give answers in excel form. B2-B1 etc. 17 Use formulas to assign overhead to each product using both activity rates and activity proportions (%).1819 Create if/then statements to verify that the two methods produce the same results.20Note: Use cell A2 from the given information to complete this question.212223 Activity Cost Pool24 Material Handling25 Machine Set-Ups26 Engineering Support27 Power and Space28 Total Overhead Cost2930314A Graded WorlOverhead Assigned Using Activity RatesEconomyDeluxeTotal3...+Overhead Assigned Using Activity Proportions(%)DeluxeEconomyTotalVerification: Create if/then statementsto determine if the two methodsproduce identical results by indicating"pass" or "fail"Economy DeluxepasspasspasspasspasspasspasspasspasspassTotalpasspasspasspasspass 1Sundial Company has assigned $710,000 in total overhead cost to four different activity cost pools. The activity requirements for its two2 products lines, Economy and Deluxe, are shown below.3Input formulas to solve for the various unknowns in the table below. The formulas may vary for each cost pool depending on what items4 are known and unknown.+56 16789Note: Use cell A2 from the given information to complete this question.10 Activity Cost Pool11 Material Handling12 Machine Set-Ups13 Engineering Support14Power and Space15 Total overhead cost+/Assign indirect costs to products or services using activity based costing.4ActivityOverhead Cost Cost Driver5,000$ 300,000$210,000$ 710,000ActivityRateMaterial movesper moveper set-upSet-upsEngineering hours $12.50 per hour20,000 square feet.per square feetEconomyModelActivity Requirements by Product LineActivityDeluxeProportion (%) Model3,0009002,0003002,00020%50%ActivityProportion (%)

This is the question which is all about the activity based costs which have to be assigned based…

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 Cost Pool Material Handling Machine Set-Ups Engineering Support Power and Space Total overhead cost Activity Overhead Cost Cost Driver 5,000 $ 300,000 $ 210,000 $ 710,000 Material moves Set-ups Engineering hours 20,000 square feet. Activity Rate per move per set-up 12.50 per hour per square feet Economy Model Activity Requirements by Product Line Deluxe Activity Model Proportion (%) 2,000 300 2,000 Activity Proportion (%) 20% 50% 3,000 900