Total =55 points: Productivity Calculation Tab (30 points) + What-If Analysis T Hint: Use Excel formulas to caleulate your answer. For Example: To calculato the Parenfs total labor dollara, you multiply lak In Excel you ontori NCT'Cs The "." alan telis Excel that you are entering a formula and then you multhp your data Cempute the single-tactor productivity for materials for the subsidiary operations is units per doll (enter your formuli in cell 845). aterseet your findines by indicatine which of the two eatieies is more productive in terms ef diege-tactor materials prodoctivity in uniti per Campute the single-factor productivity for equigment for the Parent operationt in units per hour fenteryour formula in cell as3) units.'hour Comeule the single factor prodactivify for equipment for the Subseiary operations in units per heur (e iteryour formulain cell B56). whitsfibur Internet vour findings by indicating which of the two entieies is more productive in terms of aingle-tactor equipment groductivity in wnits pe Compute the eingle-tactor productivity for equipment for the Parent operations in units per defir fenteryour formula in cell aSA|unituls Compute the single-tactor groductivity for equipment for the subuidiay operations in units per hour fenteryour formula in ceti Bs unitsfhour interpret your findings by indicating which of the two entities is mere productive in termis af dinde-iactor equlpment prodactivity in anits Comoute the sinele-facter araductivitu far eauinment for the Parent operations in units per dollar fenter your formula in cell a64). Interpeet your findings by indicating which of the two entities is more productive in terms of ende-bactac equipment productivitylin unitspe talfactor Productivisy: L Compute the total bactor groductivity (all factars) fer the Parent epe rations in inits pee dollar (enter your formula in cell a75l. Compute the totaldacter predactivitv lall factari) for the Subsidiary operations in units per dollar fenteryour formulain cell art? Productivity Analysis Assignmen Tatal - 55 points: Productivitv Calculation Tab [30 noints) + W. The formula for Propt is Tocal Aerthut - Fotal Cdati The formala fer Tatal Revenue a Total Chita Sald "Seling Prior aer tikit