MyLab Operations Management with Pearson eText -- Access Card -- for Operations Management: Sustainability and Supply Chain Management
12th Edition
ISBN: 9780134165325
Author: Jay Heizer, Barry Render, Chuck Munson
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 4, Problem 2P
•• 4.2
- a. Plot the above data on a graph. Do you observe any trend, cycles, or random variations?
- b. Starting in year 4 and going to year 12,
forecast demand using a 3-year moving average. Plot your forecast on the same graph as the original data. - c. Starting in year 4 and going to year 12, forecast demand using a 3-year moving average with weights of .1, .3, and .6, using .6 for the most recent year. Plot this forecast on the same graph.
- d. As you compare forecasts with the original data, which seems to give the better results?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Question #2
Month
Demand
1
45
2
48
3
43
4
48
5
49
6
54
7
47
8
50
9
46
10
47
Using the table above, calculate two forecasts using the following method:-
First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 45.0 and an alpha of 0.4.
ii. Calculate the weighted moving average for periods 4 through 10, using weights of .70, .20, and .10, with 0.70 applied to the most recent data.
iii. Calculate the mean absolute deviation (MAD) for each forecasting procedure. Which forecasting procedure would you select? Why?
Questions:
1. What are some of the potential benefits of a more formalized approach to forecasting?
2. Prepare a weekly forecast for the next four weeks for each product. Briefly explain why you chose the methods you used. (Hint for product 2, a simple approach, possibly some sort of naive/intuitive approach, would be preferable to a technical approach in view of the manager's disdain of more technical methods).
Q 6
Identify two business situations where the Delphi method might be used to generate forecasts. Can you think of any difficulties and pitfalls associated with using the Delphi method?
Chapter 4 Solutions
MyLab Operations Management with Pearson eText -- Access Card -- for Operations Management: Sustainability and Supply Chain Management
Ch. 4 - What is a qualitative foretasting model, and when...Ch. 4 - Identify and briefly describe the two general...Ch. 4 - Identify the three forecasting time horizons....Ch. 4 - Briefly describe the steps that are used to...Ch. 4 - A skeptical manager asks what medium-range...Ch. 4 - Explain why such forecasting devices as moving...Ch. 4 - What is the basic difference between a weighted...Ch. 4 - What three methods are used to determine the...Ch. 4 - Research and briefly describe the Delphi...Ch. 4 - What is the primary difference between a...
Ch. 4 - Define time series.Ch. 4 - What effect does the value of the smoothing...Ch. 4 - Explain the value of seasonal indices in...Ch. 4 - Which forecasting technique can place the most...Ch. 4 - In your own words, explain adaptive forecasting.Ch. 4 - What is the purpose of a tracking signal?Ch. 4 - Explain, in your own words, the meaning of the...Ch. 4 - What is the difference between a dependent and an...Ch. 4 - Give examples of industries that are affected by...Ch. 4 - Give examples of industries in which demand...Ch. 4 - Prob. 21DQCh. 4 - Prob. 22DQCh. 4 - The following gives the number of pints of type B...Ch. 4 - 4.2 a. Plot the above data on a graph. Do you...Ch. 4 - Refer to Problem 4.2. Develop a forecast for years...Ch. 4 - A check-processing center uses exponential...Ch. 4 - The Carbondale Hospital is considering the...Ch. 4 - The monthly sales for Yazici Batteries, Inc., were...Ch. 4 - The actual demand for the patients at Omaha...Ch. 4 - Daily high temperatures in St. Louis for the last...Ch. 4 - Lenovo uses the ZX-81 chip in some of its laptop...Ch. 4 - Data collected on the yearly registrations for a...Ch. 4 - Use exponential smoothing with a smoothing...Ch. 4 - Consider the following actual and forecast demand...Ch. 4 - As you can see in the following table, demand for...Ch. 4 - Following are two weekly forecasts made by two...Ch. 4 - Refer to Solved Problem 4.1 on page 138. a. Use a...Ch. 4 - Solved example 4.1 Sales of Volkswagens popular...Ch. 4 - Refer to Solved Problem 4.1. Using smoothing...Ch. 4 - Consider the following actual (At) and forecast...Ch. 4 - Income at the architectural firm Spraggins and...Ch. 4 - Question 4.20 Resolve Problem 4.19 with =.1 and ...Ch. 4 - Question 4.21 Refer to the trend-adjusted...Ch. 4 - Question 4.22 Refer to Problem 4.21. Complete the...Ch. 4 - Question 4.23 Sales of quilt covers at Bud Baniss...Ch. 4 - Question 4.25 The following gives the number of...Ch. 4 - Prob. 25PCh. 4 - Question 4.27 George Kyparisis owns a company...Ch. 4 - Question 4.28 Attendance at Orlandos newest...Ch. 4 - Question 4.29 North Dakota Electric Company...Ch. 4 - Question 4.33 The number of internal disk drives...Ch. 4 - Dr. Lillian Fok, a New Orleans psychologist,...Ch. 4 - Emergency calls to the 911 system of Durham, North...Ch. 4 - Using the 911 call data in Problem 4.43, forecast...Ch. 4 - Question 4.47 Storrs Cycles has just started...Ch. 4 - Question 4.49 Boulanger Savings and Loan is proud...Ch. 4 - Question 4.24 Mark Gershon, owner of a musical...Ch. 4 - Lori Cook has developed the following forecasting...Ch. 4 - Prob. 45PCh. 4 - Question 4.32 The following data relate the sales...Ch. 4 - Question 4.34 The number of auto accidents in...Ch. 4 - Question 4.35 Rhonda Clark, a Slippery Rock,...Ch. 4 - Accountants at the Tucson firm, Larry Youdelman,...Ch. 4 - Sales of tablet computers at Ted Glickmans...Ch. 4 - Question 4.38 City government has collected the...Ch. 4 - Using the data in Problem 4.39, apply linear...Ch. 4 - Bus and subway ridership for the summer months in...Ch. 4 - Thirteen students entered the business program at...Ch. 4 - Question 4.48 Dave Fletcher, the general manager...Ch. 4 - The following are monthly actual and forecast...Ch. 4 - Prob. 1CSCh. 4 - Prob. 2CSCh. 4 - Prob. 3CSCh. 4 - For its first 2 decades of existence, the NBAs...Ch. 4 - For its first 2 decades of existence, the NBAs...Ch. 4 - For its first 2 decades of existence, the NBAs...Ch. 4 - For its first 2 decades of existence, the NBAs...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...
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
- Under what conditions might a firm use multiple forecasting methods?arrow_forwardQUESTION 1 The table below shows the sales figures for a brand of shoe over the last 12 months. Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150 a. Using the following, forecast the sales for the months up to January the following year:-i. A simple three month moving average. ii. A three period weighted moving average using weights of 1, 2 and 3. Assign thehighest weight to the most recent data. iii. Exponential Smoothing when α= .6 and the forecast for March is 350.iv. Determine which of the three forecasting technique is the most accurate using MADarrow_forwardQUESTION 1 Sales of Fat Lips Burgers for 2012 are shown in the table below. 1. Do the 2 month SMA forecast 2. Do 2 month WMA forecast using the information below WMA – 2: last month, 1 – last 2 months 3. For the month of January 2012, the forecast was 438. Do the EMA forecast with the smoothing constant = 0.3. What is the forecast for Jan 2013? 4. Compare the forecasts above using MAD, MSE and MAPE. Which forecast method gives the least errors? Month Actual Sales Forecast Jan 2012 438 Feb 420 March 414 Apr 318 May 306 June 240 July 240 Aug 216 Sep 198 Oct 225 Nov 270 Dec 315 Jan 2013 - QUESTION 2Dayang sells 5 kg bags of fertilizer to local farmers in Tg Karang. The sales data for the past 11 months is shown below. Month Demand (10s of bags) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 1. Find the forecast for the month 12 using the methods below: a. Simple 4 month moving average (SMA) b.…arrow_forward
- Q. 13 Weekly demand for cases of canned food at a local grocery outlet is shown. Using a 2 period moving average, what is the forecast for week 6? Group of answer choices a. 5 b. 6 c. 7 d. 8 e. 9arrow_forwardq1- Daily highs in Sacramento for the past week (from least to most recent) were: 95, 102, 101, 96, 95, 90 and 92. Develop a forecast for today using a weighted moving average, with weights of .6, .3 and .1, where the highest weights are applied to the most recent dataq2- Consider the following demand and forecast. Period Demand Forecast 1 7 10 2 12 15 3 18 20 4 22 If MAD = 2, what is the forecast for period 4? Answer 21 22 23 none of the aboveq3- A normal distribution has a mean of 500 and a standard deviation of 50. A manager wants to simulate one value from this distribution, and has drawn the number 1.4 randomly. What is the simulated value?Q4- The local operations manager for the IRS must decide whether to hire 1, 2, or 3 temporary workers. He estimates that net revenues will vary with how well taxpayers comply with the new tax code. The following payoff table is given in thousands of dollars (e.g. 50 = $50,000). If he thinks the chances of low, medium, and high compliance are…arrow_forwardQUESTION ONE (b) The forecast of a product for the first week of January was 200 units, whereas the actual demand turned out to be 220 units. i. Find the forecast for the week of January assuming the smoothing constant 0.2 α = ii. Find the forecast for the third week of third week of January if the actual demand of the second week is 210 unitsarrow_forward
- Q: Using exponential smoothing with a weight ex of 0.6 on actual values: (a) if sales are $45,000 and $50,000 for 2010 and 2011, what would you forecast for 2012? (b) given this forecast and actual 2012 sales of $53,000, what would you then forecast for 20013? (a) (b)arrow_forwardQUESTION 1The table below shows the sales figures for a brand of shoe over the last 12 months.Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150a. Using the following, forecast the sales for the months up to January the following year:-i. A simple three month moving average. ii. A three period weighted moving average using weights of 1, 2 and 3. Assign thehighest weight to the most recent data. iii. Exponential Smoothing when α= .6 and the forecast for March is 350.iv. Determine which of the three forecasting technique is the most accurate usingMAD. b. The following table shows the number of televisions sold over the last ten years at alocal electronic store.YEAR TV SALES1 1502 3003 4804 6005 6306 6407 7008 8259 90010 980i. Using trend projection, develop a formula to predict sales for years 11 and 12. Youhave to show all working. You will need to develop a table to calculate the slope andthe intercept.…arrow_forwardQUESTION 1The table below shows the sales figures for a brand of shoe over the last 12 months. Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150 a. Using the following, forecast the sales for the months up to January the following year:- ii. A three period weighted moving average using weights of 1, 2 and 3. Assign thehighest weight to the most recent data.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
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
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