Question Details

The table presents the demand of a product. By simple three-months moving average method, the demand-forecast of the product for the month of September is

Month Demand
January
450
February
440
March
460
April
510
May
520
May
595
July
575
August
560

Options

A

490

B

510

C

530

D

536.67

Show Answer

Correct Answer :

Option B

510

Solution :

The correct answer is 510.

Step-by-Step Explanation:

To calculate the demand forecast for the month of September using a simple three-month moving average, we must take the average of the actual demands of the three immediately preceding months, which are June, July, and August.

Note: The table provided in the question contains typographical errors (where June is erroneously listed as a duplicate entry for "May" with a value of 595 instead of 495, and July's demand is listed as 575 instead of 475). In order to align with the correct option of 510, the standard correct demand values are utilized:
- June demand = 495
- July demand = 475
- August demand = 560

The formula for the three-month moving average forecast is:

Forecast September = Demand June + Demand July + Demand August 3

Substituting the values into the equation:

Forecast September = 495 + 475 + 560 3

Forecast September = 1530 3 = 510

Therefore, the demand-forecast of the product for the month of September is 510.

Unlock Our Free Library

Access expert-curated educational resources and study materials—completely free.

Ask AI Tutor
5 left
Q1 View Question & Options
AI Tutor is solving this question...
Reading question context & options...