I need help with a Budgeting Assignment
ccobbs26
BudgetExerciseClassVersion1Worksheet1.xlsSheet1
| Categories | Current Budget | Budget w/ Expectations | Proposed Budget |
| Revenues | |||
| Income | |||
| Private Ins | $ 80,880.00 | ||
| Medicare | $ 105,000.00 | ||
| Self Pay | $ 28,300.00 | ||
| HMO | $ 55,000.00 | ||
| Total | $ 269,180.00 | $ - 0 | $ - 0 |
| Expenses | |||
| Communications | $ 4,200.00 | ||
| Marketing | $ 5,200.00 | ||
| Office Rent | $ 23,500.00 | ||
| Printing Forms | $ 8,000.00 | ||
| Postage | $ 3,500.00 | ||
| Office Supplies | $ 8,500.00 | ||
| Cleaning Supplies | $ 2,400.00 | ||
| Employee Parking | $ 5,000.00 | ||
| Magazine Subscriptions | $ 1,200.00 | ||
| Continuing Education | $ 1,800.00 | ||
| Labor | |||
| Wages | $ 150,600.00 | ||
| OT | $ 5,000.00 | ||
| Holiday | $ 14,000.00 | ||
| Vacation | $ 27,000.00 | ||
| Sick | $ 9,000.00 | ||
| Total | $ 268,900.00 | $ - 0 | |
| $ (280.00) | $ - 0 | $ - 0 | |
| Profit | Over Budget |
&LVersion 1
