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
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 # | 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 | $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 Title | Provide Explanation of each Contractor Listed |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| Description of Expense | Provide 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 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 | |||||||||||
| 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 | |||||||||||
| 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 |
Program Staff Narrative DJJ Solicitation #: v
| Program Expenditures: Staff | |
| NARRATIVE | |
| Position Title | Narrative |
| 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 | |||
| 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 |
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 |
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 |
Summary
| DJJ Solicitation #: | v | |||
| Budget Summary | ||||
| Budget Categories | DJJ Total | Matching Funds | Percent of Total for Matching Funds | Total |
(DJJ & Matching Funds)
| Program: Contractors and Expenses | $0.00 | $0.00 | N/A | $0.00 |
| Program: Staffing | $0.00 | $0.00 | N/A | $0.00 |
| Support: Overhead | $0.00 | $0.00 | N/A | $0.00 |
| Support: Corporate | $0.00 | $0.00 | N/A | $0.00 |
| Subtotal | $0.00 | $0.00 | N/A | $0.00 |
| Budget prepared by: | Number of Youth | |
| Enter the name. | Number of Service Days | |
| Enter the name. | Per diem/Unit Rate | ERROR:#DIV/0! |
| Date of budget preparation: | ||
| Enter the date. |
| Expenses | Percentage of budget | |
| Program | $0.00 | 0.00% |
| Support | $0.00 | 0.00% |
| Totals | $0.00 | 0.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. | |||||||
| 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 .