Business Finance - Accounting 2 different assignments Budget Presentation

profilevennamason
BudgetAssignmentWorksheet-11.xlsx

Sheet1

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