Attachment I Cost Proposal.xlsx

XLSX spreadsheet 36 KB Posted

Attached to
DPH | Benefits Counseling Programs
Solicitation number
SFGOV-0000012235
Issued by
San Francisco County, California

About this file

This is a Cost Proposal instruction document for the City and County of San Francisco, specifically for SFGOV RFP 0000012235 titled "Benefits Counseling for State, Federal, and Insurance Programs." The document provides comprehensive guidelines for nonprofit organizations to develop cost proposals that are directly tied to grant plans and reflect reasonable, necessary, and eligible expenses. The form is structured in three main sections: Personnel Expenses (including salaries and employee fringe benefits), Operating Expenses (such as occupancy, general operating, materials and supplies, staff travel, training and development, events and food, and subcontractors), and Indirect Expenses (limited to 15 percent of total direct costs).

The cost proposal instructions establish detailed allowability criteria requiring that expenses not be prohibited under state laws or program requirements, be reasonable and necessary for program activities, relate to the program's goals, and be adequately documented. Personnel expenses must clearly document Full-Time Equivalent (FTE) allocations calculated on a 40-hour work week basis, with employees unable to exceed 1 FTE total across all positions within the program. Employee fringe benefits may include FICA, State Unemployment Insurance, health and medical benefits, retirement benefits, and worker's compensation. Operating expenses are separated into defined categories with specific allowable and unallowable items; for example, Events and Food expenses cannot include alcoholic beverages, sugar-sweetened beverages, or bottled water. The document also references San Francisco's Contract Development and Technical Assistance (CDTA) Guidelines for Cost Categorization in Nonprofit Contracts and Grants (July 16, 2025) and requires that proposers protect the spreadsheet following completion of modifications to prevent unauthorized changes to the cost proposal structure.

View the file

Other files

Show all 23

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

Instructions

Cost Proposal Instructions
The cost proposal must be directly tied to the grant plan and reflect reasonable and necessary costs. Funds may not be used for activities the organization has otherwise funded. Any costs deemed excessive, inconsistent with the grant's objectives, or not representing a prudent use of public funds will be considered ineligible.
Personnel Expenses
Staff PositionEnter the title for each position.
Annual SalaryEnter the annual salary for each position in whole dollars (no cents).
Full Time Employee (FTE)Enter the FTE allocation for each position. FTE may be calculated by the weekly hours worked related to this program. FTE positions cannot exceed 40 hours per week, 1 FTE for each employee. Calculation Formula: Weekly Hrs/40 hrs = X FTE. Example: 10 hrs/40 hrs = 0.25 FTE.
CostThe cost will be calculated automatically for each position using the formula: Annualized Salary x FTE.
Description of DutiesDescribe the duties related to the program and clients served.
ExperienceEnter any degrees, licenses or relevant experience necessary/required for each position.
Operating Expenses
Expense TypeSelect the appropriate type of expense from the drop down menu. See the Information tab for expense descriptions.
DescriptionEnter a brief description of the expense.
Cost Allocation MethodDescribe how the cost was calculated (e.g., square footage, number of employees).
CostEnter the dollar amount for each operating expense in whole dollars (no cents).
Indirect Expenses
DescriptionFor personnel, include the title for each position, FTE, and annual salary. For other expenses, provide a brief description of the expense and the methodology for calculating the cost.
CostEnter the dollar amount for each indirect expense in whole dollars (no cents).

Information

Cost Proposal Information
Please review the following information before completing the cost proposal form.
Allowable and Approved Expenses
Allowable expenses shall meet the following criteria:

- Not prohibited under state laws, regulations, or program requirements

- Reasonable and necessary costs for program activities

- Related to the goal of the program

- Be adequately documented

Approved expenses are allowable expenses that are appropriate and have been approved to support this grant. The following provides descriptions and examples of approved expenses.

Direct Costs
Direct costs are incurred for activities or services that benefit the program. Direct costs are separated into personnel and operating expenses.
Personnel Expenses
Personnel expenses that directly fulfill the goals and activities of the grant.

Salaries

- Full-time equivalent (FTE) means an employee who works full time (e.g., 40 hours per week).

- Total hours worked cannot exceed 1 FTE for each position.

- If an employee is performing project activities for two (or more) different positions, the cost proposal must clearly document in separate lines of the form, the time spent performing the activities for each separate position.

- For each employee, the total hours worked for all the positions in the program cannot exceed 1 FTE.

- Can include paid leave including legal holidays, administrative leave and sick time.

Employee Fringe Benefts

- Includes FICA, SUI, health and medical benefits, retirement benefits and/or worker’s compensation.

Subcontractors are included under operating expenses.

