Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Below is a table containing data on product demand for the most recent three months along with the forecasts that had been made for those three previous months. Calculate the MAPE.
Month | Demand | |
1 | 308 | 310 |
2 | 388 | 390 |
3 | 344 | 342 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 3 steps with 1 images
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
- 1. Which of the following is indicative of the season of heaviest demand when seasonality is measured on a quarterly basis? a. Seasonal index = .75 b. Seasonal index = 1.0 c. Seasonal index = 1.25 d. Seasonal index = 3.1 Answer: 2. The forecast calculated at the end of period t for period t+k is always the same for any value of k if the time series has systematic variability. A) True B) Falsearrow_forwarda) Apply moving average and exponential smoothing to generate two forecasts of the closing price for the entire data period. Set appropriate values for the forecast parameters (e.g., k and a). b) Plot and compare the actual and predicted data values you calculated in part (b). Provide one chart that displays actual, moving average, and exponential smoothing lines. Hint: Calculate MSE, MAD, or MAPE to compare the different forecasts. Develop your own forecast from scratch. Do NOT use Excel’s Data Analysis or Forecast Sheets.arrow_forwardPlease solve the attached question.arrow_forward
- 4. The sales (in millions of dollars) for an 18-month period are as follows. Month Sales Month Sales 1 600 600 775 10 775 3 600 11 600 4 650 12 575 700 13 625 800 14 650 550 15 600 8 775 a. Compare a three-month moving average forecast with an exponential smoothing forecast. Use a = 0.1. Which provides the better forecasts based on MSE? b. Find the forecast for the next month using the best forecast method. 2.arrow_forwardThe following represents the actual demand and two different sets of forecasts using different methods. Compute the MAD for each forecasting method and determine the best method for this set of data. Year-Qtr Actual demand Forecast methos 1 MAD1 (A-F) Forecast Method 2 MAD2 (A-F) 2020-3 98 97 89 2020-4 108 110 106 2021-1 83 68 70 2021-2 100 101 102 2021-3 95 86 87 2021-4 90 94 92 2022-1 71 68 72 2022-2 104 105 106 2022-3 84 91 88 2022-4 80 93 91 2023-1 78 68 70 2023-2 120 118 122arrow_forwardThe following data are for calculator sales in units at an electronics store over the past nine weeks: Week Sales Week Sales 1 45 53 2 50 7 59 3 44 8. 59 4 51 9 64 5 57 Use trend projection with regression to forecast sales for weeks 10 - 13. What are the error measures (CFE, MSE, o, MAD, and MAPE) for this forecasting procedure? How about ? Obtain the trend projection with regression forecast for weeks 10 – 13. (Enter your responses rounded to two decimal places.) Period Forecast, F, 10 64.81 11 67.06 12 69.31 13 71.56 Obtain the error measures. (Enter your responses rounded to two decimal places.) CFE MSE MAD МАРЕarrow_forward
- Sales for the past 6 months at Dalworth Company are given in the following table: O Month July August September October What is the Mean Absolute Deviation (MAD) for August through December forecasts produced by using exponential smoothing with a = 0.9? (Note: Do not round the forecasts, and choose the closest answer.) Multiple Choice O November December O 15.28 9.04 8.75 Sales 52 61 53 35 31 28 31.59arrow_forwardA forecast for the first six months of the year revealed a tendency to underpredict the actual demand for the revitalized Hubig’s Pies plant in the Marigny. Month Actual Forecast January 675 600 February 720 700 March 640 620 April 510 495 May 480 410 June 565 535 What is the mean squared error of this forecast? a. 1,694 b. 1,873 c. 2,075 d. 1,469arrow_forwardHere are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 315 February 418 March 390 April 430 May 400 [ June 480 July 430 August 320 September 385 October 530 November 592 555 December 300 400 350 460 390 395 355 245 340 Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent quarter 0.50, the second most recent 0.25, and the third 0.25. Do the problem using quarters, as opposed to forecasting separate months. (Round your answer to 2 decimal places.) Forecast for the fourth quarterarrow_forward
- The following table shows predicted product demand using your particular forecasting method along with the actual demand that occurred: FORECAST ACTUAL 1,480 1,530 1,380 1,480 1,680 1,580 1,730 1,780 1,630 1,680 Compute the tracking signal using the mean absolute deviation and running sum of forecast errors. Note: Negative values should be indicated by a minus sign. Round your "Mean Absolute Deviation", "Tracking Signal" to 2 decimal places and all other answers to the nearest whole number. Period Forecast Actual Deviation RSFE Absolute Deviation Sum of Absolute MAD TS Deviation 1 1,480 1,530 -50 -50 50 50 50.00 -1.00 2 1,380 1,480 -100 -150 100 150 75.00 -2.00 3 1,680 1,580 100 -50 100 250 83.33 -0.60 4 1,730 1,630 100 50 100 350 87.50 0.57 5 1,780 1,680 100 150 100 450 90.00 1.67arrow_forwardBelow is a table containing data on product demand for the most recent three months along with the forecasts that had been made for those three previous months. Calculate the MAE (or MAD). Month Demand Forecast 1 308 310 2 388 390 3 344 342arrow_forward376.98 says its wrongarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education
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
Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.