10834_Attachment-H_Budget.xlsx

XLSX spreadsheet 66 KB Posted

Attached to
10834 - PREV - Mentoring Services
Solicitation number
RFP-10478
Issued by
Leon County, Florida

About this file

This document is a budget worksheet for a state and local contract opportunity issued by the Florida Department of Juvenile Justice, Office of Prevention Services. The opportunity seeks proposals from community organizations, faith-based groups, non-profits, LLCs, and local government entities to develop and implement comprehensive programs focused on preventing juvenile delinquency through evidence-based, promising practices or demonstrated effectiveness that support mentoring services in high delinquency areas and low performing school districts throughout Florida. The contract term is for one year of service, with the budget worksheet providing detailed instructions for completing the budget categories of program contractors and expenses, program staffing, support-overhead, and support-corporate.

The budget worksheet requires respondents to provide detailed expenditure information, including contractor and program expenses, staff salaries and fringe benefits, overhead costs, and corporate staff expenses. Respondents must also specify any matching funds, and the worksheet calculates the overall per diem/unit rate based on the total budget and number of service days. The contract opportunity is open to respondents in Leon County, Florida.

View the file

Other files

File Type Posted
10834_Attachment-H_Budget.xlsx XLSX spreadsheet
10834_AttachmentS.pdf PDF
10834_ATTACHMENT M.pdf PDF
RFP_10834.pdf PDF
RFP_10834_Addendum 1.pdf PDF
10834_ATTACHMENT M.pdf PDF
10834_Attachment L.pdf PDF
10834_AttachmentN.pdf PDF
10834_ATTACHMENT Q.pdf PDF
10834_AttachmentN.pdf PDF
10834_AttachmentS.pdf PDF
RFP_10834.pdf PDF
RFP_10834_SolicitationConferenceCall_Agenda.pdf PDF
10834_ATTACHMENT Q.pdf PDF
10834_Attachment L.pdf PDF
10834_AttachmentN.pdf PDF
10834_AttachmentS.pdf PDF
RFP_10834.pdf PDF
RFP_10834_Informational_Notice_1.pdf PDF
10834_AttachmentS.pdf PDF
RFP_10834.pdf PDF
RFP_10834_Informational_Notice_1.pdf PDF
RFP_10834_Informational_Notice_2.pdf PDF
10834_ATTACHMENT Q.pdf PDF
10834_Attachment L.pdf PDF
10834_RFP_Addendum2.pdf PDF
RFP_10834_Informational_Notice_1.pdf PDF
10834_Attachment L.pdf PDF
10834_AttachmentS.pdf PDF
RFP_ 10834_Notice_of_Agency_Decision.pdf PDF
RFP_10834_Informational_Notice_1.pdf PDF
RFP_10834_SolicitationConferenceCall_Agenda.pdf PDF
10834_ATTACHMENT M.pdf PDF
10834_Attachment L.pdf PDF
10834_Attachment L.pdf PDF
10834_AttachmentN.pdf PDF
10834_AttachmentS.pdf PDF
10834_ATTACHMENT Q.pdf PDF
RFP_10834_SolicitationConferenceCall_Agenda.pdf PDF
RFP_10834_Addendum 1.pdf PDF
10834_ATTACHMENT M.pdf PDF
10834_ATTACHMENT Q.pdf PDF
10834_Attachment-H_Budget.xlsx XLSX spreadsheet
10834_AttachmentN.pdf PDF
10834_RFP_Addendum2.pdf PDF
10834_ATTACHMENT M.pdf PDF
10834_AttachmentN.pdf PDF
10834_AttachmentS.pdf PDF
10834_RFP_Addendum2.pdf PDF
RFP_10834_Informational_Notice_1.pdf PDF
Show 40 more

50 files listed here. See the rest on GovTribe.

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 enter the following: provider name, solicitation number, and version number. The file must be saved according to the prescribed naming convention (as illustrated in cell C10). Cell C12 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 #:
Circuit/County/Region #:

The required file name is: DJJBid__AttachmentH_v.xlsx

Your file name is:10834_Attachment-H_Budget.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,)

This budget is based on one year of service.

I. BUDGET DETAIL INSTRUCTIONS

For each description identified on the Budget Categories tabs noted there must be an explanation listed on the corresponding Narrative tabs.

A. PROGRAM CONTRACTORS & EXPENSES

Enter contractor and program expenses. Enter applicable matching funds in the column provided.

B. PROGRAM STAFFING

Enter the required detail for 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).

C. SUPPORT - OVERHEAD

Enter the overhead expenses to be incurred in support of the program.

D. SUPPORT - CORPORATE

Enter the corporate positions expenses to be incurred in support of the program.

II. SUMMARY

The Summary tab displays sub-totals, number of service days, and per diem/unit rate.

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 youth and service days (below the table in column 5).

4. The per diem/unit rate is calculated by dividing the Sub Total by Number of Youth by the Number of Service Days.

5. Enter the name and the date the budget was prepared.

Program 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
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
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Program-Staffing

DJJ Solicitation #:v
Program 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
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
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
Totals0.000.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00

Program Staff Narrative DJJ Solicitation #: v

Program Expenditures: Staff
NARRATIVE
Position TitleNarrative
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

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

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

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

Summary

DJJ Solicitation #:v
Budget Summary
Budget CategoriesDJJ TotalMatching FundsPercent of Total for Matching FundsTotal

(DJJ & Matching Funds)

Program: Contractors and Expenses$0.00$0.00N/A$0.00
Program: Staffing$0.00$0.00N/A$0.00
Support: Overhead$0.00$0.00N/A$0.00
Support: Corporate$0.00$0.00N/A$0.00
Subtotal$0.00$0.00N/A$0.00
Budget prepared by:Number of Youth
Enter the name.Number of Service Days
Enter the name.Per diem/Unit RateERROR:#DIV/0!
Date of budget preparation:
Enter the date.
ExpensesPercentage of budget
Program$0.000.00%
Support$0.000.00%
Totals$0.000.00%

Overall Budget

Program Support 0 0

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.
ActionDateNumber of beds/slotsPer DiemDaysTotalMinus MMFTotal to Add to Contract
Add beds/slots(example)7/1/182$230.00365$167,900.00$839.50$167,060.50
Add Recreational Therapist (example)7/1/1842$4.50365$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 .