Calculate the mse for four-week moving average

Assignment Help Operation Management

Reference no: EM131803438

Refer to the gasoline sales time series data in the given table.

Week	Sales (1000s of gallons)
1	17
2	21
3	19
4	23
5	17
6	16
7	20
8	19
9	21
10	19
11	15
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	17
2	21
3	19
4	23
5	17
6	16
7	20
8	19
9	21
10	19
11	15
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 =

Reference no: EM131803438

Questions Cloud

Create a solver model to assign the shipment of blood : Create a Solver model to assign the shipment of blood to the hospitals. What is the lowest cost for transporting blood to the four hospitals?

Prepare journal entries to record the transactions above : Prepare journal entries to record the transactions above. Prepare journal entries to record the 2016 amortization expense.

Discuss a perpetual inventory system on a fifo basis : Logan Company uses a perpetual inventory system on a FIFO basis. Assuming inventory on January 1 was 1,160 units at $7.70 each

What factors shape an organizations external competitivenes : What is external competitiveness? What factors shape an organization's external competitiveness? Why is external competitiveness so important?

Calculate the mse for four-week moving average : Compute the MSE for the four-week and five-week moving average forecasts. Round your intermediate calculations and final answers to two decimal places.

What amount of the total contract price : What amount of the total contract price would be recognized as revenue in Year 17?

Weighted average cost of capital : The company's tax rate is 40%.What is SCC Inc.'s weighted average cost of capital (rounded to the nearest tenth of apercent)?

How long wait to accumulated enough money to buy the car : You want to purchase a boat, but you need $45,000. if you could invest your entire savings of $15,000 at an annual interest rate of 15% compounded annually

What were the results focus on the financial perspective : What were the results focus on the financial perspective on customers and other stakeholders? Be as specific as you can and give concrete examples.

User Account

All Pages