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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!