Hint: Use Excel tormutas to caleulate your answer. Fer Example: To calculate the Parents total labor doliars, you multiply labor hours " labor cost Tha "s" sign to:s Ercel that you are eriecing a formule and thes you multiply the twp cells that contain pout data 3a. Compute the single-factor productivity for materials for the Parent operations in units per doliar (enter vour formula in ceil B42). 36. Compute the single-tactor productivity for materials for the Subsidiary operations in units per dollar (enter your formula in cell g45). 3c. Interpret your findines bvindicatine which of the two entities is more productive in terms of single-factor materials productivity in units per dollar. 4a. Compute the sinele-4actor areductivitv for enuiament for the Parent operations in units per hour fenter your formula in cell Bs3). 4h. Compute the singie-factor peoductivity for equipment for the subsidiary eperation in units per hour (eater your formula in cell as6). ansituheur 4c. Interpret your Andines by indicatine wich of the two extitiesis more productive in terms of ingle factor equipment productivity in units per hour. 5a. Compute the sinde-tactor productivity for equipment for the Parent operations in units per doilar fenter your formula in cell b64). 56. Compute the sinde-tactor braductivity for equipment for the Subsidiary operations in units per dollar fenter veur formula in cell 8677 . 5c. Inters ret vour findines by indicatinc which of the two entities is more productive in terms of vingle factor equipment preductivity in units per dollar. 6a. Compute the total-factor productivity (all factors) for the Parent operations in units per dollar (enter your formula in cell B75). unitu/\$ 6b. Compute the total factor productivity (all factorv) for the Subsidiary operations in units per dollar fenter your formula in cell b7s). 6c. Interpeet your Sndingsby indicating which of the two entities is more productive in terms of totalfactor productivity in units per dolier