COMPUTE

Ivermectin Pharmaceuticals sells and delivers vaccines for COVID 19 and other antidote medicines to its target market. The vaccine and antidote supply venture is competitive, and the ability to deliver orders is a huge factor in getting new customers and sustaining the old ones. The company manager wants to be sure that enough drivers and vehicles are available to deliver orders promptly and that they have sufficient quantity of inventory. From the records of previous orders, management has accumulated the following data for the past ten months:

1. Compute the monthly demand forecast for February through November using the nave method
2. Compute the monthly demand forecast for April through November using a 3-month moving average
3. Compute the monthly demand forecast for June through November using a 5-month moving average
4. Compute the monthly demand forecast for April through November 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. Use the following table as guide in the presentation of your forecast

PICTURE:

1. Ivermectin Pharmaceuticals sells and delivers vaccines for COVID 19 and other antidote medicines to its target market. The vaccine and antidote supply venture is competitive, and the ability to deliver orders is a huge factor in getting new customers and sustaining the old ones. The company manager wants to be sure that enough drivers and vehicles are available to deliver orders promptly and that they have sufficient quantity of inventory. From the records of previous orders, management has accumulated the following data for the past ten months: Month Jan Feb Mar Apr May June July Aug Sept Oct Orders 1200 900 1000 750 1100 500 750 1300 1100 006 a. Compute the monthly demand forecast for February through November using the naive method b. Compute the monthly demand forecast for April through November using a 3-month moving average C. Compute the monthly demand forecast for June through November using a 5-month moving average d. Compute the monthly demand forecast for April through November 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. e. Use the following table as guide in the presentation of your forecast Orders Forecast Naive 3-Month 5-Month 3-Month Method Moving Moving Weighted Average Average Average Jan Feb Mar Apr May June July AUE Sept Oct Nov