Concept explainers
a.
To calculate:The one-step forecasts for February through May with the use of exponential smoothing.
Introduction:Exponential smoothing of time series involves assigning datain exponentially decreasing weights fromlatest to oldest observations. Simply by putting the older data, less priority is given to the data. The newer data becomes more relevant to which more weight is assigned.
b.
To calculate:The difference in forecasts if value of
Introduction: Exponential smoothing of time series involves assigning datain exponentially decreasing weights from latest to oldest observations. Simply by putting the older data, less priority is given to the data. The newer data becomes more relevant to which more weight is assigned.
c.
To calculate: The MSEs for the forecasts obtained in parts ( a ) and ( b ) for February through April and to find out the more accurate forecasts for the value of
Introduction: Exponential smoothing of time series involves assigning datain exponentially decreasing weights from latest to oldest observations. Simply by putting the older data, less priority is given to the data. The newer data becomes more relevant to which more weight is assigned.
Want to see the full answer?
Check out a sample textbook solutionChapter 2 Solutions
Production and Operations Analysis, Seventh Edition
- 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_forwardThe Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?arrow_forward
- The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?arrow_forwarda. What is the mean square error for time periods 2 through 4 using the average forecasting method? b. What is the mean absolute error for time periods 2 through 4 using the average forecasting method? c. What is the mean absolute percentage error for time period 2 through 4 using the average forecasting method? Round all answers to two decimal places. Time Period 1 2 3 4 Mean absolute error (MAE) Mean squared error (MSE) Mean absolute percentage error (MAPE) Electric Bill 510 315 420 480 Average Forecast Forecast Errorarrow_forwardplease answer in excel Jean’s Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that she can schedule the personnel. The manager uses α = 0.3 for exponential smoothing, and the forecast for the first week was 24 calls. The manager also uses 3 weekly moving averages technique. a) Using 3 period moving averages, forecast the number of calls for week 7. b) Using exponential smoothing, forecast the number of calls for week 7. c) Compare these two forecasting techniques using Mean Squared Errors (MSE) measure. Which one is better?arrow_forward
- 9) 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_forwardAt the ABC Floral Shop, an argument developed between two of the owners, Bob and Henry, over the accuracy of forecasting methods. Bob argued that exponential smoothing with α = .1 would be the best method. Henry argued that the shop would get a better forecast with α = .3.a. Using F1 = 100 and the data from problem 3, which of the two managers is right?b. Graph the two forecasts and the original data using Excel. What does the graph reveal?c. Maybe forecast accuracy could be improved. Try additional values of α = .2, .4, and .5 to see if better accuracy is achieved.arrow_forwardExplain 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 violatesarrow_forward
- Please do not give solution in image format thanku 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 1 2 3 4 5 6 7 8 Cost/Unit ($) 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 (α=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 α =0.2 and forecast of 21 for year 5 3) If α value was not provided in the question above, what value of α would you choose?arrow_forwardYou discovered that the forecasting error falls beyond the acceptable ranges in the past three years. Make a reliable forecast for the demand on your product/service using at least 10 periods of your historical data to forecast the demand for the coming 5 periods. Then compute the MAD for these 5 periods . Period Actual (A) Forecast (F) (A-F) Error 1 107 110 -3 2 125 121 4 3 115 112 3 4 118 120 -2 5 108 109 1 6 118 120 -2 7 108 109 1 8 115 112 -3 9 140 137 -3 10 106 102 -4arrow_forwardThe accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c. a. Use Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smoothing constant of 0.3. Complete the exponential smoothing forecast model for stock A. (Type integers or decimals rounded to two decimal places as needed.) Date Forecast A 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…arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage LearningMarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing