Please help me answer #9 and #10

Total = 55 points: Productivity Calculati Current Values Use column F for Data: question 8 Metric Parent (Domestic) Subsidiary (LDC) Parent (Domestic) Sales (units) 1,400,000 450,000 1,400,000 Units Produced 1,400,000 480,000 1,400,000 Labor (hours) 40,000 20,000 40,000 Labor Cost ($) per hour $14.57 $5.52 $14.57 Materials Cost (5) $400,000 $200,000 $400,000 Equipment (Hours) 120,000 30,000 120,000 Equipment Cost ($) $1,359,600 $225,000 $1,359,600 Fixed Costs ($) $2,000,000 $725,000 $2,000,000 Selling Price per Unit $9.99 $7.99 $9.99 What-lf Productivity Values Based on New Data Entered in Column F Measure Parent Organization Labor Productivity (units/labor hour) 35.00 Labor Productivity (units/labor $) 2.40 Materials Productivity (units/$) 3.50 Equipment Productivity (units/hour) 11.67 Equipment Productivity (units/s) 1.03 Total-Factor Productivity (units/$) 0.32 Patent Equipment Pur 7 (Part #2) 9. Calculate Total Revenue prior to any equipment changes using data in cells C6 through C14 above. The formula for Profit is Total Revenue - Total Costs The formula for Total Revenue is Total Units 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 total revenue. Provide a recommendation whether to purchase the equipment and also provide supporting evidence for your recommendation. 8