LP Model Maureen Becker, Jefferson County Regional Hospital Scheduling, SAT homework help

Dr. Maureen Becker, head administrator at Jefferson County Regional Hospital

See attached file:

I need the following:

a.  Formulate a linear programming model for this problem.

b.  Solve the model by using the computer.

Linear Programming with spreadsheet to Include excel spreadsheet with LP, and sensitivity report.

a. Formulate a linear programming model for this problem.

 b. Solve the model by using the computer.

I need excel file with LP max and sensitivity report for excel using excel QM

Step-by-step on how to input data in QM solver to obtain LP max and sensitivity