Question: (SHOW YOUR COMPLETE WORK) The actual demand data for a product being sold at a local store during the past eight weeks are shown below:

(SHOW YOUR COMPLETE WORK) The actual demand data for a product being sold at a local store during the past eight weeks are shown below: Determine the demand forecast for THIS WEEK using each of the following methods: a. A 4-week moving average. [3 points] b. A 4-week weighted moving average using weights of 15,5,3, and 2 for one week ago, two weeks ago, three weeks ago, and four weeks ago, respectively. (Hint: the higher weights are applied to the more recent time periods.) [9 points] c. Exponential smoothing using the following: smoothing constant, =0.40 and the demand forecast for three weeks ago =143 units. [12 points] Use the appropriate label/unit of measurement in your answers. Leave the numbers in decimals and go up to 5 decimal places for higher accuracy
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
