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?

Step 1

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

The formula for calculating moving average forecast is:

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:**

Step 3

**Calculation of moving average for perio...**

Tagged in

Find answers to questions asked by student like you

Show more Q&A

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...

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...

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...

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

A: Click to see the answer

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

A: Click to see the 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...

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...

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 / ...

Q: How is planning and conrol linked?

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