Attachment_I_Cost_Proposal.xlsx
XLSX spreadsheet 38 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 San Francisco's Benefits Counseling for State, Federal, and Insurance Programs grant (SFGOV-0000012235). The document provides comprehensive guidelines for nonprofit organizations to develop detailed cost proposals that must be directly tied to the grant plan and reflect reasonable, necessary, and prudent use of public funds. The proposal template allows for the submission of personnel expenses (up to seven staff positions with annual salaries, full-time equivalent allocations, and descriptions of duties and required experience), operating expenses (categorized as occupancy, general operating, materials and supplies, staff travel, training and staff development, events and food, and subcontractors), and indirect expenses. The instructions emphasize that any costs deemed excessive, inconsistent with grant objectives, or duplicative of other funding sources will be deemed ineligible.
Personnel expenses must be directly tied to program fulfillment and may include salaries, paid leave, and fringe benefits such as FICA, health insurance, and worker's compensation. Operating expenses are limited to costs incurred as a result of program activities, with specific allowable and unallowable categories clearly defined—for example, events and food expenses exclude alcoholic beverages, sugar-sweetened beverages, and bottled water. Indirect expenses, which support general management and program direction, are capped at 15 percent of total direct costs and must be listed as separate line items with detailed descriptions and cost allocation methodologies. All expenses must be adequately documented and aligned with the Contract Development and Technical Assistance (CDTA) guidelines for cost categorization in nonprofit contracts and grants, as updated July 16, 2025.
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 Position | Enter the title for each position. |
| Annual Salary | Enter 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. |
| Cost | The cost will be calculated automatically for each position using the formula: Annualized Salary x FTE. |
| Description of Duties | Describe the duties related to the program and clients served. |
| Experience | Enter any degrees, licenses or relevant experience necessary/required for each position. |
| Operating Expenses | |
| Expense Type | Select the appropriate type of expense from the drop down menu. See the Information tab for expense descriptions. |
| Description | Enter a brief description of the expense. |
| Cost Allocation Method | Describe how the cost was calculated (e.g., square footage, number of employees). |
| Cost | Enter the dollar amount for each operating expense in whole dollars (no cents). |
| Indirect Expenses | |
| Description | For 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. |
| Cost | Enter 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 - Example | Annual Salary | FTE | Cost |
| Program Director | $ 100,000 | 1.00 | $ 100,000 |
Jeff DuBois: Example of an personnel expense. The cost will not be included in the totals on this form.
| Description of Duties | Provides primary medical care to program clients including an initial risk assessment, history and physical, ordering pertinent labs. |
| Experience | MD license, 15 hrs of HIV-related CME annually, and direct care of at least 20 HIV+ patients annually, 5 yrs experience. |
| Staff Position 1 | Annual Salary | FTE | Cost |
| $ - 0 | |||
| Description of Duties | |||
| Experience |
| Staff Position 2 | Annual Salary | FTE | Cost |
| $ - 0 | |||
| Description of Duties | |||
| Experience |
| Staff Position 3 | Annual Salary | FTE | Cost |
| $ - 0 | |||
| Description of Duties | |||
| Experience |
| Staff Position 4 | Annual Salary | FTE | Cost |
| $ - 0 | |||
| Description of Duties | |||
| Experience |
| Staff Position 5 | Annual Salary | FTE | Cost |
| $ - 0 | |||
| Description of Duties | |||
| Experience |
| Staff Position 6 | Annual Salary | FTE | Cost |
| $ - 0 | |||
| Description of Duties | |||
| Experience |
| Staff Position 7 | Annual Salary | FTE | Cost |
| $ - 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 Type | Description | Cost Allocation Method | Cost |
| Occupancy | Example - Rent for program | 500sq 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 RATE | 0% |
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 Type | Description for Proposer - Appears in Cost Information Tab |
| 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. |
| 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 .