budget
rakhi
budget_for_previous_year_updated_2014.xls2013 EXPENSES
| PUT THE NAME OF YOUR HOSPITAL HERE | ||||
| DEPARTMENT | ||||
| ANNUAL BUDGET FOR 2013 | ||||
| 2014 | ||||
| SALARIES | $471,000.00 | $ 494,550.00 | NOTE: There are tabs/worksheets in the lower left corner that contain additional information needed | |
| EDUCATION | $1,200.00 | 1260 | ||
| MAINTENANCE CONTRACTS | $25,000.00 | 26250 | ||
| REPAIRS | $3,500.00 | 3675 | ||
| FOOD | $300.00 | 315 | ||
| STORAGE | $7,200.00 | 7560 | ||
| POSTAGE | $1,200.00 | 604.8 | ||
| OFFICE SUPPLIES | $36,000.00 | 38520 | ||
| PROFESSIONAL DUES | $250.00 | |||
| TRAVEL | $1,800.00 | |||
| TOTAL | $547,450.00 | |||
| AVERAGE HOURLY RATE | $18.87 | $19.81 | ||
| REVENUE | $80,000.00 | 84000 |
SALARY WORKSHEET
| THE NAME OF YOUR HOSPITAL HERE | |||
| 2013 SALARIES | |||
| SALARY EXPENSES WORK SHEET | |||
| POSITION | SALARY | HOURLY RATE | *2080 |
| DIRECTOR | $80,000.00 | ||
| SUPERVISOR | $28.00 | $58,240.00 | |
| CODER | $22.00 | $45,760.00 | |
| CODER | $22.00 | $45,760.00 | |
| CODER | $18.00 | $37,440.00 | |
| COORDINATOR | $20.00 | $41,600.00 | |
| CLERK | $12.00 | $24,960.00 | |
| CLERK | $12.00 | $24,960.00 | |
| CLERK | $12.00 | $24,960.00 | |
| ADMIN ASST | $15.00 | $31,200.00 | |
| ADMIN ASST | $15.00 | $31,200.00 | |
| RECEPTIONIST | $12.00 | $24,960.00 | |
| $391,040.00 | |||
| DIRECTOR SALARY ADDED BACK IN | $80,000.00 | ||
| TOTAL SALARIES FOR DEPARTMENT | $471,040.00 |
MONTHLY EXPENSES
| PUT THE NAME OF YOUR HOSPITAL HERE | ||||||||||||||
| DEPARTMENT NAME | ||||||||||||||
| PUT THE NAME OF YOUR HOSPITAL HERE | ||||||||||||||
| DEPARTMENT NAME | ||||||||||||||
| MONTHLY EXPENSES FOR 2013 | ||||||||||||||
| JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YTD | 2014 | |
| SALARIES | $40,006.14 | $36,134.58 | $40,006.14 | $38,715.62 | $40,006.14 | $38,715.62 | $40,006.14 | $40,006.14 | $40,006.14 | $40,006.14 | $38,715.62 | $40,006.14 | $471,040.00 | $3,675.00 |
| EDUCATION | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $1,200.00 | $1,260.00 |
| MAINTENANCE CONTRACTS | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $25,000.00 | $26,250.00 |
| REPAIRS | $291.67 | $291.67 | $291.67 | $291.67 | $291.67 | $291.67 | $291.67 | $291.67 | $291.67 | $291.67 | $291.67 | $291.67 | $3,500.00 | $3,675.00 |
| FOOD | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $300.00 | $315.00 |
| STORAGE | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $7,200.00 | $7,560.00 |
| POSTAGE | $48.00 | $48.00 | $48.00 | $48.00 | $48.00 | $48.00 | $48.00 | $48.00 | $48.00 | $48.00 | $48.00 | $48.00 | $576.00 | $604.80 |
| OFFICE SUPPLIES | $3,000.00 | $3,000.00 | $3,000.00 | $3,000.00 | $3,000.00 | $3,000.00 | $3,000.00 | $3,000.00 | $3,000.00 | $3,000.00 | $3,000.00 | $3,000.00 | $36,000.00 | $38,520.00 |
| PROFESSIONAL DUES | $20.83 | $20.83 | $20.83 | $20.83 | $20.83 | $20.83 | $20.83 | $20.83 | $20.83 | $20.83 | $20.83 | $20.83 | $250.00 | |
| TRAVEL | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $1,800.00 | |
| TOTAL | $46,324.97 | $42,453.41 | $46,324.97 | $45,034.45 | $46,324.97 | $45,034.45 | $46,324.97 | $46,324.97 | $46,324.97 | $46,324.97 | $45,034.45 | $46,324.97 | $548,156.52 | |
| AVERAGE HOURLY RATE | ||||||||||||||
| REVENUE | $6,666.67 | $6,666.67 | $6,666.67 | $6,666.67 | $6,666.67 | $6,666.67 | $6,666.67 | $6,666.67 | $6,666.67 | $6,666.67 | $6,666.67 | $6,666.67 | $80,000.00 | 84000 |
