provide formula 1. Sundial Company has assigned $710,000 in total overhead cost to four different activity cost

provide formula

Transcribed Image Text:

1. Sundial Company has assigned $710,000 in total overhead cost to four different activity cost pools. The activity requirements for its two 2 products lines, Economy and Deluxe, are shown below. 3 45678c 9 20 21 A 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. 1 30 31 Assign indirect costs to products or services using activity based costing. Note: Use cell A2 from the given information to complete this question. 10 Activity Cost Pool 11 Material Handling 12 Machine Set-Ups 13 Engineering Support 14 Power and Space 15 Total overhead cost 16 17 Use formulas to assign overhead to each product using both activity rates and activity proportions (%). 18 19 Create if/then statements to verify that the two methods produce the same results. Note: Use cell A2 from the given information to complete this question. 22 23 Activity Cost Pool 24 Material Handling 25 Machine Set-Ups 26 Engineering Support 27 Power and Space 28 Total Overhead Cost 29 Activity Overhead Cost Cost Driver 5,000 S 300,000 $ 210.000 S 710,000 Material moves Set-ups Activity Rate per move per set-up Engineering hours $12.50 per hour 20,000 square feet. Overhead Assigned Using Activity Rates Economy Deluxe Total per square feet Economy Model Economy Activity Requirements by Product Line Activity Proportion (%) 2,000 300 2,000 Overhead Assigned Using Activity Proportions (%) Deluxe 20% 50% Total Deluxe Activity Model Proportion (%) 3,000 900 Verification: Create if/then statements to determine if the two methods produce identical results by indicating "pass" or "fail" Deluxe Economy pass pass pass pass pass pass pass pass pass pass Total pass pass pass pass pass M 1. Sundial Company has assigned $710,000 in total overhead cost to four different activity cost pools. The activity requirements for its two 2 products lines, Economy and Deluxe, are shown below. 3 45678c 9 20 21 A 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. 1 30 31 Assign indirect costs to products or services using activity based costing. Note: Use cell A2 from the given information to complete this question. 10 Activity Cost Pool 11 Material Handling 12 Machine Set-Ups 13 Engineering Support 14 Power and Space 15 Total overhead cost 16 17 Use formulas to assign overhead to each product using both activity rates and activity proportions (%). 18 19 Create if/then statements to verify that the two methods produce the same results. Note: Use cell A2 from the given information to complete this question. 22 23 Activity Cost Pool 24 Material Handling 25 Machine Set-Ups 26 Engineering Support 27 Power and Space 28 Total Overhead Cost 29 Activity Overhead Cost Cost Driver 5,000 S 300,000 $ 210.000 S 710,000 Material moves Set-ups Activity Rate per move per set-up Engineering hours $12.50 per hour 20,000 square feet. Overhead Assigned Using Activity Rates Economy Deluxe Total per square feet Economy Model Economy Activity Requirements by Product Line Activity Proportion (%) 2,000 300 2,000 Overhead Assigned Using Activity Proportions (%) Deluxe 20% 50% Total Deluxe Activity Model Proportion (%) 3,000 900 Verification: Create if/then statements to determine if the two methods produce identical results by indicating "pass" or "fail" Deluxe Economy pass pass pass pass pass pass pass pass pass pass Total pass pass pass pass pass M