Company DIB observes the demand of product Z over 20 periods as follow:Period ActualDemand (units)Period ActualDemand (units)1 198 11 2002 175 12 1983 172 13 1954 194 14 2235 177 15 2026 186 16 1847 193 17 1678 196 18 1949 211 19 17010 205 20 159Assume the initial forecast is 200 units.Requirements:a) Plot a line chart* that covers 20 periods and consists of the following THREE (3) lines:The actual demand line (5 marks)The exponential smoothing forecast line with alpha = 0.2 (5 marks)The exponential smoothing forecast line with alpha = 0.8 (5 marks)*Suggestion: Use MS Excel to plot the line chart.b) Compute the Mean Absolute Deviation (MAD) for periods 1 to 20. Tabulate youranswers. (11 marks)c) Which smoothing constant produces a better forecast? Comment on your observation.(4 marks)Note: Keep your answers to ONE (1) decimal place.
Question
Company DIB observes the demand of product Z over 20 periods as follow:Period ActualDemand (units)Period ActualDemand (units)1 198 11 2002 175 12 1983 172 13 1954 194 14 2235 177 15 2026 186 16 1847 193 17 1678 196 18 1949 211 19 17010 205 20 159Assume the initial forecast is 200 units.Requirements:a) Plot a line chart* that covers 20 periods and consists of the following THREE (3) lines:The actual demand line (5 marks)The exponential smoothing forecast line with alpha = 0.2 (5 marks)The exponential smoothing forecast line with alpha = 0.8 (5 marks)*Suggestion: Use MS Excel to plot the line chart.b) Compute the Mean Absolute Deviation (MAD) for periods 1 to 20. Tabulate youranswers. (11 marks)c) Which smoothing constant produces a better forecast? Comment on your observation.(4 marks)Note: Keep your answers to ONE (1) decimal place.
Solution
To answer this question, we will need to follow several steps:
a) To plot a line chart in Excel, you will need to input your data into the spreadsheet. In one column, you will have your periods (1-20), and in the next column, you will have your actual demand values. Then, you will need to calculate the exponential smoothing forecast for alpha = 0.2 and alpha = 0.8. Once you have these values, you can select your data and choose the "Line Chart" option from the "Insert" menu.
b) To compute the Mean Absolute Deviation (MAD), you will need to calculate the absolute differences between the actual demand and the forecasted demand for each period. Then, sum up these absolute differences and divide by the total number of periods (20 in this case).
c) To determine which smoothing constant produces a better forecast, you will need to compare the MAD values for alpha = 0.2 and alpha = 0.8. The lower the MAD, the better the forecast.
Please note that without the actual data, I cannot perform these calculations for you. However, I hope these steps will guide you in solving the problem.
Similar Questions
The manager of a service station wants to forecast the demand of unleaded gasoline next month in order to place an order with the distributor. The manager has accumulated ten months of demand data. Use this data to answer the following TWO questions.month gasoline demandedOctober 360November 326December 284January 225February 290March 311April 329May 365June 540July 441 Flag question: Question 2Question 2Tips8.5 ptsCompute an exponentially smoothed forecast for August, using an 𝛼 value of 0.30. Round to two decimal places.
A computer software firm has experienced the demand for their software package as shown below.Month Demand (D)1 562 613 554 705 666 65Using 𝛂 = 0.4, what is the exponential smoothing forecast for month 3? (Assume F1 = 56) (answer in whole number)
Use diagram below to answer question Periods: 1 2 3 4 5 Forecast: 20 20 30 20 25 Actual demand: 22 18 25 20 19 The Mean Absolute Deviation (MAD) for the data given is
Consider the following time series: Period 1 2 3 Demand 15 24 26 Forecast the demand for period 3 using exponential smoothing with W (smoothing coefficient) = 0.4. Express your answer without rounding
July Actual Demand 400 unitsAugust Actual Demand 350 unitsSeptember Actual Demand 352 unitsUsing simple exponential smoothing, what would your forecast be for October if the exponentially smoothed forecast for the month July was 450 units and the smoothing constant was 0.20.
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.