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 SalaryMonthly Fringe Benefits
Total Number of FTEsNumber of FTEs w/ BenefitsRetirementFICAHealth InsuranceLife InsuranceWorkers Comp InsuranceUn/Re-employment InsuranceTotal Fringe BenefitsTotal Salary and BenefitsTotal Matching FundsTotal 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 TitleProvide 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 #DescriptionAnnual Expenditure Detail
Unit CostNumberProgram TotalMatching
Contractor TitleAmountUnitof Units
(DJJ)FundsTotal
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
7Staff Training and Seminars$0.00$0.00
8Recruitment / Background Screening / Drug Screening$0.00$0.00
9Cell Phone / Telephone / Utilities / Office Rent$0.00$0.00
10Other / Miscellaneous (Must Be Related To Program Activities)$0.00$0.00
11Staff 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 TitleProvide Explanation of each Contractor Listed
0
0
0
0
0
0
Description of ExpenseProvide 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
DescriptionUnit CostNumber of UnitsProgram Total
Matching FundsTotal
AmountUnit
Breakout All Costs For Equipment and Property Below
10.000.00
20.000.00
30.000.00
40.000.00
50.000.00
60.000.00
70.000.00
80.000.00
90.000.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
DescriptionNarrative
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 SalaryMonthly Fringe Benefits
Total Number of FTEsNumber of FTEs w/ BenefitsRetirementFICAHealth InsuranceLife InsuranceWorkers Comp InsuranceUn/Re-employment InsuranceTotal Fringe BenefitsTotal Salary and BenefitsTotal Matching FundsTotal 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
10Totals0.000.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 TitleNarrative
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/23Total
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 CategoriesDJJ TotalMatching FundsPercent of Total for Matching FundsTotal

(DJJ & Matching Funds)

Personnel Services$0.00$0.00ERROR:#DIV/0!$0.00
Contractors$0.00$0.00ERROR:#DIV/0!$0.00
Expenses$0.00$0.00ERROR:#DIV/0!$0.00
Non-Expendable Property$0.00$0.00ERROR:#DIV/0!$0.00
Support Expenditures: Overhead$0.00$0.00ERROR:#DIV/0!$0.00
Support Expenditures: Corporate$0.00$0.00ERROR:#DIV/0!$0.00
Sub total$0.00$0.00ERROR:#DIV/0!$0.00
Cost Reimbursement Short Budget Form$0.00$0.00
Grand total$0.00$0.00ERROR:#DIV/0!$0.00
Document prepared by
Enter name & telephone number
Payment RateRate Type (e.g. Hourly, Per slot, etc.)Number of Units (hours/slots)Number of Service Days in RFPTotal Contract Amount
Per Facility Day365$0.00
Per Facility Day (Leap Years)366$0.00

Support- Overhead

DJJ Solicitation #:v
Support Expenditures: Overhead
Line item #Annual Expenditure Detail
DescriptionUnit CostNumber of UnitsProgram Total
Matching FundsTotal
AmountUnit
1Accounting0.000.00
2Advertising0.000.00
3Audit services0.000.00
4Banking0.000.00
5Corporate Headquarters0.000.00
6Insurance (comprehensive, liability, vehicle)0.000.00
7Legal fees and services0.000.00
8Licensure0.000.00
9Payroll0.000.00
10Professional development and training0.000.00
11Professional fees0.000.00
12Staff travel0.000.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 TYPETOTAL NUMBER OF YOUTH SERVED PER DAYUNIT PRICESERVICE DAYSANNUAL 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 Program130$ 5.65170$ 124,865.00FALSE
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 .