To calculate the forecast of week 7 using a 5-week moving average, we need to take the sales data from week 2 to week 6.

Here are the steps:

1. Add the auto sales of week 2 to week 6: 10 (week 2) + 9 (week 3) + 11 (week 4) + 10 (week 5) + 13 (week 6) = 53

2. Divide the sum by 5 (since we are calculating a 5-week moving average): 53 / 5 = 10.6

So, the forecast for week 7 using a 5-week moving average is 10.6.

Question

To calculate the forecast of week 7 using a 5-week moving average, we need to take the sales data from week 2 to week 6.

Here are the steps:

1. Add the auto sales of week 2 to week 6: 10 (week 2) + 9 (week 3) + 11 (week 4) + 10 (week 5) + 13 (week 6) = 53

2. Divide the sum by 5 (since we are calculating a 5-week moving average): 53 / 5 = 10.6

So, the forecast for week 7 using a 5-week moving average is 10.6.

Knowee AI · Accepted Answer

To calculate the forecast of week 7 using a 5-week moving average, we need to take the sales data from week 2 to week 6.

Here are the steps:

1. Add the auto sales of week 2 to week 6: 10 (week 2) + 9 (week 3) + 11 (week 4) + 10 (week 5) + 13 (week 6) = 53

2. Divide the sum by 5 (since we are calculating a 5-week moving average): 53 / 5 = 10.6

So, the forecast for week 7 using a 5-week moving average is 10.6.

Auto sales data at Carmen’s Chevrolet are shown below. Identify the forecast of week 7 using a 5-week moving average?Week 1 2 3 4 5 6 7Auto Sales 8 10 9 11 10 13 -The answer should be correct up to one decimal point.