Can someone help me with this, please.

Part 1 Examine Problem 12 on Page 101. Problem 12 is about the United Aluminum Company of Cincinnati. Formulate a linear programming model for it. After you formulate the model, solve it using Excel Solver like you learned in class. Make sure you ask Solver to give you the sensitivity report. Based on the report, answer the following questions: A. Interpret the meaning of the three shadow prices in the sensitivity report. Your answer must be thorough. B. Which constraints are binding? Which constraints are non-binding? C. The manufacturing firm has contacted United Aluminum to inform them of their intention to reduce the size of the contract for medium-grade aluminum from 8 tons to 6.5. What impact will that have on United's cost? Explain using numbers. D. Would the solution value change if the contract requirements for high-grade aluminum were increased from 12 tons to 20 tons? Explain your answer. Yes or No is not enough. - Linear Programming Model United Aluminum Company of Cincinnati produces three grades (high, medium, and lo + of aluminum at two mills. Each mill has a different production capacity (in tons per day) for each grade, as follows: Let x1 = # of days for mill 1 Let x2 = # of days for mill 2 Mill Objective: Minimize the cost of operation Aluminum Grade 1 2 * Cost of operation = # of days mill is operating * operating cost per day High 6 2 Min Z = 6,000 x1 + 7,000 x2 Medium 2 2 Constraints: Low 4 10 High Grade 6x1+2x2 > 12 Medium Grade 2x1 +2x2 28 Low Grade 4x1+10x2 25 The company has contracted with a manufacturing firm to supply at least 12 tons of high- grade aluminum, 8 tons of medium-grade aluminum, and 5 tons of low-grade aluminum. It costs United $6,000 per day to operate mill 1 and $7,000 per day to operate mill 2. The company wants to know the number of days to operate each mill to meet the contract at the minimum cost. Formulate a linear programming model for this problem. Non-negativity x1,x220