Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part I Part II Question 2: Prineville Fire Department (25 points) Note that in your Excel file, you will find templates for the results table
Part I
Part II
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 1: 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 1 personnel of that rank. For example, loss of a Step 4 firefighter will be filled by a Step 1 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 1 2 4 $66,066 $88,725 $117,117 $68,048 $91,387 $120,631 Firefighter $60,500 $63,525 Lieutenant $81,250 $85,312 Captain $107,250 $112,612 Fiscal Year 2018 Staffing (Full Time Equivalent) Step Rank 1 2 Firefighter 2148 Lieutenant 18 Captain PRINEVILLE FIRE DEPARTMENT PERSONNEL Average Turnover Rate (for any reason) by Grade and Step Step Grade 12 Firefighter 0.020 0 .060 0.090 Lieutenant 0.120 0.020 0.130 Captain 0.090 0.080 0.020 0.050 0.150 0.070 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 1: 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 1 personnel of that rank. For example, loss of a Step 4 firefighter will be filled by a Step 1 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 1 2 4 $66,066 $88,725 $117,117 $68,048 $91,387 $120,631 Firefighter $60,500 $63,525 Lieutenant $81,250 $85,312 Captain $107,250 $112,612 Fiscal Year 2018 Staffing (Full Time Equivalent) Step Rank 1 2 Firefighter 2148 Lieutenant 18 Captain PRINEVILLE FIRE DEPARTMENT PERSONNEL Average Turnover Rate (for any reason) by Grade and Step Step Grade 12 Firefighter 0.020 0 .060 0.090 Lieutenant 0.120 0.020 0.130 Captain 0.090 0.080 0.020 0.050 0.150 0.070
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started