asap

SECTION B: Case Study B (Total - 30 Marks) Background and Content The CitruSun Corporation ships frozen orange juice concentrate from processing plants in Eustis 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 Clemont Miami $260 $230 Orlando $220 $240 Tallahassee $290 $310 The 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 $E$10 Eustis Tallahassee $C$11 Clermont Miami SD$11 Clermont Orlando $E$11 Clermont Tallahassee Final Reduced Objective Value Cost Coefficient 0 50 260 10 220 10 290 10 230 5 240 0 310 OOOOOO Allowable Allowable Increase Decrease 1E+30 50 20 0 0 310 50 230 20 1E+30 Constraints Adjustable Cells Cell Name SC$10 Eustis Miami SD$10 Eustis Orlando $E$10 Eustis Tallahassee SC$11 Clermont Miami SD$11 Clermont Orlando $E$11 Clermont Tallahassee Final Reduced Objective Value Cost Coefficient 0 50 260 10 0 220 10 0 290 10 0 230 5 0 240 0 0 310 Allowable Allowable Increase Decrease 1E+30 50 20 0 0 310 50 230 0 20 1E+30 0 Constraints Cell Name $C$12 Shipped Miami $D$12 Shipped Orlando $E$12 Shipped Tallahassee $F$10 Eustis Used $F$11 Clermont Used Final Shadow Value Price 10 230 15 240 10 310 20 -20 15 0 Constraint Allowable Allowable R.H. Side Increase Decrease 10 5 10 15 5 5 10 5 5 20 5 5 20 1E+30 5 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 of the company increased Eustis used R.H. side by 1 unit, what would be the impact on (6 marks) the optimal solution? 5 is the company able to increase shipped Miami more than 5 units to maximise the profit? (6 marks) SECTION B: Case Study B (Total - 30 Marks) Background and Content The CitruSun Corporation ships frozen orange juice concentrate from processing plants in Eustis 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 Clemont Miami $260 $230 Orlando $220 $240 Tallahassee $290 $310 The 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 $E$10 Eustis Tallahassee $C$11 Clermont Miami SD$11 Clermont Orlando $E$11 Clermont Tallahassee Final Reduced Objective Value Cost Coefficient 0 50 260 10 220 10 290 10 230 5 240 0 310 OOOOOO Allowable Allowable Increase Decrease 1E+30 50 20 0 0 310 50 230 20 1E+30 Constraints Adjustable Cells Cell Name SC$10 Eustis Miami SD$10 Eustis Orlando $E$10 Eustis Tallahassee SC$11 Clermont Miami SD$11 Clermont Orlando $E$11 Clermont Tallahassee Final Reduced Objective Value Cost Coefficient 0 50 260 10 0 220 10 0 290 10 0 230 5 0 240 0 0 310 Allowable Allowable Increase Decrease 1E+30 50 20 0 0 310 50 230 0 20 1E+30 0 Constraints Cell Name $C$12 Shipped Miami $D$12 Shipped Orlando $E$12 Shipped Tallahassee $F$10 Eustis Used $F$11 Clermont Used Final Shadow Value Price 10 230 15 240 10 310 20 -20 15 0 Constraint Allowable Allowable R.H. Side Increase Decrease 10 5 10 15 5 5 10 5 5 20 5 5 20 1E+30 5 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 of the company increased Eustis used R.H. side by 1 unit, what would be the impact on (6 marks) the optimal solution? 5 is the company able to increase shipped Miami more than 5 units to maximise the profit? (6 marks)