rfp_13123_exhibit_c_budget_excel_document.xlsx
XLSX spreadsheet 66 KB Posted
- Solicitation number
- BPM013123
- Issued by
- California
About this file
This is a budget template and instructions document for the County of San Diego's Commercial Sexual Exploitation of Children (CSEC) Response Team Services contract, issued under RFP 13123. The document provides a standardized budget format for a twelve-month contract period, with instructions for contractors to complete the Program Budget template. The budget template requires itemization of all personnel costs including wages, salaries, and fringe benefits, as well as detailed breakdowns of non-personnel expenses such as consultant services, mileage, transportation, insurance, space rentals, consumable supplies, equipment, utilities, and other operational costs. Contractors must list each staff position separately with corresponding hourly rates, hours worked, and percentage allocation to the program, and must ensure all costs are reasonable, necessary, and allowable.
The budget instructions specify strict requirements for fringe benefits calculation, including FICA, State Unemployment Insurance (SUI), health/dental insurance, and retirement contributions, with detailed formulas provided for each category. The document mandates comprehensive insurance coverage including Commercial General Liability of $2,000,000 per occurrence with a $4,000,000 general aggregate limit, Automobile Liability of $1,000,000 per incident, Workers' Compensation of $1,000,000, Professional Liability of $2,000,000, Cyber/Information Security Liability of $2,000,000, and Sexual Abuse or Molestation (SAM) Liability of $1,000,000 per occurrence. The template includes built-in formulas that cannot be modified, and all data entry is restricted to blue-shaded cells. Unexpended funds will not carry over to subsequent fiscal years, and individual program payments cannot exceed the budgeted amounts in Exhibit C of the contract.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| rfp_13123_draft_agreement.docx | DOCX document | |
| rfp13123.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
Text version
Budget Instructions
| I. Overview |
| ▪ Provide a complete Program Budget for a twelve (12) month contract period. Complete this budget template using the format and instructions below. If more than twelve months is being requested, provide a separate Program Budget a for each additional twelve month period. |
| ▪ The template has formulas built-in; do not change any of the formulas. |
| II. Program Budget Template Instructions (D-1 - 10) |
| ▪ Only enter data in blue-shaded cells. |
| ▪ Breakdown expenses by category as provided in the templates. |
| ▪ Ensure costs are reasonable, necessary and allowable for the program. |
| ▪ List each staff position separately funded through this budget, including, title, total hours worked, percent of time allocated to this program, hourly rate and number of months at the specified rate. |
| ▪ Fringe benefits should be calculated as a percentage of salaries or itemized as applicable. |
| ▪ Health/Dental: 1. Identify the monthly insurance cost per employee; 2. Identify the number of employees receiving health/dental insurance; 3. Identify the number of months coverage will be provided (usually 12); 4. Multiply: monthly amount X number of employees X number of months = total Health/Dental Insurance cost. |
| ▪ Retirement: 1. Identify the monthly retirement contribution per employee; 2.Identify the number of employees receiving retirement benefits; 3. Identify the number of months contributions will be made (usually 12); 4. Multiply: monthly amount X number of employees X number of months = total retirement costs. |
| ▪ Identify contractors or service provided (if known). |
| ▪ Mileage: use the current mileage reimbursement rate (or your agency's approved rate, if different). |
| ▪ Other costs: use this category for expenses that do not fit into other categories. |
| ▪ Double check the totals are accurate and ensure a balanced budget. |
D-1
CONTRACT ANNUAL TERM BUDGET
| CONTRACTOR: | PROGRAM: | CONTRACT #: |
| CSEC Response Team Services | TBD - RFP 13123 | |
| CONTRACT PERIOD: | Prepared by: | Phone #: |
| PROGRAM(S) | |||||||
| BUDGET LINE ITEM: | TOTAL | ||||||
| PERSONNEL: | |||||||
| Wages & Salaries | $ - 0 | $ - 0 | |||||
| Fringe Benefits | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Personnel Subtotal: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| NON-PERSONNEL: | |||||||
| Consultant/Contract Services | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Mileage | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Transportation | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Insurance | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Space Cost & Rental | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Consumable Supplies | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Equipment Rental | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Fixed Assets/Equip./Minor Equip. | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Utilities | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Food | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Other Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Indirect Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Non-Personnel Subtotal: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Budget: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Unexpended funds will not be carried over from one fiscal year to the next fiscal year, payments for individual programs will not exceed program budget from Exhibit C of the Contract.
PRINTED NAME AND TITLE SIGNATURE DATE
D-1
D-2
PERSONNEL SCHEDULE
| CONTRACTOR: | PROGRAM: | CONTRACT #: | |||
| 0 | CSEC Response Team Services | TBD - RFP 13123 | |||
| CONTRACT PERIOD: | 0 | Prepared by: | 0 | Phone #: | 0 |
| (1) | (2) | (3) | (4) | (5) | (6) | (7) | (8) | |
| POSITION TITLE | TOTAL ANNUAL SALARY | TOTAL PAID HRS/WK | % OF ANNUAL SALARY CHARGED TO THIS SERVICE | HOURLY RATE | # OF MOS. AT THIS HRLY RATE | SALARY PER MONTH | TOTAL | |
| % Admin | % Direct | |||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | ||||||
| TOTAL | $ - 0 |
D-2
-1-
SUPPLEMENTAL BUDGET INFORMATION
| CONTRACTOR: | PROGRAM: | CONTRACT #: | |||
| 0 | CSEC Response Team Services | TBD - RFP 13123 | |||
| CONTRACT PERIOD: | 0 | Prepared by: | 0 | Phone #: | 0 |
| FRINGE BENEFITS |
| INSTRUCTIONS: itemize budgeted amounts for fringe benefits. Specify benefits such as FICA, SUI, Health/Dental insurance, retirement, etc. Worker's compensation is under section -4- (insurance). |
| PROGRAM(S) | ||
| FRINGE BENEFITS: | TOTAL | |
| FICA: Applicable Wages x % = |
SUI: Applicable Wages x % =
| Health/Dental Insurance |
| Mnthly amt x # of emp x # of mnths |
| Retirement |
| Mnthly amt x # of emp x # of mnths |
Other (describe)
TOTAL FRINGE BENEFITS $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
-1-
-2-
SUPPLEMENTAL BUDGET INFORMATION
| CONTRACTOR: | PROGRAM: | CONTRACT #: | |||
| 0 | CSEC Response Team Services | TBD - RFP 13123 | |||
| CONTRACT PERIOD: | 0 | Prepared by: | 0 | Phone #: | 0 |
| CONSULTANT / CONTRACT SERVICES |
| INSTRUCTIONS: itemize budgeted amounts for consultant/contract services. Identify name and type (ex. CPA, MSW, janitorial service). Describe the purpose (ex. Staff training, case consultation, facilities maintenance). |
| PROGRAM(S) | ||
| TOTAL | ||
| Name/Type of Consultant |
Consultation Purpose
Estimated Hourly Rate
Estimated Number of Hours
Estimated Cost/Annual Term $0 $0 $0 $0 $0 $0 $ - 0
TOTAL CONS/CONT SERVICES $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
-2-
-3-
SUPPLEMENTAL BUDGET INFORMATION
| CONTRACTOR: | PROGRAM: | CONTRACT #: | |||
| 0 | CSEC Response Team Services | TBD - RFP 13123 | |||
| CONTRACT PERIOD: | 0 | Prepared by: | 0 | Phone #: | 0 |
| MILEAGE |
| INSTRUCTIONS: itemize budgeted amount for mileage. |
| PROGRAM(S) | |||||||
| TOTAL | |||||||
| # of employees | |||||||
| x # of miles per month/emp. | |||||||
| x # of months | |||||||
| = total # of miles | 0 | 0 | 0 | 0 | 0 | 0 | |
| x rate per mile | |||||||
| TOTAL MILEAGE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TRANSPORTATION |
| INSTRUCTIONS: itemize budgeted amount for transportation. |
| PROGRAM(S) | |||||||
| ITEM: | TOTAL | ||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| TOTAL TRANSPORTATION: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -3- |
-4-
SUPPLEMENTAL BUDGET INFORMATION
| CONTRACTOR: | PROGRAM: | CONTRACT #: | |||
| 0 | CSEC Response Team Services | TBD - RFP 13123 | |||
| CONTRACT PERIOD: | 0 | Prepared by: | 0 | Phone #: | 0 |
| INSURANCE |
| INSTRUCTIONS: itemize coverage below. Commercial General Liability, Occurrence form, Insurance Services Office form CG0001. Automobile Liability covering all owned, non owned, hired auto Insurance Service Office form CA0001. Workers' Compensation, as required by State of California and Employer's Liability Insurance. |
| TYPE OF INSURANCE | ||||
| AND MINIMUM REQUIREMENTS | COMPANY NAME | AMOUNT OF COVERAGE | EXPIRATION DATE |
Commercial General Liability included Premises, Operations, Products and Completed Operations, Contractual Liability, and Independent Contractors Liability: $2,000,000 per occurrence for bodily injury, personal injury and property damage. The General Aggregate limit shall be $4,000,000.
Automobile Liability: $1,000,000 each incident for bodily injury and property damage.
Workers Compensation: $1,000,000 each accident for bodily injury or disease. Coverage shall include waiver of subrogation endorsement in favor of County of San Diego.
| Professional Liability (Errors & Omissions) appropriate to the professional services provided by Contractor under this contract, with limit no less than $2,000,000 per occurrence or claim, $2,000,000 aggregate. | ||
| Cyber/Information Security Liability $2,000,000 per claim with an aggregate limit of not less than $2,000,000. | ||
| Sexual Abuse or Molestation (SAM) Liability: If the CGL policy referenced above is not endorsed to include affirmative coverage for sexual abuse or molestation, Contractor shall obtain and maintain a policy covering Sexual Abuse and Molestation with a limit no less than $1,000,000 per occurrence or claim with an aggregate limit of not less than $2,000,000. | ||
| PROGRAM(S) | ||
| TOTAL | ||
| TOTAL INSURANCE | $ - 0 |
-4-
-5-
SUPPLEMENTAL BUDGET INFORMATION
| CONTRACTOR: | PROGRAM: | CONTRACT #: | |||
| 0 | CSEC Response Team Services | TBD - RFP 13123 | |||
| CONTRACT PERIOD: | 0 | Prepared by: | 0 | Phone #: | 0 |
| SPACE COSTS AND RENTAL |
| INSTRUCTIONS: itemize budgeted amount for space costs and rental below. If more than one office, include a comment in the appropriate cell and provide the address of the office location. |
| PROGRAM(S) | |||||||
| TOTAL | |||||||
| RENT FEES: | Main Office | Satellite Office | Satellite Office | Satellite Office | Satellite Office | Satellite Office | |
| # of square feet occupied | |||||||
| x price per square foot | |||||||
| = rent | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| x number of months | |||||||
| Rent Fees Total: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| ALARM FEES: | |||||||
| monthly fee | |||||||
| x number of months | |||||||
| Alarm Fees Total: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| TOTAL SPACE COSTS & RENTAL | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
-5-
-6-
SUPPLEMENTAL BUDGET INFORMATION
| CONTRACTOR: | PROGRAM: | CONTRACT #: | |||
| 0 | CSEC Response Team Services | TBD - RFP 13123 | |||
| CONTRACT PERIOD: | 0 | Prepared by: | 0 | Phone #: | 0 |
| CONSUMABLE SUPPLIES |
| INSTRUCTIONS: itemize budgeted amount for consumable supplies; if using a formula please indicate so by adding a comment to the cell. |
| PROGRAM(S) | |||||||
| TOTAL | |||||||
| ITEM: | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| TOTAL CONSUMABLE SUPPLIES | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
-6-
-7-
SUPPLEMENTAL BUDGET INFORMATION
| CONTRACTOR: | PROGRAM: | CONTRACT #: | |||
| 0 | CSEC Response Team Services | TBD - RFP 13123 | |||
| CONTRACT PERIOD: | 0 | Prepared by: | 0 | Phone #: | 0 |
| EQUIPMENT RENTAL / LEASES |
| INSTRUCTIONS: itemize budgeted amount for equipment rental and leases. |
| PROGRAM(S) | |||||||
| TOTAL | |||||||
| RENTAL / LEASE: | |||||||
| item description | |||||||
| amount per month: | |||||||
| # of months: | |||||||
| Total: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| RENTAL / LEASE: | |||||||
| item description | |||||||
| amount per month: | |||||||
| # of months: | |||||||
| Total: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| RENTAL / LEASE: | |||||||
| item description | |||||||
| amount per month: | |||||||
| # of months: | |||||||
| Total: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| RENTAL / LEASE: | |||||||
| item description | |||||||
| amount per month: | |||||||
| # of months: | |||||||
| Total: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| TOTAL RENTAL / LEASE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -7- |
-8-
SUPPLEMENTAL BUDGET INFORMATION
| CONTRACTOR: | PROGRAM: | CONTRACT #: | |||
| 0 | CSEC Response Team Services | TBD - RFP 13123 | |||
| CONTRACT PERIOD: | 0 | Prepared by: | 0 | Phone #: | 0 |
| FIXED ASSETS / EQUIPMENT / MINOR EQUIPMENT |
| INSTRUCTIONS: fixed assets - itemize all equipment purchases; equipment - as a result of purchase or exercise of a lease option, with a value of $5,000 or more and/or a life of one year or more in non-expendable and the title vests in the County of San Diego and/or funding sources; minor equipment - equipment costing less then $5,000. Contractor is responsible for inventory control, record keeping, pickup and return of assets to the County. |
| PROGRAM(S) | |||||||
| TOTAL | |||||||
| FIXED ASSETS: | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| Total Fixed Assets | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| EQUIPMENT / MINOR EQUIP. | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| Equipment Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL FIXED ASSETS & EQUIP | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
-8-
-9-
SUPPLEMENTAL BUDGET INFORMATION
| CONTRACTOR: | PROGRAM: | CONTRACT #: | |||
| 0 | CSEC Response Team Services | TBD - RFP 13123 | |||
| CONTRACT PERIOD: | 0 | Prepared by: | 0 | Phone #: | 0 |
| UTILITIES / TELEPHONE |
| INSTRUCTIONS: itemize budgeted amount for utilities and telephone. |
| PROGRAM(S) | |||||||
| TOTAL | |||||||
| UTILITIES: | |||||||
| Gas & Electric | $ - 0 | ||||||
| Water | $ - 0 | ||||||
| $ - 0 | |||||||
| Total Utilities | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TELEPHONE: | |||||||
| Landline | $ - 0 | ||||||
| Mobile | $ - 0 | ||||||
| Total Telephone | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL UTILITIES/TELEPHONE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| FOOD - RESIDENTIAL FACILITIES ONLY |
| INSTRUCTIONS: Itemize budgeted amount for food. |
| PROGRAM(S) | |||||||
| TOTAL | |||||||
| FOOD: | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| TOTAL FOOD | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
-9-
-10-
SUPPLEMENTAL BUDGET INFORMATION
| CONTRACTOR: | PROGRAM: | CONTRACT #: | |||
| 0 | CSEC Response Team Services | TBD - RFP 13123 | |||
| CONTRACT PERIOD: | 0 | Prepared by: | 0 | Phone #: | 0 |
| INDIRECT COST (Federal Approved Rate) |
| INSTRUCTIONS: provide information on the Federally approved Indirect Rate charged to this contract. Attach a copy of the approved document. |
| PROGRAM(S) | ||
| TOTAL | ||
| INDIRECT COSTS: | $ - 0 |
| OTHER COSTS |
| List all other costs not identified above, including description and costs. For out of town travel, include transportation, plus lodging costs, times number of employees, times number of days, equals total trip cots. Itemization must be specific - rather than using the term "etc." or "miscellaneous" to identity other cost items. |
| PROGRAM(S) | |||||||
| OTHER COSTS: | TOTAL | ||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| TOTAL OTHER COSTS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
-10-
File details come from the government source that posted it. Updated .