Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Authentication
digital resources
208x Filetype XLSX File size 0.02 MB Source: mesh-mn.org
Sheet 1: About This Tool
| About This Tool | |||||||||
| The Simple HSS Budget Forecasting Tool was created by the Housing Stabilization Services Technical Assistance Team (HSS-TA Team), which is a partnership between CSH, Ei-Consultants, MESH, and North Star Policy Consulting. This tool is NOT a substitute for official guidance from DHS. This tool is intended to help your agency think about direct staff costs and revenue. It is intended to be a simplified version of a budgeting tool, meant to visualize how much revenue Housing Stabilization Services could generate for your agency, as well as how much billable time each staff person will need to work in order to break even to cover the costs of their pay. Please note that this tool does NOT include all the possible costs associated with HSS such as medical billing, staff training, supervising staff, travel, EHR software that you may choose to purchase, etc. A more detailed Services Budget Tool that does include these factors is available on the HSS-TA Team section of the MESH website. |
|||||||||
| Related resources from the HSS-TA Team: | |||||||||
| HSS-TA Team Resources & Tools webpage | |||||||||
| CSH Services Budget Tool | |||||||||
| CSH Services Budget Tool Companion Guide | |||||||||
| Staff Costs Forecasting Tool | ||||||||||||||||||
| PERSONNEL COSTS | FRINGE BENEFITS | TOTAL | ||||||||||||||||
| Employee | Position Title | 2021 Pay Rate | Base Hours | Annual Salary | FICA | Medicare | SUTA | Life/AD&D Insurance | LTD | Health Insurance | Workers' Comp | Retirement | Retirement Match | Total Fringe Benefits | Total Annual Cost | Total Monthly Cost | ||
| John Doe | Case Manager | $22.00 | 2,080 | $45,760.00 | 45,760 | 2,837.12 | 663.52 | 700.00 | 324.00 | 425.57 | 11,132.00 | 457.60 | 1,372.80 | 1,372.80 | $19,285.41 | $65,045.41 | $5,420.45 | |
| 2,080 | $- | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | $- | $- | $- | ||||
| 2,080 | $- | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | $- | $- | $- | ||||
| TOTAL | $45,760.00 | TOTAL | $19,285.41 | $65,045.41 | $5,420.45 | |||||||||||||
no reviews yet
Please Login to review.
