Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Apple has made available the following information for materials (pints) used in the past 6 weeks. Apple has made available the following information for materials
Apple has made available the following information for materials (pints) used in the past 6 weeks. Apple has made available the following information for materials (pints) used in the past 6 weeks. (20 Marks) Week of Pints used Aug 31 360 Aug 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 Marks) . 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started