Questions 1-8: below pertain to the attached United Aluminum Company scenario. Excel generated solution and sensitivity report to answer the questions 2-8 provided below. (5x8=40 points) The United Aluminum Company of Cincinnati produces three grades (high, medium, and low) of aluminum at two mills. Each mill has a different production capacity (in tons per day) for each grade as follows. Aluminum Grade Mill 1 2 High 6 2 Medium 2 2 Low 4 10 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 milll and $7,000 to operate mill 2. The company wants to know the number of days to operate each mill in order to meet the contract at the minimum cost. Target Cell (Min) Cell Name Original Value Final Value 5859 2= Objective function 24000 24000 Adjustable Cell: Cell Name Original Value Final Value 38$18 x1= decision variables 38$19 x2= decision variables 0 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SBS18 x1= decision variables 8000 1000 800 0 SB$19 x2= decision variables 1000 7000 1+30 1000 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SIS17 high grade 24 12 12 1E+30 31518 medium 3000 8 18+30 18 0 11 1E+30