Five-week moving averages for the time series

Assignment Help Operation Management

Reference no: EM132194833

(Algorithmic) Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) 1 18 2 21 3 19 4 22 5 18 6 16 7 21 8 19 9 21 10 21 11 16 12 23 Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. Week Sales 4-Week Moving Average 5-Week Moving Average 1 18 2 21 3 19 4 22 5 18 6 16 7 21 8 19 9 21 10 21 11 16 12 23 Compute the MSE for the four-week and five-week moving average forecasts. Round your intermediate calculations and final answers to two decimal places. MSE for four-week moving average = MSE for five-week moving average = What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation?

Reference no: EM132194833

Questions Cloud

Interested in learning how culture affects consumption : The engineers of Evapolar are interested in learning how culture affects consumption.

Money market so important to treasury management : Why is the money market so important to treasury management? Describe the key inputs used when developing a short-term investment policy.

Value of the objective function at the optimal solution : What is the value of the objective function at the optimal solution?

Describe what project scope management : Describe what project scope management is and why it is important in project management.

Five-week moving averages for the time series : Compute four-week and five-week moving averages for the time series.

Estimate stahlmaere expected mean profit : Then use a data table to repeat the simulation 1000 times. From the simulation results, estimate Stahlmaere's expected mean profit.

Analyze the future of utilization management approaches : Discuss basic approaches and techniques used in utilization management. Analyze the future of utilization management approaches.

Refer to the evaluating data quality learning activity : Refer to the "Evaluating Data Quality" learning activity. Imagine that you are a marketing specialist at a media company.

Compute the measures of forecast accuracy : Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy.

User Account

All Pages