Decision variables: $x_{i}is$ defined $tobe$ the number $of$ nurses hired $to$ start $on$ day $iof$ the

week $(assume$ the first day $is$ Monday$)$

minimize,$x_1+x_2+x_3+x_4+x_5+x_6+x_7$

Subject $to$:

$x_1,+x_4+x_5+x_6+x_{7}18(cover$ staffing requirement for Monday$)$

$x_1+x_2,+x_5+x_6+x_{7}25(cover$ staffing requirement for Tuesday$)$

$x_1+x_2+x_3,+x_6+x_{7}15(cover$ staffing requirement for Wednesday$)$

$x_1+x_2+x_3+x_4,+x_{7}30(cover$ staffing requirement for Thursday$)$

$x_1+x_2+x_3+x_4+x_5,40(cover$ staffing requirement for Friday$)$

$x_2+x_3+x_4+x_5+x_6,20(cover$ staffing requirement for Saturday$)$

$x_3+x_4+x_5+x_6+x_{7}23(cover$ staffing requirement for Sunday$)$

$x_{i}0,x_i$ are integers

Question $1.$ Solve the problem using $MS$ Excel Solver and find $an$ optimal solution and

the optimal objective value. $(Note$: when you create constraints $in$ the Solver, you have

$to$ specify that the cells for decision variables are INT type.$)$

Submission requirement:

Note: you must specify the decision variables $as$ "integer" $in$ the Solver.

Summarize your answers $inaMS$ Word $orPDF$ document.

Submit the spreadsheet model with "Answer report". Name $itas$ "Problem

$1.xlsx".$

$DO$ NOT BOTHER ANSWERING $IF$ YOU'RE NOT GONNA $DO$ THE EXCEL SHEET, HELP $IS$ USELESS WITHOUT THE ACTUAL SOLVER MODEL?