Please answer it in detail, and show the detailed process.

INSTRUCTIONS You have been given the assignment of forecasting the human resource needs of Tropic Explorations (the Company) that currently employs approximately 1100 people. The Company presently has 50 exploration sites located throughout tropical Australia, each of which employs approximately 14 individuals. The Company is planning an expansion into regional areas and expects to add 38 new exploration sites over the next three years. Exploration sites within the Company differ considerably in size, so the figures represent averages. During the past month, the Company has placed an order for 30 automated survey machines to be placed in its old exploration site offices. These machines are scheduled to be in operation December 31, one year from now. The Company has found that for each new machine purchased, one less geologist is needed, on average. A breakdown of the Company's current staffing is shown in Table 1. The Company 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 main office, the old site offices, and the new regional site offices. Your boss would like to know this information for each of the next three years and for each of the major personnel categories (i.e., supervisors, geologists, and main office). Your job is to complete Table 2. (10 points) Second, your boss would like to know the number of new employees the Company will need to hire for each major persor nel category for each of the next three years. Your job is to complete Table 3. (12.5 points) Finally, your boss would like to know the total number of employees who will be working for the Company as of the end of each of the next three years. Your job is to complete Table 4. (12.5 points) Table 1: Present staffing Total Employees Number of site offices Supervisors per site office Number of Supervisors Geologists per Office Number of Geologists Sit office employees Main Office Employees 1100 50 4 200 10 500 700 400 Table 2: Turnover Employee Category Old Site Office Supervisors Year 1 Year 2 Year 3 Old Geologists Main Office New Site Office Supervisors New Geologists Year 1 Year 2 Year 3 Table 3: Number of Employees to be Hired Employee Category Old Site Office Supervisors Old Geologists Main Office New Site Office Supervisors New Geologists TOTALS Year 1 Year 2 Year 3 Table 4: Year-End Employment Employee Category Old Site Office Supervisors Old Geologists Main Office New Site Office Supervisors New Geologists TOTALS In order to complete your assignment, your boss has told you to make a number of assumptions. They are: A. You are making all projections in December for subsequent years ending December 31. B. With regard to the old site offices, assume a. The 50 old site offices employ 4 supervisors and 10 geologists each. b. On December 31 (one year hence) 30 machines are placed in operation and replace 30 geologists. C. The Company does not terminate any employees because of the new machine. Rather, as geologists quit throughout the year, 30 are not replaced. d. Turnover is 30 percent for geologist personnel, and 20 percent for supervisors. C. With regard to new site offices, assume a. New site offices are added as follows: 10 in Year 1, 12 in Year 2, and 16 in Year 3. b. Each new site office employs 14 individuals (4 supervisors and 10 geologists). C. New site offices are added evenly throughout the year. Thus, for the purpose of calculating turnover, on average, there are 5 new site offices in Year 1 (50% x 10); 16 in year 2 [10 in Year 1 plus 6 (50% x 12)]; and 30 in Year 3 (22 plus 8 (50% x 16)]. [NOT APPLICABLE] d. Turnover is 30 percent for geologists, and 20 percent for supervisors. D. With regard to the main office, assume that turnover will be 10 percent per year. INSTRUCTIONS You have been given the assignment of forecasting the human resource needs of Tropic Explorations (the Company) that currently employs approximately 1100 people. The Company presently has 50 exploration sites located throughout tropical Australia, each of which employs approximately 14 individuals. The Company is planning an expansion into regional areas and expects to add 38 new exploration sites over the next three years. Exploration sites within the Company differ considerably in size, so the figures represent averages. During the past month, the Company has placed an order for 30 automated survey machines to be placed in its old exploration site offices. These machines are scheduled to be in operation December 31, one year from now. The Company has found that for each new machine purchased, one less geologist is needed, on average. A breakdown of the Company's current staffing is shown in Table 1. The Company 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 main office, the old site offices, and the new regional site offices. Your boss would like to know this information for each of the next three years and for each of the major personnel categories (i.e., supervisors, geologists, and main office). Your job is to complete Table 2. (10 points) Second, your boss would like to know the number of new employees the Company will need to hire for each major persor nel category for each of the next three years. Your job is to complete Table 3. (12.5 points) Finally, your boss would like to know the total number of employees who will be working for the Company as of the end of each of the next three years. Your job is to complete Table 4. (12.5 points) Table 1: Present staffing Total Employees Number of site offices Supervisors per site office Number of Supervisors Geologists per Office Number of Geologists Sit office employees Main Office Employees 1100 50 4 200 10 500 700 400 Table 2: Turnover Employee Category Old Site Office Supervisors Year 1 Year 2 Year 3 Old Geologists Main Office New Site Office Supervisors New Geologists Year 1 Year 2 Year 3 Table 3: Number of Employees to be Hired Employee Category Old Site Office Supervisors Old Geologists Main Office New Site Office Supervisors New Geologists TOTALS Year 1 Year 2 Year 3 Table 4: Year-End Employment Employee Category Old Site Office Supervisors Old Geologists Main Office New Site Office Supervisors New Geologists TOTALS In order to complete your assignment, your boss has told you to make a number of assumptions. They are: A. You are making all projections in December for subsequent years ending December 31. B. With regard to the old site offices, assume a. The 50 old site offices employ 4 supervisors and 10 geologists each. b. On December 31 (one year hence) 30 machines are placed in operation and replace 30 geologists. C. The Company does not terminate any employees because of the new machine. Rather, as geologists quit throughout the year, 30 are not replaced. d. Turnover is 30 percent for geologist personnel, and 20 percent for supervisors. C. With regard to new site offices, assume a. New site offices are added as follows: 10 in Year 1, 12 in Year 2, and 16 in Year 3. b. Each new site office employs 14 individuals (4 supervisors and 10 geologists). C. New site offices are added evenly throughout the year. Thus, for the purpose of calculating turnover, on average, there are 5 new site offices in Year 1 (50% x 10); 16 in year 2 [10 in Year 1 plus 6 (50% x 12)]; and 30 in Year 3 (22 plus 8 (50% x 16)]. [NOT APPLICABLE] d. Turnover is 30 percent for geologists, and 20 percent for supervisors. D. With regard to the main office, assume that turnover will be 10 percent per year