would you please answer question number 9 and 10 based on the information provided on the table

MGMIT 20 Productivity Assignment) Excel Selam Wote File Home Page Layout Formulas Data Review View Help Search A Total = 55 points: Productivity Calculation Tab (30 points) + What If Current Value U column to question Patent (Domestic Subsidiary (LDO Parunt (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 $14.57 $400.000 $200,000 $400 000 120.000 30.000 120.000 $1,359,800 $225.000 51.359 500 $2 000 000 $725,000 $2 000 000 $9.99 $7.99 5999 Data Metik 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 16 17 19 What If Productivity Values Based on Now Data Entered in Column F Measure Parent Organization Labor Productivity (units/labor hour) 35.00 Labor Productivity (units/labor $) 2.40 Materials Productivity (units/5) 3.50 Equipment Productivity (units/hout) 1167 Equipment Productivity (units/5) 1.03 Total-Factor Productivity (units/5) 22 27 Libor Productivity Calculation What Analysis MIGHT 3.0 ProyExch Formulas View Ture X 9. Calculate Total Revenue prior to any equipment changes in data in cells through Cabo The formula for Profit is Total Rewenue Total Costs The formula for Totalrene is Totul Unit Sold Selling Price per Unit Pre Equipment Purchase Total Profit Post Equipment Purchase Total Profit 10. Summarize your observations concerning how the potential new equipment purchase will impact each of the productivity values and totale Provide a recommendation with top the que and also provide supporting evidence for your recommendation Products What It Analysis Ser 2