An internet company performs three services: Installation, Repair and Warranty Assurance. The Table below shows the service mix as well as the labor hours and supply costs associated with each type of service. Service Mix Labor Hours per Service Supply Costs Per Service Installation 50% 5 $55 Repair 25% 3 $110 Warranty Assurance 25% 4 $165 The service mix is the same from one month to the next. As a result, the company can use a single set of planning values based on the weighted averages of labor hours and supply cost. Calculate these values per service. Labor Hours Per Service ? Supply Costs Per Service ? The company expects the total services for the next three months to be 160, 148 and 180, respectively. With this service forecast and the planning values above, calculate the estimated labor hours and supply costs for each of the next three months in the cells provided. You MUST use formulas, not numbers in each answer cell. Part II: Answer the questions on the Questions tab/worksheet.

An internet company performs three services: Installation, Repair and Warranty Assurance. The Table below shows the service mix as well as the labor hours and supply costs associated with each type of service. The service mix is the same from one month to the next. As a result, the company can use a single set of planning values based on the weighted averages of labor hours and supply cost. Calculate these values per service. Labor Hours Per Service? Supply Costs Per Service ? The company expects the total services for the next three months to be 160,148 and 180 , respectively. With this service forecast and the planning values above, calculate the estimated labor hours and supply costs for each of the next three months in the cells provided. You MUST use formulas, not numbers in each answer cell. An internet company performs three services: Installation, Repair and Warranty Assurance. The Table below shows the service mix as well as the labor hours and supply costs associated with each type of service. The service mix is the same from one month to the next. As a result, the company can use a single set of planning values based on the weighted averages of labor hours and supply cost. Calculate these values per service. Labor Hours Per Service? Supply Costs Per Service ? The company expects the total services for the next three months to be 160,148 and 180 , respectively. With this service forecast and the planning values above, calculate the estimated labor hours and supply costs for each of the next three months in the cells provided. You MUST use formulas, not numbers in each answer cell