ATT- Attachement E - Budget Proposal - Program Budget Template.xlsx

XLSX spreadsheet 25 KB Posted

Attached to
Ryan White Part B
Solicitation number
DPHE26-ASP-6177
Issued by
San Bernardino County, California

About this file

This document is a budget proposal template and training outline for the Ryan White Part B HIV/AIDS Program in California. The file provides comprehensive guidance on budget development, cost allocation, and billing procedures for organizations seeking funding under this program. It includes detailed instructions on categorizing costs as direct costs, administrative costs, and quality management (CQM) costs, along with allowable expenses such as personnel, fringe benefits, travel, equipment, supplies, contractual services, and facility-related costs. The template demonstrates cost allocation across multiple funding streams and service categories, with emphasis on maintaining compliance with the 10% administrative cost cap and proper documentation of budget narratives justifying each line item.

The sample budget example provided illustrates a one-year budget period (March 1, 2023 through February 29, 2024) totaling $262,687.50 in program costs, with an 87% direct cost allocation, 8% administrative costs, and 5% CQM costs. Personnel costs represent the largest expense category at $203,287.50 (including fringe benefits at 17%), followed by facility-related costs of $17,500, contractual services of $5,200, and supplies of $8,950. The document references Policy Clarification Notices (PCNs 15-01, 16-02, and 21-02) and 45 CFR Part 75 regulations governing cost allocation and eligible uses of funds, including allowable client billing for incentives, transportation, and food. The template emphasizes categorical billing requirements, the need for supporting documentation, and the prohibition on cost duplication across multiple funding sources.

View the file

Other files

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

Outline

Budget Training OutlineNotes
Budget/Cost Categories vs Service Categories
Cost Allocation Plan
Line Item Budget Format
Budget Narrative Justification Format
Administrative vs Indirect Costs
Redistribution vs ReallocationNo need for new budget for new personnel (Transmittal)
Budget Modifications; 25% redistributionAll day long! No need for limit unless it changes scope.
Board of Supervisors Approval RequirementsOnly when the overall contract total changes. Also initiation of contracts. Language changes in contract.
Billing Training
Categorical Billing
Necessary Accompanied Backups
Necessary In-House Backups
Billing Barriers/Common ErrorsBackup (lack of); rounding in Excel.
Allowable PurchasesFood on EHE budget. Transportation, etc.
Allowable Client Billing (Incentives/transportation/food, etc.)Client Cut-Off points - no duplication across funding
Service Category Training
Discrete Service Categories and Allowable ExpensesCase Conferences, Group Sessions
Services Budgeted/Billed vs Services Provided
PCN's
15-01
16-02
21-02

Line Item Budget Sample

ABC Organization
Ryan White Part A/B/Ending the HIV Epidemic
Line Item Budget
Budget Period x/x/20xx - x/xx/20xx
Budget Example
SalaryProgram FTEProgram CostDirect CostsAdmin CostsCQM CostsProgram Total
Personnel
Doe, Jane; MD$ 100,0001.00$ 100,000.00$ 90,000.00$ - 0$ 10,000.00$ 100,000.00
Doe, John; Linkage Specialist$ 45,0000.75$ 33,750.00$ 33,750.00$ - 0$ - 0$ 33,750.00
Doe, James; Case Manager$ 65,0000.50$ 32,500.00$ 32,500.00$ - 0$ - 0$ 32,500.00
Doe, June; Program Manager$ 75,0000.10$ 7,500.00$ - 0$ 7,500.00$ - 0$ 7,500.00
Personnel Subtotal$ 173,750.00$ 156,250.00$ 7,500.00$ 10,000.00$ 173,750.00
FringePercentProgram CostDirect CostsAdmin CostsCQM CostsProgram Total
FICA6.5%$ 11,293.75$ 10,156.25$ 487.50$ 650.00$ 11,293.75
Staff Insurance1.2%$ 2,085.00$ 1,875.00$ 90.00$ 120.00$ 2,085.00
Retirement7.9%$ 13,726.25$ 12,343.75$ 592.50$ 790.00$ 13,726.25
Disability0.1%$ 173.75$ 156.25$ 7.50$ 10.00$ 173.75
Worker's Compensation0.1%$ 173.75$ 156.25$ 7.50$ 10.00$ 173.75
Other Benefits1.2%$ 2,085.00$ 1,875.00$ 90.00$ 120.00$ 2,085.00
Fringe Subtotal17.0%$ 29,537.50$ 26,562.50$ 1,275.00$ 1,700.00$ 29,537.50