Operating Expenses
Operating expenses are costs incurred as a result of activities performed to fulfill the goals of the grant. Categories for operating expenses include the following:
Occupancy
Facilities or occupancy costs associated with building space, rental/lease of space used to run the program, rent for main space and auxiliary space, and costs associated with facility upkeep and maintenance, including janitorial services. Unallowable expenses include property taxes, loans against own property, and security deposits.
General Operating
General operating expenses include:

- Utilities (percentage allocation of utilities, such as gas, electric, and water bill, used by each program)

- Equipment (equipment purchase, lease, and maintenance costs that directly benefit program participants. Includes computers, IT systems, furniture, ongoing or one-time lease, printers, and photocopying equipment. Includes direct costs or percentage allocation of shared equipment used by each program)

- Telecommunications (telephone, fax, internet, and cell phones used for programmatic purposes.

Materials and Supplies
Materials and supplies used in the operation of the program and consistent with the type of services provided by the program. Includes project supplies, office supplies, and postage.
Staff Travel
Transportation and travel costs used for the program. Includes local transportation, out-of-town travel for program purposes, and field work. Includes mileage, vehicle rental, tolls, gas, parking costs, air travel, and ground transportation if staff are required to travel to perform the grant plan.
Training and Staff Development
Staff development costs used to pay registration or attendance fees for staff to attend workshops or trainings aimed to build capacity for the program. Staff development costs may include out-of-town conferences, including transportation, lodging, food or per diem for staff.
Events and Food
Events and field trip costs related to the program. Includes vehicle rentals for participants, transportation for participants, food/meals for participants, and costs of permits needed for events. Unallowable expenses include alcoholic beverages, sugar-sweetened beverages, and/or bottled water.
Subcontractors
Contractual services provided to program participants or contractor by consultants, independent contractors, or other entities that are non-staff individuals.
Other
Other expenses not described above.
Indirect Expenses
Indirect expenses are related to the general management (i.e. activities for the direction and control of the program) that benefit the grant plan. If expenses are included under personnel or operating, those costs cannot also be included under indirect expenses.

Indirect expenses cannot be supported by costs typically incurred and paid by the organization.

Each administrative expense/indirect cost item needs to be listed in the cost proposal as a separate line item with a description, cost allocation and cost.

Indirect expenses are limited to 15% of the total of direct costs.

Contract Development and Technical Assistance (CDTA)
CDTA facilitates the development of City contracts with health service providers, thus ensuring the availability of community services. The CDTA website provides information and resources to help navigate the contract development process and access to policies, procedures, forms and guidelines. Links to their website and guidelines for cost categorization are provided below. Please note that allowed expenses in the guidelines may not be an approved expense for this grant. Approved expenses are listed above.
CDTA Website
Guidelines for Cost Categorization in Nonprofit Contracts and Grants (July 16, 2025)

https://www.sf.gov/departments--contract-development-and-technical-assistance-cdtahttps://media.api.sf.gov/documents/Guidelines_for_Cost_Categorization_in_Nonprofit_Contracts_v.2.0_-_7.16.25_KmBL7A2.pdf Cost Proposal

ATTACHMENT "I"
COST PROPOSAL FORM
REQUEST FOR GRANT PROPOSALS SFGOV- 0000012235
Benefits Counseling for State, Federal, and Insurance Programs
SECTION 1: PERSONNEL EXPENSES

Jeff DuBois: For additional staff positions, go to the last row before Subtotal Salaries. Add 5 rows for each position. Copy all of the information for Staff Position 7 including the row above it and paste below the last position. Rename the position to 8, 9, etc.

Staff Position - ExampleAnnual SalaryFTECost
Program Director$ 100,0001.00$ 100,000

Jeff DuBois: Example of an personnel expense. The cost will not be included in the totals on this form.

Description of DutiesProvides primary medical care to program clients including an initial risk assessment, history and physical, ordering pertinent labs.
ExperienceMD license, 15 hrs of HIV-related CME annually, and direct care of at least 20 HIV+ patients annually, 5 yrs experience.
Staff Position 1Annual SalaryFTECost
$ - 0
Description of Duties
Experience
Staff Position 2Annual SalaryFTECost
$ - 0
Description of Duties
Experience
Staff Position 3Annual SalaryFTECost
$ - 0
Description of Duties
Experience
Staff Position 4Annual SalaryFTECost
$ - 0
Description of Duties
Experience
Staff Position 5Annual SalaryFTECost
$ - 0
Description of Duties
Experience
Staff Position 6Annual SalaryFTECost
$ - 0
Description of Duties
Experience
Staff Position 7Annual SalaryFTECost
$ - 0
Description of Duties
Experience

SUBTOTAL SALARIES $ - 0

EMPLOYEE FRINGE BENEFITS % 0%

Jeff DuBois: Replace with your employee fringe benefits rate. See the Information tab for examples of fringe benefits.

SUBTOTAL PERSONNEL EXPENSES $ - 0

SECTION 2: OPERATING EXPENSES

Expense TypeDescriptionCost Allocation MethodCost
OccupancyExample - Rent for program500sq ft x $60$ 30,000

Jeff DuBois: Example of an operating expense. The cost will not be included in the totals on this form.

SUBTOTAL OPERATING EXPENSES $ - 0

SUBTOTAL DIRECT EXPENSES $ - 0

Jeff DuBois: Total of personnel and operating expenses.

SECTION 3: INDIRECT EXPENSES

Description Cost

SUBTOTAL INDIRECT EXPENSES$ - 0
CALCULATED INDIRECT RATE0%

Jeff DuBois: Cannot exceed the indirect % on the Information sheet.

Jeff DuBois: Total of personnel and operating expenses.

Jeff DuBois: Example of an personnel expense. The cost will not be included in the totals on this form.

Jeff DuBois: Example of an operating expense. The cost will not be included in the totals on this form. TOTAL EXPENSES $ - 0

&F &P of &N

PAU Only PAU Instructions

IMPORTANT: Be sure to complete steps 2 and 3 before uploading to PeopleSoft.
1. Review the Information tab with the business owner. Update the following based on funding or grant specific requirements.
- Indirect rate

- Personnel expenses - ensure all items are allowable under the grant.

- Operating expenses - update the table below and add/remove rows as necessary (be sure to update the Information and Cost Proposal tabs to reflect any changes made below).

- Indirect expenses

Note: The descriptions below are from the CDTA guidelines, but should be modified to align with the grant plan. Use the link below to review these guidelines (which includes other expense types).
Guidelines for Cost Categorization in Nonprofit Contracts and Grants (July 16, 2025)
Operating Expense TypeDescription for Proposer - Appears in Cost Information Tab
OccupancyFacilities or occupancy costs associated with building space, rental/lease of space used to run the program, rent for main space and auxiliary space, and costs associated with facility upkeep and maintenance, including janitorial services. Unallowable expenses include property taxes, loans against own property, and security deposits.
General OperatingGeneral operating expenses include:

- Utilities (percentage allocation of utilities, such as gas, electric, and water bill, used by each program)

- Equipment (equipment purchase, lease, and maintenance costs that directly benefit program participants. Includes computers, IT systems, furniture, ongoing or one-time lease, printers, and photocopying equipment. Includes direct costs or percentage allocation of shared equipment used by each program)

- Telecommunications (telephone, fax, internet, and cell phones used for programmatic purposes.

Materials and SuppliesMaterials and supplies used in the operation of the program and consistent with the type of services provided by the program. Includes project supplies, office supplies, and postage.
Staff TravelTransportation and travel costs used for the program. Includes local transportation, out-of-town travel for program purposes, and field work. Includes mileage, vehicle rental, tolls, gas, parking costs, air travel, and ground transportation if staff are required to travel to perform the grant plan.
Training and Staff DevelopmentStaff development costs used to pay registration or attendance fees for staff to attend workshops or trainings aimed to build capacity for the program. Staff development costs may include out-of-town conferences, including transportation, lodging, food or per diem for staff.
Events and FoodEvents and field trip costs related to the program. Includes vehicle rentals for participants, transportation for participants, food/meals for participants, and costs of permits needed for events. Unallowable expenses include alcoholic beverages, sugar-sweetened beverages, and/or bottled water.
SubcontractorsContractual services provided to program participants or contractor by consultants, independent contractors, or other entities that are non-staff individuals.
OtherOther expenses not described above.
2. Protect this spreadsheet when all modifications are done.
- Protect the Instructions and Information sheets using the default settings.

- Protect the Cost Proposal sheet but select the option to allow inserting rows.

- Hide this sheet. DELETING THIS SHEET WILL CAUSE ERRORS ON THE OTHER SHEETS!

- Protect the entire workbook.This will prevent proposers from unhiding this sheet.

3. Test the spreadsheet.
- Close and reopen the workbook.

- Test filling in all sections of the cost proposal. Test adding rows for one of the sections. Make sure formulas are correct after adding rows.

- Test if you can edit or delete cells and rows on the other sheets.

https://media.api.sf.gov/documents/Guidelines_for_Cost_Categorization_in_Nonprofit_Contracts_v.2.0_-_7.16.25_KmBL7A2.pdf

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