Sundial Co. has assigned $710,00 in total overhead cost to four different activity cost pools. The activity requirements for its two product lines, economy and Deluxe, are show 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.

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.

Saif HOME INSERT X Assigning indirect costs to products or services using activity based costing - Excel DATA REVIEW VIEW FILE PAGE LAYOUT FORMULAS Calibri po General X 11 2. M 12 AutoSum" AY AA === A E I Wrap Text 3 Merge & Center - ? - Sign In # Sort & Find & Filter Select Editing Paste BI U. $ % , ,99 Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Clear Clipboard Font Alignment Number Cells H22 D Activity Requirements by Product Line Proportion (%) Activity Economy Model Proportion (%) 2,000 300 2,000 20% 50% Deluxe Model 3,000 900 Activity Cost Pool Overhead Cost Activity Cost Driver Activity Rate 5 Material Handling $ 300,000 5,000 Material moves per move 6 Machine Set-Ups $ 210,000 Set-ups per set-up 7 Engineering Support Engineering hours $ 12.50 per hour 8 Power and Space 20,000 square feet. per sq. ft. 9 Total overhead cost $ 710,000 10 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. Overhead Assigned Using Activity Rates Overhead Assigned Using Activity Proportions (%) Verification: Create if/then statements to determine if the two methods produce identical results by indicating "pass" or "fail" Economy Deluxe Total Economy Deluxe Total Economy Deluxe Total 15 Activity Cost Pool 16 Material Handling 17 Machine Set-Ups 18 Engineering Support 19 Power and Space 20 Total Overhead Cost ... Sheet1