Please answer questions 1a, 2a, 2b, and 3c from the last screenshot.

32 SKILL BUILDER Human Resource Forecasting Assignment I. OBJECTIVES A. To give you practice in forecasting an organization's human resource needs. B. To familiarize you with some of the factors that affect an organization's future human resource needs (growth, automation, turnover). C. To familiarize you with the complexities involved in making human resource forecasts. D. To point out that all human resource forecasting is based on assumptions and that these assumptions are critical to the accuracy of the forecast. Incorrect assumptions lead to erroneous forecasts. II. TIME REQUIRED TO COMPLETE: One to two hours III. INSTRUCTIONS You have been given the assignment of forecasting the human resource needs of the National Bank and Trust Company which currently employs approximately 1,100 people. The bank presently has 50 branch offices located throughout the metropolitan area, each of which employs approximately 14 individuals. The bank expects to add 38 branches during the next three years. Branches within the bank differ considerably in size, so the figures given represent averages. During the past month, the bank has placed an order for 30 automated teller machines to be placed in its former branch offices. These machines are scheduled to be in operation December 31, one year from now. The bank has found that for each new machine purchased, one less teller is needed, on average. A breakdown of the bank's current staffing is shown in Table 2.1. The bank 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 former branches, and the new branches. 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, tellers/clerical, and main office). Your job is to complete Table 2.2. Second, your boss would like to know the number of new employees the bank will need to hire for each major personnel category for each of the next three years. Your job is to complete Table 2.3. Table 2.1 Present Staffing 1,100 50 4 Total Employees Number of Branches Supervisors per Branch Number of Supervisors Tellers per Branch Number of Tellers Branch Employees Main Office Employees 200 10 500 700 400 Table 2.1 Turnover Year 1 Year 2 Year 3 Employee Category Former Branch Supervisors Former Branch Tellers Main Office New Branch Supervisors New Branch Tellers Table 2.3 Number of Employees to be Hired Year 1 Year 2 Year 3 Employee Category Former Branch Supervisors Former Branch Tellers Main Office New Branch Supervisors New Branch Tellers Totals Table 2.4 Year-End Employment Year 1 Year 2 Year 3 Employee Category Former Branch Supervisors Former Branch Tellers Main Office New Branch Supervisors New Branch Tellers Totals Finally, your boss would like to know the total number of employees who will be working for the bank as of the end of each of the next three years. Your job is to complete Table 2.4. 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 former branches, assume 1. The 50 former branches employ four supervisors and ten clerical personnel/tellers each 2. On December 31 (one year hence), 30 teller machines are placed in operation and replace 30 tellers. 3. The bank does not terminate any employees because of the new teller machines. Rather, as tellers quit throughout the year, 30 are not replaced. 4. Turnover is 30 percent for tellers/clerical personnel, and 20 percent for supervisors. C. With regard to new branches, assume 1. New branches are added as follows: 10 in Year 1, 12 in Year 2, and 16 in Year 3. 2. Each new branch employs 14 individuals (four supervisors and ten tellers/clerical). 3. New branches are added evenly throughout the year. Thus, for the purpose of calculating turnover, on average, there are five new branches in Year (50% 10); 16 in Year 2 [10 in Year 1 plus 6 (50% 12)]; and 30 in Year 3 (22 plus 8 (50% 16)). 4. Turnover is 30 percent for tellers/clerical personnel, and 20 percent for supervisors. D. With regard to the main office, assume that turnover will be 10 percent per year. Skill builder: Human Resource Forecasting Assignment (pp. 103-105) You have been given the assignment of forecasting the human resource needs of the National Bank and Trust Company which currently employs approximately 1,100 people. The bank presently has 50 branch offices located throughout the metropolitan area, each of which employs approximately 14 individuals. The bank expects to add 38 branches during the next three years. Branches within the bank differ considerably in size, so the figures given represent averages. During the past month, the bank has placed an order for 30 automated teller machines to be placed in its former branch offices. These machines are scheduled to be in operation December 31, one year from now. The bank has found that for each new machine purchased, one less teller is needed, on average. A breakdown of the bank's current staffing is shown in Table 2.1. (p. 104) 1. Based on some of the given assumptions at the bottom of p. 104 (continuing onto p.105), your job is to forecast how many new employees the bank will need to hire for each major personnel category for each of the next 3 years. a. Please complete the forecasting task by filling out Table 2.3 on p. 104 prior to class. 2. Your forecasting results may be different from other team members, which is fine for this exercise. a. Bring your result to your team discussion. b. Explain why you made your forecasting that way. c. Ask other team members for their team rationales (if different from yours). 32 SKILL BUILDER Human Resource Forecasting Assignment I. OBJECTIVES A. To give you practice in forecasting an organization's human resource needs. B. To familiarize you with some of the factors that affect an organization's future human resource needs (growth, automation, turnover). C. To familiarize you with the complexities involved in making human resource forecasts. D. To point out that all human resource forecasting is based on assumptions and that these assumptions are critical to the accuracy of the forecast. Incorrect assumptions lead to erroneous forecasts. II. TIME REQUIRED TO COMPLETE: One to two hours III. INSTRUCTIONS You have been given the assignment of forecasting the human resource needs of the National Bank and Trust Company which currently employs approximately 1,100 people. The bank presently has 50 branch offices located throughout the metropolitan area, each of which employs approximately 14 individuals. The bank expects to add 38 branches during the next three years. Branches within the bank differ considerably in size, so the figures given represent averages. During the past month, the bank has placed an order for 30 automated teller machines to be placed in its former branch offices. These machines are scheduled to be in operation December 31, one year from now. The bank has found that for each new machine purchased, one less teller is needed, on average. A breakdown of the bank's current staffing is shown in Table 2.1. The bank 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 former branches, and the new branches. 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, tellers/clerical, and main office). Your job is to complete Table 2.2. Second, your boss would like to know the number of new employees the bank will need to hire for each major personnel category for each of the next three years. Your job is to complete Table 2.3. Table 2.1 Present Staffing 1,100 50 4 Total Employees Number of Branches Supervisors per Branch Number of Supervisors Tellers per Branch Number of Tellers Branch Employees Main Office Employees 200 10 500 700 400 Table 2.1 Turnover Year 1 Year 2 Year 3 Employee Category Former Branch Supervisors Former Branch Tellers Main Office New Branch Supervisors New Branch Tellers Table 2.3 Number of Employees to be Hired Year 1 Year 2 Year 3 Employee Category Former Branch Supervisors Former Branch Tellers Main Office New Branch Supervisors New Branch Tellers Totals Table 2.4 Year-End Employment Year 1 Year 2 Year 3 Employee Category Former Branch Supervisors Former Branch Tellers Main Office New Branch Supervisors New Branch Tellers Totals Finally, your boss would like to know the total number of employees who will be working for the bank as of the end of each of the next three years. Your job is to complete Table 2.4. 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 former branches, assume 1. The 50 former branches employ four supervisors and ten clerical personnel/tellers each 2. On December 31 (one year hence), 30 teller machines are placed in operation and replace 30 tellers. 3. The bank does not terminate any employees because of the new teller machines. Rather, as tellers quit throughout the year, 30 are not replaced. 4. Turnover is 30 percent for tellers/clerical personnel, and 20 percent for supervisors. C. With regard to new branches, assume 1. New branches are added as follows: 10 in Year 1, 12 in Year 2, and 16 in Year 3. 2. Each new branch employs 14 individuals (four supervisors and ten tellers/clerical). 3. New branches are added evenly throughout the year. Thus, for the purpose of calculating turnover, on average, there are five new branches in Year (50% 10); 16 in Year 2 [10 in Year 1 plus 6 (50% 12)]; and 30 in Year 3 (22 plus 8 (50% 16)). 4. Turnover is 30 percent for tellers/clerical personnel, and 20 percent for supervisors. D. With regard to the main office, assume that turnover will be 10 percent per year. Skill builder: Human Resource Forecasting Assignment (pp. 103-105) You have been given the assignment of forecasting the human resource needs of the National Bank and Trust Company which currently employs approximately 1,100 people. The bank presently has 50 branch offices located throughout the metropolitan area, each of which employs approximately 14 individuals. The bank expects to add 38 branches during the next three years. Branches within the bank differ considerably in size, so the figures given represent averages. During the past month, the bank has placed an order for 30 automated teller machines to be placed in its former branch offices. These machines are scheduled to be in operation December 31, one year from now. The bank has found that for each new machine purchased, one less teller is needed, on average. A breakdown of the bank's current staffing is shown in Table 2.1. (p. 104) 1. Based on some of the given assumptions at the bottom of p. 104 (continuing onto p.105), your job is to forecast how many new employees the bank will need to hire for each major personnel category for each of the next 3 years. a. Please complete the forecasting task by filling out Table 2.3 on p. 104 prior to class. 2. Your forecasting results may be different from other team members, which is fine for this exercise. a. Bring your result to your team discussion. b. Explain why you made your forecasting that way. c. Ask other team members for their team rationales (if different from yours)