ESBD_399071_1740523377058_RFP 2025-009 Budget Forms.xlsx

55 KB Posted

Attached to
Management and Operation of Child Care Services (CCS)
Solicitation number
2025-009
Issued by
Bexar County, Texas

About this file

Written by GovTribe AI ·

This is a budget forms Excel workbook for RFP 2025-009 issued by Workforce Solutions Alamo for Child Care Services. The file contains multiple budget templates including a Line Item Budget form, Salary Schedule form, and Transition Budget form, designed to capture detailed financial information from proposers. The estimated annual budget for this contract is $125,679,717.00.

The forms require detailed breakdowns of personnel costs (including salaries, benefits, and staff development), non-personnel costs (such as supplies, equipment, and professional services), indirect costs, and profit margins. The workbook includes specific tabs for staffing costs across different service areas including Client Services, Provider Services/Claim Processing, Financial Management, and Other Staff/Management positions. Additional worksheets contain state-specific information about unemployment insurance tax rates and Federal Unemployment Tax Act (FUTA) rates from 2010-2016 for reference in budget calculations.

View the file

Other files

File Type Posted
ESBD_399071_1740523377058_RFP 2025-009 Budget Forms.xlsx XLSX spreadsheet
ESBD_399071_1740523339354_RFP 2025-009 Child Care Services (CCS).pdf PDF
ESBD_399071_1740523339354_RFP 2025-009 Child Care Services (CCS).pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Approval Sheet

ResCare Workforce Services
Pricing Summary and Approval Form
Due DateDue Date
PROGRAM INFORMATIONNEW PROPOSALRE-BIDIf this is a rebid and the PA is not new to the program, they should be putting the information together with assistance from the analyst
with the analyst ultimately responsible for the budget expense tab and the accuracy of the information
Project Name:Location:
Customer Name:
Contract Dates:BeginsEnds
Budget Dates:BeginsEndsOnly varies when start up needs to be taken into account

BUDGET SUMMARY

Total Contract AmtERROR:#REF!# of Support Employees
RevenueERROR:#REF!# of Direct EmployeesERROR:#REF!
Revenue wo/markup# of Clients to Be Served
Indirect RateERROR:#REF!Per Client Cost
Profit RateERROR:#REF!
ContributionERROR:#REF!Value at Current Indirect RateERROR:#REF!
Contribution PercentageERROR:#REF!Value at Proposed Indirect RateERROR:#REF!
VarianceERROR:#REF!
Required In-Kind Offset
Type of ContractTerms of Contract
ARBOR FINANCIAL GUIDELINES
(Please enter percentages used for each of the following indicators for this budget)
Fringe Benefit RateERROR:#REF!
Audit FeeERROR:#REF!
G&A IndirectERROR:#REF!
Regional IndirectERROR:#REF!Proposed IndirectERROR:#REF!WIA
Fee/Profit RateERROR:#REF!Proposed IndirectERROR:#REF!Welfare

Significant variables and/or issues:

Budget Prepared By:Date:2 of the 3 are needed on all
Approvals:Dir of Revenue Cycle / BMDate:
DOGMDate:always
OODate:required if the contract is over $500k

&"Arial Narrow,Regular"&6&D&T &"Arial Narrow,Regular"&6&P of &N &Z&F

Form A - Line Item Budget

WORKFORCE SOLUTIONS ALAMO
CHILD CARE SERVICES RFP
PROPOSED LINE - ITEM BUDGET
PROPOSER NAME:
BUDGET PREPARED BY:
BUDGET PERIOD:
The Estimated Annual Budget is $125,679,717.00.
CCSTotal
COST CATEGORY/LINE ITEMBudgetBudget
I. PERSONNEL
Salaries
FICA
Workers Compensation
Unemployment
Health Insurance
Life Insurance
Retirement
Other Fringe Benefit (Specify Here)
Staff Development & Conferences
Staff Travel
Local Mileage Reimbursement
Other (Performance Based Incentive for PD)
Personnel Subtotal
II. NON-PERSONNEL
Office Supplies
Printing
Postage
Telecommunications
Equipment Rental
Insurance
Dues/Membership/Subscriptions
Audit / Accounting Services
Advertising / Publicity
Professional Services
Furniture & Equip. Under $500
Furniture & Equip. Over $500
Other Misc. (Specify Here)
Operations Subtotal

III. INDIRECT COST OR MANAGEMENT FEE (if applicable)

IV. PROFIT

GRAND TOTAL

