A. Formulate a spreadsheet model that can be used to determine the production schedule that will minimize the total cost of meeting demand in each month. B. Using the sensitivity report, answer the following questions: - What is the optimal solution and what is the optimal value of the objective function? - What is the maximum inventory holding cost for month 3 for which the original optimal solution remains optimal. Interpret your answer. -If YS does not have any beginning inventory, how much would this change the objective function value? Answer this question without recalculation and justify your answer. -If YS can produce up to 4100 units in month 1, how much would this change the objective function value? Answer this question without recalculation and justify your answer.

The task consists of writing a repair formula by hand and solving it using an accelerator.

Problem 3. The production manager for the Yonsei Corporation must determine how many units of product to produce over the next four months. Yonsei has a beginning inventory of 100 units, and demand for the four months is 2000 units in month 1, 4000 units in month2, 3000 units in month 3 , and 1500 units in month 4. Yonsei has limited production capacity in each month. That is, up to 4000 units can be produced in month 1, 3000 units in month 2, 2000 units in month 3, and 4000 units in month 4. Each product held in inventory in months 1 and 2 incurs an inventory holding cost of $250 per unit; the holding cost for months 3 and 4 is $300 per unit. The production costs for the first month are $10,000 per unit; these costs expected to increase by 10% each month because of increases in labor and material costs. Yonsei specified that the ending inventory for month 4 must be at least 500 units. A. Formulate a spreadsheet model that can be used to determine the production schedule that will minimize the total cost of meeting demand in each month. B. Using the sensitivity report, answer the following questions: - What is the optimal solution and what is the optimal value of the objective function? - What is the maximum inventory holding cost for month 3 for which the original optimal solution remains optimal. Interpret your answer. - If Yonsei does not have any beginning inventory, how much would this change the objective function value? Answer this question without recalculation and justify your answer. - If Yonsei can produce up to 4100 units in month 1, how much would this change the objective function value? Answer this question without recalculation and justify your answer. Problem 3. The production manager for the Yonsei Corporation must determine how many units of product to produce over the next four months. Yonsei has a beginning inventory of 100 units, and demand for the four months is 2000 units in month 1, 4000 units in month2, 3000 units in month 3 , and 1500 units in month 4. Yonsei has limited production capacity in each month. That is, up to 4000 units can be produced in month 1, 3000 units in month 2, 2000 units in month 3, and 4000 units in month 4. Each product held in inventory in months 1 and 2 incurs an inventory holding cost of $250 per unit; the holding cost for months 3 and 4 is $300 per unit. The production costs for the first month are $10,000 per unit; these costs expected to increase by 10% each month because of increases in labor and material costs. Yonsei specified that the ending inventory for month 4 must be at least 500 units. A. Formulate a spreadsheet model that can be used to determine the production schedule that will minimize the total cost of meeting demand in each month. B. Using the sensitivity report, answer the following questions: - What is the optimal solution and what is the optimal value of the objective function? - What is the maximum inventory holding cost for month 3 for which the original optimal solution remains optimal. Interpret your answer. - If Yonsei does not have any beginning inventory, how much would this change the objective function value? Answer this question without recalculation and justify your answer. - If Yonsei can produce up to 4100 units in month 1, how much would this change the objective function value? Answer this question without recalculation and justify your