Question: To complete assignment use EXCEL or a similar spreadsheet application !!!!!!!!! Due 10/7/17 Prepare a salary your FY 2015 Salary Projection Report for the Jefferson
| To complete assignment use EXCEL or a similar spreadsheet application!!!!!!!!! Due 10/7/17 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
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help