Question
Asked Feb 3, 2019
326 views

Given the following historical data, what is the moving-average forecast for period 6 based on the last three periods?
Period Value
1 33
2 28
3 25
4 32
5 27

Did is solve correctly I tried it in excel is 29.5 correct
or do avg(25+32+27)/3 =29
Please advise?

check_circle

Expert Answer

Step 1

Calculation of moving average forecast for period 6 based on the last three periods:

The formula for calculating moving average forecast is:

 

 

fullscreen
Step 2

Calculation of moving average forecast:

The moving average calculated for period 3 will become the forecast for period 4. The moving average calculated for period 4 will become the forecast for period 5. The moving average calculated for period 5 will become the forecast for period 6 and so on. 

Calculation of moving average for period 3:

 

fullscreen
Step 3

Calculation of moving average for perio...

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in
BusinessOperations Management

Causal forecasting method

Related Operations Management Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: Problem 12.1L. Houts Plastics is a large manufacturer of​ injection-molded plastics in North Carolin...

A: ABC classification system:It is the system used for inventory control process. It refers to the thre...

question_answer

Q: A Lighting company seeks to study the percentage of the defective glass shells being manufactured. T...

A: Since we have the data on 3 factors (temperature, humidity and expertise) and each of the factors ha...

question_answer

Q: As an IT manager, how would you resolve this sensitive issue with the employees who are oppesed to t...

A: Ways to overcome resistance from employees who are opposing the implementation of new ERP system:The...

question_answer

Q: Describe post-sale service arrangements the firm does or should provide?Explain how the firm’s repai...

A: Click to see the answer

question_answer

Q: similarities and differences in psychodynamic, behavioural and cognitive theories

A: Click to see the answer

question_answer

Q: Is the shipping industry affected by dynamic competition, being there are alliances being made with ...

A: Dynamic competition in shipping industry:The instrumentality shipping networks are generated as carr...

question_answer

Q: Assume you are a manufacturer of small kitchen electrics, like Hamilton Beach/Proctor Silex, and you...

A: Focus teams is glorious thanks to hear the voice of true analysis among a bunch of any size .With al...

question_answer

Q: ProHaul specializes in trans-American shipments for businesses through the delivery of containers. F...

A: Calculating the value of break-even sales for the company. We have, Break-Even Sales = Fixed Cost / ...

question_answer

Q: How is planning and conrol linked?

A: Planning:Planning is the initial step in establishing an objective or accomplishing it. Planning is ...