1. Business
  2. Operations Management
  3. question 12 twenty days of demand data have been provided...

Question: question 12 twenty days of demand data have been provided...

Question details

Question 12: Twenty days of demand data have been provided in the Excel worksheet, as well as a first forecast for day two. Please build an exponential smoothing forecasting model that will compute forecasts for days 3 to 21, and report your forecast for day 21 (to two decimal places).

QUESTION 12 Twenty days of demand data have been provided in the Excel worksheet, as well as a first forecast for day two. Please build an exponential smoothing forecasting model that will compute forecasts for days 3 to 21, and report your forecast for day 21 (to two decimal places) Workbook

F-12-4 AutoSave OFF U Home Insert Page Layout Formulas Data Review View General Calibri (Body) Paste H15 alpha 0.55 Day (t) Demand (D,) Forecast (F.) 1420 1418 1420.00 1436 1441 1441 1457 1448 1439 1458 1448 1446 1460 1466 1467 1471 1478 1477 1492 1474 10 12 13 14 15 16 17 18 19 20 21 10 12 13 14 15 16 17 18 19 20 21 23 24 25 26 27 28 29 30 31 32 One you have built the exponential smoothing model for calculating forecast.s for days 3 to 21, report the forecasted demand for day 21 1455

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution