How do you solve this in Excel? What formula to use?

Grocery store customers 6 10 Day FIGURE 5.3 Daily Customers at FoodCo Grocery Estimating Average Demand with the Moving-Average Method 1. Using the data shown in Figure 5.3 and Table 5.1, compute a four-day moving average forecast for the number of customers on the fifth day. TABLE 5.1 Daily Customers at FoodCo Grocery Day Customers 228 228 225 188 The moving-average forecast at the end of day 4 for the number of customers on day 5 is D, +D, +D3 +D4 228 +228 + 225 + 188 - 217.25 4 Thus, at the end of day 4, we forecast that there will be 217 customers on day 5. 2. If the number of customers on day 5 turns out to be 193, com- pute the forecast for day 6. D. + D, +De+D 228 +225 + 188 + 193 = 208.50 n 2 Thus, the forecast at the end of day 5 for customers on day 6 is 209 (the exact number of 208.50 can be rounded to the nearest integer for con- venience). If we wish to forecast further into the future, we would ap- ply this same numberi.e., the forecast for customers on days 7 through 12 would also be 209