Chapter 4 - Question 1, parts a and b.Provide a textbox with the LP formulation. Clearly show the optimal value along with the optimal solution in a textbox.

1. Honeydew Chemical's Chief Operating Officer, Ienka Rae, needs to plan their production for the next three months. Honeydew Chemicals produces a single productliquid fertilizerfor which the following relevant information for the next 3 periods (months) is available. PERIOD PRODUCTION COST INVENTORY HOLDING COST PRODUCTION PER LITER IS) CHARGED AT THE END CAPACITY OFA PERIOD PER LITER ISI The company has an initial inventory of 100 liters at the beginning of period 1, and is required to hold a minimum inventory of at least 50 liters at the end of period 3. a. Formulate a linear program, clearly dening all variables used, to determine the production and inventory in each period that minimizes the total cost for Honeydew over the 3 periods. while meeting its demand requirements. b. Use Solver to nd the optimal solution to the linear program from part a. Turn in the spreadsheet model with solution. c. The company has an option to use overtime to increase its production capac- ity in each of the 3 periods. The overtime manufacturing cost per liter is 10% higher than the normal manufacturing cost per liter, for each period. The over- time capacity for each of the 3 periods is as follows