7-Appendix C – Contract Budget Workbook – Congregate Nutrition.xlsx

XLSX spreadsheet 42 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 Congregate Nutrition Services under the Older Americans Act (OAA) Title III-C-1 program, prepared for Delaware's Division of Services for Aging and Adults with Disabilities (DSAAPD). The workbook is designed to calculate unit costs for five meal types: Breakfast, Mid-Day, Dinner, Medical Food, and Grab and Go meals. The document provides a standardized template for agencies to break down and justify their meal costs across multiple expense categories including staff salaries, fringe benefits, training, facility costs, insurance, nutrition counseling, food supplies, and indirect costs. The budget workbook facilitates contract planning and validation for both Home-Delivered and Congregate Nutrition Services programs, establishing the foundation for determining total funding requirements based on planned units of service.

The budget workbook requires agencies to detail their unit cost methodology across 31 cost categories for each meal type, with automatic calculation of total unit costs and contract totals. Funding sources include planned USDA allocations, DSAAPD Title III-C-1 funding, and projected program income from donations. The workbook includes validation sections that reconcile planned units of service against maximum DSAAPD resources available, program income contributions, and matching fund requirements for both Home-Delivered and Congregate Nutrition Services separately. As of the revision date of August 1, 2023, this document serves as the standard budget submission tool for agencies seeking to contract with Delaware for nutrition services to older Americans, with all current entries showing zero values pending contractor completion and submission.

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

Breakfast Meal

Agency:
Program/Service:Congregate Nutrition
Contract Period:
Meal Type:Breakfast 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
Prof fee-audit, taxret, legal
Dues, Permits & Vehicle tx/tags
Janitorial supplies
Computer supplies & access
Other: Identify in Methodology
Other: Identify in Methodology
Indirect Costs
Total Unit Cost$0.00

Mid-Day Meal

Agency:0
Program/Service:Congregate Nutrtion
Contract Period:0
Meal Type:Mid-Day 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
Prof fee-audit, taxret, legal
Dues, Permits & Vehicle tx/tags
Janitorial supplies
Computer supplies & access
Other: Identify in Methodology
Other: Identify in Methodology
Indirect Costs
Total Unit Cost$0.00

Dinner Meal

Agency:
Program/Service:Congregate Nutrition
Contract Period:0
Meal Type:Dinner 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
Prof fee-audit, taxret, legal
Dues, Permits & Vehicle tx/tags
Janitorial supplies
Computer supplies & access
Other: Identify in Methodology
Other: Identify in Methodology
Indirect Costs
Total Unit Cost$0.00

Medical Food

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

Grab and Go Meal

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

Contract Totals

Agency:0
Program/Service:Congregate Nutrition
Contract Year:0
OAA - Title III-C-1BreakfastMid-DayDinnerMedicalGrab and Go
MealMealMealFoodMeal
Unit Cost$0.00$0.00$0.00$0.00ERROR:#REF!TOTALS
Planned Service Units000000
Funding Required$0$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 - Title III-C-1 $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 .