would you please answer question 9 and 10 based on the information in the table. thanks

Page Layout Forms MGMT 9630 Productivity Assignment - Esco Search Data Review View C14 1 4 5 6 2 Productivity Analysis Assignment Total = 55 points: Productivity Calculation Tab (30 points) + What-If Analysis Current Values Use column for questi Parent (Domestic Subsidiary (LDC) Parent (Domestic 1.400,000 450,000 1,400,000 1.400,000 480,000 1.400.000 40,000 20,000 40.000 $14.57 $5.52 $1457 $400.000 $200 000 $400,000 120,000 30 000 120,000 $1,369,600 $225,000 $1,359 800 $2,000,000 $725,000 $2.000.000 $9.99 S7 99 $9.99 Metric Sales (units) Units Produced Labor hours) Labor Cost ($) per hour Materials Cost (5) Equipment (Hours) Equipment Cost (5) Fixed Costs (5) Selling Price per Unit 9 10 11 12 13 15 16 17 18 SHARE What if Productivity Values Based on Now Data Entered in Column F Measure Parent Organization tabor Productivity (units/labor hour) 35.00 Labor Productivity (units/labor) 2.40 Materials Productivity (units/5) 3.50 Equipment Productivity (units/hour) 11.67 Equipment Productivity (units/5) 103 Total Factor Productivity (units/8) 02 Productivity Calestation What If Analysis Som Parent Equipment Puch 47 Past 1. Calculate Total Revenue prior to any equipment changes wing data in cells through the The formula for Profit is Total Revenue Total Costs A The formula for Total Revenge Is Total Units Sold Selling Price per Unit Precipment Puchar Total Pratt Post Equipment Purchase Total 50 Prot 51 10. Summae your observation concerning how the potentialement purch will impacteath of the productivity for and provide a recommendation whether to the equip 52 and also provide supporting evidence for your recommendation 53 56 40 mant Purchase 9. Calculate Total Revenue prior to any equipment changes using data in cells through there The formula for Profit is Total Revenue - Total Costs 21 The formula for Total Revenue is total Units Sold Selling Price per Unit Pre Equipment Purchase Total 4 Prati Post Equipment Purchase Total Prett R 10. Summarize your observation concerning how the potential new egalment purchase will impact each of the productivity toes and total revenue Provide a recommendation starter to put the supe 52 and also provide supporting evidence for your recommendation 54 KS Total = 55 points: Productivity Calculation Tab (30 points) + What If Analy On Vas gosto 10 11 Sales (units) Units Produced Labor (hours) Labor Cost (5) per hour Materials Cost (5) Equipment (our Equipment Cost (5) Fixed Costs ($) Selling Price per Unit 1,400,000 1.400.000 40.000 $1457 $400 000 120,000 $1,350,000 $2,000,000 $0.99 450,000 480.000 20,000 $5.52 $200.000 30,000 $225,000 $725,000 $7.90 1.400,000 1.400,000 40.000 514 57 $400,000 120.000 51,359.500 $2.000.000 59.90 14 15 16 17 18 19 20 21 What If Protectivity Values Based on New Data Entored in Column Measure Parent Organization Labor Productivity (units/labor hour) 35.00 tabor Productivity (units/abor $) 2.60 Materials Productivity (units/5) 3.50 Equipment Productivity (units/hour) 11.67 Equipment Productivity (units/51 103 0.12 Total-Factor Productivity (units/S) 23 34 Page Layout Forms MGMT 9630 Productivity Assignment - Esco Search Data Review View C14 1 4 5 6 2 Productivity Analysis Assignment Total = 55 points: Productivity Calculation Tab (30 points) + What-If Analysis Current Values Use column for questi Parent (Domestic Subsidiary (LDC) Parent (Domestic 1.400,000 450,000 1,400,000 1.400,000 480,000 1.400.000 40,000 20,000 40.000 $14.57 $5.52 $1457 $400.000 $200 000 $400,000 120,000 30 000 120,000 $1,369,600 $225,000 $1,359 800 $2,000,000 $725,000 $2.000.000 $9.99 S7 99 $9.99 Metric Sales (units) Units Produced Labor hours) Labor Cost ($) per hour Materials Cost (5) Equipment (Hours) Equipment Cost (5) Fixed Costs (5) Selling Price per Unit 9 10 11 12 13 15 16 17 18 SHARE What if Productivity Values Based on Now Data Entered in Column F Measure Parent Organization tabor Productivity (units/labor hour) 35.00 Labor Productivity (units/labor) 2.40 Materials Productivity (units/5) 3.50 Equipment Productivity (units/hour) 11.67 Equipment Productivity (units/5) 103 Total Factor Productivity (units/8) 02 Productivity Calestation What If Analysis Som Parent Equipment Puch 47 Past 1. Calculate Total Revenue prior to any equipment changes wing data in cells through the The formula for Profit is Total Revenue Total Costs A The formula for Total Revenge Is Total Units Sold Selling Price per Unit Precipment Puchar Total Pratt Post Equipment Purchase Total 50 Prot 51 10. Summae your observation concerning how the potentialement purch will impacteath of the productivity for and provide a recommendation whether to the equip 52 and also provide supporting evidence for your recommendation 53 56 40 mant Purchase 9. Calculate Total Revenue prior to any equipment changes using data in cells through there The formula for Profit is Total Revenue - Total Costs 21 The formula for Total Revenue is total Units Sold Selling Price per Unit Pre Equipment Purchase Total 4 Prati Post Equipment Purchase Total Prett R 10. Summarize your observation concerning how the potential new egalment purchase will impact each of the productivity toes and total revenue Provide a recommendation starter to put the supe 52 and also provide supporting evidence for your recommendation 54 KS Total = 55 points: Productivity Calculation Tab (30 points) + What If Analy On Vas gosto 10 11 Sales (units) Units Produced Labor (hours) Labor Cost (5) per hour Materials Cost (5) Equipment (our Equipment Cost (5) Fixed Costs ($) Selling Price per Unit 1,400,000 1.400.000 40.000 $1457 $400 000 120,000 $1,350,000 $2,000,000 $0.99 450,000 480.000 20,000 $5.52 $200.000 30,000 $225,000 $725,000 $7.90 1.400,000 1.400,000 40.000 514 57 $400,000 120.000 51,359.500 $2.000.000 59.90 14 15 16 17 18 19 20 21 What If Protectivity Values Based on New Data Entored in Column Measure Parent Organization Labor Productivity (units/labor hour) 35.00 tabor Productivity (units/abor $) 2.60 Materials Productivity (units/5) 3.50 Equipment Productivity (units/hour) 11.67 Equipment Productivity (units/51 103 0.12 Total-Factor Productivity (units/S) 23 34