I need help solving this as soon as possible!
Q3) Alpha Company 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 below 1. Input formulas to solve for the various unknown in the table below. The formulas may vary for each cost pool depending on what items are known and unknown. Acthity Requirementsby Product Line Activity ActMty Cost Paol Deluxe Model Ovcrhaad Coat ActvMty Cost Driver 5,000 Material moves 1,200 Set-ups 10,000 Engineering hous 20,000 Square feet. Actiulty Rate Economy Model 2,000 300 2,000 Proportion(%) 00,000$ 210,000 Material Handeling Machine Set-Ups Encineering Support Power and Space Total averhead cost 3,000 900 per move per set-up per hour per sq.ft. 12.50 20% 50% 710,000 2.1 Use formula to assign overhead to each product using activity rates and activity proportions[6) 2.2 Check the result with if/then statenent 2.3 Create if/then statements to verify that the two methods produce the same results Overhead Assigned Using Acthwlty Rates Overhead Assigned Using Activity Proportions(%) ActMity Cost Pocl Material Handeling Machine Set-Ups Engineering Support Power and Space Tatal averhead cost Ttal Tatal Answer checked Verifications: Create if/then statements to determine if the two methods produce identical results by indicating "pass or "fail Deluoe Q3) Alpha Company 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 below 1. Input formulas to solve for the various unknown in the table below. The formulas may vary for each cost pool depending on what items are known and unknown. Acthity Requirementsby Product Line Activity ActMty Cost Paol Deluxe Model Ovcrhaad Coat ActvMty Cost Driver 5,000 Material moves 1,200 Set-ups 10,000 Engineering hous 20,000 Square feet. Actiulty Rate Economy Model 2,000 300 2,000 Proportion(%) 00,000$ 210,000 Material Handeling Machine Set-Ups Encineering Support Power and Space Total averhead cost 3,000 900 per move per set-up per hour per sq.ft. 12.50 20% 50% 710,000 2.1 Use formula to assign overhead to each product using activity rates and activity proportions[6) 2.2 Check the result with if/then statenent 2.3 Create if/then statements to verify that the two methods produce the same results Overhead Assigned Using Acthwlty Rates Overhead Assigned Using Activity Proportions(%) ActMity Cost Pocl Material Handeling Machine Set-Ups Engineering Support Power and Space Tatal averhead cost Ttal Tatal Answer checked Verifications: Create if/then statements to determine if the two methods produce identical results by indicating "pass or "fail Deluoe
