Please help. I am so lost!

1 Productivity Analysis Assignment Total = 55 points: Productivity Calculation Tab (30 points) + What-If Analysis Tab (25 points) 2 3 4 Data: Hint: Use Excel formulas to calculate your answer. Metric 5 6 Sales (units) 7 Units Produced 8 Labor (hours) 9 Labor Cost ($) per hour 10 Materials Cost ($) 11 Equipment (Hours) 12 Equipment Cost ($) 13 Fixed Costs ($) 14 Selling Price per Unit 15 Use data in columns C & D for the Calculation Exercises 1a - 60 Subsidiary (Less Parent (Domestic) Developed Country) 1,750,000 650,000 1,400,000 480,000 40,000 20,000 $14.57 $5.52 $400,000 $200,000 120,000 30,000 $1,359,600 $225,000 $2,000,000 $725,000 $19.99 $19.99 For Example: To calculate the Parent's total labor dollars, you multiply labor hours * labor cost In Excel, you enter: =C7*C8 The "=" sign tells Excel that you are entering a formula and then you multiply the two cells that contain your data Total points this worksheet = 30 points C D E F G H 1 B Calculation Exercises: 16 17 Labor Productivity (units/hour) 18 19 1a. Compute the single-factor productivity for labor for the Parent operations in units per hour (enter your formula in cell B20). units/labor hour 20 Cell B20 must be a formula 21 22 1b. Compute the single-factor productivity for labor for the Subsidiary operations in units per hour (enter your formula in cell B23). units/labor hour 23 Cell B23 must be a formula 24 25 26 1c. Interpret your findings by indicating which of the two entities is more productive in terms of single-factor labor productivity in units per hour 27 28 Labor Productivity (units/$) 29 30 2a. Compute the single-factor productivity for labor for the Parent operations in units per dollar (enter your formula in cell B31). units/labor $ 31 Cell B31 must be a formula- 32 A H 30 B C D E F G 2a. Compute the single-factor productivity for labor for the Parent operations in units per dollar (enter your formula in cell B31). units/labor $ 31 Cell B31 must be a formula 32 33 34 Cell B34 must be a formula 35 2b. Compute the single-factor productivity for labor for the Subsidiary operations in units per dollar (enter your formula in cell B34). units/labor $ 2c. Interpret your findings by indicating which of the two entities is more productive in terms of single-factor labor productivity in units per dollar. 36 37 38 39 Materials Productivity (units/$) 40 3a. Compute the single-factor productivity for materials for the Parent operations in units per dollar (enter your formula in cell B42). units/$ 41 42 Cell B42 must be a formula- 43 44 45 Cell B45 must be a formula 46 3b. Compute the single-factor productivity for materials for the Subsidiary operations in units per dollar (enter your formula in cell B45). units/$ 47 3c. Interpret your findings by indicating which of the two entities is more productive in terms of single-factor materials productivity in units per dollar. A B C E F G H 46 47 3c. Interpret your findings by indicating which of the two entities is more productive in terms of single-factor materials productivity in units per dollar. 48 49 50 Equipment Productivity (units/hour) 51 52 4a. Compute the single-factor productivity for equipment for the Parent operations in units per hour (enter your formula in cell B53). units/hour 53 Cell B53 must be a formula 54 55 56 Cell B56 must be a formula 57 58 4b. Compute the single-factor productivity for equipment for the Subsidiary operations in units per hour (enter your formula in cell B56). units/hour 4c. Interpret your findings by indicating which of the two entities is more productive in terms of single-factor equipment productivity in units per hour. 60 61 Equipment Productivity (units/$) 62