Help with 1a-2c please

Total = 55 points: Productivity Calculation Tab (30 points) + What-if Analysis Tab (25 points) Data: Use data in columns CAD for the Calculation Exercises 1.6 Parent (Domestic) Subsidiary (Less 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 800 $225,000 $2,000,000 $725,000 $19.99 $19.99 Hint: Use Excel formulas to calculate your answer. For Example: To calculate the Parent's totallator dollars, you multiply labor hours labor cost In Excel you enter CPC The sign tells Excel that you are entering a formula and then you multiply the two cells that contain your data Metric Sales (units) Units Produced Labor (hours) Labor Cost (5) per hour Materials Cost ($) Equipment (Hours) Equipment Cost (5) Fixed Costs ($) Selling Price per Unit 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 820). units/labor hour 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 10. Interpret your findings by Indicating which of the two entities is more productive in terms of single-factor labor productivity in units per hour Labor Productivity (units/5) 2. Compute the single-factor productivity for labor for the Parent operations in units per dollar (enter your formula in cell 831). units/Tabor units/abor ah.compute the single-tactor productivity for labor for the subsidiary operations in units per dollar fenter your foemula in cell 34). mem units./labors 2. Interpret your findings by indicating which of the two entities is more productive in terms of single factor labor productivity in units per dollar