Dixie Pizza is a successful startup that sees its demand for pizza increase quickly. For the last six months, monthly demand is shown in the table below. Using a forecast for the first month of 290, an initial trend forecast of 50, and smoothing parameters of 0.2 for demand smoothing and 0.2 for trend smoothing, forecast the demand for the next month. Month 1 2 5 6 Actual 340 410 470 540 610 680 Round your answer to two decimal places. Do not round intermediate calculations. Using alpha (a) = 0.2 and beta (3) = 0.2, what is the double exponential smoothing forecast for period 6?

Dixie Pizza is a successful startup that sees its demand for pizza increase quickly. For the last six months, monthly demand is shown in the table below. Using a forecast for the first month of 290, an initial trend forecast of 50, and smoothing parameters of 0.2 for demand smoothing and 0.2 for trend smoothing, forecast the demand for the next month. Month 1 2 5 6 Actual 340 410 470 540 610 680 Round your answer to two decimal places. Do not round intermediate calculations. Using alpha (a) = 0.2 and beta (3) = 0.2, what is the double exponential smoothing forecast for period 6?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.6: Moving Averages Models

Problem 22P: The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six...

See similar textbooks

Similar questions

Under what conditions might a firm use multiple forecasting methods?
The 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?
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?
The file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel Agency. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b?
My App is a small but growing start-up that sees demand for several of its apps increasing quickly. The table below shows the last six months of downloads. Use a forecast for the first month of 220,000, an initial trend forecast of 35,000, and smoothing parameters of 015 for both demand smoothing and trend smoothing Month (t) Monthly Application Downloads Forecast for Next Month Trend 220,000.00 35,000.00 200,000 2 250, 100 334,000 380,000 440,000 500,000 (Round your answers to 2 decimal places.) Complete the table above, filling in the "Forecast for next month" and "Trend" columns, using double a. exponential smoothing (Round your answers to 2 decimal places.) Month 7's forecast is b.
A manufacturer of printed circuit boards uses exponentialsmoothing with trend to forecast monthly demand of its product.At the end of December, the company wishes to forecast salesfor January. Th e estimate of trend through November has been200 additional boards sold per month. Average sales have beenaround 1000 units per month. Th e demand for December was1100 units. Th e company uses a 0.20 and b 0.10. Make aforecast including trend for the month of January
st Info Period 1 2 3 4 5 6 7 8 9 10 K Develop two exponential smoothing forecasts for periods 2 through 11. For the first forecast, use a = 0.3. For the second, use α = 0.7. Assume that your forecast for period 1 was 205. Click the icon to view the time series data. Find the exponential smoothing forecast for each period when a = 0.3 (enter your responses rounded to one decimal place). Demand 222 249 222 228 235 155 161 153 163 152 X Period 1 2 Demand 222 249 Forecast (α = 0.3) 205
UltraPure used two different techniques (F1 and F2) to forecast demand for cases of bottled water. Actual demand and the two sets of forecasts are in the table below. PREDICTED DEMAND Period Demand F1 F2 1 68 67 60 2 75 67 67 3 70 71 70 4 74 69 72 5 69 71 77 6 72 70 77 7 80 72 75 8 78 75 83 a. Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.) b. Compute the MSE for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.) c. Compute MAPE for each data set. Which forecast appears to be more accurate? (Round your intermediate calculations to 2 decimal places and and final answers to 2 decimal places.)
After plotting the following demand data, a manager has concluded that a trend-adjusted exponential smoothing model is appropriate to predict future demand. Period, t At Actual 1 208 2 219 3 232 4 244 5 258 6 268 7 285 8 296 9 313 10 ? Use periods 1 to 4 to estimate the initial smoothed average and trend. Use a = 0.6 and b = 0.5 to develop forecasts for periods 6 through 10. (Round your answers to 2 decimal places.) What is the forecast for period 10?(round the answer to 2 decimal places)
Below is a table containing data on product demand for the most recent five months along with the forecasts that had been made for those 5 previous months. Use the 3-period simple moving average method to forecast the number of sales to expect next month. Month Demand Forecast 1 308 341 2 388 343.3 3 344 364.7 4 400 346.7 5 341 377.3
Below is a table containing data on product demand for the most recent five months along with the forecasts that had been made for those 5 previous months. Use the exponential smoothing method to forecast the number of sales to expect next month. Use the following value of alpha: 0.2. Month Demand Forecast 1 308 349.2 388 340.9 3 344 350.3 4 400 349.1 341 359.3
Answer the following questions. 1. What is the current economic climate? 2. What should be our forecast accuracy target if there is a high degree of volatility in customer orders and long lead times? 3. We have a new chief sales officer who is proposing that we should forecast in dollars, not in units/cases. I have never heard of anyone forecasting in dollars. It is true that dollarized forecasts can help Sales in knowing precisely what sales target they should be hitting. But, is it the best practice?