2. Solving a Multiperiod Production Problem using Excel's Solver. (8 points). Recall the following problem that we formulated in class. 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 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. Use our first formulation of this problem and build a spreadsheet model of it in Excel. Solve the model using Excel's Solver. Determine how to minimize the net cost incurred in meeting the demands of the next four months. Specifically state how much of the commodity to produce each month and identify the optimal total net cost under this scenario. 3. Formulating & Solving a Multiperiod Production Problem using Excel's Solver (8 points). A company faces the following demands during the next 3 weeks: week 1, 20 units; week 2, 10 units; week 3, 15 units. The unit production costs during each week are as follows: week 1, $13; week 2, $14; week 3, $15. A holding cost of $2 per unit assessed against each week's ending inventory. At the beginning of week 1, the company has 5 units on hand. In reality, not all goods produced during a month can be used to meet the current month's demand. To model this fact, we assume that only half of the goods produced during a week can be used to meet the current week's demands. Determine how to minimize the cost of meeting the demand for the next 3 weeks using Excel's Solver. Specifically state how much of the commodity to produce each month and identify the optimal total net cost under this scenario