Productivity Analysis Assignment Total = 55 points: Productivity Calculation Tab (30 points) + What-If Analysis Tab (25 points) 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 $582,800.00 $400,000 120,000 $1,359,600 $2,000,000 $9.99 Subsidiary (LDC) 450,000 480,000 20,000 $110,400.00 $200,000 30,000 $225,000 $725,000 $7.99 Use column F for 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 Productivity Measure Choose the correct answer for each productivity calculation Increased Labor Productivity in terms of units/labor hour Increased Labor Productivity in terms of units/labor $ Materials Productivity in terms of units/Materials Cost (5) Equipment Productivity in terms of units/hour Equipment Productivity in terms of units/$ Total Factor Productivity in terms of units/$ decreased increased 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 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. Productivity Analysis Assignment Total = 55 points: Productivity Calculation Tab (30 points) + What-If Analysis Tab (25 points) 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 $582,800.00 $400,000 120,000 $1,359,600 $2,000,000 $9.99 Subsidiary (LDC) 450,000 480,000 20,000 $110,400.00 $200,000 30,000 $225,000 $725,000 $7.99 Use column F for 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 Productivity Measure Choose the correct answer for each productivity calculation Increased Labor Productivity in terms of units/labor hour Increased Labor Productivity in terms of units/labor $ Materials Productivity in terms of units/Materials Cost (5) Equipment Productivity in terms of units/hour Equipment Productivity in terms of units/$ Total Factor Productivity in terms of units/$ decreased increased 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 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
