Instructions: Using Solver determine how many units to produce in each of the following 5 months to be able meet demands in each of these months and minimize total production and storage costs and still have 1,000 units in inventory at the end of July. (Total storage costs are based on inventories at the end of each month.) April May June July beginning inventory demand capacity production cost/unit storage cost/unit March 2,000 11,000 14,000 $12,000 $500 10,000 15,000 $12,300 $600 13,000 14,500 $12,200 $550 15,000 16,000 $12,900 $700 12,000 13,000 $13,100 $400