Attachment I Cost Proposal.xlsx
XLSX spreadsheet 52 KB Posted
- Solicitation number
- SFGOV-0000012173
- Issued by
- San Francisco County, California
About this file
This is a cost proposal instruction and template document for the City and County of San Francisco's Request for Grant Proposals (SFGOV-0000012173) for Residential Non-Medical Case Management for People Living with HIV. The document provides comprehensive instructions and a standardized Excel template for organizations to submit detailed cost proposals that must be directly tied to the grant plan and reflect reasonable, necessary, and prudent uses of public funds. The cost proposal template accommodates two separate programs and includes sections for personnel expenses, operating expenses, and indirect expenses, with built-in formulas for automatic calculations. Proposers must document staff positions with annual salaries, full-time equivalent (FTE) allocations calculated on a weekly hour basis, and detailed descriptions of duties and required experience. The template allows for up to seven staff positions per program, with expandable rows for additional positions as needed.
The document outlines specific allowable and approved expense categories including personnel salaries and fringe benefits, occupancy costs, general operating expenses (utilities, equipment, telecommunications), materials and supplies, staff travel, training and staff development, events and food for participants, and subcontractor services. Indirect expenses are capped at 15 percent of total direct costs for SF General Fund programs and 9 percent for Ryan White Part B programs. Unallowable expenses explicitly exclude property taxes, security deposits, client housing costs, alcoholic beverages, sugar-sweetened beverages, and bottled water. The document includes instructions for protecting the spreadsheet and testing formulas before submission, ensuring data integrity and preventing unauthorized modifications to the cost proposal template.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment D 12L Compliance.docx | DOCX document | |
| Attachment I-1 Budget Narrative.docx | DOCX document | |
| Attachment E CMD LBE Form 2A_Professional Services.pdf | ||
| Attachment M City's Contract Terms G-100 for Grant Services.pdf | ||
| RFGP_12173_Residential_Non-Medical_Case_Management_HIV.pdf | ||
| DPH___Residential_Non-Medical_Case_Management_HIV.xml | XML file | |
| Attachment C Reference Form.docx | DOCX document | |
| Attachment G HCAO Declaration Form.pdf | ||
| Attachment A Contact Information Cover Sheet.docx | DOCX document | |
| Attachment B Non-Collusion Affidavit Form.docx | DOCX document | |
| Attachment F MCO Declaration Form.pdf | ||
| Attachment H First Source.docx | DOCX document | |
| DPH___Residential_Non-Medical_Case_Management_HIV.pdf |
Show all 13
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 (excluding client housing) |
| 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, facility/room improvements, including janitorial services. Unallowable expenses include property taxes, loans against own property, security deposits, and client housing costs. |
| 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/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.
SF General Fund Program indirect expenses are limited to 15% of the total of direct costs.
Ryan White Part B Program indirect expenses are limited to 9% 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 Summary
| ATTACHMENT I | |||
| COST PROPOSAL FORM | |||
| REQUEST FOR GRANT PROPOSALS SFGOV-0000012173 | |||
| Residential Non-Medical Case Management for People Living with HIV | |||
| PROGRAM | 1 | 2 | Total |
| SECTION 1: PERSONNEL EXPENSES | |||
| SUBTOTAL SALARIES | $ - 0 | $ - 0 | $ - 0 |
| EMPLOYEE FRINGE BENEFITS % | 0% | 0% | 0.0% |
| SUBTOTAL PERSONNEL EXPENSES | $ - 0 | $ - 0 | $ - 0 |
| SECTION 2: OPERATING EXPENSES | |||
| Occupancy (excluding client housing) | $ - 0 | $ - 0 | $ - 0 |
| General Operating | $ - 0 | $ - 0 | $ - 0 |
| Materials and Supplies | $ - 0 | $ - 0 | $ - 0 |
| Staff Travel | $ - 0 | $ - 0 | $ - 0 |
| Training/Staff Development | $ - 0 | $ - 0 | $ - 0 |
| Events and Food | $ - 0 | $ - 0 | $ - 0 |
| Subcontractors | $ - 0 | $ - 0 | $ - 0 |
| Other | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL OPERATING EXPENSES | $ - 0 | $ - 0 | $ - 0 |
SUBTOTAL DIRECT EXPENSES $ - 0 $ - 0 $ - 0
| SECTION 3: INDIRECT EXPENSES | |||
| CALCULATED INDIRECT RATE | 0% | 0% | 0% |
| SUBTOTAL INDIRECT EXPENSES | $ - 0 | $ - 0 | $ - 0 |
TOTAL EXPENSES $ - 0 $ - 0 $ - 0
&F &P of &N
Cost Proposal - P1
| ATTACHMENT I |
| COST PROPOSAL FORM |
| REQUEST FOR GRANT PROPOSALS SFGOV-0000012173 |
| Residential Non-Medical Case Management for People Living with HIV |
| PROGRAM 1 NAME |
| 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 %
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 (excluding client housing) | 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
Cost Proposal - P2
| ATTACHMENT I |
| COST PROPOSAL FORM |
| REQUEST FOR GRANT PROPOSALS SFGOV-0000012173 |
| Residential Non-Medical Case Management for People Living with HIV |
| PROGRAM 2 NAME |
| 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 %
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 (excluding client housing) | 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 (excluding client housing) | 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, facility/room improvements, including janitorial services. Unallowable expenses include property taxes, loans against own property, security deposits, and client housing costs. |
| 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/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, Information and Summary sheets using the default settings. |
- Protect each 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 .