Question: List of formulas: Simple moving average method: Ft+1 = (Dt + Dt-1 + Dt-2 + + Dt-n+1)/n Weighted moving average method: Ft+1 = W1D1 +

List of formulas:

  • Simple moving average method: Ft+1 = (Dt + Dt-1 + Dt-2 + + Dt-n+1)/n
  • Weighted moving average method: Ft+1 = W1D1 + W2D2 + + WnDt-n+1
  • Exponential smoothing method: Ft+1 = Ft + (Dt Ft)

Demands for a newly developed salad bar at the PQR restaurant for the first four months of this year are shown in the table below. Round to three decimal places. ----------------------------------

Month Demand

----------------------------------

January 67 February 58 March 71 April 65

----------------------------------

Use the problem statement and table to answer the questions below.

Question:

What is the forecast for May if the four-month weighted moving average method is used? [Note: Use weights of 0.4 for the most recent demand, 0.3, 0.2, and 0.1 for the oldest demand.]

A. 65.600

B. 68.000

C. 71.000

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 General Management Questions!