tc={EE553FF8-1B84-4CF6-B4B7-4361B01EE464}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

@Brandee Perez @Carlos Garcia Is this accurate Reply:

@Jennifer Ledford I'm going to defer to Carlos at this time since he is the expert when it comes to childcare.

Form B - Salary Schedule

WORKFORCE SOLUTIONS ALAMO
CHILD CARE SERVICES RFP
PROPOSED SALARY SCHEDULE
PercentageTotal AmountCCS Amount
OperatingPositionMonthlyof timeNumberChargedCharged to
AreaNumberPosition TitleSalarychargedof Monthsto ContractContract
I. Client Services Staff
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
Client Services Subtotal
II. Provider Services Staff/Claim Processing
1
2
3
4
Provider Services/Claim Processing Subtotal
III. Financial Management
1
2
3
4
5
6
7
Financial Management
IV. Other Staff - Including Supervisor/Management Staff
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Other Staff Subtotal
Overall Totals
Total Number of Staff proposed:

&"Arial,Bold"&16CCS Staffing Costs

Budget Backup: Personnel Salaries&"Arial,Regular" &"Arial,Bold"Page &P

Transition Budget Form

WORKFORCE SOLUTIONS ALAMO
CHILD CARE SERVICES RFP
TRANSITION PROPOSED LINE-ITEM BUDGET
PROPOSER NAME:
BUDGET PREPARED BY:
BUDGET PERIOD:
1 Month Transition
COST CATEGORY/LINE ITEMBudget
I. PERSONNEL
Salaries
FICA
Workers Compensation
Unemployment
Health Insurance
Life Insurance
Retirement
Other Fringe Benefit (Specify Here)
Staff Development & Conferences
Staff Travel
Local Mileage Reimbursement
Other (Performance Based Incentive for PD)
Personnel Subtotal
II. NON-PERSONNEL
Office Supplies
Printing
Postage
Telecommunications
Equipment Rental
Insurance
Dues/Membership/Subscriptions
Audit / Accounting Services
Advertising / Publicity
Professional Services
Furniture & Equip. Under $500
Furniture & Equip. Over $500
Other Misc. (Specify Here)
Operations Subtotal

III. INDIRECT COST OR MANAGEMENT FEE (if applicable)

IV. PROFIT

GRAND TOTAL

Estimated Wage Bases

SUI Taxable Wage Limits
State2011 Taxable Wage Limit2012 Taxable Wage Limit2013 Taxable Wage Limit2014 Taxable Wage Limit2015 Taxable Wage LimitEstimated 2016 Taxable Wage Limit
AK$34,600$35,800$36,900$37,400$38,700$38,700
AL$8,000$8,000$8,000$8,000$8,000$8,000
AR$12,000$12,000$12,000$12,000$12,000$12,000
AZ$7,000$7,000$7,000$7,000$7,000$7,000
CA$7,000$7,000$7,000$7,000$7,000$7,000
CO$10,000$11,000$11,300$11,700$11,800$12,200
CT$15,000$15,000$15,000$15,000$15,000$15,000
DC$9,000$9,000$9,000$9,000$9,000$9,000
DE$10,500$10,500$10,500$18,500$18,500$18,500
FL$7,000$8,000$8,000$8,000$7,000$7,000
GA$8,500$8,500$9,500$9,500$9,500$9,500
HI$34,200$38,800$39,600$40,400$40,900$40,900
IA$24,700$25,300$26,000$26,800$27,300$27,300
ID$33,300$34,100$34,800$35,200$36,000$36,000
IL$12,740$13,560$12,900$12,960$12,960$12,960
IN$9,500$9,500$9,500$9,500$9,500$9,500
KS$8,000$8,000$8,000$8,000$12,000$12,000
KY$8,000$9,000$9,300$9,600$9,900$10,200
LA$7,700$7,700$7,700$7,700$7,700$7,700
MA$14,000$14,000$14,000$14,000$15,000$15,000
MD$8,500$8,500$8,500$8,500$8,500$8,500
ME$12,000$12,000$12,000$12,000$12,000$12,000
MI$9,000$9,500$9,500$9,500$9,500$9,500
MN$27,000$28,000$29,000$29,000$30,000$30,000
MO$13,000$13,000$13,000$13,000$13,000$13,000
MS$14,000$14,000$14,000$14,000$14,000$14,000
MT$26,300$27,000$27,900$29,000$29,500$29,500
NC$19,700$20,400$20,900$21,400$21,700$21,700
ND$25,500$27,900$31,800$33,600$35,600$35,600
NE$9,000$9,000$9,000$9,000$9,000$9,000
NH$12,000$14,000$14,000$14,000$14,000$14,000
NJ$29,600$30,300$30,900$31,500$32,000$32,000
NM$21,900$22,400$22,900$23,400$23,400$23,400
NV$26,600$26,400$26,900$27,400$27,800$27,800
NY$8,500$8,500$8,500$10,300$10,500$10,700
OH$9,000$9,000$9,000$9,000$9,000$9,000
OK$18,600$19,100$20,100$18,700$17,000$17,500
OR$32,300$33,000$34,100$35,000$35,700$35,700
PA$8,000$8,250$8,500$8,750$9,000$9,500
PR$7,000$7,000$7,000$7,000$7,000$7,000
RI$19,000$19,600$20,200$20,600$21,200$21,200
SC$10,000$12,000$12,000$12,000$14,000$14,000
SD$11,000$12,000$13,000$14,000$15,000$15,000
TN$9,000$9,000$9,000$9,000$9,000$9,000
TX$9,000$9,000$9,000$9,000$9,000$9,000
UT$28,600$29,500$30,300$30,800$31,300$31,300
VA$8,000$8,000$8,000$8,000$8,000$8,000
VI$22,600$23,700$23,600$22,500$22,900$22,900
VT$13,000$16,000$16,000$16,000$16,400$16,400
WA$37,300$38,200$39,800$41,300$42,100$42,100
WI$13,000$13,000$14,000$14,000$14,000$14,000
WV$12,000$12,000$12,000$12,000$12,000$12,000
WY$22,300$23,000$23,800$24,500$24,700$25,500

