Reference no: EM132466325
The city council of Jefferson City decided to create new Tourism Department in FY 2019. The department has a director, secretary, marking director, two van drivers, and three tourism officers. As the budget officer for the city, your job is to create personnel budget for the department using the information listed below. Only consider the items that are listed. Read each bullet prior to beginning the assignment.
Complete the FTE column.
The department director has a salary of $109,000 and is a FTE.
The secretary has a salary of $48,000 and is a FTE.
The marketing director has a salary of $65,500 and is a FTE.
Each driver has a salary of $40,000 and is a FTE.
Each tourism officer has a salary of $20,000 and works part time (PTE). Although they each work 6 months out of the year, they are paid over a 12-month period.
FICA is 12.4% and Medicare is 2.9% for all employees. Only consider employer contributions to FICA and Medicare.
Health insurance costs are $3,000 per year for each FTE.
Each tourism officer has a clothing budget of $500.
Each driver has a clothing budget of $750.
Each tourism officer is eligible for 50% of the fringe benefits (health insurance premium, life insurance and pension).
Training costs associated with each tourism officer is $500.
Training costs associated with each driver is $800.
Life insurance premiums are $25 per month for each FTE.
Pensions are 9.5% of salary for each FTE. The city pays the full amount.
Use the attached Excel template for this assignment.