"Use excel solver to find optimal solution"

The solution is to be attached as an Excel file to an email that you will send me by the above due date. The following output was obtained for a production scheduling problem: demand capacity production cost/unit holding cost/unit May 1000 1400 $1,100 $15 June July August 1500 2100 1400 1600 2000 1500 $1,200 $1,400 $1,300 $12 $18 $13 In addition to meeting demands each month and satisfying other normal constraints, ending inventory must be at least 200 units. Ending inventory in April was 1500 units