Question: Apple has made available the following information for materials (pints) used in the past 6 weeks week of Pints Used Aug 31 360 Sept 7
Apple has made available the following information for materials (pints) used in the past 6 weeks
| week of | Pints Used |
| Aug 31 | 360 |
| Sept 7 | 389 |
| Sept 14 | 410 |
| Sept 21 | 381 |
| Sept 28 | 368 |
| Octob 5 | 374 |
Given this information determine the following.
1.4.1 Forecast the demand for the week of Oct 12 using a 3-week moving average. (2 Marks)
1.4.2 Using a 3-week weighted moving average with weights of 0.1, 0.3, 0.6 for the most recent week. Forecast demand for the week of October 12. (3 Marks)
1.4.3 Compute the forecast for the week of October 12, using exponential smoothing (given the forecast for August 31 of 360 pints and a smoothing constant a=0.2). (6 Marks)
1.4.4 The demand for electric power supplied by Eskom over the period 2003 to 2009 is shown in the table below in megawatts. Nike wants you to forecast demand for 2010 by using the simple linear regression method (9
| year | time | demand |
| 2003 | 1 | 74 |
| 2004 | 2 | 79 |
| 2005 | 3 | 80 |
| 2006 | 4 | 90 |
| 2007 | 5 | 105 |
| 2008 | 6 | 142 |
| 2009 | 7 | 122 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
