1: 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 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:

PART !: PRINEVILLE FIRE DEPARTMENT PERSONNEL

Fiscal Year 2019 Salary Schedule

Step

Rank

1

2

3

4

Firefighter

$58,250

$61,162

$63,609

$65,517

Lieutenant

$91,000

$95,550

$99,372

$102,353

Captain

$109,250

$114,712

$119,301

$122,880

Fiscal Year 2018 Staffing (Full Time Equivalent)

Step

Rank

1

2

3

4

Firefighter

75

70

52

51

Lieutenant

20

18

17

14

Captain

8

6

5

10

PART 2: PRINEVILLE FIRE DEPARTMENT PERSONNEL

Fiscal Year 2019 Salary Schedule

Step

Rank

1

2

3

4

Firefighter

$58,250

$61,162

$63,609

$65,517

Lieutenant

$91,000

$95,550

$99,372

$102,353

Captain

$109,250

$114,712

$119,301

$122,880

Fiscal Year 2018 Staffing (Full Time Equivalent)

Step

Rank

1

2

3

4

Firefighter

75

70

52

51

Lieutenant

20

18

17

14

Captain

8

6

5

10