Total = 55 points: Productivity Calculation Tab (30 points) Current Values Use column for Data: questions Metric Parent (Domestic) Subsidiary (LDC) Parent (Domestic) Sales (units) 14,00.000 4,50.000 14.00,000 Units Produced 14.00,000 4,80,000 14,00.000 Labor (hours) 40,000 20,000 30.000 Labor Cost (S) per hour $14.57 $5.52 $14.57 Materials Cost (5) $4,00,000 $2,00,000 $4,00,000 Equipment (Hours) 1,20,000 30,000 1.00.000 Equipment Cost (5) $13,59,600 $2,25,000 $12,48,000 Fixed Costs (5) $20,00,000 $7.25,000 $20,00,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) 46.67 Labor Productivity (units/labor $) 3.20 Materials Productivity (units/$) 3.50 Equipment Productivity (units/hour) 14.00 Labor 1. Provide one possible explanation how the Parent can be more productive when considering labor productivity in units per hour, but the subsidiary in more productive in una per deter) Parent Equipment Purchase (Part 1 8. Assume purchase of new equipment at an incremental, one time fixed cost of $1,500,000 resulting in a reduction in labor hours to 10,000, a redaction intent Hour te 100.000, dando 51.248,000 with all other costs remaining the same. Change the appropriate values in column above. Answer the questions below by comparinoductivity value in cells Dist33 the "Productivity Calculation worksheet. For example, if the value in D18 on this worksheet (Labor Productivity in units/abor hour) is less than the value for Labor Productivity in unt/lat De Parent operation on the Product choose decreased Productivity Measure Choose the correct answer for each productivity calculation Labor Productivity in terms of increased units/abor hour What If Analysis Parent Purchase (Part Calculate Total Revenue prior to any equipment changes using data in cells through C14 above The form for Profit is Total Revenue Total Costs The formule for Total Newme is Total Units Sold Selling Price per Unit Pre Equipment Purchase Total 50.000 Profit Post Equipment Purchase Total 300,00.000 Profit 10. Summarle your observations concerning how the potential new equipment purchase will impact each of the productivity values and total revenue Provide a recommendation whether to purda provide supporting evidence for your recommendation. Total = 55 points: Productivity Calculation Tab (30 points) Current Values Use column for Data: questions Metric Parent (Domestic) Subsidiary (LDC) Parent (Domestic) Sales (units) 14,00.000 4,50.000 14.00,000 Units Produced 14.00,000 4,80,000 14,00.000 Labor (hours) 40,000 20,000 30.000 Labor Cost (S) per hour $14.57 $5.52 $14.57 Materials Cost (5) $4,00,000 $2,00,000 $4,00,000 Equipment (Hours) 1,20,000 30,000 1.00.000 Equipment Cost (5) $13,59,600 $2,25,000 $12,48,000 Fixed Costs (5) $20,00,000 $7.25,000 $20,00,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) 46.67 Labor Productivity (units/labor $) 3.20 Materials Productivity (units/$) 3.50 Equipment Productivity (units/hour) 14.00 Labor 1. Provide one possible explanation how the Parent can be more productive when considering labor productivity in units per hour, but the subsidiary in more productive in una per deter) Parent Equipment Purchase (Part 1 8. Assume purchase of new equipment at an incremental, one time fixed cost of $1,500,000 resulting in a reduction in labor hours to 10,000, a redaction intent Hour te 100.000, dando 51.248,000 with all other costs remaining the same. Change the appropriate values in column above. Answer the questions below by comparinoductivity value in cells Dist33 the "Productivity Calculation worksheet. For example, if the value in D18 on this worksheet (Labor Productivity in units/abor hour) is less than the value for Labor Productivity in unt/lat De Parent operation on the Product choose decreased Productivity Measure Choose the correct answer for each productivity calculation Labor Productivity in terms of increased units/abor hour What If Analysis Parent Purchase (Part Calculate Total Revenue prior to any equipment changes using data in cells through C14 above The form for Profit is Total Revenue Total Costs The formule for Total Newme is Total Units Sold Selling Price per Unit Pre Equipment Purchase Total 50.000 Profit Post Equipment Purchase Total 300,00.000 Profit 10. Summarle your observations concerning how the potential new equipment purchase will impact each of the productivity values and total revenue Provide a recommendation whether to purda provide supporting evidence for your recommendation