Being the operations manager of a large hotel, you need to ensure a sufficient number of staff to keep the guests happy. The hotel staff works 2 shifts 7 days a week (14 shifts). Employees get 2 consecutive days off each week. After solving for staffing requirements, you end up with the following sensitivity report: 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $C$3 No. of Employees M, Tu 40 0 600 0 50 10 $D$3 No. of Employees Tu, W 10 0 600 225 0 11 SE$3 No. of Employees W. Th 20 0 600 0 50 12 $F$3 No. of Employees Th, F 30 0 550 50 450 13 $G$3 No. of Employees F, Sa 0 450 500 1E+30 450 14 SH$3 No. of Employees Sa, Su 0 450 500 1E+30 450 15 SI$3 No. of Employees Su, M 25 0 550 50 450 16 $J$3 No. of Employees M. Tu 40 0 600 0 50 17 $K$3 No. of Employees Tu, W 10 0 600 225 0 18 SLS3 No. of Employees W, Th 20 0 600 0 50 19 $M$3 No. of Employees Th, F 30 0 550 50 450 20 $N$3 No. of Employees F, Sa 0 450 500 1E+30 450 21 $o$3 No. of Employees Sa, Su 0 450 500 1E+30 450 22 $P$3 No. of Employees Su, M 25 0 550 50 450 23 24 Constraints 25 Final Shadow Constraint Allowable Allowable 26 Cell Name Value Price R.H. Side Increase Decrease 27 $a$5 Monday 60 0 60 30 10 28 SQ$6 Tuesday 75 0 65 10 1E+30 65 30 1E+30 95 nez Modnandau 25 24 Constraints 25 26 Cell Name 27 $Q$5 Monday 28 $QS6 Tuesday 29 $a$7 Wednesday 30 $QS8 Thursday 31 SQ$9 Friday 32 $A$10 Saturday 33 $A$11 Sunday 34 $Q$12 Monday 35 $A$13 Tuesday 36 $Q$14 Wednesday 37 SQS15 Thursday 38 SQ$16 Friday 39 SQ$17 Saturday 40 $Q$18 Sunday Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 60 0 60 30 10 75 0 65 10 1E+30 95 0 65 30 1E+30 75 0 75 10 10 95 50 95 30 20 125 500 125 10 5 100 50 100 10 40 60 0 60 30 10 75 0 65 10 1E+30 95 0 65 30 1E430 75 0 75 10 10 95 50 95 30 20 125 500 125 10 5 100 50 100 10 40 How many staff members work on Tuesday? Type your final answer into the field provided below. Do not include any special characters (such as @$%^&*) This question is not case sensitive There is only one correct answer Answer Being the operations manager of a large hotel, you need to ensure a sufficient number of staff to keep the guests happy. The hotel staff works 2 shifts 7 days a week (14 shifts). Employees get 2 consecutive days off each week. After solving for staffing requirements, you end up with the following sensitivity report: 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $C$3 No. of Employees M, Tu 40 0 600 0 50 10 $D$3 No. of Employees Tu, W 10 0 600 225 0 11 SE$3 No. of Employees W. Th 20 0 600 0 50 12 $F$3 No. of Employees Th, F 30 0 550 50 450 13 $G$3 No. of Employees F, Sa 0 450 500 1E+30 450 14 SH$3 No. of Employees Sa, Su 0 450 500 1E+30 450 15 SI$3 No. of Employees Su, M 25 0 550 50 450 16 $J$3 No. of Employees M. Tu 40 0 600 0 50 17 $K$3 No. of Employees Tu, W 10 0 600 225 0 18 SLS3 No. of Employees W, Th 20 0 600 0 50 19 $M$3 No. of Employees Th, F 30 0 550 50 450 20 $N$3 No. of Employees F, Sa 0 450 500 1E+30 450 21 $o$3 No. of Employees Sa, Su 0 450 500 1E+30 450 22 $P$3 No. of Employees Su, M 25 0 550 50 450 23 24 Constraints 25 Final Shadow Constraint Allowable Allowable 26 Cell Name Value Price R.H. Side Increase Decrease 27 $a$5 Monday 60 0 60 30 10 28 SQ$6 Tuesday 75 0 65 10 1E+30 65 30 1E+30 95 nez Modnandau 25 24 Constraints 25 26 Cell Name 27 $Q$5 Monday 28 $QS6 Tuesday 29 $a$7 Wednesday 30 $QS8 Thursday 31 SQ$9 Friday 32 $A$10 Saturday 33 $A$11 Sunday 34 $Q$12 Monday 35 $A$13 Tuesday 36 $Q$14 Wednesday 37 SQS15 Thursday 38 SQ$16 Friday 39 SQ$17 Saturday 40 $Q$18 Sunday Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 60 0 60 30 10 75 0 65 10 1E+30 95 0 65 30 1E+30 75 0 75 10 10 95 50 95 30 20 125 500 125 10 5 100 50 100 10 40 60 0 60 30 10 75 0 65 10 1E+30 95 0 65 30 1E430 75 0 75 10 10 95 50 95 30 20 125 500 125 10 5 100 50 100 10 40 How many staff members work on Tuesday? Type your final answer into the field provided below. Do not include any special characters (such as @$%^&*) This question is not case sensitive There is only one correct
