To complete assignment use EXCEL
Prepare a salary your FY 2015 Salary Projection Report for the Jefferson City Fire Department for FY 2015 using the actual budget for FY 2014 as a model along with a budget request for two new fire fighter (2a positions. use the following information in year FY 2015 Salary Projection and budget projections. 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 each staff person.
| 1. The salary of the chief increased 7% while everyone else received a 5% increase |
| 2. FICA is 12.4% and Medicare is 2.9% for all employees. Only consider employer contributions to FICA and Medicare |
| 3. The cost of health insurance increased 5%. |
| 4. The cost of uniforms increased 2%. |
| 5. The fire fighter's pay range is $30,000.00-$40,000.00. You will pay the new fire fighters (2a) $35,000.00 |
| 6. The new fire fighters (2a) will receive the same benefits package as the other FY 2015 employees |
| 7. Cost of training the new fire fighters is $2,000 per employee. |
| 8. The pension rate in FY 2015 is the same as it was in FY 2014. |
| 9. The clerical staff member .works a half day shcedule 12 months per year (.5 FTE). |
Complete the FTE column
HERE IS THE ACTUAL BUDGET FOR 2014, TO USE FOR 2015!!!,..... i WASN'T ABLE TO ALIGN THE CHART HORIZONTALLY, I HAVE ALL THE DATE HERE, IF WHOEVER IS ASSISTING ME, CAN ALIGN IT, IN EXCEL, WOULD BE AWESOME!!!!!!.... THANK YOU SO MUCH.
Please provide the formula used to calculate the salary for FY 2015 and FICA for the same year
Jefferson City Fire Department Personnel Services Budget
FY 2014
Postion
Chief
Shift Commander
Fire Fighter 1a
Fire Fighter 1b
Clerical (PT)
FTE
1
3
12
26
.5
Total: 42.5
Salary
$87,000.00
150,000.00
420,000.00
650,000.00
45,000.00
Total: $1,352,000.00
SS
$5,394.00
9,300.00
26,040.00
40,300.00
2,790.00
Total:$83,824.00
Health Ins
$2,160.00
6,480.00
25,920.00
56,160.00
0.00
Total: $90,720.00
Pension
$17,400.00
30,000.00
84,000.00
130,000.00
9,000.00
Total: $270,400.00
Medicare
$1,260.50
2,175.00
6,090.00
9,425.00
652.50
Total: 19,604.00
Uniforms
$750.00
2,250.00
9,000.00
19,500.00
0.00
Total: $31,500.00
TOTAL
$113,965.50
200,205.00
570,050.00
905,385.00
57,442.50
TOTAL: $1,848,048.00
summer Services and Operating Budgets 3. Prepare a salary projection report for the Jefferson City Fire Department FY 2019 using the actual budget for FY 2018 as a model along with a budget Irequest 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 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 897 answers Was this answer helpful? bo The table is construed from the data given in question for the Budget Year 2014 C15 From the budget changes which need to be implemented in Year 2015, the corresponding columns have been calculated and a new table has been prepared accordingly. 1 Jeffer 2 round 3 Y 2015 The Health Insurance is considered to be $2268/employee for the year 2015 and Uniform Cost is considered as $745/employee. 5 6 hiel 7 i Co BUDGET FOR YEAR 2014 FTE 9 e Figl 10 local 11 OTAL 12 13 Y DOIS 3 Postion Chief Shift Commander Fire Fighter la Fire Fighter 1b Clerical (PT) Salary SS $87.000.000 $5,394.00 $150,000.00 $9,300.00 $420,000.00 $26,040.00 $650,000.00 $40,300.00 $45,000.00 $2,790.00 $1,352,000.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 $9,000.00 $270, 400,00 Medicare $1.260.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 $113.965.50 $200,205.00 $571.050.00 $905,135.00 $57.442.50 $1,848,048.00 26 0.5 15 hief 16 CC 17 re Fig 18 Fig 19 Jorical 20 OTAI 21 Total 42.5 BUDGET FOR YEAR 2015 FTE Rea 3 Postion Ichief Shift Commander Fire Fighter la Fire Fighter 1b Clerical (PT) Fire Fighter 2a (New) Total Salary $93,090.00 $157,500.00 $441,000.00 $682 500.00 $47,250.00 $70,000.00 $1,491,340.00 SS $5,771.58 $9,765.00 $27,342.00 $42.315.00 $2,929.50 $4,340.00 $92,463.08 Health Ins $2,268.00 $5,804.00 $27,216.00 $58.968.00 $0.00 $4,536.00 $99,792.00 Pension $18,618.00 $31,500.00 $88,200.00 $136,500.00 $9.450.00 $14,000.00 $298,268.00 Medicare $1,349.81 $2,283.75 $6,394.50 $9.896.25 $685.13 $1,015.00 $21,624.43 Uniforms $765.00 $2,295.00 $9,180.00 $19.890.00 $0.00 $1.530.00 $33,660.00 Training $0.00 $0.00 $0.00 $0.00 $0.00 $4,000.00 $4,000.00 TOTAL $121,862.39 $210,147.75 $599,332.50 $950,069.25 $60,314.63 $99.421.00 $2,041,147.51 2 6 0.5 2 42.5 View comments (1) > summer Services and Operating Budgets 3. Prepare a salary projection report for the Jefferson City Fire Department FY 2019 using the actual budget for FY 2018 as a model along with a budget Irequest 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 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 897 answers Was this answer helpful? bo The table is construed from the data given in question for the Budget Year 2014 C15 From the budget changes which need to be implemented in Year 2015, the corresponding columns have been calculated and a new table has been prepared accordingly. 1 Jeffer 2 round 3 Y 2015 The Health Insurance is considered to be $2268/employee for the year 2015 and Uniform Cost is considered as $745/employee. 5 6 hiel 7 i Co BUDGET FOR YEAR 2014 FTE 9 e Figl 10 local 11 OTAL 12 13 Y DOIS 3 Postion Chief Shift Commander Fire Fighter la Fire Fighter 1b Clerical (PT) Salary SS $87.000.000 $5,394.00 $150,000.00 $9,300.00 $420,000.00 $26,040.00 $650,000.00 $40,300.00 $45,000.00 $2,790.00 $1,352,000.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 $9,000.00 $270, 400,00 Medicare $1.260.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 $113.965.50 $200,205.00 $571.050.00 $905,135.00 $57.442.50 $1,848,048.00 26 0.5 15 hief 16 CC 17 re Fig 18 Fig 19 Jorical 20 OTAI 21 Total 42.5 BUDGET FOR YEAR 2015 FTE Rea 3 Postion Ichief Shift Commander Fire Fighter la Fire Fighter 1b Clerical (PT) Fire Fighter 2a (New) Total Salary $93,090.00 $157,500.00 $441,000.00 $682 500.00 $47,250.00 $70,000.00 $1,491,340.00 SS $5,771.58 $9,765.00 $27,342.00 $42.315.00 $2,929.50 $4,340.00 $92,463.08 Health Ins $2,268.00 $5,804.00 $27,216.00 $58.968.00 $0.00 $4,536.00 $99,792.00 Pension $18,618.00 $31,500.00 $88,200.00 $136,500.00 $9.450.00 $14,000.00 $298,268.00 Medicare $1,349.81 $2,283.75 $6,394.50 $9.896.25 $685.13 $1,015.00 $21,624.43 Uniforms $765.00 $2,295.00 $9,180.00 $19.890.00 $0.00 $1.530.00 $33,660.00 Training $0.00 $0.00 $0.00 $0.00 $0.00 $4,000.00 $4,000.00 TOTAL $121,862.39 $210,147.75 $599,332.50 $950,069.25 $60,314.63 $99.421.00 $2,041,147.51 2 6 0.5 2 42.5 View comments (1) >
