Show all formulas in excel please, Trying to learn this.

During the next four months, a customer requires,

respectively, 500, 650, 1000, and 700 units of a com- modity, and no backlogging is allowed (that is, the cus- tomers requirements must be met on time). Production

costs are $50, $80, $40, and $70 per unit during these months. The storage cost from one month to the next is

$20 per unit (assessed on ending inventory). It is esti- mated that each unit on hand at the end of month 4 can

be sold for $60. Assume there is no beginning inventory. a. Determine how to minimize the net cost incurred in meeting the demands for the next four months.