week5
jrunner
HIMA600Week5BudgetforPreviousYear1.xls2006 EXPENSES
| PUT THE NAME OF YOUR HOSPITAL HERE | |
| HEALTH INFORMATION MANAGEMENT | |
| ANNUAL BUDGET FOR 2016 | |
| SALARIES | $471,040.00 |
| EDUCATION | $1,200.00 |
| MAINTENANCE CONTRACTS | $25,000.00 |
| REPAIRS | $3,500.00 |
| FOOD | $300.00 |
| STORAGE | $7,200.00 |
| POSTAGE | $1,200.00 |
| OFFICE SUPPLIES | $36,000.00 |
| PROFESSIONAL DUES | $250.00 |
| TRAVEL | $1,800.00 |
| TOTAL | $547,490.00 |
| AVERAGE HOURLY RATE | $18.87 |
| REVENUE | $78,000.00 |
SALARY WORKSHEET
| THE NAME OF YOUR HOSPITAL HERE | |||
| 2016 SALARIES | |||
| SALARY EXPENSES WORK SHEET | |||
| POSITION | SALARY | HOURLY RATE | *2080 |
| DIRECTOR | $80,000.00 | ||
| DRG COORDINATOR | $28.00 | $58,240.00 | |
| CODER | $22.00 | $45,760.00 | |
| CODER | $22.00 | $45,760.00 | |
| CODER | $18.00 | $37,440.00 | |
| SUPERVISOR | $20.00 | $41,600.00 | |
| CLERK | $12.00 | $24,960.00 | |
| CLERK | $12.00 | $24,960.00 | |
| CLERK | $12.00 | $24,960.00 | |
| ROI CLERK | $15.00 | $31,200.00 | |
| ROI CLERK | $15.00 | $31,200.00 | |
| VITAL STATS CLERK | $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 | |||||||||||||
| HEALTH INFORMATION MANAGEMENT | |||||||||||||
| MONTHLY EXPENSES FOR 2016 | |||||||||||||
| JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YTD | |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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,500.00 | $6,500.00 | $6,500.00 | $6,500.00 | $6,500.00 | $6,500.00 | $6,500.00 | $6,500.00 | $6,500.00 | $6,500.00 | $6,500.00 | $6,500.00 | $78,000.00 |
