RFP10769_AttachmentH_Budget_.xlsx
XLSX spreadsheet 41 KB Posted
- Attached to
- RFP#10769 – Aftercare Resource Navigator Program
- Solicitation number
- RFP-10627
- Issued by
- Leon County, Florida
About this file
This is a budget template spreadsheet from the Florida Department of Juvenile Justice (DJJ) for RFP #10769 for the Aftercare Resource Navigator Program. The template includes separate worksheets for Direct Service Personnel, Administration Personnel, Expenses, Non-Expendable Property, and a Summary section, with each requiring separate submissions for each proposed circuit.
The budget template is structured to capture detailed financial information including monthly salaries, fringe benefits (retirement, FICA, health insurance, life insurance, workers comp, and unemployment insurance), operational expenses, contracted services, and non-expendable property. The template includes provisions for both contract totals and matching funds, with a requirement that the contract total must not exceed the Total Annual Amount specified in Attachment B, Section XIV of the RFP. The template also includes an "Adding Funds" worksheet for potential amendments to add or change funding, with calculations for per diem adjustments and bed/slot additions.
View the file
Other files
Show all 41
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
Direct Service Personnel
| DJJ Solicitation #: 10769 |
| Respondent: [ENTER RESPONDENT NAME HERE] |
| Circuit #: [ENTER CIRCUIT NUMBER HERE] |
| NOTE: A SEPARATE BUDGET MUST BE SUBMITTED FOR EACH CIRCUIT PROPOSED. |
| Direct Service Personnel | ||||||||||||||
| INCLUDE ALL POSITIONS THAT WILL PROVIDE DIRECT SERVICES TO YOUTH. ADMINISTRATION PERSONNEL SHOULD BE INCLUDED ON THE NEXT TAB. | ||||||||||||||
| Line Item # | Position Title | Monthly Fringe Benefits | ||||||||||||
| Total Number of FTEs | Number of FTEs w/ Benefits | Full-Time Equivalent Monthly Salary | Retirement | FICA | Health Insurance | Life Insurance | Workers Comp Insurance | Un/Re-employment Insurance | Total Fringe Benefits | Contract Total Salary and Benefits | Total Matching Funds | Total Annual Salaries and Benefits | ||
| 1 | Aftercare Resource Navigator | $0.00 | $0.00 | $0.00 | ||||||||||
| 2 | $0.00 | $0.00 | $0.00 | |||||||||||
| 3 | $0.00 | $0.00 | $0.00 | |||||||||||
| 4 | $0.00 | $0.00 | $0.00 | |||||||||||
| 5 | $0.00 | $0.00 | $0.00 | |||||||||||
| 6 | $0.00 | $0.00 | $0.00 | |||||||||||
| 7 | $0.00 | $0.00 | $0.00 | |||||||||||
| 8 | $0.00 | $0.00 | $0.00 | |||||||||||
| 9 | $0.00 | $0.00 | $0.00 | |||||||||||
| 10 | $0.00 | $0.00 | $0.00 | |||||||||||
| 11 | $0.00 | $0.00 | $0.00 | |||||||||||
| 12 | $0.00 | $0.00 | $0.00 | |||||||||||
| 13 | $0.00 | $0.00 | $0.00 | |||||||||||
| 14 | $0.00 | $0.00 | $0.00 | |||||||||||
| 15 | $0.00 | $0.00 | $0.00 | |||||||||||
| 16 | $0.00 | $0.00 | $0.00 | |||||||||||
| 17 | $0.00 | $0.00 | $0.00 | |||||||||||
| 18 | $0.00 | $0.00 | $0.00 | |||||||||||
| 19 | $0.00 | $0.00 | $0.00 | |||||||||||
| 20 | $0.00 | $0.00 | $0.00 | |||||||||||
| 21 | $0.00 | $0.00 | $0.00 | |||||||||||
| 22 | $0.00 | $0.00 | $0.00 | |||||||||||
| 23 | $0.00 | $0.00 | $0.00 | |||||||||||
| 24 | $0.00 | $0.00 | $0.00 | |||||||||||
| 25 | $0.00 | $0.00 | $0.00 | |||||||||||
| Totals | 0.00 | 0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Administration Personnel
| DJJ Solicitation #: 10769 |
| Respondent: [ENTER RESPONDENT NAME HERE] |
| Circuit #: [ENTER CIRCUIT NUMBER HERE] |
| NOTE: A SEPARATE BUDGET MUST BE SUBMITTED FOR EACH CIRCUIT PROPOSED. |
| Administration Personnel | ||||||||||||||
| INCLUDE ALL POSITIONS THAT WILL PROVIDE ADMINISTRATIVE SUPPORT SERVICES AND MANAGEMENT. DIRECT SERVICE PERSONNEL SHOULD BE INCLUDED ON THE PREVIOUS TAB. | ||||||||||||||
| Line Item # | Position Title | Monthly Fringe Benefits | ||||||||||||
| Total Number of FTEs | Number of FTEs w/ Benefits | Full-Time Equivalent Monthly Salary | Retirement | FICA | Health Insurance | Life Insurance | Workers Comp Insurance | Un/Re-employment Insurance | Total Fringe Benefits | Contract Total Salary and Benefits | Total Matching Funds | Total Annual Salaries and Benefits | ||
| 1 | $0.00 | $0.00 | $0.00 | |||||||||||
| 2 | $0.00 | $0.00 | $0.00 | |||||||||||
| 3 | $0.00 | $0.00 | $0.00 | |||||||||||
| 4 | $0.00 | $0.00 | $0.00 | |||||||||||
| 5 | $0.00 | $0.00 | $0.00 | |||||||||||
| 6 | $0.00 | $0.00 | $0.00 | |||||||||||
| 7 | $0.00 | $0.00 | $0.00 | |||||||||||
| 8 | $0.00 | $0.00 | $0.00 | |||||||||||
| 9 | $0.00 | $0.00 | $0.00 | |||||||||||
| 10 | $0.00 | $0.00 | $0.00 | |||||||||||
| 11 | $0.00 | $0.00 | $0.00 | |||||||||||
| 12 | $0.00 | $0.00 | $0.00 | |||||||||||
| 13 | $0.00 | $0.00 | $0.00 | |||||||||||
| 14 | $0.00 | $0.00 | $0.00 | |||||||||||
| 15 | $0.00 | $0.00 | $0.00 | |||||||||||
| 16 | $0.00 | $0.00 | $0.00 | |||||||||||
| 17 | $0.00 | $0.00 | $0.00 | |||||||||||
| 18 | $0.00 | $0.00 | $0.00 | |||||||||||
| 19 | $0.00 | $0.00 | $0.00 | |||||||||||
| 20 | $0.00 | $0.00 | $0.00 | |||||||||||
| 21 | $0.00 | $0.00 | $0.00 | |||||||||||
| 22 | $0.00 | $0.00 | $0.00 | |||||||||||
| 23 | $0.00 | $0.00 | $0.00 | |||||||||||
| 24 | $0.00 | $0.00 | $0.00 | |||||||||||
| 25 | $0.00 | $0.00 | $0.00 | |||||||||||
| Totals | 0.00 | 0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Expenses
| DJJ Solicitation #: 10769 | |||||||
| Respondent: [ENTER RESPONDENT NAME HERE] | |||||||
| Circuit #: [ENTER CIRCUIT NUMBER HERE] | |||||||
| NOTE: A SEPARATE BUDGET MUST BE SUBMITTED FOR EACH CIRCUIT PROPOSED. | |||||||
| Expenses | |||||||
| Line Item # | Description | Annual Expenditure Detail | |||||
| Unit Cost | Number of Units | Contract Total | Matching Funds | Total | |||
| Amount | Unit of Measure | ||||||
| Contracted Staff/Services/Consultants | |||||||
| 1 | $0.00 | $0.00 | |||||
| 2 | $0.00 | $0.00 | |||||
| 3 | $0.00 | $0.00 | |||||
| 4 | $0.00 | $0.00 | |||||
| 5 | $0.00 | $0.00 | |||||
| 6 | $0.00 | $0.00 | |||||
| Contracted Staff/Services/Consultants Subtotal | $0.00 | $0.00 | $0.00 | ||||
| Operational Expenses | |||||||
| 7 | Staff Training/Seminars | $0.00 | $0.00 | ||||
| 8 | Recruitment/Background Screening/Drug Testing | $0.00 | $0.00 | ||||
| 9 | Communications/Utilities/Office Lease | $0.00 | $0.00 | ||||
| 10 | Comprehensive/Liability/Vehicle Insurance | $0.00 | $0.00 | ||||
| 11 | Staff Travel/Vehicle Lease/Fuel | $0.00 | $0.00 | ||||
| 12 | Program Activities | $0.00 | $0.00 | ||||
| 13 | $0.00 | $0.00 | |||||
| 14 | $0.00 | $0.00 | |||||
| 15 | $0.00 | $0.00 | |||||
| 16 | $0.00 | $0.00 | |||||
| 17 | $0.00 | $0.00 | |||||
| 18 | $0.00 | $0.00 | |||||
| 19 | $0.00 | $0.00 | |||||
| 20 | $0.00 | $0.00 | |||||
| 21 | $0.00 | $0.00 | |||||
| 22 | $0.00 | $0.00 | |||||
| 23 | $0.00 | $0.00 | |||||
| 24 | $0.00 | $0.00 | |||||
| 25 | $0.00 | $0.00 | |||||
| Program Expenses Subtotal | $0.00 | $0.00 | $0.00 |
Totals $0.00 $0.00 $0.00
Non-Expendable Property
| DJJ Solicitation #: 10769 | |||||||
| Respondent: [ENTER RESPONDENT NAME HERE] | |||||||
| Circuit #: [ENTER CIRCUIT NUMBER HERE] | |||||||
| NOTE: A SEPARATE BUDGET MUST BE SUBMITTED FOR EACH CIRCUIT PROPOSED. | |||||||
| Non-Expendable Property | |||||||
| Line Item # | Description | Annual Expenditure Detail | |||||
| Unit Cost | Number of Units | Contract Total | Matching Funds | Total | |||
| Amount | Unit of Measure | ||||||
| 1 | $0.00 | $0.00 | |||||
| 2 | $0.00 | $0.00 | |||||
| 3 | $0.00 | $0.00 | |||||
| 4 | $0.00 | $0.00 | |||||
| 5 | $0.00 | $0.00 | |||||
| 6 | $0.00 | $0.00 | |||||
| 7 | $0.00 | $0.00 | |||||
| 8 | $0.00 | $0.00 | |||||
| 9 | $0.00 | $0.00 | |||||
| 10 | $0.00 | $0.00 | |||||
| 11 | $0.00 | $0.00 | |||||
| 12 | $0.00 | $0.00 | |||||
| 13 | $0.00 | $0.00 | |||||
| 14 | $0.00 | $0.00 | |||||
| 15 | $0.00 | $0.00 | |||||
| Totals | $0.00 | $0.00 | $0.00 |
Summary
| DJJ Solicitation #: 10769 | ||||
| Respondent: [ENTER RESPONDENT NAME HERE] | ||||
| Circuit #: [ENTER CIRCUIT NUMBER HERE] | ||||
| NOTE: A SEPARATE BUDGET MUST BE SUBMITTED FOR EACH CIRCUIT PROPOSED. | ||||
| Summary | ||||
| Budget Categories | Contract Total | Matching Funds | Percent of Total for Matching Funds | Total (Contract + Matching Funds) |
| Direct Service Personnel | $0.00 | $0.00 | 0.00% | $0.00 |
| Administration Personnel | $0.00 | $0.00 | 0.00% | $0.00 |
| Expenses | $0.00 | $0.00 | 0.00% | $0.00 |
| Non-Expendable Property | $0.00 | $0.00 | 0.00% | $0.00 |
| Totals | $0.00 | $0.00 | 0.00% | $0.00 |
| ↓ | ||||
| Document prepared by | ↓ | Contract Total must be equal to or less than the Total Annual Amount Not to Exceed for the circuit proposed, as shown in Attachment B, Section XIV, of the RFP. | ||
| [ENTER NAME HERE] | ↓ | |||
| → → → | ||||
| Document approved by | ||||
| [ENTER NAME HERE] |
| Date |
| [ENTER DATE HERE] |
Adding Funds
| Changing Funds |
| This tab is to be used only for Amendments adding/changing funding |
| Instructions: For adding beds/slots - add the current date, the number of beds/slots to be added and the current per diem. For an increased per diem for added services - add the current date, the number of contracted beds/slots and the amount to be added to the existing per diem. The figure in column H is the amount that needs to be added to the relevant worksheets and to ensure accuracy on the summary page. | |||||||
| Action | Date | Number of beds/slots | Per Diem | Days | Total | Minus MMF | Total to Add to Contract |
| Add beds/slots(example) | 7/1/18 | 2 | $230.00 | 365 | $167,900.00 | $839.50 | $167,060.50 |
| Add Recreational Therapist (example) | 7/1/18 | 42 | $4.50 | 365 | $68,985.00 | $344.93 | $68,640.08 |
| 365 | $0.00 | $0.00 | $0.00 | ||||
| 365 | $0.00 | $0.00 | $0.00 | ||||
| 365 | $0.00 | $0.00 | $0.00 | ||||
| 365 | $0.00 | $0.00 | $0.00 | ||||
| 365 | $0.00 | $0.00 | $0.00 | ||||
| 365 | $0.00 | $0.00 | $0.00 | ||||
| 365 | $0.00 | $0.00 | $0.00 | ||||
| 365 | $0.00 | $0.00 | $0.00 | ||||
| 365 | $0.00 | $0.00 | $0.00 | ||||
| 365 | $0.00 | $0.00 | $0.00 |
File details come from the government source that posted it. Updated .