Instructions for the employment services revenue estimator tool

How to use the tool

Each row of the estimated revenue tool represents one person. Only enter services that the person would use when estimating revenues. For example, if one waiver participant uses DT&H 15 minute units and Employment Support 15 minute units, you would enter staffing ratios and weekly units for these two services only. 

The spreadsheet consists of gray and white cells. The white cells require user entry and have a description box with instructions that can be seen when the user hovers over the cell. The gray boxes are populated fields and will have values after the user enters in the appropriate information.

Troubleshooting

Potential issue: Instead of an estimated rate or revenue, I see “#VALUE!” or “#N/A.”

Solution: You have not entered a value in one of the required fields to calculate this rate. Go back and ensure that you have selected or entered all required fields for this service rate.

Potential issue: I am not able to enter a staffing ratio for some services.

Solution: All of the individual services default to a 1:1 staffing ratio, as that is the only ratio available for individual services. You do not need to enter a staffing ratio. Simply enter the weekly units to get the estimated service rate.

Potential issue: For DTH Daily, this person does not get transportation but I am not able to get a rate without entering this information.

Solution: You must enter in all of the fields to get a rate. If a client does not get transportation, choose the appropriate fields, ending with “0 Miles” option for the Daily Mileage field.

Important data definitions

• Staffing customization: This customization is for deaf and hard of hearing people who meet specific criteria outlined in the Quick Reference for Staffing Customization. If no customization is needed, choose “No Customization.”
• County of residence: County where the person lives.
• Staffing ratio: Each service should have its own average staffing ratio.
• Rate with RVF: This rate populates based on the selected service, staffing ratio and county of residence. It represents projected 2019 framework values, following the 2017 legislative session.
• Weekly units: The number of units the person will use each week of the particular service.
• Total weekly revenue: Each service has a weekly revenue total under its header. This populates after the user enters the required inputs.
• Projected weekly revenue: This field adds up all of the weekly revenues for each of the services the person uses and provides a summary total weekly revenue.