/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Q18-8OQ : Actual demand for a product fo... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

: Actual demand for a product for the past three months was:

Three months ago

400 units

Two months ago

350 units

Last month

325 units

  1. Using a simple three-month moving average, make a forecast for this month.
  2. If 300 units were demanded this month, what would your forecast be for next month?
  3. Using simple exponential smoothing, what would your forecast be for this month if the exponentially smoothed forecast for three months ago was 450 units and the smoothing constant was 0.20?

Short Answer

Expert verified

Answer

A moving average (rolling average or running average) could be a calculation to investigate data points by creating a series of averages of various subsets of the complete data set. It's also called a moving mean.

Step by step solution

01

a) Using a simple three-month moving average, make a forecast for this month

By using a simple three-month moving average, the forecast for this month is calculated as follows:

Simplemovingaverage=A1+A2+..........+Ann

Forecast(thismonth)=325+350+4003=358

02

b) If 300 units were demanded this month, what would your forecast be for next month

The forecastis the calculation that is the data from real-time activities and is dependent on the set of variables that are figured out for the number of statistical forecast situations.

If 300 units were demanded this month, then the forecast be for next month is calculated as follows:

Simplemovingaverage=A1+A2+..........+Ann

forecastforthenextmonth=300+325+3503=325

03

Using simple exponential smoothing, what would your forecast be for this month if the exponentially smoothed forecast for three months ago was 450 units and the smoothing constant was 0.20

If the exponentially smoothed forecast for three months ago was 450 units and the smoothing constant was 0.20, the forecast for this month is calculated as follows:

Ft=Ft-1+α(At-1-Ft-1)

role="math" localid="1650535070962" Ftwomonthsago=450+.20(400-450)=440Fonemonthago=440+.20(350-440)=422Fthismonth=422+.20(325-422)=403

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Question: After using your forecasting model for six months, you decide to test it using MAD and a tracking signal. Here are the forecast and actual demands for the six months;

Period

Forecast

Actual

May

450

500

June

500

550

July

550

400

August

600

500

September

650

675

October

700

600

a. Find the tracking signal.

b. Decide whether your forecasting routine is acceptable.

Question: Which qualitative forecasting technique was developed to ensure that the input from every participant in the process is weighted equally?

Historical demand for a product is:

Month

Demand

January

12

February

11

March

15

April

12

May

16

June

15

a. Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast.

b. Using a simple three-month moving average, find the July forecast.

c. Using single exponential smoothing witha= 0.2 and a June forecast =13, find the July forecast. Make whatever assumptions you wish.

d. using simple linear regression analysis, calculate the regression equation for the preceding demand data.

e. using the regression equation in d, calculate the forecast for July.

The widespread scientific application of yield management began within what industry?

DAT, Inc. needs to develop an aggregate plan for its product line. Relevant data are

The forecast for next year is

Management prefers to keep a constant workforce and production level, absorbing variations in demand through inventory excesses and shortages. Demand not met is carried over to the following month. Develop an aggregate plan that will meet the demand and other conditions of the problem. Do not try to find the optimum; just find a good solution and state the procedure you might use to test for a better solution. Make any necessary assumptions.

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.