SOLVED

Question
Answered
Asked by bramelia
Using the below information, create an excel table for using the excel solver add-in. The results must show the objective cell, variable cells, and constraints cells to be used in the excel add-in solver. State the specific constraints to use in the solver. Problem 1: Traveling Nurse Scheduling Objective $0.00 Starting Day 4 day cost # Starting on this day Required Nurses this day Total Cost Sunday $1,200.00 0 13 $0.00 Monday $1,200.00 0 16 $0.00 Tuesday $1,200.00 0 15 $0.00 Wednesday $1,400.00 0 14 $0.00 Thursday $1,600.00 0 15 $0.00 Friday $1,600.00 0 18 $0.00 Saturday $1,400.00 0 19 $0.00 You are scheduling a week’s worth of nurses traveling from outside of the area to supplement the staffing at a hospital. Because they are coming from out of town, they need to be scheduled on consecutive days. These particular nurses are for the night shift only, so we don’t have to worry about shift by shift assignements, just the nights of the week that they will work. Each nurse works 10 hour shifts on four consecutive days and then travels back home. If a nurse starts on Friday, they work Friday, Saturday, Sunday, Monday. In the spreadsheet you can
SCIENCE
HEALTH SCIENCE
NURSING

******CLICK ORDER NOW BELOW AND OUR WRITERS WILL WRITE AN ANSWER TO THIS ASSIGNMENT OR ANY OTHER ASSIGNMENT, DISCUSSION, ESSAY, HOMEWORK OR QUESTION YOU MAY HAVE. OUR PAPERS ARE PLAGIARISM FREE*******."