Chat with us, powered by LiveChat SUPPLYCHAIN ASSIGNMENT 3 | excelpaper.org/
+1(978)310-4246 credencewriters@gmail.com

## 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,850,000 750,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,425,000 479,586 In Excel, you enter: =C8*C9 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.56 \$5.51 Materials Cost (\$) \$400,259 \$201,378 Equipment (Hours) 120,598 30,578 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 Calculation Exercises: Labor Productivity (units/hour) 1a. Compute the single-factor productivity for labor for the Parent operations in units per hour (enter your formula in cell B20). Cell B20 must be a formula units/labor hour 1b. Compute the single-factor productivity for labor for the Subsidiary operations in units per hour (enter your formula in ce
error: Content is protected !!