Develop a spreadsheet for the Wagner–Whitin algorithm as shown in Table 5.4.

a. Simply perform the calculations on the spreadsheet, finding the optimal solution manually.

b. Now use the spreadsheet to find the optimal solution.

c. Repeat parts 5.14a and 5.14b for the Silver–Meal heuristic.

d. Repeat parts 5.14a and 5.14b for the LUC method.

e. Repeat parts 5.14a and 5.14b for the PPB method.