Total Personnel $ 203,287.50

Personnel Without Benefits
Button, Benjamin$ 65,0000.20$ 13,000.00$ 13,000.00$ - 0$ 13,000.00
Eyre, Jane$ 65,0000.20$ 13,000.00$ 13,000.00$ - 0$ - 0$ 13,000.00

Personnel Subtotal $ 26,000.00 $ 26,000.00 $ - 0 $ - 0 $ 26,000.00

Total Personnel Without Benefits $ 26,000.00

TravelProgram CostDirect CostsAdmin CostsCQM CostsProgram Total
Local Travel$ 500.00$ 396.00$ - 0$ - 0$ 396.00
Long Distance Travel$ 1,250.00$ - 0$ 650.00$ 600.00$ 1,250.00
Travel Total$ 1,750.00$ 396.00$ 650.00$ 600.00$ 1,646.00
EquipmentProgram CostDirect CostsAdmin CostsCQM CostsProgram Total
Equipment > $5,000

Equipment Total $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

SuppliesProgram CostDirect CostsAdmin CostsCQM CostsProgram Total
Equipment < $5,000$ 2,750.00$ 2,750.00$ 2,750.00
Office Supplies$ 1,200.00$ 1,200.00$ 1,200.00
Printing/Advertising Costs*$ 1,500.00$ 1,500.00$ 1,500.00
Medical Supplies$ 3,500.00$ 3,500.00$ 3,500.00
Supplies Total$ 8,950.00$ 3,500.00$ 5,450.00$ - 0$ 8,950.00
ContractualProgram CostDirect CostsAdmin CostsCQM CostsProgram Total
Laboratory$ 4,000.00$ 4,000.00$ 4,000.00
Cleaning$ 1,200.00$ 600.00$ 100.00$ 500.00$ 1,200.00
Security$ - 0
Consultants$ - 0
Other$ - 0
Contractual Total$ 5,200.00$ 4,600.00$ 100.00$ 500.00$ 5,200.00
OtherProgram CostDirect CostsAdmin CostsCQM CostsProgram Total
Rent*$ 3,500.00$ 2,500.00$ 1,000.00$ - 0$ 3,500.00
Property Insurance*$ 1,200.00$ 800.00$ 400.00$ - 0$ 1,200.00
Utlilties*$ 800.00$ 600.00$ 200.00$ - 0$ 800.00
Licenses (Essential Software/Staff Licenses)$ - 0$ - 0$ - 0$ - 0$ - 0
Repair & Maintenance$ 12,000.00$ 8,000.00$ 4,000.00$ - 0$ 12,000.00
Membership Dues$ - 0$ - 0$ - 0$ - 0$ - 0
Staff Recruitment$ - 0$ - 0$ - 0$ - 0$ - 0
Equipment Total$ 17,500.00$ 11,900.00$ 5,600.00$ - 0$ 17,500.00
Program Income
Separate Training
Direct$ 262,687.50$ 229,208.50$ 229,208.50
Admin$ 20,575.00$ 20,575.00
CQM$ 12,800.00$ 12,800.00
Indirect
$$ 262,687.50$ 229,208.50$ 20,575.00$ 12,800.00$ 262,583.50
%100%87%8%5%100%

* Only include these in "Other" if they are not already included in Indirect

Budget Narrative Sample

ABC Organization
Ending the HIV Epidemic
Budget Narrative Justification
Budget Period 3/1/2023 - 2/29/2024
Direct Costs
Personnel$ 229,312.50
Doe, Jane; MD - 1.0 FTE @ $90,000/year
Purpose and activities of this position as they relate to direct care.
Doe, John; Linkage Specialist - 0.75 FTE @ $33,750/year
Purpose and activities of this position as they relate to direct care.
Doe, James; Case Manager - 0.50 FTE @ $32,500/year
Purpose and activities of this position as they relate to direct care.
Fringe$ 29,537.50
Explanation of what Fringe covers and how it is calculated.
Personnel Without Benefits$ 26,000.00
Button, Benjamin; Part-Time Case Manager - 0.20 FTE @ $13,000/year
Purpose and activities of this position as they relate to direct care.
Eyre, Jane; Part-Time Linkage Specialist - 0.20 FTE @ $13,000/year
Purpose and activities of this position as they relate to direct care.
Travel$ 396.00
Local Travel for 2 personnel to engage clients at home or at other locations for linkage to care purposes.
30 miles/month x 2 persons x $0.55 cents/mile x 12 months
EquipmentProgram CostDirect CostsAdmin CostsCQM CostsProgram Total
Equipment > $5,000

