Productivity Analysis Assignment Total = 55 points: Productivity Calculation Tab (30 points) + What If Analysis Tab (25 points) Hint: Use Excel formulas to calculate your answer. For Exansle: To cakulase the Parseff total labor dollars, you malipy labor hours "labor cost in frect, yeu mater; actrce The "w" uign talls Excat thut you we sentaring a formula and than you mubliply the two celts that contain you dats 12. Combute the single-factor oroductivity for tobor for the Parent operatbons in units per hour (enter your formula in cell a20). 1b. Compute the single.tactor productivity for labor for the Subulilary operations in units per hour (enter your formula in cell Bz3). units/labor hour 1e. Intareet vour findinas by indicating which of the two entities is more productive in terms of single-factor labor productivity in wnits per hour Labor Productivity (unites) 2a. Compute the single-factor broductivity for laber for the Parent operations in units per dollar (enter yeur formula in cell 831 ). 4a. Compute the sinele-factor productwity for equipment for tha Parent operations in units per hour (enter your formula in cell is 53 ). units.flvour 4b. Compute the single-factor productivity for equipment for the Subsidlary operations in units per hour (enter your formula in cell Bs6). 4c. Interpret your findings by indicatine which af the two entities is more productive in terms of single-factor equipment producthity in units per hour. Equipment Productivity (units/s) Sa. Compute the sinale-factor productivity for equipment for the Parent operations in units per dollar (enter your formula in call Bos). 5b. Compute the single-factor productivity for equipment for the Subsidiary operations in units per dollar fenter your formula in celf Es7). 5t. Interpret your findines by indicating which of the two entities is more prodoctive in terms of single-factor eauipment productivity in units per doilar, 5a. Compute the totaHactor neoductlivity (all factors) for the Parent operations in units per dollar (enter your formula in cell azs). b. Compute the totalfactor aroductivity (all factors) for the Subidiary operations in units per dolla (enter your formula in ceil sys)