RFP 101 - RCAP - Appendix G - Budget Worksheet.xls

XLS spreadsheet 82 KB Posted

Attached to
RFP #101 - Racine County Alternatives Program (RCAP)
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 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
NamePositionAnnual SalaryTotal FTEEnter Program Name RCAP
Direct Staff FTEAdmin/Clerical/Supervision
TOTAL$ - 00.000.000.00

Expense budget

EXPENSE BUDGET BY PROGRAM Worksheet 2
Expenses Allocated to Program
RCAP
Line ItemTotal
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
SuppliesCurrent Brand**Proposer's Brand**Charge Per Day
GPS (Global Positioning System)Attenti's Unit
SCRAMAMS CAM
Remote Breath SCRAMAMS CAM
Sweart Patch *includes fee to be sent to the lab for testingPharmchek
SuppliesCurrent Brand**Proposer's Brand**Charge Per Unit
12 panel CLIA waived Urine Cups *about 100 orderd per monthPremier BioTech
9 panel urine cups w/ EtG (alcohol test) *about 150 ordered per monthPremier BioTech
10 panel oral drug test *about 150 ordered per monthPremier BioTech
6 panel oral drug test *about 400 ordered per monthPremier BioTech
Fentanyl urine dips *about 25 ordered per monthPremier BioTech
Gabapentin dips *only used on specific drug court clints known to abuse thisPremier BioTech
**Proposers Brand must be comparable to Current Brand**

Budget Detail

Budget Detail Worksheet 4
OccupancyAnnual 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 FeesAnnual Cost
Legal Services
Accounting Services
Audit
Other Consultants
TOTAL PROFESSIONAL FEE$ - 0
Client Related Services ( Please List)
ServiceAnnual Cost
TOTAL CLIENT RELATED$ - 0
MiscellaneousAnnual 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 .