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.

Problem 1. Recall the problem of "Workforce scheduling of a hospital" in Homework \#1. This roblem's formulation is as follows: Decision variables: xi is defined to be the number of nurses hired to start on day i of the week (assume the first day is Monday) minimize x1+x2+x3+x4+x5+x6+x7 Subject to: x1+x4+x5+x6+x718 (cover staffing requirement for Monday) x1+x2+x5+x6+x725 (cover staffing requirement for Tuesday) x1+x2+x3+x6+x715 (cover staffing requirement for Wednesday) x1+x2+x3+x4+x730 (cover staffing requirement for Thursday) x1+x2+x3+x4+x540 (cover staffing requirement for Friday) x2+x3+x4+x5+x620 (cover staffing requirement for Saturday) x3+x4+x5+x6+x723 (cover staffing requirement for Sunday) xi0,xi are integers