8-Appendix D – Contract Budget Workbook – Home-Delivered Nutrition.xlsx
XLSX spreadsheet 33 KB Posted
- 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 Breakdown | Unit Cost Total | Methodology 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 Breakdown | Unit Cost Total | Methodology 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 Breakdown | Unit Cost Total | Methodology 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 |
| SSBG | Emergency | Medical | Modified & | |||
| Meal | Meal | Food | Therapeutic Meal | |||
| Unit Cost | $0.00 | $0.00 | $0.00 | ERROR:#REF! | TOTALS | |
| Planned Service Units | 0 | 0 | 0 | 0 | 0 | |
| Funding Required | $0 | $0 | $0 | ERROR:#REF! | ERROR:#REF! |
| OAA - Title III-C-2 | Emergency | Medical | Modified & | |||
| Meal | Meal | Food | Therapeutic Meal | |||
| Unit Cost | $0.00 | $0.00 | $0.00 | ERROR:#REF! | TOTALS | |
| Planned Service Units | 0 | 0 | 0 | 0 | 0 | |
| Funding Required | $0 | $0 | $0 | ERROR:#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 | |||||
| Total | VALIDATION | ||||
| Home Delivered | |||||
| SSBG Funds | Contract Budget | Budget Wksht | Difference | ||
| Planned Units of Service | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Maximum DSAAPD Resources | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Total | VALIDATION | ||||
| Home Delivered & Congregate | |||||
| Older Americans Act (OAA) | Contract Budget | Budget Wksht | Difference | ||
| Planned Units of Service | HD | ERROR:#REF! | |||
| Congregate | ERROR:#REF! | ||||
| Total | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Maximum DSAAPD Resources | HD | ERROR:#REF! | |||
| Congregate | ERROR:#REF! | ||||
| Total | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Program Income | HD | ERROR:#REF! | |||
| Congregate | ERROR:#REF! | ||||
| Total | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Matching Funds | HD | ERROR:#REF! | |||
| Congregate | ERROR:#REF! | ||||
| Total | ERROR:#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 .