Productivity Calculations
Productivity Analysis Assignment
Total = 55 points: Productivity Calculation Tab (30 points) + What-If Analysis Tab (25 points) Assignment Learning Objectives
Use data in columns C & D for the
Data: Calculation Exercises 1a - 6c 1. Calculate single factor and total factor productivity measures
Metric Parent (Domestic) Subsidiary (Less Developed Country) Hint: Use Excel formulas to calculate your answer. 2. Interpret productivity measures and draw appropriate conclusions
Sales (units) 1,750,000 650,000 For Example: To calculate the Parent's total labor dollars, you multiply labor hours * labor cost 3. Use formulas in Excel
Units Produced 1,400,000 480,000 In Excel, you enter: =C7*C8 4. Use Excel to perform "What-If" Analysis
Labor (hours) 40,000 20,000 The "=" sign tells Excel that you are entering a formula and then you multiply the two cells that contain your data
Labor Cost ($) per hour $14.57 $5.52
Materials Cost ($) $400,000 $200,000
Equipment (Hours) 120,000 30,000
Equipment Cost ($) $1,359,600 $225,000
Fixed Costs ($) $2,000,000 $725,000
Selling Price per Unit $19.99 $19.99 Total points this worksheet = 30 points