M05 Instructions Download the MO5 _Template.xlsx. You must use this template. Put your Name and the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
M05 Instructions Download the MO5 _Template.xlsx. You must use this template. Put your Name and the Stevens Pledge in the spaces provided. Part I: Installation Repair Warranty Assurance 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 ? 50% 25% 25% Labor Hours per Service 5 3 4 Supply Costs Per Service 1470 $55 $110 $165 STEVENS INSTITUTE of TECHNOLOGY THE INNOVATION UNIVERSITY 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. Part II: Answer the questions on the Questions tab/worksheet. 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. Name(s): Pledge: Installation Repair Warranty Assurance Labor Hours Per Service: Supply Costs Per Service: Month 1 Month 2 Month 3 Service Mix 50% 25% 25%9 Labor Hours Supply Costs per Service Per Service 5 3 Sales Forecast Month $55 $110 $165 Total Labor Total Supply Hours for the Costs for the Month 1) Define Sales and Operation Planning (Aggregate Planning) 2) What are the TWO main approaches to aggregate planning called? 3) In general, under what conditions might a firm favor a level production plan over a chase plan? When might a firm prefer a chase production plan over a level plan? M05 Instructions Download the MO5 _Template.xlsx. You must use this template. Put your Name and the Stevens Pledge in the spaces provided. Part I: Installation Repair Warranty Assurance 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 ? 50% 25% 25% Labor Hours per Service 5 3 4 Supply Costs Per Service 1470 $55 $110 $165 STEVENS INSTITUTE of TECHNOLOGY THE INNOVATION UNIVERSITY 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. Part II: Answer the questions on the Questions tab/worksheet. 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. Name(s): Pledge: Installation Repair Warranty Assurance Labor Hours Per Service: Supply Costs Per Service: Month 1 Month 2 Month 3 Service Mix 50% 25% 25%9 Labor Hours Supply Costs per Service Per Service 5 3 Sales Forecast Month $55 $110 $165 Total Labor Total Supply Hours for the Costs for the Month 1) Define Sales and Operation Planning (Aggregate Planning) 2) What are the TWO main approaches to aggregate planning called? 3) In general, under what conditions might a firm favor a level production plan over a chase plan? When might a firm prefer a chase production plan over a level plan?
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
VCI/Ellison, which represents the consolidation of the heavy transportation equipment units of two previously separate and regional companies, is facing worldwide pricing pressures from customers and...
-
Figure shows a cycle consisting of five paths: AB is isothermal at 300 K, BC is adiabatic with work = 5.0 J, CD is at a constant pressure of 5 atm, D E is isothermal, and EA is adiabatic with a...
-
The completed work sheet for Valerie Insurance Agency as of December 31 is presented in your Working Papers or in CengageNow, along with the general ledger as of December 31 before adjustments....
-
The exponential function E 1 t 2 = 2 10 2 t approximates the number of bacteria in a certain culture after t hours. a) The initial number of bacteria is determined when t = 0. What is the initial...
-
An experiment is performed to compare the rotational speed of two conveyers, Conveyer \(X\) and Conveyer \(Y\). 30 belts are loaded with an optimal weight, each is put on one of the conveyers, and...
-
Rancho Mortgage, Inc., is planning a new advertising campaign designed to attract homebuyers in a difficult economic environment. Rancho wants to promote its new loan product, which offers a fixed...
-
Throughout the course, have learned about various concepts in international finance. This assignment provides an opportunity for you to apply those concepts and reflect on important topics in...
-
A farmer notices an algae bloom in the pond next to a large crop field. This farmer knows that algae blooms are generally caused by increased nitrogen in the water. What should this farmer check to...
-
You have just recently been appointed the companys Chief Purchasing Officer. You will oversee a company with worldwide operations located at 55 buying locations. Your organization has five major...
-
Company A will pay no dividen for its stock over 5 years. The company then will pay $7 per share in year 6 and then increase dividend 8% per year thereafter. If the required return rate is 11%, what...
-
On January 1, Year 4, Dean purchased all of Kay's $10 par, voting common stock for $600,000. On that date, the fair values of Kay's assets and liabilities equaled their carrying amounts of $660,000...
-
Simplify. w w +7w+12 6w-96
-
Following are the draft balance sheets (summarized) of Delta Limited (DL), a listed company, and its subsidiaries Gamma Limited (GL) and Sigma Limited (SL) as at 31 December 2013: Non-current assets...
-
Find a . b. a = 4i + j, bi- 3j+k
-
Question 20 The relationship between services and providers is much stronger than that between products and producers. True False
-
What steps must a business take to implement a program of social responsibility?
-
Rebecca and Walter Bunge have been married for 5 years. They live at 883 Scrub Brush Street, Apt. 52B, Las Vegas, NV 89125. Rebecca is a homemaker and Walt is a high school teacher. Rebecca's Social...
-
Larry Gaines, age 42, sells his personal residence on November 12, 2012, for $144,000. He lived in the house for 7 years. The expenses of the sale are $10,500, and he has made capital improvements of...
-
Bea Jones (age 32) moved from Texas to Florida in December 2011. She lives at 654 Ocean Way, Gulfport, FL 33707. Bea's Social Security number is 466-78-7359 and she is single. Her earnings and income...
-
A rationale for the use of the price-to-sales (P/S) approach is: a. Sales are more volatile than earnings. b. P/S ratios assess cost structures accurately. c. Revenues are less subject to accounting...
-
Consider a company that earned \($4.00\) per share last year and paid a dividend of \($1.00.\) The firm has maintained a consistent payout ratio over the years and analysts expect this to continue....
-
A cyclical company tends to a. have earnings that track the overall economy. b. have a high price-to-earnings ratio. c. have less volatile earnings than the overall market.
Study smarter with the SolutionInn App