7-HSS-26-066 - AppE-Budget Wkbk-CRC.xlsx

XLSX spreadsheet 89 KB Posted

Attached to
CAREGIVER RESOURCE CENTERS
Solicitation number
HSS-26-066
Issued by
Delaware

About this file

This is a budget worksheet for a Caregiver Resource Centers (CRC) contract opportunity in Delaware administered by the Division of Services for Aging and Adults with Physical Disabilities (DSAAPD), identified as contract 7-HSS-26-066. The worksheet is designed to detail projected expenses and funding sources for agencies providing caregiver support services in the community. The budget structure accommodates multiple service delivery models including general programming, congregate nutrition services, and home-delivered nutrition services. The worksheet is formatted to capture staff salaries, fringe benefits calculated at 43%, travel and training costs, infrastructure costs, supplies, equipment, and indirect costs. Budget allocations are tracked across multiple funding sources including OAA (Older Americans Act) funds, NSIP (Nutrition Services Incentive Program), SSBG (Social Services Block Grant), State Tobacco funds, Local Cash, In-Kind contributions, Program Income, and USDA commodities.

The budget worksheet includes validation mechanisms to ensure alignment between budget projections and contract budgets across different service categories and funding streams. Unit cost calculations are required for SSBG and State-funded services, while OAA programs must account for program income and establish reimbursement rates. The worksheet requires detailed narratives justifying staff salary determinations, fringe benefit calculations, travel and training expenses, and infrastructure costs. A comparison worksheet tracks variance between current and proposed contracts, and the document includes separate budget sections for congregate meals and home-delivered meals with meal type specifications. The mileage reimbursement rate is set at $0.50 per mile with a DSAAPD maximum allowable rate of $0.40 per mile. All budget calculations are subject to validation for internal consistency between the main budget worksheet and nutrition-specific worksheets.

View the file

Other files

File Type Posted
2-HSS-26-066 - CRC-AttA.docx DOCX document
5-HSS-26-066 - AppC-Vendor Frms.xlsx XLSX spreadsheet
3-HSS-26-066 - CRC-AttB.docx DOCX document
4-HSS-26-066 - CRC-AttC-OAAPS Mthly Rpt.xlsx XLSX spreadsheet
1-HSS-26-066 - CRC - Final.docx DOCX document
6-HSS-26-066 - AppD-Templates-PSA, BAA DTI TCs.docx DOCX document

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

Budget Worksheet

BUDGET WORKSHEET
0
0
0

Budget Items TOTAL OAA NSIP SSBG State Tobacco Local Cash In-Kind Program Income USDA Administration

ValidationFor Provider Use
C-1Staff SalariesERROR:#VALUE!ERROR:#VALUE!$0$0$0$0$0ERROR:#VALUE!
C-2Staff Fringe BenefitsERROR:#VALUE!ERROR:#VALUE!$0$0$0$0$0ERROR:#VALUE!
C-3Travel/Training (Total)$0$0$0$0$0$0$00
Mileage = Rate $0.50 X Miles$0ERROR:#REF!
Training$0ERROR:#REF!
Other (specify)0
C-4Contractual (Total)$0$0$0$0$0$0$00
Infrastructure Cost$0$0
C-7Indirect Costs (Total Salaries w/o fringe x rate)ERROR:#VALUE!ERROR:#VALUE!$0$0$0$0$0
C-8Total BudgetERROR:#VALUE!ERROR:#VALUE!
C-9Total Budget w/oERROR:#VALUE!
Local Cash / In Kind

Salary Worksheet

SALARY WORKSHEET

Agency:
Program / Service:
Contract Period:
Salary Paid w/Salary Paid w/Salary Paid w/Salary Paid w/Salary Paid w/Salary Paid w/TotalValidation
Name of StaffTitle/PositionProjectTotalAnnual% of TimeOAASSBGStateTobaccoLocal Cash/ProgramContract
HoursHoursSalaryon ProjectFundsFundsFundsFundsIn-KindIncomeSalaryFor Provider Use
ERROR:#VALUE!ERROR:#VALUE!
ERROR:#VALUE!ERROR:#VALUE!
ERROR:#VALUE!ERROR:#VALUE!
$0
$0
$0
$0
$0
TotalsERROR:#VALUE!$0$0$0$0$0ERROR:#VALUE!
Fringe Benefits43%ERROR:#VALUE!$0$0$0$0$0ERROR:#VALUE!

