8-Appendix D – Contract Budget Workbook – Home-Delivered Nutrition.xlsx

XLSX spreadsheet 33 KB Posted

Attached to
Congregate Nutrition & Home Delivered Nutrition Services
Solicitation number
HSS-24-049A
Issued by
Delaware

About this file

This is a Contract Budget Workbook for Home-Delivered Nutrition Services prepared by the Delaware Department of Services for Aging and Adults with Disabilities (DSAAPD). The document serves as a budgeting template for meal agencies providing home-delivered nutrition programs to older adults, specifically designed to calculate unit costs for different meal types including regular meals, emergency meals, and medical/therapeutic meals. The workbook is structured to accommodate multiple meal types and contract periods, with sections for detailed cost breakdowns and validation of planned service units against available funding. The contract period referenced in the template is dated 12/31/99, though the document was revised on 8/1/2023.

The budget workbook itemizes all allowable cost categories for home-delivered nutrition services, including staff salaries, fringe benefits, travel (mileage at $0.40 per mile), training, rent, utilities, phone and internet, insurance (liability and auto), nutrition counseling, dietician services, equipment, office and paper supplies, medical supplies, raw food, and vehicle expenses. The document establishes a unit cost calculation methodology and includes validation sections for tracking funding from multiple sources: Supplemental Security Income Block Grant (SSBG) funds, Older Americans Act (OAA) Title III-C-2 funds, project income from donations, and DSAAPD direct funding. The template includes reconciliation between planned service units, projected funding requirements, and available resources from both state and federal sources, with built-in error checking to ensure budget alignment across home-delivered and congregate nutrition programs.

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

Meal

Agency:
Program/Service:Home Delivered Nutrition
Contract Period:
Meal Type:Meal
Unit Cost BreakdownUnit Cost TotalMethodology of Unit Cost Breakdown
Staff Salaries
Fringe Benefits
Travel (Mileage x .40 per mile)
Training
Rent
Electricity/Heat/Other Utilities
Phone/Internet/Media/Postage
Printing/Advertising/Photocopy
Postage
Insurance - Liability
Insurance - Auto
Repairs/Maintenance
Nutrition Counseling
Dietician
Equipment
Office Supplies
Paper Supplies
Medical Supplies
Program Supplies
Raw Food
Vehicle Expenses
Other: Identify in Methodology
Other: Identify in Methodology
Other: Identify in Methodology
Other: Identify in Methodology
Other: Identify in Methodology
Other: Identify in Methodology
Indirect Costs
Total Unit Cost$0.00

Emergency Meal

Agency:0
Program/Service:Home Delivered Nutrition
Contract Period:12/31/99
Meal Type:Emergency Meal
Unit Cost BreakdownUnit Cost TotalMethodology of Unit Cost Breakdown
Staff Salaries
Fringe Benefits
Travel (Mileage x .40 per mile)
Training
Rent
Electricity/Heat/Other Utilities
Phone/Internet/Media/Postage
Printing/Advertising/Photocopy
Postage
Insurance - Liability
Insurance - Auto
Repairs/Maintenance
Nutrition Counseling
Dietician
Equipment
Office Supplies
Paper Supplies
Medical Supplies
Program Supplies
Raw Food
Vehicle Expenses
Other: Identify in Methodology
Other: Identify in Methodology
Other: Identify in Methodology
Other: Identify in Methodology
Other: Identify in Methodology
Other: Identify in Methodology
Indirect Costs
Total Unit Cost$0.00

Medical Food

Agency:0
Program/Service:Home Delivered Nutrition
Contract Period:12/31/99
Meal Type:Medical Food
Unit Cost BreakdownUnit Cost TotalMethodology of Unit Cost Breakdown
Staff Salaries
Fringe Benefits
Travel (Mileage x .40 per mile)
Training
Rent
Electricity/Heat/Other Utilities
Phone/Internet/Media/Postage
Printing/Advertising/Photocopy
Postage
Insurance - Liability
Insurance - Auto
Repairs/Maintenance
Nutrition Counseling
Dietician
Equipment
Office Supplies
Paper Supplies
Medical Supplies
Program Supplies
Raw Food
Vehicle Expenses
Other: Identify in Methodology
Other: Identify in Methodology
Other: Identify in Methodology
Other: Identify in Methodology
Other: Identify in Methodology
Other: Identify in Methodology
Indirect Costs
Total Unit Cost$0.00

Contract Totals

Agency:0
Program/Service:Home Delivered Nutrition
Contract Year:12/31/99
SSBGEmergencyMedicalModified &
MealMealFoodTherapeutic Meal
Unit Cost$0.00$0.00$0.00ERROR:#REF!TOTALS
Planned Service Units00000
Funding Required$0$0$0ERROR:#REF!ERROR:#REF!
OAA - Title III-C-2EmergencyMedicalModified &
MealMealFoodTherapeutic Meal
Unit Cost$0.00$0.00$0.00ERROR:#REF!TOTALS
Planned Service Units00000
Funding Required$0$0$0ERROR:#REF!ERROR:#REF!

Funding Required ERROR:#REF!

Total Service Units 1

Projected per Meal Project Income (PI) $0.00

Planned USDA Funding $0

Projected Project Income (Donations) $0

Planned DSAAPD Funding - SSBG $0

Planned DSAAPD Funding - Title III-C-2 $0

Difference ERROR:#REF!

DSAAPD Contract Funding$0
Revised 8/1/2023

Nutrition Budget Validation

Home Delivered and Congregate Contract Budget Validation
TotalVALIDATION
Home Delivered
SSBG FundsContract BudgetBudget WkshtDifference
Planned Units of ServiceERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Maximum DSAAPD ResourcesERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
TotalVALIDATION
Home Delivered & Congregate
Older Americans Act (OAA)Contract BudgetBudget WkshtDifference
Planned Units of ServiceHDERROR:#REF!
CongregateERROR:#REF!
TotalERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Maximum DSAAPD ResourcesHDERROR:#REF!
CongregateERROR:#REF!
TotalERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Program IncomeHDERROR:#REF!
CongregateERROR:#REF!
TotalERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Matching FundsHDERROR:#REF!
CongregateERROR:#REF!
TotalERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!

Total Maximum DSAAPD Resources ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

&F 3/25/09

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