fill in the yellow shaded area with formulas only!

All answers must be entered as a formula. Click OK to begin. Om 1. Assign indirect costs to products or services using activity based costing. X 5 Assigning indirect costs to products or services using activity based costing - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11 A A Be Wrap Text General WE Paste BIU- Merge & Center - Insert Delete Format $ . %8. Conditional Format as Cell Formatting Table Styles Number Styles Clipboard Font Alignment Cels A1 Sundial Co. has assigned $710,000 in total overhead cost to four different activity cost pools. The activity requirements for its B D E F G H 1 . .C 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 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 Proportion % Activity Cost Pool 5 Material Handling 6 Machine Set-Ups Overhead Cost $ 300,000 $ 210,000 Activity Cost Driver 5,000 Material moves Set-ups Activity Rate per move per set-up Activity Economy Model Proportion (%) 2,000 300 Deluxe Model 3,000 900 Proportion %) Overhead Cost $ 300,000 $ 210,000 Activity Cost Pool Material Handling Machine Set-Ups Engineering Support Power and Space Total overhead cost per move Activity Cost Driver Activity Rate 5,000 Material moves Set-ups per set-up Engineering hours $ 12.50 per hour 20,000 square feet. per sq. ft. Activity Economy Model Proportion (%) 2,000 300 2,000 20% Deluxe Model 3,000 900 50% $ 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. Overhead Assigned Using Activity Rates Overhead Assigned Using Activity Proportions (96) Verificatior statements to methods progiu indicating Economy Economy Deluxe Total Economy Deluxe Total Activity Cost Pool Material Handling Machine Set-Ups Engineering Support Power and Space Total Overhead Cost D G H 1 K Cost Driver Material moves Proportion (%) Activity Rate per move per set-up $ 12.50 per hour per sq. ft. Set-ups Activity Economy Model Proportion (%) 2,000 300 2,000 20% 50% Deluxe Model 3,000 900 Engineering hours square feet oth activity rates and activity proportions (%). produce the same results. Activity Rates Overhead Assigned Using Activity Proportions (%) Verification: Create if/tben statements to determine if the two methods produce identical results by indicating "pass" or "fail" Economy Deluxe Total Total Economy Deluxe Total