Budget Worksheet Supplement

BUDGET WORKSHEET SUPPLEMENT

0
0
0
Narrative is REQUIRED for each Category where DSAAPD funds have been allocated on the Budget Worksheet.

C-1 Staff Salaries Amount charged to DSAAPD ERROR:#VALUE!

Explain how Staff Salaries were determined and justify any increase from the previous contract year.

C-2Staff Fringe BenefitsAmount charged to DSAAPDERROR:#VALUE!
Fringe Benefits Rate
Explain how Staff Fringe Benefits were determined and justify any increase from the previous contract year.
Show the break down of the Fringe Benefit Rate.

C-3 Travel / Training Amount charged to DSAAPD $0

Explain how the following costs were determined, what is included in the costs and justify any
increase from previous contract year.

Mileage*

Mileage Rate $0.50 Total Mileage = $0.00

Amount charged to DSAAPD $0

* DSAAPD maximum allowable mileage rate is $0.40/mile

Training Amount charged to DSAAPD $500

Amount charged to DSAAPD

C-4 Infrastructure Cost Amount charged to DSAAPD $0

Explain how the following costs were determined, what is included in the costs and justify any
increase from previous contract year.
Rent
Rental LocationSq. Footage being charged to DSAAPDCost Per Sq. Ft.Total
$0
$0
$0
$0
Total IFC$0
In-Kind Amount$0
DSAAPD Cost$0
DSAAPD Cost/Sq FootERROR:#DIV/0!
Total Months Charged to Rent:DSAAPD Cost/MonthERROR:#DIV/0!

Infrastructure Cost - Additional Narrative Amount charged to DSAAPD $0

Other Program Cost Calculation

Other Program Cost Unit Reimbursement Rates
OAA FundsIn- Kind
Rent$0$0
Electricity$0$0
Heat$0$0
Telephone$0$0
Utilities Other$0$0
Printing/Advertising$0$0
Postage$0$0
Insurance$0$0
Repairs$0$0
Room Rental$0$0
Office Supplies$0$0
Program Supplies$0$0
Photocopy$0$0

Total $0 $0

Sq FootTotal Cost
0$0
0$0
0$0
Total Sq. Ft.0$0.00
IFC Unit CostERROR:#DIV/0!
DSAAPD IFC Unit CostERROR:#DIV/0!

Final Budget

FINAL BUDGET

0
0
0
BUDGET ITEMS
BUDGET
C-1Staff SalariesERROR:#VALUE!
C-2Staff Fringe BenefitsERROR:#VALUE!
C-3Travel/Training$0
C-4Infastructure Cost$0
C-5Total Budget (Including Local Cash / In-Kind)ERROR:#VALUE!
C-6Total Budget w/o Local Cash / In-KindERROR:#VALUE!
OAASSBGStateTobacco
Planned Units of Service00000
Unit Cost$0.00$0.00$0.00$0.00
Planned Program Income$0
Program Income per Unit of Service$0.00
Other Resources (USDA Commodities)$0
DSAAPD Resources NeededERROR:#VALUE!
Total Resources w/o local cash/in-kindERROR:#VALUE!
OAA
Reimbursement Rate$0.00
DSAAPD Resources Needed = (C-9)Total Budget w/o Local Cash or In-Kind - Planned Program Income - Other Resources (USDA Commodities)
Reimbursement Rate = Unit Cost - Program Income per Unit of Service (for OAA units only)

Comparison Worksheet

COMPARISON WORKSHEET

