Consider below the linear programming problem. The formulation and sensitivity analysis output is given:

Minimize cost or z = 100x₁ + 32x₂ + 32x₃ + 32x₄ + 32x₅ + 32x₆

x₁ ? 12 (Max. full-timers)

x₁ + x₂ ? 10 (9am to 10am)

x₁ + x₂ + x₃ ? 12 (10am to 11am)

0.5x₁ + x₂ + x₃ + x₄ ? 14 (11am to noon)

0.5x₁ + x₂ + x₃ + x₄ + x₅ ? 16 (Noon to 1pm)

x₁ + x₃ + x₄ + x₅ + x₆ ? 18 (1pm to 2pm)

x₁ + x₄ + x₅ + x₆ ? 17 (2pm to 3pm)

x₁ + x₅ + x₆ ? 15 (3pm to 4pm)

x₁ + x₆ ? 10 (4pm to 5pm)

4x₂ + 4x₃ + 4x₄ + 4x₅ + 4x₆ ? 56 (Corporate policy)

x₁, x₂, x₃, x₄, x₅, and x₆ ? 0 (Non-negativity)

A B C D E F G H 1 Microsoft Excel 14.0 Sensitivity Report Worksheet: [BDA2d.xlsx]Sheet1 3 Report Created: 9/11/2013 11:49:47 AM 4 6 Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $8$8 Number of full-time tellers needed Full time 10 100 1E+30 52 10 $B$9 Number of part-time tellers needed between 9am and 1pm Full time 0 0 32 52 11 $8$10 Number of part-time tellers needed between 10am and 2pm Full time 7 0 32 0 50 12 $8$11 Number of part-time tellers needed between 1lam and 3pm Full time 2 32 66.66666667 0 13 $8$12 Number of part-time tellers needed between noon and 4pm Full time 5 0 32 0 66.56656667 14 $8513 Number of part-time tellers needed between 1pm and 5pm Full time 0 32 52 15 16 Constraints 17 Final Shadow Constraint Allowable Allowable 18 Cell Name Value Price R.H. Side Increase Decrease 19 $8$19 Max. full-timers LHS 10 0 12 1E+30 2 20 $8$20 9am to 10am LHS 10 0 10 6 0 21 $B$21 10am to 11am LHS 17 12 5 18+30 22 $8$22 11am to noon LHS 14 66.66666667 14 0 E 23 $8$23 Noon to 1pm LHS 19 16 3 16+30 24 $8$24 1pm to 2pm LHS 24 0 18 6 18+30 25 $8525 2pm to 3pm LHS 17 0 17 5 2 26 $8$26 3pm to 4pm LHS 15 66.66666667 15 0 27 $8$27 4pm to 5pm LHS 10 0 10 28 $8$28 Corporate policy LHS 56 -8.666666667 56 60 0