HIM 305
kennybabs
CapstoneSpreadsheetHIM305.xlsxLast Year Budget
| Coppin State Regional Health Center | ||
| Health Information Management Department Budget | ||
| 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 |
Salaries Budget
| POSITION | SALARY | HOURLY RATE | Yearly | ||
| 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
| 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 |
