Gen Combo Looseleaf Operations Management In Supply Chain; Connect Access Card
7th Edition
ISBN: 9781260149647
Author: Roger G Schroeder, M. Johnny Rungtusanatham, Susan Meyer Goldstein
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 10, Problem 5P
5-The Yummy Ice Cream Company uses the exponential smoothing method. Last week the
- a. Using a α = .1, prepare a forecut for next week.
- b. Calculate the forecast using a α = .2 and a α = .3. Which value of a gives the best forecast, assuming actual demand is 95,000 gallons?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Al Maha Plastic manufacturing Companies last Six weekly values of Sales were 90, 110, 115, 135, 140, 150 and 160 units. Forecasts (same for all the six weeks) were 110 units for all the weeks. Calculate MAD, and Tracking Signal for these six weeks.
Wee k
Actual Sales
Forecaste d Sale
Error
Cumulative Error
Absolute Error
Cumulative Absolute Error
MAD
Tracking Signal
1
2
3
4
5
6
7
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)
Weekly demand for an item averaged 100 units over the past year. Actual demand forthe next eight weeks is shown in what follows:a. Plot the data on graph paper.b. Letting a = 0.25, calculate the smoothed forecast for each week.c. Comment on how well the forecast is tracking actual demand. Is it lagging or leading actual demand?
Chapter 10 Solutions
Gen Combo Looseleaf Operations Management In Supply Chain; Connect Access Card
Ch. 10.S - Ace Hardware sells spare parts for lawn mowers....Ch. 10.S - eXcel The daily demand for chocolate donuts from...Ch. 10.S - The SureGrip Tire Company produces tires of...Ch. 10.S - eXcelManagement believes there is a seasonal...Ch. 10.S - Management of the ABC Floral Shop believes that...Ch. 10 - Prob. 1DQCh. 10 - What is the distinction between forecasting and...Ch. 10 - Qualitative forecasting methods should be used...Ch. 10 - Describe the uses of qualitative, time-series, and...Ch. 10 - Qualitative forecasts and causal forecasts are not...
Ch. 10 - Prob. 6DQCh. 10 - What are the advantages of exponential smoothing...Ch. 10 - How should the choice of be made for exponential...Ch. 10 - Prob. 9DQCh. 10 - Prob. 10DQCh. 10 - Explain how CPFR can be used to reduce forecasting...Ch. 10 - Under what circumstances might CPFR be useful, and...Ch. 10 - Daily demand for marigold flowers at a large...Ch. 10 - The number of daily calls for the repair of Speedy...Ch. 10 - 3-The ABC Floral Shop sold the following number of...Ch. 10 - The Handy Dandy Department Store had forecast...Ch. 10 - 5-The Yummy Ice Cream Company uses the exponential...Ch. 10 - Using the data in problem 2, prepare exponentially...Ch. 10 - Compute the errors of bias and absolute deviation...Ch. 10 - eXcel At the ABC Floral Shop, an argument...Ch. 10 - Only a portion of the following table for...Ch. 10 - A candy store has sold the following number of...Ch. 10 - eXcel A grocery store sells the following number...Ch. 10 - Prob. 12PCh. 10 - The Easyfit tire store had demand for tires shown...Ch. 10 - Prob. 14P
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
- Under what conditions might a firm use multiple forecasting methods?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. 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_forward
- 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. What does the Institute of Supply Management code of ethics say about financial conflicts of interest?arrow_forwarda. What do we mean by forecast?b. Can a forecast have an error? Justify your answer.arrow_forwardUsing exponential smoothing with a weight of 0.6 on actual values: (a) If sales are $45,000 and $50,000 for 2017 and 2018, what would you forecast for 2019. (The first forecast is equal to the actual value of the preceding year) (b) Given the forecast and actual 2019 sales of $53,000, what would you forecast for 2020arrow_forward
- Indicate how and why each of these factors is important to thesuccessful operation of a supermarket:b. Forecastingarrow_forwardChapter 14 1. How would you conduct a trend analysis? Provide an example. 2. Explain the three different source of information and forecast assumptions. Chapter 15 3. Explain the four common uses of comparisons that the manager will find helpful. Chapter 16 4. Explain the importance of assumptions when building a budget? Chapter 17 5. Explain the rationale for replacing existing equipment with new equipment.arrow_forwardTh e manager of a small health clinic would like to useexponential smoothing to forecast demand for laboratory servicesin the facility. However, she is not sure whether to use a high orlow value of α . To make her decision, she would like to comparethe forecast accuracy of a high and low α on historical data. Shehas decided to use an α = 0.7 for the high value and α = 0.1 forthe low value. Given the following historical data, which do youthink would be better to use? Week Demand (lab requirements)1 3302 3503 3204 3705 3686 343arrow_forward
- 5. (a) When a new business is started, or a patent idea needs funding, venture capitalists or investment bankers will want to see a business plan that includes forecast information related to a profit and loss statement. What type of forecasting information do you suppose would be required? (b) A picnic spot is open on Thursday, Friday and Saturday. The manager hopes to improve resource availability and scheduling of part-time employees by forecasting visitors in the next week. Data on visitors of the recent 5 weeks at the spot has been found. On Saturday, Thursday, and Friday there were 182. 95, and 280 in week 1; 197, 105, and 295 in week2; 178, 92, and 275 in week 3; 210, 109, and 305 in week 4; and 192, 100. and 284 in week 5. i. Find seasonal relatives of the days. ii. Forecast number of visitors in the resort for week 6 and that is for the days of week 6.arrow_forwardForecast Including TrendAssume a previous forecast, including a trend of 110 units, a previous trend estimate of 10 units, an alpha of .20, and a delta of .30. If actual demand turned out to be 115 rather than the forecast 110, calculate the forecast for the next period.arrow_forwardMSE answer for part a = 5.95 is incorrect. Please do recalculations with the correct answer. also the rest of the question was not answered so here it is: Use ? = 0.2 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (Round your answer to two decimal places.) Use ? = 0.4 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage LearningMarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational PublishingPurchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher: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
Forecasting 2: Forecasting Types & Qualitative methods; Author: Adapala Academy & IES GS for Exams;https://www.youtube.com/watch?v=npWni9K6Z_g;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License