Formulate a linear program for the below problem and solve your formulation using Excel Solver and submit your work here.

A customer requires during the next four months, respectively, 50,65,100 and 70 units of a commodity (no backlogging is allowed). Production costs are $5, $8, $4 and $7 per unit during these months. The storage cost from one month to the next is $2 per unit (assessed on ending inventory). It is estimated that each unit on hand at the end of the month 4 could be sold for $6. Formulate an LP that will minimize the net cost incurred in meeting the demands of the next four months. (Please show all excel formulas, I am trying to learn this)