0
0
0
A.Projected Contract Expenses w/o Local Cash / In-KindCurrentProposed
% Line Item ChangeContractContractVariance
1.Salary$0$0
2.Fringe Benefits$0$0
3.Travel / Training$0$0
4.Contractual$0$0
5.Supplies$0$0
6.Equipment / Other Direct Costs$0$0
7.Infastructure Cost$0$0
Total Projected Contract Expenses w/o Local Cash / In-Kind$0ERROR:#VALUE!
B.Project Revenue (Funding Sources)
Total DSAAPD Funds Requested
n Final Budget$0ERROR:#VALUE!
Other Revenue Sources
n USDA$0$0
n Project Income$0$0
Total Contract Revenue$0ERROR:#VALUE!
C.Units of Service0
n Unit Cost (SSBG)$0.00
n Unit Cost (State)$0.00
n Unit Cost (Tobacco)$0.00
n Unit Cost (OAA)$0.00
n Reimbursement Rate (OAA)$0.00
* Total Contract Revenue must equal Total Contract Expenses
* Total DSAAPD Funds is the sum of Title III & NSIP Cash or SSBG

Unit Cost Contract Budget Unit Cost Contract Budget

Agency:0
Program/Service:0
Contract Year:0
STATE
A.Unit Cost$0.00
B.Planned Service Units0
C.Total Resources Needed
a.Maximum DSAAPD Resources (A x B)$0
SSBG
A.Unit Cost$0.00
B.Planned Service Units0
C.Total Resources Needed
a.Maximum DSAAPD Resources (A x B)$0
TOBACCO
A.Unit Cost$0.00
B.Planned Service Units0
C.Total Resources Needed
a.Maximum DSAAPD Resources (A x B)$0
OAA Programs (with Program Income)
A.Unit Cost$0.00
B.Program Income per Unit of Service$0.00
C.DSAAPD Reimbursement Rate (A - B)$0.00
D.Planned Service Units0
E.Total Resources Needed:
a.Maximum DSAAPD Resources (C x D)$0
b.Program Income (B x D)$0
c.10% Matching Funds$0
(E.a) ÷ 0.9 - (E.a)

Total Contract Amount $0

Budget Workbook V8 &F 3/21/2012

Congregate

CONGREGATE NUTRITION WORKSHEET
0
0
0
Budget ItemsMeal Type and Other Nutrition Interventions
TOTALMedicalSpecialOtherNutrition
BreakfastMid-dayEveningFoodsFoods(Specify)InterventionValidationFor Provider Use
C-1Staff Salaries$0ERROR:#VALUE!
C-2Staff Fringe Benefits$0ERROR:#VALUE!
C-3Travel/Training (Total)$0$0$0$0$0$0$0$0TRUE
Mileage = Rate X Miles$0
Training$0
Other (specify)$0
C-4Contractual (Total)$0$0$0$0$0$0$0$0TRUE
Rent (include cost per sq. ft.)$0
Electricity$0
Heat$0
Telephone/Internet$0
Utilities Other$0
Printing/Advertising$0
Postage$0
Insurance$0
Repairs$0
0$0
0$0
0$0
0$0
C-5Supplies (Total)$0$0$0$0$0$0$0$0TRUE
Office Supplies$0
Paper Supplies$0
Medical Supplies$0
Program Supplies$0
Photocopy$0
Raw Food$0
Prepared Meals$0
Vehicle (oil, gas, etc)$0
ERROR:#REF!$0
ERROR:#REF!$0
C-6Equipment/Other Direct Costs (Total)$0$0$0$0$0$0$0$0ERROR:#REF!
ERROR:#REF!$0
ERROR:#REF!$0
C-7Indirect Costs (Total Salaries w/o fringe x rate)$0ERROR:#VALUE!
C-8Total Budget$0$0$0$0$0$0$0$0ERROR:#VALUE!
Older Americans Act$0ERROR:#VALUE!
Units of Service0
Reimbursement Rate
SSBG$0TRUE
Units of Service0
Reimbursement Rate
State$0TRUE
Units of Service0
Reimbursement Rate
Tobacco$0TRUE
Units of Service0
Reimbursement Rate
Program Income$0TRUE
Units of Service0
Per Meal
USDA Commodities$0TRUE
Units of Service0
Per Meal
Local$0TRUE
$0$0$0$0$0$0$0$0
TRUETRUETRUETRUETRUETRUETRUETRUE
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00