Equipment Total $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Supplies$ 3,500.00
Explanation of what medical supplies will be purchased. It is acceptable to use general terms and not exact amounts, as items within this category may change amounts through the course of the year. For example: "Medical Supply consumable goods such as gloves, masks, tongue depressers, swabs, etc. Durable goods such as vital sign machines, thermometers, and other items as needed."
Contractual$ 5,200.00
Item
Explanation of costs with the full outline of the contract scope and item costs. Using Laboratory as an example:
Contract with LabCorp

3/1/2023 - 2/29/2024 $5,200 200 CD4 Tests @ $200/Test 300 Viral Load Tests @ $175/Test 50 Tests for Ois @ $55/Test

Other$ 11,900.00
Explanation for each line item. Rent, for Example:
Rent for facility to perform direct and administrative activities 71.4% Direct
Direct Costs Total$ 305,846.00
Administrative Costs
Personnel$ 229,312.50
Doe, June; Program Manager - 0.10 FTE @ $7,500/year
Purpose and activities of this position as they relate to Administration.

Etc

Links

45 CFR part 75, subpart E
Direct Cost Definitions
https://www.ecfr.gov/current/title-45/section-75.413
Indirect Costs
https://www.ecfr.gov/current/title-45/section-75.414
Policy Clarification Notices
PCN 15-01 Treatment of Costs under the 10% Administrative Cap for Ryan White HIV/AIDS Program Parts A, B, C, and D
https://ryanwhite.hrsa.gov/sites/default/files/ryanwhite/grants/pcn-15-01.pdf
PCN 15-01 Frequently Asked Questions
https://ryanwhite.hrsa.gov/sites/default/files/ryanwhite/grants/faq-policy-clarification-notice-15-01.pdf
PCN 16-02 Eligible Individuals and Allowable Uses of Funds
https://ryanwhite.hrsa.gov/sites/default/files/ryanwhite/grants/service-category-pcn-16-02-final.pdf
PCN 16-02 Housing Services FAQ
https://ryanwhite.hrsa.gov/sites/default/files/ryanwhite/grants/housing-faqs-final.pdf
PCN 16-02 Standalone Dental Insurance FAQ
https://ryanwhite.hrsa.gov/sites/default/files/ryanwhite/grants/faqs-dental-insurance.pdf
PCN 16-02 Frequently Asked Questions
https://ryanwhite.hrsa.gov/sites/default/files/ryanwhite/grants/faq-service-definitions-pcn-final.pdf
PCN 21-02 Determining Client Eligibility & Payor of Last Resort in the Ryan White HIV/AIDS Program
https://ryanwhite.hrsa.gov/sites/default/files/ryanwhite/grants/pcn-21-02-determining-eligibility-polr.pdf
PCN 21-02 Dear Colleague Letter
https://ryanwhite.hrsa.gov/sites/default/files/ryanwhite/grants/dear-colleague-letter-pcn-21-02-polr.pdf
Ryan White Part A Funding Guidance
https://www.grants.gov/web/grants/view-opportunity.html?oppId=333255

https://www.ecfr.gov/current/title-45/section-75.413https://ryanwhite.hrsa.gov/sites/default/files/ryanwhite/grants/pcn-15-01.pdfhttps://www.grants.gov/web/grants/view-opportunity.html?oppId=333255https://www.ecfr.gov/current/title-45/section-75.414https://ryanwhite.hrsa.gov/sites/default/files/ryanwhite/grants/faq-policy-clarification-notice-15-01.pdfhttps://ryanwhite.hrsa.gov/sites/default/files/ryanwhite/grants/pcn-21-02-determining-eligibility-polr.pdfhttps://ryanwhite.hrsa.gov/sites/default/files/ryanwhite/grants/dear-colleague-letter-pcn-21-02-polr.pdfhttps://ryanwhite.hrsa.gov/sites/default/files/ryanwhite/grants/service-category-pcn-16-02-final.pdfhttps://ryanwhite.hrsa.gov/sites/default/files/ryanwhite/grants/housing-faqs-final.pdfhttps://ryanwhite.hrsa.gov/sites/default/files/ryanwhite/grants/faqs-dental-insurance.pdfhttps://ryanwhite.hrsa.gov/sites/default/files/ryanwhite/grants/faq-service-definitions-pcn-final.pdf

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