1. A company has the following demand data for the last three years of sales for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. A company has the following demand data for the last three years of sales for their popular product B. Month January February March April May June July August September October November December 2017 2018 2019 80 82 93 70 98 121 85 90 138 101 113 124 85 121 143 138 140 162 127 133 157 131 156 178 102 125 136 96 134 143 88 118 122 79 101 115 There are currently 5 workers assigned to the production line, each capable of producing approximately 8 units per month. It is assumed that each month has the same number of production days. They can hire more workers at a hiring and training cost of $800 per worker. If they layoff any workers, the unemployment cost is $2,000 per worker. The product has a standard production cost (labor, material, and overhead) of $300 per unit. The extra cost to produce one unit on overtime is $50 and the maximum overtime is two units per month per worker. They can use inventory but it will cost them $25 per unit per month for any unit in inventory at the end of the month. Failure to meet market demand typically will imply the customer will buy from another supplier, and therefore cost the company $100 in profit. They currently have 0 units in inventory. a. Use the demand data to develop a forecast for 2020 annual demand (month by month). What method did you use and why? [1.0] b. Use your forecast data to develop a Sales & Operation Plan that you think is the best. Discuss why you think your method is the best and discuss the pros and cons of using your method over alternative approaches (considering using the chase, level and combination strategy). [1.5] Note: there is no single correct answer. 1. A company has the following demand data for the last three years of sales for their popular product B. Month January February March April May June July August September October November December 2017 2018 2019 80 82 93 70 98 121 85 90 138 101 113 124 85 121 143 138 140 162 127 133 157 131 156 178 102 125 136 96 134 143 88 118 122 79 101 115 There are currently 5 workers assigned to the production line, each capable of producing approximately 8 units per month. It is assumed that each month has the same number of production days. They can hire more workers at a hiring and training cost of $800 per worker. If they layoff any workers, the unemployment cost is $2,000 per worker. The product has a standard production cost (labor, material, and overhead) of $300 per unit. The extra cost to produce one unit on overtime is $50 and the maximum overtime is two units per month per worker. They can use inventory but it will cost them $25 per unit per month for any unit in inventory at the end of the month. Failure to meet market demand typically will imply the customer will buy from another supplier, and therefore cost the company $100 in profit. They currently have 0 units in inventory. a. Use the demand data to develop a forecast for 2020 annual demand (month by month). What method did you use and why? [1.0] b. Use your forecast data to develop a Sales & Operation Plan that you think is the best. Discuss why you think your method is the best and discuss the pros and cons of using your method over alternative approaches (considering using the chase, level and combination strategy). [1.5] Note: there is no single correct answer.
Expert Answer:
Related Book For
Horngrens Cost Accounting A Managerial Emphasis
ISBN: 9780135628478
17th Edition
Authors: Srikant M. Datar, Madhav V. Rajan
Posted Date:
Students also viewed these mechanical engineering questions
-
Describe the development and functions of the U.S. banking system.Your answer should include, but not just be a catalog of, important legislation over time.Your answer should include the activities...
-
Abstract Aggregate production planning is a critical skill for anyone studying operations and supply chain management. Because most of the world's manufacturing occurs in China, this case takes place...
-
You think XYZ stock has potential for an upward move in price. You have no position whatsoever in the stock now. You would like to take the opportunity of any up movement in price but want to...
-
Given the data (a) Calculate (2.8) using Newtons interpolating polynomials of order 1 through 3. Choose the sequence of the points for your estimates to attain the best possible accuracy. (b) Utilize...
-
Explain how hard links and soft links differ with respective to i-node allocations.
-
An oscillator vibrating at 1250 Hz produces a sound wave that travels through an ideal gas at 325 m/s when the gas temperature is 22.0C. For a certain experiment, you need to have the same oscillator...
-
What are the principal elements in the cash flowgrowth relationship?
-
Leon Corporation has authorized 400,000 shares of $1 par value common stock, of which 320,000 are issued and 280,000 are outstanding. On May 15, the board of directors declared a cash dividend of...
-
SimpleSimon's Bakery purchases supplies on terms of 1.7 divided by 10 comma net 29 1.7/10,net29. If SimpleSimon's chooses to take the discountoffered, it must obtain a bank loan to meet itsshort-term...
-
Institutions that make loans and accept deposits are O banks O finance companies over-the-counter markets O exchanges
-
A bank offers you a loan for $10,000 within 36% APR. You will make monthly payments with a 2-year payment schedule. What is the monthly annuity payment under this schedule?
-
You can start thinking about the intersection of government and the economy in the United States by considering your everyday life. From the time you get up in the morning until you go to bed at...
-
Will technology replace middle class jobs discuss your answer with long term implications for the work force paraphrase and do t use chatgpt majorly 500 words with reference I have just 1hr for this .
-
There are three levels of efficiency under the efficient market hypothesis (EMH), namely weak form, semi-strong form and strong form. a) Describe a market anomaly that refutes the weak form of the...
-
The control panel on a spaceship contains a light that blinks every 2 . 7 6 s as observed by an astronaut in the ship. If the spaceship is moving past Earth with a speed of 0 . 7 1 3 c , determine...
-
8 Required information Part 4 of 4 Problem 6-1A (Algo) Perpetual: Alternative cost flows LO P1 [The following information applies to the questions displayed below.] 7 Warnerwoods Company uses a...
-
In each of the following independent cases, document the system using whatever technique(s) your instructor specifies. a. Dreambox Creations (www.dreamboxcreations.com/) in Diamond Bar, California,...
-
Journal entries for overhead Catherine V. Company is a small manufacturing operation producing casings for automotive batteries. During July, it manufactured 10,000 units of product and incurred the...
-
Journal entries for overhead Yalova Manufacturing Company produces lamp bases using a job order costing system. During 1993, the company completed 32,000 units of product and incurred the following...
-
(AlCPA) Under or overapplied overhead Nil Co. uses a predetermined factory overhead application rate based on direct labor cost. For the year ended December 31,1992, Nil's budgeted factory overhead...
Study smarter with the SolutionInn App