Assignment 3 HUMAN RESOURCE STAFFING Richland Health has thr

Assignment 3

HUMAN RESOURCE STAFFING

Richland Health has three hospitals in the greater Tampa, Florida area. Demand for patient services vary considerably during the fall and winter months, due to the temporary influx of the aged population. From October through March, providing adequate nursing staff is extremely difficult for Richland Health. Last year, to address this problem, Richland Health contracted with Cross Country TravCorp to hire traveling nurses during these 6 months. TravCorp offered to provide nurses under the following four contract options:

Option

Length of Employment

Cost

1

One month

$2,500

2

Two months

$5,800

3

Three months

$8,500

4

Four months

$12,000

Longer contract periods are more expensive because fewer nurses are willing to commit to longer work assignments. During the next six months, Richland has projected the following needs for additional nurses.

Month__________________

Oct

Nov

Dec

Jan

Feb

Mar

Temp Nurses Needed

15

28

24

31

25

19

Each month, Richland can hire as many nurses as needed under each of the four options. For instance, if Richland hires five nurses in October under Option 2, Cross Country TravCorp will supply Richland with five traveling nurses who will work two months: October and November. For this, Davis must pay 5($5,800) = $29,000. Richland Health does not want to commit to any contractual obligations for traveling nurses beyond March. No traveling nurses should be employed past March.

Each nurse hired in the traveling-nurse program must receive training at the time of hire, at a cost to Richland Health of $875 per hire, regardless of the option under which the nurse is hired. The training program is required even if the person has worked for Richland Health in the past.

Richland Health needs to know how many traveling nurses to hire in each of the 6 months under each of the 4 contract options so that it can meet its projected demand in each month.

Part 2 - a

Use the second worksheet called ‘Part 2 - LP’ to develop a linear programming model to determine the number of nurses Richland Health should hire each month under each contract option in order to meet the projected needs at a minimum total cost. (The orange cells will be your variables.) Solve your LP using MS Solver.

Solution

Send it via the link on google docs.