It has been a busy year with staff turnover, new employees and new equipment on order. Your CEO has requested a forecast of the human resource needs for North West Regional Hospital for the coming years. North West Regional Hospital (NWRH) is a purpose built, 180-bed inpatient facility and the largest regional hospital in the state. NWRH also has 15 outreach sites located throughout tropical, northern Australia, each of which employs approximately 17 individuals. In total, NWRH currently employs 700 people. Over the coming three years, NWRH is planning an expansion into additional regional areas and expects to add 25 new outreach sites. Each outreach site varies in size according to the needs of the community, so the figures represent averages.

During the past month, NWRH has placed an order for 3 new dialysis machines to increase its renal support services. These machines are scheduled to be in operation December 31, one year from now in existing outreach sites only. NWRH has found that for each new machine purchased requires four (4) additional nurses, on average. In addition, five (5) new doctors are added in year 2. A breakdown of NWRHs current staffing is shown in Table 1.

Your CEO has asked you to perform three human resource-forecasting tasks. First, based on the assumptions given below, you are required to determine employee turnover for the inpatient facility office, the old outreach sites, and the new outreach sites. The CEO would like to know this information for each of the next three years and for each of the major personnel categories (i.e., Doctors, Nurses, and Inpatient Facility Administration staff). Your job is to complete Table 2.

Second, your CEO would like to know the number of new employees NWRH will need to hire for each major personnel category for each of the next three years. Your job is to complete Table 3.

Finally, your CEO would like to know the total number of employees who will be working for NWRH as of the end of each of the next three years. Your job is to complete Table 4.

In order to complete your assignment, your CEO has told you to make a number of assumptions. They are:

1. You are making all projections in December for subsequent years ending December 31

2. With regard to the existing outreach offices, assume
   1. The 15 existing outreach offices employ 5 doctors and 12 nurses each.
   2. On December 31 (one year hence) 3 new dialysis machines are placed in operation and require an additional 12 nurses (4 per machine).
   3. On December 31 in the 2nd year, 5 new doctors are employed.
   4. Turnover rate is 40 percent for nursing personnel, and 20 percent for doctors.

3. With regard to new outreach sites, assume

1. New outreach sites are added as follows: 6 in Year 1, 10 in Year 2, and 9 in Year 3.
2. Each new outreach site employs 17 individuals (5 doctors and 12 nurses).
3. Turnover is 30 percent for nurses, and 20 percent for doctors.

4. With regard to the inpatient facility, assume that turnover will be 15 percent per year.

Table 1: Present staffing

Total Employees	700
Number of outreach sites	15
Doctors per outreach site	5
Number of Doctors	75
Nurses per outreach site	12
Number of Nurses	180
Outreach facility employees	255
Inpatient Facility Employees	445

Table 2: Turnover

Employee Category	Current Year	Year 1	Year 2	Year 3
Old outreach site Doctors
Old outreach site nurses
Inpatient facility
New outreach site Doctors
New outreach site nurses
TOTALS

Table 3: Number of Employees to be hired

Employee Category	Current Year	Year 1	Year 2	Year 3
Old outreach site Doctors
Old outreach site nurses
Inpatient facility
New outreach site Doctors
New outreach site nurses
TOTALS

Table 4: Year-End Employment

Employee Category	Current Year	Year 1	Year 2	Year 3
Old outreach site Doctors
Old outreach site nurses
Inpatient facility
New outreach site Doctors
New outreach site nurses
TOTALS

Please explain how to calculate those number step by step