Hint: Use Excel formulas to caleulate your anawer. Foe Example: To ealeutate the Parenhs weat labor dollars, you metiply later hours * labor cest In Exeet, you enter: nctres your dats a. Compute the sinde-factor productivity for equipment for the Parent operations in units per dollar (enter your formula in cell B64). b. Compute the sinde-tactor productivity for equipment for the Subsidiary operations in units per dollar (enter your formula in cell a67). units/s ic. Interpret your findings by indicating which of the two entities is more productive in terms of single-tactor equipment productivity in units per do 5a. Comoute the total-factor oroductivitu Lall factorsi for the Parent operations in units per dollar (enter your formula in cell 875 ). Sb. Compute the total-tactor productivity (all factors) for the Subsldiay operations in units per dollar (enter your formula in cell ara). 3a. Combute the sinde-factor oroductivitw for matevials for the Parent operationsin units per dolla: (enter your formula in cell B42). 3b. Compute the sinde-factor oroductivitv for materials for the subvidiary operations in units per dollar (enter your formula in cell B45). 3c. Interpret wour findines bvindicatine which of tha twe entibles is more productive in terms of slnde-foctor materials productivity in units par dollas. 4a. Compute the dinde-factor aroductivitv for eaulement for the Parent operations in units per hour (enter vour formula in cell as 3 ). 4b. Compute the sinde-tactor productivity for equipment for the Subsidiary operations in units per hour (enter your formula in cell as 6 f units/hour 4c. interpet wour findines bvindicatine which of the two entities is moee productive in terms of sinde-tactor equipment productiviyin units per hour