In one modification of the Pigskin problem, the maximum storage constraint and the holding cost are based on the average inventory (not ending inventory) for a given month, where the average inventory...

In one modification of the Pigskin problem, the maximum storage constraint and the holding cost are based on the average inventory (not ending inventory) for a given month, where the average inventory is defined as the sum of beginning inventory and ending inventory, divided by 2, and beginning inventory is before production or demand. Modify the Pigskin model with this new assumption, and use Solver to find the optimal solution. How does this change the optimal production schedule? How does it change the optimal total cost?