please help with question and tables

I. OBJECTIVES A. To give you practice in forecasting an organization's human resource need 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 Ill. 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, base 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 each major personnel category for each of the next years. Your job is to complete Table 2.3