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
Videos
Textbook Question
Chapter 10, Problem 3P
3-The ABC Floral Shop sold the following number of geraniums during the last two weeks:
| Day | Demand | Day | Demand |
| 1 | 200 | 8 | 154 |
| 2 | 134 | 9 | 182 |
| 3 | 147 | 10 | 197 |
| 4 | 165 | 11 | 132 |
| 5 | 183 | 12 | 163 |
| 6 | 125 | 13 | 157 |
| 7 | 146 | 14 | 169 |
Develop a spreadsheet for the following.
- a. Calculate
forecasts using a three- and five-period moving average. - b. Graph these forecasts and the original data using Excel. What does the graph show?
- c. Which of the above forecasts is best? Why?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Explain the trade-off between responsiveness and stability in a forecasting system that uses time-series data.
Who needs to be involved in preparing forecasts? 3. How has technology had an impact on forecasting?
What capability would an organization have to have to not need forecasts?
Give three examples of unethical conduct involving forecasting and the ethical principle each violates
3. A large Portland manufacturing would like to forecast the monthly demand for a piece of pollutioncontrol equipment. Suppose the monthly sales figures for the past five months have been as follows:Month 1 2 3 4 5Actual Demand 14 17 20 21 25a. Make a forecast for 6th month using a three-period moving average (MA). What would be the forecastfor 6th month?b. The manager would like to use simple exponential smoothing to forecast. Use alpha = 0.25. Whatwould be the forecast for 6th month?c. Find the better forecast out of Moving Average and Simple Exponential Smoothing
4
.Substitute for Problem # 4 on in attachment)-Calculate the MAD,revised MAD and the Revised Forecast for months 1-6 for the following three groups,where the Forecast stands for Forecast Demand.Has your forecast improved ? Tell me how would you go about improving the revised forecast( for each of the three groups)without actually doing so?
Estate Planning Group Auditing and Accounting Group Business Consulting Group
Month Actual Demand Forecast Actual Demand Forecast Actual Demand Forecast
1 100 125 270 230 140 135
2 90 125 240 230 130 135
3 110 125 280 230 160 135
4 115 125 260 230 180 135
5 130 125 300 230 200 135
6 115 125 220 230 190 135
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_forwardThe file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.arrow_forwardPls help me it mathematics for economics Problem 1: Sheet 1 a) Find on the Internet a time series, which contains at least 20 entries. Provide a short description of this time series. Also provide a link to that data set. b) Perform 2 different suitable forecast methods for the next time period. c) Compare 2 forecast methods using mean square error (MSE).arrow_forward
- MSE 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_forward9) Gasoline sales Times Series week sales (1000s of gallons 1 17 2 21 3 19 4 23 5 18 6 16 7 20 8 18 9 22 10 20 11 15 12 22 With the above gasoline time series data, show the exponential smoothing forecast using alpha = 0.1 i)Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of Alpha= 0.1 or alpha=0.2 for the gasoline sales time series? ii)Are the results the same if you apply MAE as the measure of accuracy? iii)What are the results if MAPE is used?arrow_forwardCorporate triple-A bond interest rates for 12 consecutive months follow. Month 1 2 3 4 5 6 7 8 9 10 11 12 Value 9.5 9.3 9.4 9.6 9.8 9.7 9.8 10.5 9.9 9.7 9.6 9.6 a. Construct a time series plot. What type of pattern exists in the data? b. Develop the three-month moving averages for this time series. Compute MSE. c. Compute MAE. d. Compute MAPE. e. What is the three-month moving average forecast for the next month (month 13)?arrow_forward
- Th 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_forwardFollowing are two weekly forecasts made by two different methods for the number of gallons of gasoline, in thousands, demanded at a local gasoline station. Also shown are actual demand levels, in thousands of gallons: Week Forecast Method 1 Actual Demand 1 0.95 0.72 2 1.08 0.98 3 0.92 1.07 4 1.17 1.04 Week Forecast Method 2 Actual Demand 1 0.80 0.72 2 1.21 0.98 3 0.88 1.07 4 1.17 1.04 Part 2 The MAD for Method 1 = enter your response here thousand gallons (round your response to three decimal places).arrow_forwardSlide 6: Forecast• Describe the forecasting methods used by Walmart to anticipate demand for resources.• Highlight the importance of having accurate forecasts in the company's operations.7. Slide 7: Inventory Control• Evaluate Walmart Company's inventory control practices, including the techniques usedto manage and control inventory levels.• Discuss how having inventory control impacts company operations and customer satisfaction.arrow_forward
- The following data show the number of liters of gasoline sold by Mackrin's in Colorado for the past 12 weeks. Which forecasting model would you recommend to Mackrin's manager? Why? What demand forecast would you recommend for week 13? Week Actual Demand (1000 liters) Forecasting (1000 liters) FSMA /A-F/ FWMA /A-F/ FES, α=0.3 /A-F/ 1 17 2 21 17 4 3 19 18.2 0.8 4 23 19 4 18.44 4.56 5 18 21 3 20.8 2.8 19.81 1.81 6 16 20 4 20 4 19.3 3.3 7 20 19 1 18.3 2.3 18.31 1.69 8 18 18 0 18.7 0.7 18.82 0.82 9 22 18 4 18.2 4.2 18.6 3.4 10 20 20 0 19.8 0.2 19.62 0.38 11 15 20 5 20.2 5.2 19.73 4.73 12 22 19 3 18.2 3.8 18.3 3.7 13 19 19.5 19.41 MAD 2.67 2.9 2.7 MSE 10.22…arrow_forward4, The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c. Complete the exponential smoothing forecast model for stock B. (Type integers or decimals rounded to two decimal places as needed.) Date Forecast B 09/03/2010 09/07/2010 enter your response here 09/08/2010 enter your response here 09/09/2010 enter your response here 09/10/2010 enter your response here 09/13/2010 enter your response here 09/14/2010 enter your response here 09/15/2010 enter your response here 09/16/2010 enter your response here 09/17/2010 enter your response here 09/20/2010 enter your response here 09/21/2010 enter your response here Date A B C D Stock Exchange 09/03/2010 127.07 18.54 20.84 15.44 10,536.56 09/07/2010 124.84 18.21 20.45 15.55 10,245.77 09/08/2010 125.67 17.77 20.83 15.72…arrow_forwardFollowing are two weekly forecasts made by two different methods for the number of gallons of gasoline, in thousands, demanded at a local gasoline station. Also shown are actual demand levels, in thousands of gallons: Week Forecast Method 1 Actual Demand 1 0.90 0.70 2 1.05 1.00 3 0.95 1.00 4 1.20 1.00 Week Forecast Method 2 Actual Demand 1 0.80 0.70 2 1.20 1.00 3 0.90 1.00 4 1.11 1.00 The MAD for Method 1 = nothing thousand gallons (round your response to three decimal places).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,
Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage Learning
MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
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
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