FOR EACH ANSWER PLEASE WRITE THE THE RESULT AND THE EQUATION USED (EX: =B2+D6)

4 B D E F G H J 1 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 shown bel 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. 3 Activity Requirements by Product Line Activity Activity Deluxe Proportion Activity Cost Pool Overhead Cost Activity Cost Driver Activity Rate Economy Model Proportion (%) Model (%) 5 Material Handling $ 300,000 5,000 Material moves per move 2,000 3,000 6 Machine Set-Ups $ 210,000 Set-ups per set-up 300 900 7 Engineering Support Engineering hours $ 12.50 per hour 2,000 20% 8 Power and Space 20,000 square feet per sq. ft. 50% 9 Total overhead cost $ 710,000 11 Use formulas to assign overhead to each product using both activity rates and activity proportions (%). 12 Create if/then statements to verify that the two methods produce the same results. 13 14 Overhead Assigned Using Activity Rates Overhead Assigned Using Activity Proportions (%) Verification: Create if/ statements to determine if methods produce identical r indicating "pass" or "f: Deluxe Economy Deluxe Total Economy Deluxe Total Economy 15 Activity Cost Pool 16 Material Handling 17 Machine Set-Ups 18 Engineering Support 19 Power and Space 20 Total Overhead Cost 4 B D E F G H J 1 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 shown bel 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. 3 Activity Requirements by Product Line Activity Activity Deluxe Proportion Activity Cost Pool Overhead Cost Activity Cost Driver Activity Rate Economy Model Proportion (%) Model (%) 5 Material Handling $ 300,000 5,000 Material moves per move 2,000 3,000 6 Machine Set-Ups $ 210,000 Set-ups per set-up 300 900 7 Engineering Support Engineering hours $ 12.50 per hour 2,000 20% 8 Power and Space 20,000 square feet per sq. ft. 50% 9 Total overhead cost $ 710,000 11 Use formulas to assign overhead to each product using both activity rates and activity proportions (%). 12 Create if/then statements to verify that the two methods produce the same results. 13 14 Overhead Assigned Using Activity Rates Overhead Assigned Using Activity Proportions (%) Verification: Create if/ statements to determine if methods produce identical r indicating "pass" or "f: Deluxe Economy Deluxe Total Economy Deluxe Total Economy 15 Activity Cost Pool 16 Material Handling 17 Machine Set-Ups 18 Engineering Support 19 Power and Space 20 Total Overhead Cost