1. You have five physician-practice clients for your World Outpatient clinic. Each physician practice sends you all of their clients. For the purposes of budgeting, we will assume the varying amounts of listed gross revenue for each month a client sends patients to the clinic. Please note that each client starts with the clinic at different times during the year. Complete the revenue part of the budget worksheet (Budget Assignment Worksheet.xlsx Download Budget Assignment Worksheet.xlsx) by calculating the monthly totals and totals for each client.
2. The expenses are divided into labor and non-labor sections.
   1. For the labor expenses, you are given the needed information to calculate total individual and clinic labor costs. Use 2,080 as the number of hours a full-time employee works.
   2. For the non-labor expenses, you are given the total available to budget. Allocate those total dollars to each non-labor expense with the percentages your manager has provided.
3. Note, in all cases, any calculations must be shown in the Excel file.

Stocker & Associates World Outpatient Clinic

Summer 2018

January

February

March

April

May

June

July

August

September

October

November

December

Total

Revenues

Client 1

Client 2

Client 3

Client 4

Client 5

TOTALS

Client Monthly Revenue Estimate

Start Month

Client 1

$15,000

January

Client 2

$18,000

January

Client 3

$22,000

April

Client 4

$28,000

June

Client 5

$31,000

September

Labor Expenses

Hourly Wage

Status

# of positions

TOTAL ANNUAL COST

Staff Positions

Intake Coordinator

$ 12.50

Fulltime

2

Intake Assistant

$ 10.00

Halftime

1

Physicians

$ 68.00

Fulltime

2

Advanced Nurse Practitioner

$ 46.00

Fulltime

1

Registered Nurse

$ 28.00

Fulltime

3.5

Laboratory Scientist

$ 31.00

Fulltime

2

Radiology Technician

$ 21.00

Fulltime

1

TOTAL LABOR EXPENSE

Non-labor Operating Expenses

Fringe Benefits

35.0%

Equipment leases

6.5%

Materials and Supplies

16.0%

Travel

9.5%

Marketing

33.0%

TOTAL Non-labor Expenses

$655,000

100.0%

TOTAL Labor Expenses

TOTAL EXPENSES

NET Revenue Projected for Budget Year

Ratios

Salary as percent of total expense

Salary as percent of total revenue

Percentage of labor expense from physician and advanced nurse practitioner