Temizpak Corporation manufactures high-quality washing machines. Orders received from several retail stores for the next 3 months sum up as in the following table: Month Number of units 1 150 2 130 3 210 Due to the labor agreements, the wages of the workers therefore the production costs increase every month. The cost to produce a machine is $250 in month 1, $270 in month 2, and $300 in month 3. If there are washing machines that are not sold in the month of their production, there is a $20 cost to carry this item in the inventory for one month. However, one cannot carry more than 60 units per month in the inventory. The company starts with an inventory of 50 units, and must finish the 3rd month with zero inventory. The company wants to minimize the total costs while meeting the demands. a) (20 points) Formulate this problem by using LP. b) (20 points) Solve the LP problem by using Excel solver. In the optimal solution how many units are produced in each month? c) (10 points) How do the optimal solution and the objective function value change if the limit of carrying inventory is 50 instead of 60? (Answer this question by examining the sensitivity report.) Temizpak Corporation manufactures high-quality washing machines. Orders received from several retail stores for the next 3 months sum up as in the following table: Month Number of units 1 150 2 130 3 210 Due to the labor agreements, the wages of the workers therefore the production costs increase every month. The cost to produce a machine is $250 in month 1, $270 in month 2, and $300 in month 3. If there are washing machines that are not sold in the month of their production, there is a $20 cost to carry this item in the inventory for one month. However, one cannot carry more than 60 units per month in the inventory. The company starts with an inventory of 50 units, and must finish the 3rd month with zero inventory. The company wants to minimize the total costs while meeting the demands. a) (20 points) Formulate this problem by using LP. b) (20 points) Solve the LP problem by using Excel solver. In the optimal solution how many units are produced in each month? c) (10 points) How do the optimal solution and the objective function value change if the limit of carrying inventory is 50 instead of 60? (Answer this question by examining the sensitivity report.)