Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Rustag Hospital has used moving average forecasting method to predict corona vaccine and surgical mask inventory requirements. The manager of the hospital wants to maintain

image text in transcribed
Rustag Hospital has used moving average forecasting method to predict corona vaccine and surgical mask inventory requirements. The manager of the hospital 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: Feb Aug Oct Jan 120 Mar 100 April 75 May 110 June 50 July 75 Sept 110 Nov ? 90 130 90 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] Use exponential smoothing with smoothing parameter =0.3 to compute the demand forecast for the month March. [1 Mark] e

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Integral Audit Acceptions Objectives And Practices

Authors: David Pavón, Catalina Rueda

1st Edition

6206302083, 978-6206302087

More Books

Students also viewed these Accounting questions

Question

Why is it said that much of culture is invisible?

Answered: 1 week ago

Question

The company has fair promotion/advancement policies.

Answered: 1 week ago