Attachment I Cost Proposal.xlsx

XLSX spreadsheet 52 KB Posted

Attached to
DPH | Residential Non-Medical Case Management HIV
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

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 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 (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
PROGRAM12Total
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 RATE0%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 - 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 %

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
Occupancy (excluding client housing)Example - 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

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 - 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 %

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
Occupancy (excluding client housing)Example - 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
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 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/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, 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 .