Question: Complete answer please SOLVE MANUALLY. The Super Supplies Store (SSS) is the leading company that sells and delivers office and school supplies in Puerto Galera,
Complete answer please
SOLVE MANUALLY. The Super Supplies Store (SSS) is the leading company that sells and delivers office and school supplies in Puerto Galera, Oriental Mindoro. Earl, the manager always wants to delight the company's clients by delivering the orders on-time. Thus, the company should have adequate inventory in stock and there should be enough drivers and vehicles. To achieve the said objective an accurate demand forecast for deliveries during the next month is a necessary information. The management was able to secure the records of previous orders for the past 10 months which can be an excellent basis for the needed demand forecast for February 2021 1. Compute the monthly demand forecast for May 2020 through February 2021 using the naive method. 2. Compute the monthly demand forecast for July 2020 through February 2021 using a 3-month moving average. 3. Compute the monthly demand forecast for September 2020 through February 2021 using a 5 month moving average 4. Compute the monthly demand forecast for July 2020 through February 2021 using a 3-month weighted moving average. Use weights of 0.5, 0.33, and 0.17, with the heavier weights on the more recent months. 5. Compute the mean absolute deviation for September 2020 through January 2021 for each of the methods used. Which method would you use to forecast demand for February 2021? Year Actual Orders/Demands 120 2020 90 100 Month Apr May Jun Jul Aug Sep Oct 75 110 50 75 Nov 130 Dec 110 2021 90 Jan Feb

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
