Background and content: The City Corporation ships frozen orange juice concentrate from processing plants in Eusts and Clermont to distributors in Miami, Orlando, and Tallahassee. Each plant can produce 20 tons of concentrate each week. The company has just received orders of 10 tons from Miami for the coming week, 15 tons for Orlando, and 10 tons for Tallahassee. The cost per ton for supplying each of the distributors from each of the processing plants is shown in the following table. Eustis ckmont Miami $260 $230 Orlando $220 Tallahassee $290 $310 $240 TISI model has been done and after solving the problem, sensitivity analysis is given in below table: Adjustable Cells Cell Name $C$10 Eustis Miami $D$10 Eustis Orlando SES10 Eustis Tallahassee $C$11 Clermont Miami $D$11 Clermont Orlando SE$11 Clermont Tallahassee Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease SO 260 15.30 50 10 0 220 20 0 10 0 0 310 10 0 230 230 5 0 240 20 o 0 310 1E+30 0 290 808 Constraints Cell Name Final Value Shadow Constraint Allowable Allowable Price R.H. Side increase Decrease du: SD$11 Clermont Orlando SE$11 Clermont Tallahassee 5 0 240 310 0 15.30 0 Constraints Cell Name $C$12 Shipped Miami $D$12 Shipped Orlando SE$12 Shipped Tallahassee $F$10 Eustis Used $F$11 Clermont Used Final Value 10 15 10 20 15 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 230 10 5 10 240 15 5 5 310 10 5 5 -20 20 5 5 0 20 15:30 5 I o 24 Assessment Tasks: Considering sensitivity analysis table answer all 5 questions below. 1. If the objective function for Eustis Miami decreases by 10 points what would be the impact on the optimal solution? (6 marks) 2. which constraints are binding? Why? (6 marks) 3. Should the company increase shipped Tallahassee? If so what would be the impact on the optimal solution? (6 marks) 4. If the company increased Eustis used R.H. side by 1 unit, what would be the impact on the optimal solution? (6 marks) 5. is the company able to increase shipped Miami more than 5 units to maximise the profit? (6 marks) I Background and content: The City Corporation ships frozen orange juice concentrate from processing plants in Eusts and Clermont to distributors in Miami, Orlando, and Tallahassee. Each plant can produce 20 tons of concentrate each week. The company has just received orders of 10 tons from Miami for the coming week, 15 tons for Orlando, and 10 tons for Tallahassee. The cost per ton for supplying each of the distributors from each of the processing plants is shown in the following table. Eustis ckmont Miami $260 $230 Orlando $220 Tallahassee $290 $310 $240 TISI model has been done and after solving the problem, sensitivity analysis is given in below table: Adjustable Cells Cell Name $C$10 Eustis Miami $D$10 Eustis Orlando SES10 Eustis Tallahassee $C$11 Clermont Miami $D$11 Clermont Orlando SE$11 Clermont Tallahassee Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease SO 260 15.30 50 10 0 220 20 0 10 0 0 310 10 0 230 230 5 0 240 20 o 0 310 1E+30 0 290 808 Constraints Cell Name Final Value Shadow Constraint Allowable Allowable Price R.H. Side increase Decrease du: SD$11 Clermont Orlando SE$11 Clermont Tallahassee 5 0 240 310 0 15.30 0 Constraints Cell Name $C$12 Shipped Miami $D$12 Shipped Orlando SE$12 Shipped Tallahassee $F$10 Eustis Used $F$11 Clermont Used Final Value 10 15 10 20 15 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 230 10 5 10 240 15 5 5 310 10 5 5 -20 20 5 5 0 20 15:30 5 I o 24 Assessment Tasks: Considering sensitivity analysis table answer all 5 questions below. 1. If the objective function for Eustis Miami decreases by 10 points what would be the impact on the optimal solution? (6 marks) 2. which constraints are binding? Why? (6 marks) 3. Should the company increase shipped Tallahassee? If so what would be the impact on the optimal solution? (6 marks) 4. If the company increased Eustis used R.H. side by 1 unit, what would be the impact on the optimal solution? (6 marks) 5. is the company able to increase shipped Miami more than 5 units to maximise the profit? (6 marks)