You have taken over as the finance director at Upstate Psychiatric Services (UPS), a mental health facility operated by the state. You have to put together next year's personnel budget for social workers and all you are given is some information about the operation of the hospital. In general, social workers are scheduled to visit a certain number of clients per day, eight hours per day, five days per week (social work visits do not occur on the weekend), and 52 weeks per year. On average, social workers require 1 or 2 hour to meet with a client (you will find the specific time in the Excel file). Social workers are full time staff, get paid a base salary per year. They are entitled to vacation time and sick leave (personal days). Health insurance is $2,400 (paid by the hospital), and the hospital are also required to pay 7.65% of salary for social security, 6% for pension, and 8% for unemployment/disability insurance. Using this information calculate the personnel budget for social workers. The number of clients per day, clients per hour, vacation and sick leave, and the base salary are in the Excel file. Also assume the following:

1. No turnover or no impact of turnover

2. Social workers all get paid same amount (no seniority bonus)

3. Fringe benefits apply to base salary

4. Clinic is open 260 days this year (52 x 5) What is the number of social workers required to serve all the clients? What is the total amount of base salary paid by UPS (across all staff)? What is the total amount of fringe benefits paid? What is the total budget request? Present your results in a table.

Budgeting Social Workers at UPS

Parameters

Days per week 5

Weeks per year 52

Hours per day 8

Clients per day 300

Productivity rate (clients per hour): 1.00

Vacation (weeks) 1

Sick leave (weeks) 1

Salary $37,000

Health insurance (cost per social worker per year) $2,400

Social Security (% of base salary) 7.65%

Pension (% of base salary) 6.00%

Unemployment/disability insurance (% of base salary) 8.00%