UDDLE NNESSEE IL UNIVERSITY Total = 55 points: Productivity Calculation Tab (30 points) + What-lf Analysis Tab (2 Current Values Data: Metric Parent (Domestic Subsidiary LDC) Sales (units) 1,400,000 450,000 Units Produced 1.400,000 480.000 Labor (hours) 40.000 20,000 Labor Cost (5) per hour $1457 $5.52 Materials Cost (5) 3.000.000 $200.000 Equipment (Hous) 120,000 30.000 Equipment Cost (5) $1.350.000 $225,000 Fixed Costs (5) $2.000.000 $725,000 Selling Price per Und $9.99 $7.99 What It Productivity Values Based on New Data Entered in Column Measure Parent Organization Labor Productivity (units/abor hour 35.00 Labor Productivity (units/labor $) 2.40 Material Productivity (units/5) 3.50 Equipment Productivity (units/hour 11.67 Tquipment Productivity (1/5) 1.03 Total Factor Productivity wit/s) 0.32 Use column for question Parent (Domestic 1,400,000 1,400,000 40 000 $14.57 $400.000 120.000 $1.359,600 $2.000.000 7. Provide one possible explanation how the Parent can be more productive when considering labor productivity in units per hour, but the subsidiary is more productive in units per dollar Parent Equipment Purchase 6. Anume purchase of new ewitment an incremental, one-time e cost of $1.500,000 sulting in a reduction in the hours to 30.000, a reduction in En Moonste 100.000, and of Tirant Cits 10 $1,748,000 with all other cots remaining the same Chahe appropriate values icon Answer the question belowly comparing the new productivity value in touch to the values you cated on the Productivity worth Port on this worshtator Production in which the then the literaturhout the rection on the productivity new the theo Equipment Purchase IP 1. Calculate Total Revenue prior to y elment changes using data in cells C6 through C14 above The formula for Profit is Total Revenue Total Costs The formula for Tatol Revenue is Total Units Sold Selling Price per Unit Prement Purchase Total Profit Post Equipment Purchase Total Prot 10. Summarise your burvations concerning how the potential new equipment purchase will impact each of the productivity values and total revenue Provide a recommendation whether to purchase them and also provide supporting evidence for your recommendation . UDDLE NNESSEE IL UNIVERSITY Total = 55 points: Productivity Calculation Tab (30 points) + What-lf Analysis Tab (2 Current Values Data: Metric Parent (Domestic Subsidiary LDC) Sales (units) 1,400,000 450,000 Units Produced 1.400,000 480.000 Labor (hours) 40.000 20,000 Labor Cost (5) per hour $1457 $5.52 Materials Cost (5) 3.000.000 $200.000 Equipment (Hous) 120,000 30.000 Equipment Cost (5) $1.350.000 $225,000 Fixed Costs (5) $2.000.000 $725,000 Selling Price per Und $9.99 $7.99 What It Productivity Values Based on New Data Entered in Column Measure Parent Organization Labor Productivity (units/abor hour 35.00 Labor Productivity (units/labor $) 2.40 Material Productivity (units/5) 3.50 Equipment Productivity (units/hour 11.67 Tquipment Productivity (1/5) 1.03 Total Factor Productivity wit/s) 0.32 Use column for question Parent (Domestic 1,400,000 1,400,000 40 000 $14.57 $400.000 120.000 $1.359,600 $2.000.000 7. Provide one possible explanation how the Parent can be more productive when considering labor productivity in units per hour, but the subsidiary is more productive in units per dollar Parent Equipment Purchase 6. Anume purchase of new ewitment an incremental, one-time e cost of $1.500,000 sulting in a reduction in the hours to 30.000, a reduction in En Moonste 100.000, and of Tirant Cits 10 $1,748,000 with all other cots remaining the same Chahe appropriate values icon Answer the question belowly comparing the new productivity value in touch to the values you cated on the Productivity worth Port on this worshtator Production in which the then the literaturhout the rection on the productivity new the theo Equipment Purchase IP 1. Calculate Total Revenue prior to y elment changes using data in cells C6 through C14 above The formula for Profit is Total Revenue Total Costs The formula for Tatol Revenue is Total Units Sold Selling Price per Unit Prement Purchase Total Profit Post Equipment Purchase Total Prot 10. Summarise your burvations concerning how the potential new equipment purchase will impact each of the productivity values and total revenue Provide a recommendation whether to purchase them and also provide supporting evidence for your recommendation