Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Question
The director of the Riley County, Kansas, library system would like to Below are the data for the past 4 weeks: a) Calculate a seasonal index for each day of the week. b) If the trend equation for this problem is y = 201. 74 + .18x, what is the forecast for each day of week 5? Round your forecast to the nearest whole number. |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps
Knowledge Booster
Similar questions
- i need this to study stop canceling my questions A check-processing center uses exponential smooth- ing to forecast the number of incoming checks each month. The number of checks received in June was 40 million, while the fore- cast was 42 million. A smoothing constant of .2 is used. a) What is the forecast for July?b) If the center received 45 million checks in July, what would be the forecast for August?c) Why might this be an inappropriate forecasting method for the situationarrow_forwardeBook Problem 6-05 Consider the following time series data. 3 16 Week 1 Week 2 Value 18 13 a. Choose the correct time series plot (1) € (!!!) Time Series Value Time Series Value 28642986420 284H2G86420 1 4 11 2 {B} 2 TH 3 Week (t) Week (t) 5 6 € (iv) Time Series Value Time Series Value 28642 NO 28642 NO 1 2 2 4 3₁ Week (t) Week (t) 5 6arrow_forward4) A small manufacturing firm has recorded a time series of the cost per unit for the firm's leading product over the past eight years. Year Cost/Unit($) 1 2 3 4 5 6 7 8 20 24.5 28.2 27.5 26.6 30 31 36 a) If you are not given a base value or trend, what would be the forecast for the year 10 made at the end of year 8 (a=0.2, ß=0.4). b) Forecast for the year 9 using 1) 5-month weighted average using 0.1,0.1,0.1,0.2,0.3, with the heaviest weight applied to the recent month 2) Exponential smoothing using a =0.2 and forecast of 21 for year 5 3) If a value was not provided in the question above, what value of a would you choose?arrow_forward
- 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 MAE (or MAD). Month Demand Forecast 1 308 310 2 388 390 3 344 342arrow_forwardGiven the table below, complete the missing cell values applying the Exponential Smoothing method of forecasting and Mean Absolute Deviation. Answer also the other 2 related questions below the table. Numbers with decimal should take 2 decimal places. Actual Quarter Tonnage Unloaded 1 2 3 4 5 6 7 8 175 160 170 160 160 170 180 200 Forecast for a=3 175 175.0 170.5 167.2 165.1 166.6 170.6 Sum of absolute deviation = Absolute Deviation for a = .3 Other questions: (1) What is the MAD for a = .3? (2) Which smoothing constant would you prefer? 0.00 15.00 0.50 10.35 4.93 13.45 29.41 80.89 Forecast for a = .6 175 166.0 168.4 163.4 161.3 166.5 174.6 Absolute Deviation for a = .6 0.00 15.00 4.00 8.40 3.36 8.66 13.46 25.38arrow_forwardProfessor Very Busy needs to allocate time next week to include time for office hours. He needs to forecast the number of students who will seek appointments. He has gathered the following data: Week 6 weeks ago 5 weeks ago 4 weeks ago 3 weeks ago 2 weeks ago Last week # Students 83 110 95 80 65 50 What is this week's forecast using trend-adjusted (double) smoothing with alpha = .5 and beta = .1, if the forecast for last week was 65, the forecast for two weeks ago was 75, and the trend estimate for last week's forecast was -5? 49.3 78.7 51.3 50.6 65.4arrow_forward
- Please answer all questions!arrow_forwardOne forecasting model was used to forecast demand for a product. The forecasts and the demand are shown in the table below. Use two decimals in your answer. Actual Forecast 1 40 41 2 35 38 3 38 35 4 33 30 The Mean Absolute Deviation (MAD) is O 0.5 2.5 O 1.48 7.01arrow_forwardA security company had to deploy guards for emergencies multiple times in the last four evenings. The numbers of emergencies for Monday, Tuesday, Wednesday, and Thursday were 7, 4, 8, and 11, respectively. What would be the security company's forecast for the number of emergencies on Friday using an exponential smoothing forecasting approach? (Use \alpha= 0.2 and a forecast for Monday of 10 emergencies)arrow_forward
- Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. MONTH ACTUAL January 120 February 145 March 146 April 171 May 154 June 182 July 138 August 135 September 146 a. Forecast April through September using a three-month moving average. b. Use simple exponential smoothing with an alpha of 0.20 to estimate April through September, using the average of January through March as the initial forecast for April. c-1. Calculate MAD for Three-month moving average and Exponential smoothing. c-2. Use MAD to decide which method produced the better forecast over the six-month period.arrow_forwardSince the beginning of the year, the purchase manager at a department store has been recording sales data to be used to compute 4-period moving averages to forecast sales for an upcoming month. Sales data for the months of January through September are reported in the table below. Month January February March April May June July August September Sales 21 20 39 22 29 14 42 28 27 Computed forecast values are not rounded. Compute the four-period moving average forecast for October. value as a whole number by rounding. Specify the Compute the mean absolute deviation (MAD) for the four-period moving average forecasts. Specify the MAD as a whole number by rounding. Compute the mean squared error (MSE) for the four-period moving average forecasts. Specify the MSE as a whole number by rounding. Compute the mean absolute percentage error (MAPE) for the four-period moving average forecasts. Specify the MAPE as a whole number by rounding. CHECK ANSWERarrow_forwardIf month one has 240,000 demands, month two 250,080 demands, month three 325,00 demands, month four 370,000 demands, month five 420,000 demands and month six 509,00 demands. Use a forecast for the first month of 240,000, an initial trend forecast of 50,000, and smoothing parameters of 0.35 for both demand smoothing and trend smoothing. Compute the forecasts and trends using double exponential smoothingarrow_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.