10818_Attachment H_Budget.xlsx
XLSX spreadsheet 76 KB Posted
- Attached to
- #10818-RFP-C6-Pinellas JAC
- Solicitation number
- RFP-06582
- Issued by
- Pinellas County, Florida
About this file
This document is a budget template for a state and local contract opportunity issued by the Florida Department of Juvenile Justice (DJJ) and the Office of Probation and Community Intervention. The RFP is for the provision of administrative services, detention screening, security, and intake services at the Juvenile Assessment Center (JAC) that serves Circuit 6, Pinellas County. The selected respondent must provide these services 24 hours per day, 7 days a week. The budget template details the required line items for personnel, contractors, overhead, corporate support, and other program expenses. Respondents must complete the budget template and submit it as part of their proposal. The total annual maximum proposed contract dollar amount cannot exceed $125,000.
The price sheet in the document requires respondents to provide the total number of youth served per day, the unit price, the number of service days, and the annual maximum proposed contract dollar amount. The price must not exceed the $125,000 annual maximum stated in the RFP. The contract term and any renewal options are at the Department's discretion.
View the file
Other files
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
Provider Info & Instructions Please indicate the provider name, solicitation number, and version number in the fields below. You must also save the file according to the prescribed naming convention (as illustrated in cell C10). Cell C14 will confirm when you have correctly named the file.
| Respondent (Provider) Name: |
| Contract or Solicitation #: |
Enter a version number based on the number of submissions for Department review (initial submission = 1, 2nd submission = 2, etc.)
Version #:
The required file name is: DJJBid__AttachmentH_v.xlsx
| Your file name is: | 10818_Attachment H_BudgetForProbation.xlsx |
| (Note: After saving the file, it may be necessary to click on the cell above, press F2, and press enter to update the formula,) |
| Date from: | <Enter date this budget effective 00/00/0000> |
| Date to: | <Enter date this budget ends 00/00/0000> |
| Date Submitted | <Enter date this budget submitted 00/00/0000> |
| Name of person completing | <Enter name> |
I. BUDGET DETAIL INSTRUCTIONS
A. COST REIMBURSEMENT (Limited to First Year of Operations)
By category, enter the program start up expenses. These expenses cannot exceed those which will be incurred in the first year of operation. Department approval is required before expending these funds as reimbursement is subject to budget availability.
B. PROGRAM CONTRACTORS & FACILITIES
Enter contractor and program facility expenses. Enter applicable matching funds in the column provided.
C. PROGRAM STAFFING
All commonly used positions are listed in the attachment. Use the blank rows to fill in other dedicated staff positions. Please provide required detail on the number of FTEs, salaries, and benefits of all staff assigned to the solicited service.
1. Enter the # of full-time equivalent staff (FTEs) that will be utilized for each listed position. Note that this number can be less than 1.00 (e.g., 0.20 FTEs should be listed for staff that are allocated for one 8-hour day per week).
2. As a subgroup of the total FTEs for each position, enter the number of FTEs receiving benefits that are included in the Total Number of FTEs w/Benefits column. For example, if 5.00 total FTEs are listed for a position, 3.00 of these may be staff receiving benefits (which would be indicated here), whereas the remaining 2.00 FTEs may be accounted for by 4 half-time employees (0.50 FTEs) who do not receive benefits.
3. Enter the gross monthly FTE salary to be paid for each position type.
4. Enter the average monthly amount allocated for fringe benefits.
5. For positions funded through matching, enter the total matching funds (across all funded FTEs in the position).
D. SUPPORT - OVERHEAD
Enter the overhead expenses incurred in support of the program.
E. SUPPORT - CORPORATE
Enter the corporate position expenses incurred in support of the program.
II. SUMMARY
The Summary tab displays the program costs to be paid by the Department if the project is funded.
1. As the budget detail tabs are completed, the total amounts are automatically calculated and populated into the respective budget categories on the Summary tab.
2. Review the Summary tab to ensure all budget details have been completed and expenses populated in the corresponding categories.
3. Enter the number of beds/slots (below the table in column 5)
4. The per diem is calculated by dividing the Sub Total + MMF (DJJ) by Number of Beds/Slots by the Number of Days.
5. Overlay cell is for contracts without a bundled rate per diem. Leave blank for new solicitations.
6. The Unfilled Bed per diem (Column 5) is calculated by subtracting 10.00 from the per diem.
Personnel Services
| DJJ Solicitation #: | v | |||||||||||||
| Personnel Expenditures: Salaries Plus Fringe | ||||||||||||||
| Line item # | Position Title | |||||||||||||
| Full-Time Equivalent Monthly Salary | Monthly Fringe Benefits | |||||||||||||
| Total Number of FTEs | Number of FTEs w/ Benefits | Retirement | FICA | Health Insurance | Life Insurance | Workers Comp Insurance | Un/Re-employment Insurance | Total Fringe Benefits | 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 | |||||||||||
| 26 | $0.00 | $0.00 | $0.00 | |||||||||||
| 27 | $0.00 | $0.00 | $0.00 | |||||||||||
| 28 | $0.00 | $0.00 | $0.00 | |||||||||||
| 29 | $0.00 | $0.00 | $0.00 | |||||||||||
| 30 | $0.00 | $0.00 | $0.00 | |||||||||||
| 31 | $0.00 | $0.00 | $0.00 | |||||||||||
| 32 | $0.00 | $0.00 | $0.00 | |||||||||||
| 33 | $0.00 | $0.00 | $0.00 | |||||||||||
| 34 | $0.00 | $0.00 | $0.00 | |||||||||||
| 35 | $0.00 | $0.00 | $0.00 | |||||||||||
| 36 | $0.00 | $0.00 | $0.00 | |||||||||||
| 37 | $0.00 | $0.00 | $0.00 | |||||||||||
| 38 | $0.00 | $0.00 | $0.00 | |||||||||||
| 39 | $0.00 | $0.00 | $0.00 | |||||||||||
| 40 | $0.00 | $0.00 | $0.00 | |||||||||||
| 41 | $0.00 | $0.00 | $0.00 | |||||||||||
| 42 | $0.00 | $0.00 | $0.00 | |||||||||||
| 43 | $0.00 | $0.00 | $0.00 | |||||||||||
| 44 | $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 |
Personnel Narrative
| DJJ Solicitation #: | v |
| Personnel Expenditures | |
| NARRATIVE | |
| Position Title | Provide A Description Of Each Position With Calculations If Not Captured On Previous Tab |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 |
Contractors & Expense
| DJJ Solicitation #: | v | |||||||
| Program Expenditures: Contracted Staff and Expenses | ||||||||
| Line # | Description | Annual Expenditure Detail | ||||||
| Unit Cost | Number | Program Total | Matching | |||||
| Contractor Title | Amount | Unit | of Units | |||||
| (DJJ) | Funds | Total | ||||||
| 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 | ||||||
| Contractors subtotal | $0.00 | $0.00 | $0.00 |
| Expenses | ||||
| 7 | Staff Training and Seminars | $0.00 | $0.00 | |
| 8 | Recruitment / Background Screening / Drug Screening | $0.00 | $0.00 | |
| 9 | Cell Phone / Telephone / Utilities / Office Rent | $0.00 | $0.00 | |
| 10 | Other / Miscellaneous (Must Be Related To Program Activities) | $0.00 | $0.00 | |
| 11 | Staff Travel | $0.00 | $0.00 | |
| 12 | $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 | ||
| Totals | $0.00 | $0.00 | $0.00 |
Contractors & Expense Narrative
| DJJ Solicitation #: | v |
| Program Expenditures: Contracted Staff and Expenses | |
| NARRATIVE | |
| Contractor Title | Provide Explanation of each Contractor Listed |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| Description of Expense | Provide Explanation of each Expense Listed |
| Staff Training and Seminars | |
| Recruitment / Background Screening / Drug Screening | |
| Cell Phone / Telephone / Utilities / Office Rent | |
| Other / Miscellaneous |
(Must Be Related To Program Activities)
| Staff Travel |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
Non-Expendable Property
| DJJ Solicitation #: | v |
| Program Expenditures: Non-Expendable Property |
| Line item # | Annual Expenditure Detail | |||
| Description | Unit Cost | Number of Units | Program Total | |
| Matching Funds | Total |
| Amount | Unit | |||||
| Breakout All Costs For Equipment and Property Below | ||||||
| 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 | ||||
| Totals | $0.00 | $0.00 | $0.00 |
Description of Property Provide Explanation Of Each Property Listed
Support Expend. Narrative
| DJJ Solicitation #: | v |
| Support Expenditures: Overhead | |
| NARRATIVE | |
| Description | Narrative |
| Accounting | |
| Advertising | |
| Audit services | |
| Banking | |
| Corporate Headquarters | |
| Insurance (comprehensive, liability, vehicle) | |
| Legal fees and services | |
| Licensure | |
| Payroll | |
| Professional development and training | |
| Professional fees | |
| Staff travel |
Sheet3
Support-Corporate
| DJJ Solicitation #: | v |
| Support Corporate Expenditures: Staff |
| Line item # | Position Title | |||||||||||||
| Full-Time Equivalent Monthly Salary | Monthly Fringe Benefits | |||||||||||||
| Total Number of FTEs | Number of FTEs w/ Benefits | Retirement | FICA | Health Insurance | Life Insurance | Workers Comp Insurance | Un/Re-employment Insurance | Total Fringe Benefits | 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 | 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 |
Support Corp. Narrative
| DJJ Solicitation #: | v |
| Support Corporate Expenditures: Staff | |
| NARRATIVE | |
| Position Title | Narrative |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 |
Cost Reimbursement
| DJJ Solicitation #: |
| COST REIMBURSEMENT BUDGET FORM (N/A) |
| PROVIDER NAME : | |||
| ADDRESS: | |||
| TYPE OF REQUEST: | |||
| CONTRACT # | |||
| Total Contract Term: | FY 22/23 | Total | |
| Current | |||
| Total Amount | |||
| Line Item Budget Description | |||
| I. PERSONNEL SERVICES | |||
| (a) SALARIES | |||
| plus FRINGE |
TOTAL PERSONNEL:
| II. EXPENSES |
| (a) CONTRACTED STAFF/SERVICES/CONSULTANTS |
| (b) TRAINING & SEMINARS |
| (c) RECRUITMENT AND BACKGROUND SCREENINGS |
| (d) CELL PHONE/TELEPHONE/UTILITIES/OFFICE RENT |
| (e) OTHER (PROGRAM ACTIVITIES) |
| (f) TRAVEL |
TOTAL EXPENSES:
| III. NONEXPENDABLE PROPERTY | |
| (a) EQUIPMENT | |
| (b) PROPERTY | |
| TOTAL NONEXPENDABLE PROPERTY: |
| IV. ADMINISTRATION | |
| TOTAL ADMINISTRATION: |
CONTRACT TOTAL BY TERM:
MAXIMUM CONTRACT TOTAL:
Sheet2
Summary
| DJJ Solicitation #: | v | |||
| Budget Summary | ||||
| Budget Categories | DJJ Total | Matching Funds | Percent of Total for Matching Funds | Total |
(DJJ & Matching Funds)
| Personnel Services | $0.00 | $0.00 | ERROR:#DIV/0! | $0.00 |
| Contractors | $0.00 | $0.00 | ERROR:#DIV/0! | $0.00 |
| Expenses | $0.00 | $0.00 | ERROR:#DIV/0! | $0.00 |
| Non-Expendable Property | $0.00 | $0.00 | ERROR:#DIV/0! | $0.00 |
| Support Expenditures: Overhead | $0.00 | $0.00 | ERROR:#DIV/0! | $0.00 |
| Support Expenditures: Corporate | $0.00 | $0.00 | ERROR:#DIV/0! | $0.00 |
| Sub total | $0.00 | $0.00 | ERROR:#DIV/0! | $0.00 |
| Cost Reimbursement Short Budget Form | $0.00 | $0.00 | ||
| Grand total | $0.00 | $0.00 | ERROR:#DIV/0! | $0.00 |
| Document prepared by |
| Enter name & telephone number |
| Payment Rate | Rate Type (e.g. Hourly, Per slot, etc.) | Number of Units (hours/slots) | Number of Service Days in RFP | Total Contract Amount |
| Per Facility Day | 365 | $0.00 | ||
| Per Facility Day (Leap Years) | 366 | $0.00 |
Support- Overhead
| DJJ Solicitation #: | v |
| Support Expenditures: Overhead |
| Line item # | Annual Expenditure Detail | |||
| Description | Unit Cost | Number of Units | Program Total | |
| Matching Funds | Total |
| Amount | Unit | |||||
| 1 | Accounting | 0.00 | 0.00 | |||
| 2 | Advertising | 0.00 | 0.00 | |||
| 3 | Audit services | 0.00 | 0.00 | |||
| 4 | Banking | 0.00 | 0.00 | |||
| 5 | Corporate Headquarters | 0.00 | 0.00 | |||
| 6 | Insurance (comprehensive, liability, vehicle) | 0.00 | 0.00 | |||
| 7 | Legal fees and services | 0.00 | 0.00 | |||
| 8 | Licensure | 0.00 | 0.00 | |||
| 9 | Payroll | 0.00 | 0.00 | |||
| 10 | Professional development and training | 0.00 | 0.00 | |||
| 11 | Professional fees | 0.00 | 0.00 | |||
| 12 | Staff travel | 0.00 | 0.00 | |||
| Totals | $0.00 | $0.00 | $0.00 |
Sheet1 ATTACHMENT J - PRICE SHEET (MANDATORY) Do the Proposed Annual Maximum Amount equal to the Expense Total on the Summary Sheet?
| SERVICE TYPE | TOTAL NUMBER OF YOUTH SERVED PER DAY | UNIT PRICE | SERVICE DAYS | ANNUAL MAXIMUM PROPOSED CONTRACT DOLLAR AMOUNT (Not to exceed $125,000.00) | |
| TBD BASED ON ANNUAL MAXIMUM PROPOSED CONTRACT DOLLAR AMOUNT | |||||
| -1 | (4) Rate/Price | -2 | -3 | ||
| Invest in Children Program | 130 | $ 5.65 | 170 | $ 124,865.00 | FALSE |
| NOTE: IT IS MANDATORY THAT # (3) THE TOTAL ANNUAL MAXIMUM PROPOSED CONTRACT DOLLAR AMOUNT DOES NOT EXCEED THE TOTAL AVAILABLE ANNUAL MAXIMUM CONTRACT DOLLAR AMOUNT ($125,000.00) STATED IN THE RFP, IF IT IS EXCEEDED, THE RESPONDENT’S PROPOSAL WILL NOT BE EVALUATED. |
INSTRUCTIONS:
| In cell # (1) above, the Respondent shall insert the “Total Number of Youth Served Per Day”. |
| In cell # (2), the Respondent shall insert the number of “Service Days” (total number of days annually that youth will be served). |
| In cell # (3), the Respondent shall insert the “Annual Maximum Proposed Contract Dollar Amount”. |
| In cell # (4), the Respondent shall insert the “Unit Price”. |
Note: THE TOTAL ANNUAL MAXIMUM PROPOSED AMOUNT (3) WILL BE MULTIPLIED BY THE NUMBER OF YEARS IN THE INITIAL TERM OF THE CONTRACT (AS APPLICABLE). TERMS OF LESS THAN ONE YEAR SHALL BE PRO-RATED. ANY RENEWAL OPTIONS EXERCISED IS AT THE DEPARTMENT’S DISCRETION AND SHALL BE ON THE SAME TERMS AND CONDITIONS OF THE ORIGINAL CONTRACT.
By submission of and signature on this form, the prospective Provider agrees to all terms and conditions of this RFP and commits the prospective Provider to the prices stated.
NAME: _________________________________________________ TITLE: ______________________________
COMPANY: ____________________________________________________________________________________
E-MAIL ADDRESS: ______________________________________________________________________________
TELEPHONE NUMBER: __________________________________________________________________________
SIGNATURE: _____________________________________________ DATE: _________________________
File details come from the government source that posted it. Updated .