Current Values Data: Metric Sales (units) Units Produced Labor (hours) Labor Cost ($) per hour Materials Cost ($) Equipment (Hours) Equipment Cost ($) Fixed Costs ($) Selling Price per Unit Parent (Domestic) 1,400,000 1,400,000 40,000 $14.57 $400,000 20,000 $1,359,600 $2,000,000 $9.99 Subsidiary (LDC) 450,000 480,000 20,000 $5.52 $200,000 30,000 $225,000 $725,000 $7.99 Use column Ffor question 8 Parent (Domestic) 1,400,000 1,400,000 40,000 $14.57 $400,000 120,000 $1,359,600 $2,000,000 $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/$) 1.03 Total-Factor Productivity (units/$) 0.32 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 30,000, a reduction in Equipment Hours to 100,000, and a reduction of Equipment Costs to $1,248,000 with all other costs remaining the same. Change the appropriate values in column Fabove. Answer the questions below by comparing the new productivity value in cells D18 through D23 to the values you calculated on the "Productivity Calculations" worksheet. For example, if the value in D18 on this worksheet (Labor Productivity in units/labor hour) is less than the value for Labor Productivity in units/labor hour for the Parent operations on the "Productivity Calculations" worksheet, then choose "decreased" Productivity Measure Choose the correct answer for each productivity calculation Labor Productivity in terms of units/labor hour Labor Productivity in terms of units/labor $ Materials Productivity in terms of units/Materials Cost ($) Equipment Productivity in terms of units/hour Equipment Productivity in terms of units/$ Total Factor Productivity in terms of units/$