A customer requires during the next four months, respectively, 50,65,100 and 70 units of a commodity (no backlogging is

[answerhappygod]

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. Show Excel formulas and calculations.