We will use solver to implement a solution to a linear programming problem. This problem is an inventory problem (production over multiple periods with an ending inventory variable for each period) with some additional binary variables (the decision to produce each period and the decision to hold inventory in each period).
