Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel Solver with binary. How can I use binary to solve this questions on excel? What are the step and what should i put in

Excel Solver with binary. How can I use binary to solve this questions on excel? What are the step and what should i put in my solver?

Note: All answers must be found using the "Simplex LP" solver setting in Excel Solver.

The following problem is adapted from 3-17 in the Balakrishnan, Render, and Stair textbook.

A hospital emergency room is open 24 hours a day. Nurses report for duty at 1 a.m., 5 a.m., 9 a.m., 1 p.m., 5 p.m., or 9 p.m., and each works an 8-hour shift. Nurses are paid the same, regardless of the shift they work. The following table shows the minimum number of nurses needed during the six periods into which the day is divided.

Shift

Time (24-hr time scale)

Nurses needed

1

1-5

4

2

5-9

13

3

9-13

17

4

13-17

10

5

17-21

12

6

21-1

5

  1. How should the hospital schedule the nurses so that the total staff required for one day's operation is minimized? Your answer should come from an optimization model rather than guess-and-check. Even though it's impossible to schedule half of a nurse, you don't need to make any of the variables integer. This is a special case where integer solutions happen automatically.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Operations Management

Authors: Jay Heizer, Barry Render

11th edition

9780132921145, 132921146, 978-0133408010

More Books

Students also viewed these General Management questions