Question: Problem 3 (30 points) Joe Kool has decided to use 3-month weighted moving average method for one of his company's products. Last year's monthly sales

Problem 3 (30 points) Joe Kool has decided to use 3-month weighted moving average method for one of his company's products. Last year's monthly sales data are given in table Month Sales 1 2 3 4 5 5325 5405 5200 5510 5765 5210 5375 5585 5460 6 7 8 9 10 4905 11 5755 12 6320 Joe is trying to decide the appropriate weights to select fee his forecasting method that will minimize the sum of the absolute errors between the forecasts and the actual values. Show that the determination of the optimal weights can be formulated as an LP problem. Don't need to solve it
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
