PLEASE HELP ME ANS ANSWER THE PARTS IN YELLOW SO I CAN MAKE SURE MY ANSWERS ARE CORRECT! thank you sm :)

1. Assige Indirect costs to products or services using activity based costing INSERT DATA Calon WE Paste Font Assigning indirect costs to products or services using activity based costing - Excel HOME PAGE LAYOUT FORMULAS REVIEW VIEW P Wrap Test General BLU- A. Merge Center. $. %. Conditional Formatas Cel Insert Delete Format Formatting Table Styles Alignment Celle A1 the Sundial Co. has assigned $710,000 in total overhead eost to four different activity cest pools. The activity requirements for its H 1 Sundial Co, han assignigd 5710,000 in total overhead cost to four different activity cost pools. The activity requirements for its two products lines, Economy and Deluxe, 2 put 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. 5 Activity guirements by Product Line Activity Deluxe Proportion Activity Cost Pool Owerhead Cou Activity Cost Driver Activity Rate Economy Model Proportion (%) Model 5 Material Handling 300,000 5.000 Material moves 2.000 6 Machine Set-Ups 210.000 Setups per set up 7 Engineering Support Engineering hours 12.50 per hour 20 8 Power and so 20,000 square feet Total od cost 4 S per move 1.000 900 300 2.000 per sq.ft SON 710 1 Sundal Co has assigned $10,000 in total overhead cost to our dillerent activity cost pool. The activity requirements for its to product lines, Economy and Deluxe, are shown below 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 4 Activity Deine Proportion Activity Cost Pool Owerrad Cost Activity Cost Driver Activity Rate Economy Model Progrtions Mode 5 Material Handling 5 300,000 5.000 Material moves per more 2.000 3,000 6 Machine Set Up $ 210,000 per setup 300 900 7 Engineering sport Engineering hours 12.50 per hour 2.000 2015 Power and Space 20,000 are feet per att SOK total overhead cost 5 750,000 10 11 Un formulas to assign overhead to each product using both activity rates and activity proportions 12 Create /then statements to verify that the two methods produce the same results 13 Overhead Assad Using Activity Proportions 14 Overhead Assigned Using Activity Bates Verification: Create then statements to determine if the two methods produce identical results by indicating or alle From Total To Economy Deluxe Economy 15 Activity Cost Pool 16 Marding 17 Machine Set Us 15 Engineering Support 19 Power and Space 20 Test 22 Sheet