RFP 101 - RCAP - Appendix G - Budget Worksheet.xls
XLS spreadsheet 82 KB Posted
- Solicitation number
- 101
- Issued by
- Racine County, Wisconsin
About this file
This is a budget worksheet for the Racine County Alternatives Program (RCAP) administered by the Racine County Human Services Department in Wisconsin. The RFP #101 for RCAP was released in 2020, with all questions due by August 22, 2019, and sealed proposals due September 12, 2019, by 4:00 pm. The budget worksheet is designed to capture proposed program costs across multiple expense categories and to allocate staff time across programs. The document includes sections for personnel allocation by position and program, with fields for calculating full-time equivalent (FTE) allocations expressed as decimals based on hours worked per week.
The expense budget worksheet requires proposers to detail costs across personnel (salaries, payroll taxes, and employee benefits), operating expenses (professional fees, supplies, occupancy, equipment rental/maintenance, travel, client-related costs, staff training, professional liability insurance, and miscellaneous costs), management/general overhead (capped at 10% of program allocation), and profit. Supply detail worksheets specify quantities and types of items required, including GPS monitoring devices, SCRAM (Secure Continuous Remote Alcohol Monitoring) units, breath testing equipment, drug testing supplies (12-panel, 9-panel, 10-panel, and 6-panel urine cups with various specifications), and specialty drug dip tests. Proposers are required to identify comparable brands for specified supplies. The occupancy budget section requires itemization of rent, utilities, insurance, and maintenance costs, while the professional fees section addresses legal, accounting, audit, and consulting services. All proposals must comply with specifications on file at the Human Services Department and available through the Racine County website or by contacting the department directly.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFP 101 - RCAP.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
staff time allocation
| Proposed Program Budget | ||||||
| TIME ALLOCATION WORKSHEET Worksheet 1 | ||||||
| Please enter the names of all support and line staff that will be charged to HSD programs. | ||||||
| Enter the percentage of time each position will spend in each program. | ||||||
| Express the percentage of time as a decimal. For example, John Doe will spend 8 hours a week in Program X | ||||||
| In the Program X column, enter .20 beside John's name. (8hr x 52 weeks = 416. Divided by 2080, = .20) | ||||||
| Personnel by Program | ||||||
| FTE Equivalent Allocation | ||||||
| Name | Position | Annual Salary | Total FTE | Enter Program Name RCAP | ||
| Direct Staff FTE | Admin/Clerical/Supervision | |||||
| TOTAL | $ - 0 | 0.00 | 0.00 | 0.00 |
Expense budget
| EXPENSE BUDGET BY PROGRAM Worksheet 2 | |
| Expenses Allocated to Program | |
| RCAP | |
| Line Item | Total |
| Personnel | |
| Salaries | |
| Payroll Taxes | |
| Employee Benefits | |
| Subtotal Salary/Fringe | $ - 0 |
| Operating | |
| Professional Fees(See budget detail worksheet) | |
| Supplies (See supply detail worksheet) | |
| Occupancy (see budget detail worksheet) | |
| Rental/Maintenance of Equipment | |
| Travel | |
| Client Related Costs( See budget detail worksheet) | |
| Staff Training | |
| Professional Liability Insurance | |
| Miscellaneous (See budget detail worksheet) | |
| Operating SubTotal | $ - 0 |
| SUBTOTAL | $ - 0 |
| Management/General | |
| % Management/General to Program (Can't exceed 10%) | 0% |
| Profit | |
| TOTAL | $ - 0 |
Supply Detail
| Supply Detail Worksheet 3 | |||
| Supplies | Current Brand | **Proposer's Brand** | Charge Per Day |
| GPS (Global Positioning System) | Attenti's Unit | ||
| SCRAM | AMS CAM | ||
| Remote Breath SCRAM | AMS CAM | ||
| Sweart Patch *includes fee to be sent to the lab for testing | Pharmchek | ||
| Supplies | Current Brand | **Proposer's Brand** | Charge Per Unit |
| 12 panel CLIA waived Urine Cups *about 100 orderd per month | Premier BioTech | ||
| 9 panel urine cups w/ EtG (alcohol test) *about 150 ordered per month | Premier BioTech | ||
| 10 panel oral drug test *about 150 ordered per month | Premier BioTech | ||
| 6 panel oral drug test *about 400 ordered per month | Premier BioTech | ||
| Fentanyl urine dips *about 25 ordered per month | Premier BioTech | ||
| Gabapentin dips *only used on specific drug court clints known to abuse this | Premier BioTech | ||
| **Proposers Brand must be comparable to Current Brand** |
Budget Detail
| Budget Detail Worksheet 4 | |
| Occupancy | Annual Cost |
| Rent | |
| Building Depreciation | |
| Mortgage Interest | |
| Building Insurance | |
| Electricity | |
| Heating | |
| Sewer/Water | |
| contract maintenance | |
| real estate taxes | |
| building and grounds supplies | |
| TOTAL OCCUPANCY | $ - 0 |
| Professional Fees | Annual Cost |
| Legal Services | |
| Accounting Services | |
| Audit | |
| Other Consultants | |
| TOTAL PROFESSIONAL FEE | $ - 0 |
| Client Related Services ( Please List) | |
| Service | Annual Cost |
| TOTAL CLIENT RELATED | $ - 0 |
| Miscellaneous | Annual Cost |
| TOTAL MISCELLANEOUS | $ - 0 |
Agency Budget Overview
| AGENCY BUDGET OVERVIEW Worksheet 5 | |
| Enter Program Name RCAP | |
| TOTAL PROGRAM EXPENSE BUDGET |
File details come from the government source that posted it. Updated .