l. Honeydew Chemical's Chief Operating Ofcer, 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 LITEFl l$l CHARGED AT THE END CAPACITY OF A PERIOD PER LITEFl i$l --m --_m 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 3. Turn in the spreadsheet model with solution