Question: Assume you are using the moving average forecasting method based on the sales in the last 3 months to forecast the sales for the next

Assume you are using the moving average forecasting method based on the sales in the last 3 months to forecast the sales for the next month. When making the forecast for the last month, sales for the 3rd month before were 805. The forecast for the last month was 782 and then the actual sales turned out to be 793. Calculate the forecast for the next month. Use excel and show formulas.

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!

Assume you are using the moving average forecasting method based on the last four observations. When creating the forecast for the last period, the oldest of the four observations was 1945 and the...

Question 1 - 10 marks Katie Posh runs an upscale nail salon. The service process includes five activities that are conducted in the sequence described below. (The time required for each activity is...

The following data shows the sales of a product for a period of six months. Period (Month) Actual Sale of product 1 800 2 900 3 1100 4 1250 5 1350 6 1410 Answer the following questions: (a) Use 2...

5. The following data shows the sales of a product for a period of six months. Period (Month) Actual Sale of product 1 800 2 900 3 1100 4 1250 5 1350 6 1410 Answer the following questions: (a) Use 2...

a. Forecast the sales for September and October using the 5-month moving average forecasting method. b. Forecast the sales for June and July using the 4-month weighted moving average forecasting...

Part I: Calculation 7. Assuming that the exponential smoothing constant = 0.16, average first 4 quarters of data is used for previous forecast and theres the level effect only, please forecast the...

2 0 . The following data shows the sales of a product for a period of five weeks. Period ( Week ) Actual Sale of product 1 6 5 0 2 7 2 0 3 7 0 0 4 8 5 0 5 8 7 0 Answer the following questions: a )...

Homeowners Insurance - Complete 1A or 1B. 1A. If you own a home, you can list the name of the policy protecting the exposure, name of the company, premium payment, deductibles, and dollar limits for...

During routine screening, a doctor notices that 22% of her adult patients show higher than normal levels of glucose in their blooda possible warning signal for diabetes. Hearing this, some medical...

Excel will automatically check to see if an X variable column is a perfect linear combination of other columns and will omit one of the offending predictors. True false question. True False

The answers in green are correct, the answers in red are incorrect and need to be changed.