Provide a textbox with the LP formulation. Clearly show the optimal value along with the optimal solution in a textbox.

Show screenshots of EXCEL please for SOLVER reference.

The Sixth Sin Chocolate Company has come out with a new chocolate smoothie drink that they named Gula. Sarah Hopkinson, Director of Marketing Research, has indicated that test market sales of Gula have been brisk and she projects demand for the next 3 months in thousands of gallons to be 100, 140, and 190 . They expect their production costs to go down as they gain experience and economies of scale. The costs are reflected in the table below. They currently have production capacity of 160 thousand gallons per month. The company has an initial inventory of 10 thousand gallons at the beginning of period 1, and would like to hold a minimum inventory of at least 25 thousand gallons at the end of month 3 to handle any variation in demand. a. Formulate a linear program, clearly defining all variables used, to determine the production and inventory in each period that minimizes the total cost for The Sixth Sin over the 3 periods, while meeting its demand requirements. b. Use Solver to find the optimal solution to the linear program from part a