Est. FUTA Rates

FUTA Tax Rates
StateActualEstimated
2010Jan. - June 2011July - Dec. 201120122013201420152016
AK0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
AL0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
AR0.80%1.10%0.90%1.20%1.50%0.60%0.60%0.60%
AZ0.80%0.80%0.60%0.90%0.60%0.60%0.60%0.60%
CA0.80%1.10%0.90%1.20%1.50%1.80%2.10%2.40%
CO0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
CT0.80%1.10%0.90%1.20%1.50%2.30%2.80%3.10%
DE0.80%0.80%0.60%0.90%1.20%0.60%0.60%0.60%
DC0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
FL0.80%1.10%0.90%1.20%0.60%0.60%0.60%0.60%
GA0.80%1.10%0.90%1.20%1.50%0.60%0.60%0.60%
HI0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
IA0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
ID0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
IL0.80%1.10%0.90%0.60%0.60%0.60%0.60%0.60%
IN1.10%1.40%1.20%1.50%1.80%2.10%2.40%2.70%
KS0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
KY0.80%1.10%0.90%1.20%1.50%1.80%0.60%0.60%
LA0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
MA0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
MD0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
ME0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
MI1.40%1.70%1.50%0.60%0.60%0.60%0.60%0.60%
MN0.80%1.10%0.90%0.60%0.60%0.60%0.60%0.60%
MO0.80%1.10%0.90%1.20%1.50%0.60%0.60%0.60%
MS0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
MT0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
NC0.80%1.10%0.90%1.20%1.50%1.80%0.60%0.60%
ND0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
NE0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
NH0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
NJ0.80%1.10%0.90%1.20%0.60%0.60%0.60%0.60%
NM0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
NV0.80%1.10%0.90%1.20%0.60%0.60%0.60%0.60%
NY0.80%1.10%0.90%1.20%1.50%1.80%0.60%0.60%
OH0.80%1.10%0.90%1.20%1.50%1.80%2.10%2.40%
OK0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
OR0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
PA0.80%1.10%0.90%0.60%0.60%0.60%0.60%0.60%
PR0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
RI0.80%1.10%0.90%1.20%1.50%0.60%0.60%0.60%
SC1.10%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
SD0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
TN0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
TX0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
UT0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
VA0.80%1.10%0.90%0.60%0.60%0.60%0.60%0.60%
VI0.80%1.10%0.90%1.20%1.50%1.80%2.10%2.40%
VT0.80%0.80%0.60%0.90%0.60%0.60%0.60%0.60%
WA0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
WI0.80%1.10%0.90%1.20%1.50%0.60%0.60%0.60%
WV0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%
WY0.80%0.80%0.60%0.60%0.60%0.60%0.60%0.60%

File details come from the government source that posted it. Updated .