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

Inputs 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.

1. Assign indirect costs to products or services using activity based costing.

Please be advised that I do not need a formula i simply need this filled out. Thank you for your time, I appreciate this being done.

tivitDelxe Proportion Economy Model Proportion (96 Model96 Activity Cost Pool Overhead Cost Material Handling 300,000 Machine Set-Ups $ 210,000 Engineering Support Power and Space Total overhead cost 710,000 Activity Rate ost Driver 5,000 Material moves 2,000 300 2,000 3,000 900 per move per set-up Set-ups Engineering hours 12.50 per hour 20% 50% 20,000 square feet. per sq. ft. 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. Verification: Create if/then statements to determine if the two methods produce identical results by indicating "pass" or "fail Deluxe Overhead Assigned using Activity Proportions (%) Overhead Assigned Using Activity Rates Cost Pool Deluxe Deluxe Total Total Total Eco CO Material Handling Machine Set-Ups Engineering Support Power and Space Total Overhead Cost