Budgeting Classwork for Management Class
ccobbs26BudgetExerciseClassVersion2MiniWorksheetAns.xls
Sheet1
| Version 2 Mini |
| Categories | Current Budget | | Budget w/ Expectations | | Proposed Budget |
| Revenues | Revenues | | Revenues | | Revenues |
| Income | Income | | Income | | Income |
| Private Ins | $ 380,880.00 | | $ 392,306.40 | | $ 329,306.40 |
| Medicare | $ 205,000.00 | | $ 199,875.00 | | $ 199,875.00 |
| Total | $ 585,880.00 | | $ 592,181.40 | | $ 592,181.40 |
| Expenses | Expenses | | Expenses | | Expenses |
| Office Rent | $ 23,500.00 | | $ 24,440.00 | | $ 24,440.00 |
| Postage | $ 3,500.00 | | $ 3,500.00 | | $ 1,500.00 |
| Office Supplies | $ 8,000.00 | | $ 8,000.00 | | $ 3,000.00 |
| Labor |
| Wages | $ 550,600.00 | | $ 562,988.00 | | $ 562,988.00 |
| Total | $ 585,600.00 | | $ 598,928.00 | | $ 591,928.00 |
| | $ (280.00) | | $ 6,746.60 | | $ (253.40) |
| | Profit | | Over Budget | | Profit |