Budget Workbook V8 &F 3/21/2012

Congregate Contract Budget Unit Cost Contract Budget

Agency:0
Program/Service:Nutrition - Congregate Meals
Contract Year:0
OAA Programs (With Program Income)MedicalSpecializedOtherNutrition
BreakfastMid-dayEveningFoodFood(Specify)InterventionTOTALS
A.Unit Cost
B.Program Income per Unit of Service
C.DSAAPD Reimbursement Rate (A - B)
D.Planned Service Units00
E.Total Resources Needed:
a.Maximum DSAAPD Resources (C x D)$0
b.NSIP (Commodity Food)$0
c.Program Income (B x D)$0
d.10% Matching Funds$0
(E.a. ÷ 0.9) - E.a.

Total Congregate Meals Contract Amount $0

Budget Workbook V8 &F 3/21/2012

Home Delivered

HOME DELIVERED NUTRITION WORKSHEET
0
0
0
Budget ItemsMeal Type and Other Nutrition Interventions
TOTALMid-DayEveningBag MealEmergencyMedicalSpecialShelfOtherNutrition
MealsMealsEveningMealsFoodMed. FoodStable(specify)InterventionValidationFor Provider Use
C-1Staff Salaries$0ERROR:#VALUE!
C-2Staff Fringe Benefits$0ERROR:#VALUE!
C-3Travel/Training (Total)$0$0$0$0$0$0$0$0$0$0TRUE
Mileage = Rate X Miles$0
Training$0
Other (specify)$0
C-4Contractual (Total)$0$0$0$0$0$0$0$0$0$0TRUE
Rent (include cost per sq. ft.)$0
Electricity$0
Heat$0
Telephone/Internet$0
Utilities Other$0
Printing/Advertising$0
Postage$0
Insurance$0
Repairs$0
0$0
0$0
0$0
0$0
C-5Supplies (Total)$0$0$0$0$0$0$0$0$0$0TRUE
Office Supplies$0
Paper Supplies$0
Medical Supplies$0
Program Supplies$0
Photocopy$0
Raw Food$0
Prepared Meals$0
Vehicle (oil,gas, etc)$0
ERROR:#REF!$0
ERROR:#REF!$0
C-6Equipment/Other Direct Costs (Total)$0$0$0$0$0$0$0$0$0$0ERROR:#REF!
ERROR:#REF!$0
ERROR:#REF!$0
C-7Indirect Costs (Total Salaries w/o fringe x rate)$0ERROR:#VALUE!
C-8Total Budget$0$0$0$0$0$0$0$0$0$0ERROR:#VALUE!
Older Americans Act$0ERROR:#VALUE!
Units of Service0
Reimbursement Rate
SSBG$0TRUE
Units of Service0
Reimbursement Rate
State$0TRUE
Units of Service0
Reimbursement Rate
Tobacco$0TRUE
Units of Service0
Reimbursement Rate
Program Income$0TRUE
Units of Service0
Per Meal
USDA Commodities$0TRUE
Units of Service0
Per Meal
Local$0TRUE
TRUETRUETRUETRUETRUETRUETRUETRUETRUETRUE
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00

Budget Workbook V8 &F 3/21/2012

HD Contract Budget Unit Cost Contract Budget

Agency:0
Program/Service:Nutrition - Home Delivered Meals
Contract Year:0
SSBGBag MealEmergencyMedicalSpecializedShelfOtherNutrition
Mid-DayEveningEveningMealFoodMed. FoodStable(specify)InterventionTOTALS
A.Unit Cost
B.Planned Service Units0
C.Total Resources Needed
a.Maximum DSAAPD Resources (A x B)$0
OAA Programs (With Program Income)Bag MealEmergencyMedicalSpecializedShelfOtherNutrition
Mid-DayEveningEveningMealFoodMed. FoodStable(specify)InterventionTOTALS
A.Unit Cost
B.Program Income per Unit of Service
C.DSAAPD Reimbursement Rate (A x B)
D.Planned Service Units00
E.Total Resources Needed:
a.Maximum DSAAPD Resources (C x D)$0
b.NSIP (Commodity Food)$0
c.Program Income (B x D)$0
d.10% Matching Funds$0
(E.a ÷ 0.9) - E.a

