Question 2: Prineville Fire Department (25 points) Note that in your Excel file, you will find templates for the results table for Part I & II that need to be incorporated in your typed answers to this homework. Part I: No turnover Assume that you are the newly appointed Fire Chief for the City of Prineville. Personnel represent most of your budget and you want to do a quick estimate of the personnel budget for next year (FY 2019). Using the information from last year's budget and information from the city finance department, you construct a simple table with all the information. That table can be found in the sheet "Prineville FD I" of your Excel file. Under the union contract, all personnel are given a step increase for an additional year of service. However, once they reach Step 4, they are not automatically granted a promotion to the next rank. The fringe benefit rate in Prineville is 30%. Using this information, calculate the personnel budget for next year. Part 2: With turnover The budget analyst for public safety departments in Prineville criticized your estimate (in Part I), because you did not take into account turnover. She has provided you with average turnover rates by rank and step for the fire department over the last 5 years. Under union contract, the rules for filling vacancies are: "All vacancies will be filled by Step I personnel of that rank. For example, loss of a Step 4 firefighter will be filled by a Step I firefighter." Using this rules, the turnover rates given in this problem, and the information from Part I, recalculate the personnel budget for the Prineville Fire Department. Hint: Use the personnel schedule and the turnover rates to determine average number of personnel staying by Rank and Step. Using rules for seniority, determine the personnel schedule for those staying. Finally, fill the vacancies with the appropriate level staff, and calculate the salary and fringe budget.PRINEVILLE FIRE DEPARTMENT PERSONNEL Fiscal Year 2019 Salary Schedule Step Rank 2 3 Firefighter $60,500 $63,525 $66,066 $68,048 Lieutenant $81,250 $85,312 $68, 725 $91,387 Captain $107,250 $112,612 $117,117 $120,631 Fiscal Year 2018 Staffing (Full Time Equivalent) Step Rank 2 3 Firefighter 21 48 58 22 Lieutenant 18 12 10 19 Captain 5 6 10PRINEVILLE FIRE DEPARTMENT PERSONNEL Average Turnover Rate (for any reason) by Grade and Step* Step Grade Firefighter 0.020 0.060 0.090 0.050 Lieutenant 0.120 0.020 0.130 0.150 Captain 0.090 0.080 0.020 0.070