HSS26066-CARERESCTR_appE.xlsx

XLSX spreadsheet 89 KB Posted

Attached to
Caregiver Resource Centers
Solicitation number
HSS26066-CARERESCTR
Issued by
Delaware

About this file

This is a Budget Worksheet for Delaware's Caregiver Resource Centers program, designed to calculate and allocate funding across multiple budget categories and revenue sources. The worksheet accommodates various funding streams including Older Americans Act (OAA), Nutrition Services Incentive Program (NSIP), Social Services Block Grant (SSBG), State Tobacco funds, Local Cash, In-Kind contributions, Program Income, and USDA commodities. The document is structured to support both general service delivery and nutrition-specific programs, with separate worksheets for Congregate Nutrition and Home Delivered Nutrition services. Key budget line items include Staff Salaries, Staff Fringe Benefits (calculated at 43%), Travel and Training, Contractual costs, Infrastructure costs, Supplies, Equipment, and Indirect Costs. The worksheet requires detailed salary information by staff position, percentage of time allocated to the contract, and distribution of salary costs across funding sources.

The budget tool includes validation mechanisms to reconcile figures across worksheets and verify that total contract revenue equals total contract expenses. Unit cost reimbursement rates are calculated separately for OAA, SSBG, and State-funded programs, with OAA programs incorporating program income calculations and 10% matching fund requirements. The worksheet requires providers to document the determination and justification of salary increases, fringe benefit calculations, mileage expenses (with a maximum allowable DSAAPD rate of $0.40 per mile), training costs, and infrastructure costs including rent allocation. A comparison worksheet allows providers to demonstrate variance between current and proposed contract expenses across all budget categories and revenue sources, ensuring transparency in budget changes year-over-year.

View the file

Other files

File Type Posted
HSS26066-CARERESCTR_AppD.pdf PDF
HSS26066-CARERESCTR_AttA.pdf PDF
HSS26066-CARERESCTR_AttB.pdf PDF
HSS26066-CARERESCTR_appC.xlsx XLSX spreadsheet

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 .