Total Home Delivered Meals Contract Amount $0

Budget Workbook V8 &F 3/21/2012

Validation

NUTRITION VALIDATION WORKSHEET
0
0
0
Budget ItemsTOTALCongregateHome DeliveredTOTAL Budget Worksheet
Nutrition
WorksheetsValidation
C-1Staff Salaries$0$0$0ERROR:#VALUE!ERROR:#VALUE!
C-2Staff Fringe Benefits$0$0$0ERROR:#VALUE!ERROR:#VALUE!
C-3Travel/Training (Total)$0$0$0$0$0
Mileage = Rate X Miles$0$0$0$0$0
Training$0$0$0$0$0
Other (specify)$0$0$0$0$0
C-4Contractual (Total)$0$0$0$0$0
Infrastructure Cost$0$0$0$0$0
0$0$0$0$0$0
0$0$0$0$0$0
0$0$0$0$0$0
0$0$0$0$0$0
0$0$0$0$0$0
0$0$0$0$0$0
0$0$0$0$0$0
0$0$0$0$0$0
0$0$0$0$0$0
0$0$0$0$0$0
0$0$0$0$0$0
0$0$0$0$0$0
C-5Supplies (Total)$0$0$0$0$0
Office Supplies$0$0$0ERROR:#REF!ERROR:#REF!
Paper Supplies$0$0$0ERROR:#REF!ERROR:#REF!
Medical Supplies$0$0$0ERROR:#REF!ERROR:#REF!
Program Supplies$0$0$0ERROR:#REF!ERROR:#REF!
Photocopy$0$0$0ERROR:#REF!ERROR:#REF!
Raw Food$0$0$0ERROR:#REF!ERROR:#REF!
Prepared Meals$0$0$0ERROR:#REF!ERROR:#REF!
Vehicle (oil,gas, etc)$0$0$0ERROR:#REF!ERROR:#REF!
ERROR:#REF!$0$0$0ERROR:#REF!ERROR:#REF!
ERROR:#REF!$0$0$0ERROR:#REF!ERROR:#REF!
C-6Equipment/Other Direct Costs (Total)$0$0$0ERROR:#REF!ERROR:#REF!
ERROR:#REF!$0$0$0ERROR:#REF!ERROR:#REF!
ERROR:#REF!$0$0$0ERROR:#REF!ERROR:#REF!
C-7Indirect Costs (Total Salaries w/o fringe x rate)$0$0$0ERROR:#VALUE!ERROR:#VALUE!
C-8Total Budget$0$0$0ERROR:#VALUE!ERROR:#VALUE!
C-9Total Budget w/o Local Cash & In-Kind$0$0$0ERROR:#VALUE!ERROR:#VALUE!

Budget Workbook V8 &F 3/21/2012

Nutrition Budget Validation

Home Delivered and Congregate Contract Budget Validation
TotalVALIDATION
Home Delivered
SSBG FundsContract BudgetBudget WkshtDifference
Planned Units of Service00TRUE0
Maximum DSAAPD Resources$0.00$0.00TRUE$0.00
TotalVALIDATION
Home Delivered & Congregate
Older Americans Act (OAA)Contract BudgetBudget WkshtDifference
Planned Units of ServiceHD0
Congregate0
Total00TRUE0
Maximum DSAAPD ResourcesHD$0.00
Congregate$0.00
Total$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Program IncomeHD$0.00
Congregate$0.00
Total$0.00$0.00TRUE$0.00
Matching FundsHD$0.00
Congregate$0.00
Total$0.00$0.00TRUE$0.00

Total Maximum DSAAPD Resources $0.00 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!

&F 3/25/09

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