Question: Muscat Pharmacy has used moving average forecasting method to predict Gloves, medicine and surgical mask inventory requirements. The manager of the pharmacy wants to maintain

 Muscat Pharmacy has used moving average forecasting method to predict Gloves,

Muscat Pharmacy has used moving average forecasting method to predict Gloves, medicine and surgical mask inventory requirements. The manager of the pharmacy wants to maintain an adequate inventory in stock. Therefore, the manager wants to forecast the demand for deliveries during the next month. From the records of previous orders, management has accumulated the following data for the past 10 months: Jan Mar April July Aug Oct Nov Feb 40 May 45 June 50 Sept 56 37 41 37 43 47 52 ? a Compute the monthly demand forecast for February to November using the naive method. [1 mark] b. Compute the monthly demand forecast for April to November using a 3-month moving average. [4 marks) c. Compute the monthly demand forecast for June to November using a 5-month moving average. [3 marks] d. Compute the demand forecast for the month of 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. [1 mark] e. Use exponential smoothing with smoothing parameter =0.3 to compute the demand forecast for the month March. [1 Mark]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!