You have been assigned the task of completing the proposed budget for the next fiscal year for your Department. The fiscal year is from January December. You will be using the historical data provided in the Excel file as well as considering your projections for future costs.

You have been told to project a maximum 5% salary increase.

Based on 2080 hours working a year, what is your departments average hourly rate before the raise/ after the raise? (Include this in the budget worksheet)

Fringe Benefits= 12%

1. Create a salary budget for 2019. You may have to add/delete columns in the one I gave you.

2. Create an excel spreadsheet for your budget.

This is preparing your Salary Budget for the next year. I want you to have a total budget amount (including fringe benefits) that you will pay for personnel. (That should be at the bottom)

For the final, we will add this information to additional information to create a full departmental budget.

Formulas in all of calculations in Excel.

{Hospital Name}
2018 SALARIES
SALARY EXPENSES WORK SHEET
POSITION	SALARY	HOURLY RATE	Hrs Worked Per Wk
DIRECTOR	$80,000.00
CLINICAL DATA SPECIALIST		$28.00	40
CODER		$22.00	40
CODER		$22.00	32
CODER		$18.00	32
SUPERVISOR		$20.00	40
CLERK		$12.00	20
CLERK		$12.00	20
CLERK		$12.00	20
ROI CLERK		$15.00	40
ROI CLERK		$15.00	20
VITAL STATS CLERK		$12.00	40
TOTAL SALARIES FOR DEPARTMENT