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 #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 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 #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