Question: Refer to Example A.5. 1. Solve this personnel scheduling problem using Excel Solver. What are the optimum solution values? 2. Interpret the allowable increase and

Refer to Example A.5.

1. Solve this personnel scheduling problem using Excel Solver. What are the optimum solution values?

2. Interpret the €œallowable increase€ and €œallowable decrease€ values for the objective function coefficients.

3. Interpret the values of the shadow prices and the €œallowable increase€ and €œallowable decrease€ values for the righthand- side values of the constraints.

Data form example 5

Maureen Nair, hospital administrator for Trinity Hospital, would like to set up a workforce schedule for its registered nurses. Maureen wants a work schedule that will use the minimum number of nurses without affecting the quality of patient care. Nurses are needed for patient care on a continuous, 24-hour basis. Each nurse will work for eight consecutive hours. The minimum number of nurses needed to provide adequate patient care in six four-hour time intervals are provided in the following table:

TIME INTERVAL MINIMUM NUMBER OF NURSES REQUIRED 00-04 04-08 22 08-12 12-16 26 16-20 18 20-24 12

Step by Step Solution

★★★★★

3.32 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

1 The optimal schedule is as follows Time Interval Workers Starting This Shift 0004 7 0408 1 0812 21 ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Operations Management Questions!

Karen Stanley, the fictional superintendent of education of Erie County, Pennsylvania, has the responsibility of assigning students to three high schools in her county and to provide bus...

A cattle rancher in Australia wants to determine a least-cost diet to feed the cattle on his ranch. The diet, however, must contain certain minimum amounts of the following four essential nutrients:...

A fertilizer manufacturer has orders for 900 tons of a certain fertilizer from Chicago, Illinois, and 600 tons from Omaha, Nebraska. The company has 1,050 tons of this fertilizer in a warehouse in...

Formulation and solution: Lets assume, S = Number of small air compressors to produce to maximize the profit, M = Number of medium air compressors to produce to maximize the profit and L = Number of...

Refer to Example A.3. 1. Solve this product mixture problem using Excel Solver. What are the optimum solution values? 2. Interpret the allowable increase and allowable decrease values for the...

Problem #2 (48 points; 8 points each) A dietician in the Ohio State University Hospital developed a formulation of supplemental healthy breakfast that may greatly reduce the risk of heart disease....

The Bolded words are the questions asked!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Question 1) The Sea Wharf Restaurant would like to determine the best way to allocate a monthly...

A dietician has developed a formulation of a supplemental healthy breakfast that may help reduce the risk of heart disease. For each serving of the breakfast, she formulates it by mixing 5 possible...

Please Answer all. This is one problem. I will upvote. LP: Certain Sensitivity Analysis Questions must be answered based on the Excel Output below. The sandwich company, Alamo Lone Star (ALS)...

bv the 4. (20%) Read Farmer Leary problem narrative. It is Winston page 2414 1 Section 5.2. Solve the problem using Excel. Generate the sensitivity report and answer questions a-c as written below,...

One of the industrial processes for the preparation of phenol, discussed in Section 24.6, includes an acid-catalyzed rearrangement of cumene hydroperoxide as a key step. This reaction proceeds by way...

Read the case study and answer the questions: Eduction Reform in Taiwan: a search for a national identity through democratization and Taiwanisation 1. Summarize the kinds of changes which had...

which entity does not have all the following characteristics? limited liability. ability to distribute in kind appreciated assets to owners without gain recognition

=+2. What are the disadvantages of a compressed workweek?

What are the things firms must overcome to minimize the bullwhip effect?

Define the bullwhip effect and describe how it impacts supply chain integration, or how integration impacts the bullwhip effect.

Why is visibility so important when integrating processes?

In Year 1, Aliyah's Boutique (a retail clothing company) sold 10,660 units of its product at an average price of $27 per unit. The company reported estimated returns and allowances in Year 1 of 2.0...

Gough Corporation has two divisions: Domestic and Foreign. Data from the most recent month appear below: Total Company Domestic Foreign Sales $771,700 $393,700 $378,000 Variable expenses 268,525...

roblem 6: ( 6 Points)\ cording to this system, answer the following questions.\ if _(C)^(P)Prg=[[e1],[e2],[e3]] , then el= . e3= \ If _(C)^(B)R=[[d1,d4,d7],[d2,d5,d8],[d3,d6,d9]] , then: d1= d4= d2=...