it has to be done in Excel
summer Services and Operating Budgets 3. Prepare a salary projection report for the Jefferson City Fire Denart FY 2019 using the actual budget for FY 2018 as a model along with a budget request for two new fire fighter (2a) positions. Use the following information in your FY 2019 Salary Projections and budget requests (see Appendix 3B). Note that the budget has the number of employees in each position grade rather than listing each employee. Also, you should calculate the total cost of employment for each staff person. The salary of the chief increased 7% while everyone else re- ceived a 5% increase. FICA is 12.4% and Medicare is 2.9% for all employees. Only consider employer contributions to FICA and Medicare. The cost of health insurance increased 5%. The cost of uniforms increased 2%. The fire fighter's pay range is $60,000.00-$80,000.00. You will pay the new fire fighters (2a) $60,000.00 The new fire fighters (2a) will receive the same benefits pack- age as the other FY 2015 employees. Cost of training the new fire fighters is $6,000 per employee. The pension rate in FY 2019 is the same as it was in FY 2018 The clerical staff member works a half day schedule 12 months per year (.5 FTE). Complete the FTE column. 4. Three employees are retiring from Jefferson City. Your job as the human The following Appendix 3B Jefferson City Fire Department Personnel Services Budget FY 2018 Position Chief Shift Commander Fire Fighter la Fire Fighter 1b Clerical (PT) TOTAL ETE 1 3 12 26 0.5 42.5 Salary $87,000.00 150,000.00 420,000.00 650,000.00 45.000,00 $1,352,000.00 SS $5,394.00 9.300.00 26,040.00 40,300.00 2.790.00 $83,824.00 Health Ins. $2,160.00 6,480.00 25.920.00 56,160.00 0.00 $90,720.00 Pension $17,400.00 30,000.00 84,000,00 130,000.00 2.000.00 $270,400.00 Medicats $1,261.50 2,175.00 6,090.00 9,425.00 652.50 $19,604,00 Uniforms $750.00 2,250,00 9.000.00 19,500.00 0 .00 $31,500.00 TOTAL 5113,965.50 200,205.00 571,050.00 905,385.00 57.442.50 $1,848,048.00 FTE Salary SS Health Ins. Pension Medicare Uniforms TOTAL FY 2019 Position Chief Shift Commander Fire Fighter la Fire Fighter Ib Clerical (PT) TOTAL New Position Budget Request TOTAL Training Uniforms Medicare Pension Health Ins FTE Salary SS Position Fire Fighter 2a TOTAL Uniforms Training Medicare Pension GRAND TOTAL ALL POSITIONS Health Ins. FTE Salary FY 2019 19 3. Prepare a salary pro FY 2019 using the act request for two your FY 2019 Salary P hare a salary project houden for FY 2018 as a m a salary projection report for the Jefferson City Fire Departmer the actual budget for FY 2018 as a model along with a budget for two new fire fighter (2a) positions. Use the following informati 019 Salary Projections and budget requests (see Appendix 3B). Note Wie budget has the number of employees in each position grade rather than each employee. Also, you should calculate the total cost of employment for each staff person. The salary of the chief increased 7% while everyone else re- ceived a 5% increase. FICA is 12.4% and Medicare is 2.9% for all employees. Only consider employer contributions to FICA and Medicare. The cost of health insurance increased 5%. The cost of uniforms increased 2%. The fire fighter's pay range is $60,000.00-$80,000.00. You will pay the new fire fighters (2a) $60,000.00 The new fire fighters (2a) will receive the same benefits pack- age as the other FY 2015 employees. Cost of training the new fire fighters is $6,000 per employee. The pension rate in FY 2019 is the same as it was in FY 2018. The clerical staff member works a half day schedule 12 months per year (.5 FTE). Complete the FTE column. Appendix 3B Jefferson City Fire Department Personnel Services Budget FTE SS FY 2018 Position Chief Shift Commander Fire Fighter la Fire Fighter ID Clerical (PT) TOTAL Salary $87,000.00 150,000.00 420,000.00 650,000.00 45.000,00 $1,352,000.00 $5,399.00 9.300.00 26,040,00 40,300.00 2.720.00 $83,824.00 Health Ins. $2,160.00 6.480,00 25.920,00 56,160.00 0.00 $90,720.00 Pension $17,400.00 30,000.00 84,000,00 130,000.00 2.000.00 $270,400.00 Medicars $1,261.50 2,175.00 6,090.00 9,425.00 652.50 $19,604.00 Uniforms $750.00 2.250.00 9,000.00 19,500.00 TOTAL $113,965.50 200,205.00 571,050.00 905,385.00 57.442.50 $1,848,048.00 0.5 425 $31,500.00 ETE Salary SS Health Ins. Pension Medicare Uniforms TOTAL FY 2019 Position Chief Shift Commander Fire Fighter la Fire Fighter 1b Clerical (PT) TOTAL - - - - New Position Budget Request ETE Salas SS TOTAL Health Ins Pension Medicare Uniforma Training Position Fire Fighter 23 GRAND TOTAL ALL POSITIONS FY 2019 Uniforms Training TOTAL FTE Health Ins. Medicare Pension Salary
