OPERATIONS MANAGEMENT IN THE SUPPLY CHAIN: DECISIONS & CASES (Mcgraw-hill Series Operations and Decision Sciences)
7th Edition
ISBN: 9780077835439
Author: Roger G Schroeder, M. Johnny Rungtusanatham, Susan Meyer Goldstein
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 11, Problem 10P
eXcel 10. The Ban go Toy Company produces several types of toys to seasonal demand. The
A regular employee can produce $10,000 worth of toys per month, and the company has so regular employees at the end of June. Regular-time employees are paid $3800 per month, including benefits. An employee on overtime produces at the same rate as on regular time but is paid at 150 percent of the regular pay. Up to 20 percent overtime can be used in anyone month. A worker can be hired for $1000, and it costs $2000 to layoff an employee. Inventory carrying costs are 30 percent per year. The company wishes to end the year with so employees. Beginning inventory of toys is $900,000.
- a. Calculate the cost of a chase strategy.
- b. Calculate the cost of a level strategy.
- c. Using the Excel template, simulate several other strategies.
- d. Determine the effect on the chase strategy, in part a, of changing the hiring cost to $ 1500, $2000, and $2500. What do these changes suggest the relationship is between hiring cost and total cost?
- e. Use the Excel template to study the effect of demand changes on the total cost of the chase strategy. Assume various percentage increases and decreases in demand (110 percent, 120 percent, 210 percent, 220 percent, etc.).
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The Yeasty Brewing Company Produces a popular local beer known as Iron Stomach.
Beer sales are somewhat seasonal, and Yeasty is planning its production and workforce
levels on March 31 for the next six months. The demand forecasts are as follows:
Month
April
May
June
July
August
September
Production
Days
14
20
24
26
20
18
Forecasted Demand
(in hundreds of cases)
75
100
200
140
100
50
As of March 31, Yeasty had 70 workers on the payroll. Over a period of 20 working days
when there are 100 workers on the pay roll, Yeasty produced 10,000 cases of beer. The
cost to hire each worker is $200 and the cost of laying off each worker is $400. Holding
costs amount to 1 dollar per case per month.
As of March 31, Yeasty expects to have 3,000 cases of beer in stock. It plans to start
October with 3,500 cases on hand.
a) Formulate the problem of planning Yeasty's production levels as a linear
program.
b) Use Excel solver to solve the problem and give the solution (decision variables
and objective…
Short term forecast can be
used for the following
operation.
O a. Planning new facility
O b. Preparing daily worker
schedule
O c. Introducing new
product
O d. Purchasing new
equipment
PROVER S.A., one of the companies that supplies PRECISIÓN S.A. with raw materials. has asked you to formulate an aggregate plan for them. The forecast demand of your customers for each period of the next planning horizon isMonth 1 2 3 4Demand 10000 13500 11200 12000
It is considered that each worker can produce 500 units/month in normal hours and 100 units/month in overtime. The company has 20 employees and due to the high level of training required, it cannot hire anyone and cannot subcontract part of the production to another company. There is no beginning inventory.
The cost for salaries and benefits in regular time is $1,000 per worker, per month. Overtime is paid 50% more than regular time. The cost of firing someone is $2,000. It costs 6 cents per month to hold a unit in inventory.
8. Define, in the Excel provided, a feasible aggregate plan for this company. Define a plan Feasible, it does not have to be the best or the least cost. It simply has…
Chapter 11 Solutions
OPERATIONS MANAGEMENT IN THE SUPPLY CHAIN: DECISIONS & CASES (Mcgraw-hill Series Operations and Decision Sciences)
Ch. 11 - Prob. 1DQCh. 11 - Prob. 2DQCh. 11 - A school district has forecast student enrollment...Ch. 11 - Prob. 4DQCh. 11 - Prob. 5DQCh. 11 - SOP or aggregate planning sometimes is confused...Ch. 11 - The XYZ Company manufactures a seasonal product....Ch. 11 - Prob. 8DQCh. 11 - Every firm has multiple objectives such as good...Ch. 11 - Prob. 10DQ
Ch. 11 - Prob. 11DQCh. 11 - Suppose we are considering the question of how...Ch. 11 - The Ace Steel Mill estimates the demand for steel...Ch. 11 - A barbershop has the following demand for haircuts...Ch. 11 - Prob. 4PCh. 11 - Prob. 5PCh. 11 - eXcel The Chewy Candy Company would like to...Ch. 11 - A company produces to a seasonal demand, with the...Ch. 11 - Prob. 8PCh. 11 - Question: 9. The Restwell Motel in Orlando,...Ch. 11 - eXcel 10. The Ban go Toy Company produces several...Ch. 11 - A small textile company makes several types of...Ch. 11 - Valley View Hospital faces somewhat seasonal...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. Ethical decisions that affect a buyers ethical perspective usually involve the organizational environment, cultural environment, personal environment, and industry environment. Analyze this scenario using these four variables.arrow_forwardScenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What should Sharon do in this situation?arrow_forwardScenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What does the Institute of Supply Management code of ethics say about financial conflicts of interest?arrow_forward
- China effectively shuts down for two weeks each year and celebrates the lunar new year. How does that resemble (or not) peak season in Western countries?arrow_forwardThe Yeasty Brewing Company Produces a popular local beer known as Iron Stomach. Beer sales are somewhat seasonal, and Yeasty is planning its production and workforce levels on March 31 for the next six months. The demand forecasts are as follows: month production days demand(in hundred of cases) April 14 75 May 20 100 June 24 200 July 26 140 August 20 100 September 18 50 As of March 31, Yeasty had 70 workers on the payroll. Over a period of 20 working days when there are 100 workers on the pay roll, Yeasty produced 10,000 cases of beer. The cost to hire each worker is $200 and the cost of laying off each worker is $400. Holding costs amount to 1 dollar per case per month. As of March 31, Yeasty expects to have 3,000 cases of beer in stock. It plans to start October with 3,500 cases on hand. a) Formulate the problem of planning Yeasty’s production levels as a linear program. b) Use Excel solver to solve the problem and give the solution (decision variables and…arrow_forwardThe table below shows the sales of widgets (in units) over the past 5 years. Using exponential smoothing with a smoothing constant of 0.2, what is the forecast for next year? The initial forecast (for 5 years ago) was 1,200 units. Forecast: Time Sales 5 years ago 1,140 4 years ago 1,220 3 years ago 1,450 2 years ago 1,090 Last year 1,150 (Do not round intermediate calculations, round your final answer to the nearest whole number.)arrow_forward
- 8.11 The average demand for January has been 80, and the average annual demand has been 1800. Calculate the seasonal index for January. If the company forecasts annual demand next year at 2000 units, what is the forecast for January next year?arrow_forwardGreenfield Equipment is performing demand forecasting. Actual demand for Week 1 – 550, Week 2 – 490, Week 3 – 560, week 4 – 435, and Week 5 – 656. You have been asked to perform exponential smoothing with a delta of 0.3. Week 5 forecast was 519. What is week 6 forecast? Provide answer rounded to 1 decimal place.arrow_forwardA company evaluate its hiring cost is RM150 per worker and layoff cost is RM200 per worker. Currently the company has 20 workers and based on forecast demand, the actual workers required to meet January demand is 25 workers. Calculate the hiring cost or layoff cost for that month. * O RM750 O RM350 O RM250 O RM1,000arrow_forward
- Zhu Manufacturing is considering the Introduction of a family of new products. Long-term demand for the product group is somewhat predictable, so the manufacturer must be concemed with the risk of choosing a process that is inappropriate. Faye Zhu is VP of operations. She can choose among batch manufacturing or custom manufacturing, or she can invest in group technology, Zhu won't be able to forecast demand accurately until after she makes the process choice. Demand will be classified into four compartments: poor, fair, good, and excellebt The table below indicates the payoffs (profits) associated with each processidemand combination, as well as the probabilities of each long-term demand level: Demand Poor Fair Good Excellent Probability Batch Custom 0.15 0.40 -$300,000 $100,000 $1,200,000 $800,000 $400,000 $00,000 0.30 $1,200,000 $750,000 $500,000 0.15 $1,300,000 $800,000 $2,200,000 Group technology a) The alternative that provides Zhu the greatest expected monetary value (EMV) is…arrow_forwardExplain basic concepts of forecasting and time series. Explain the concept of capacity. Describe how to compute and use capacity measures. Describe long-term capacity expansion strategies. Describe short-term capacity adjustment strategies.arrow_forwardHickory Manufacturing Company forecasts the following demand for a product (in thousands of units) over the next five years. Year Forecast Demand 1 60 2 79 3 81 4 5 84 84 Currently the manufacturer has seven machines that operate on a two-shift (eight hours each) basis. Twenty days per year are available for scheduled maintenance of equipment with no process output. Assume there are 250 workdays in a year. Each manufactured good takes 25 minutes to produce. a. What is the effective capacity of the factory? b. Given the five-year forecast, how much extra capacity is needed each year? c. Does the firm need to buy more machines? If so, how many? When?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Management, Loose-Leaf VersionManagementISBN:9781305969308Author:Richard L. DaftPublisher:South-Western College Pub
MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Management, Loose-Leaf Version
Management
ISBN:9781305969308
Author:Richard L. Daft
Publisher:South-Western College Pub
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Introduction to Forecasting; Author: Ekeeda;https://www.youtube.com/watch?v=5eIbVXrJL7k;License: Standard YouTube License, CC-BY