Exhibit_B_-_Itemized_Service_Budget__ISB_.xlsx

XLSX spreadsheet 32 KB Posted

Attached to
Master Agreement AZ|CTR075477
Contract number
CTR075477
Issued by
Arizona

About this file

This document is an Itemized Service Budget (ISB) spreadsheet, which appears to be a financial template for tracking costs across multiple funding sources and programs. The document includes multiple revenue and cost categories such as personnel, employer-related expenses, professional services, travel, space, equipment, materials, operating services, and indirect costs. The budget involves various funding streams including LIHEAP (Low Income Home Energy Assistance Program), NAVIGATOR, SSBG (Social Services Block Grant), TANF (Temporary Assistance for Needy Families), NHN, CSBG (Community Services Block Grant), and Tribal Heating Assistance Program.

The spreadsheet is structured to allocate and track costs across different programs and funding sources, with specific columns for total costs, DES (Department of Economic Security) costs, and various program-specific cost allocations. All budget line items are currently showing $0.00, suggesting this is a blank template or preliminary budget document. The bottom of the spreadsheet includes validation sections for TANF administrative and intake cost percentages, with built-in checks to ensure costs do not exceed allowed limits. Revenue sources are listed as DES-DAAS, DES-CSA, and DES-CSBG CARES, with a requirement that total revenues must equal total service costs.

View the file

Other files

Show all 18

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

ISB

ITEMIZED SERVICE BUDGET

Agency:
Contract Period:
Contract No.:
Amendment No.:
1.PERSONNELTotal CostDES CostCase ManagementIntakeCommunity ServiceCheck to see if your DES costs are greater than your Total cost
TOTALLIHEAP A16NAVIGATORSSBGTANFNHNTANFCSBGSSBG*DES Costs cannot be greater than Total Costs*
# ofFTETotal Salary for theTOTALDESTribal Heating Assistance ProgramTransportReview cells highlighted in red
PositionsLevelPosition TitleContract PeriodCOSTCOSTCOSTCOSTCOSTCostCostCostCOSTCOST
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00
$0.00- 0
TOTAL PERSONNEL$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00- 0
2.EMPLOYER RELATED EXPENSES
TOTALTOTAL DESLIHEAP A16NAVIGATORSSBGTANFNHNTANFCSBGTribal Heating AssistanceSSBG
Transport
ITEMBASISCOSTCOSTCOSTCOSTCostCostCostCOSTCOST
FICA, Unemployment Insurance, Work Comp, Health Benefits, Life Insurance, Retirement, Various Fringe Benefits- 0
$0.00- 0
TOTAL EMPLOYER RELATED EXPENSES.$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00- 0
3.PROFESSIONAL AND OUTSIDE SERVICES
TOTALTOTAL DESLIHEAP A16NAVIGATORSSBGTANFNHNTANFCSBGTribal Heating AssistanceSSBG
Transport
ITEMBASISCOSTCOSTCOSTCOSTCostCostCostCOSTCOST
$0.00- 0
$0.00- 0
$0.00- 0
$0.00
$0.00- 0
$0.00- 0
$0.00- 0
$0.00
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
TOTAL PROFESSIONAL AND OUTSIDE SERVICES$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00- 0
4.TRAVEL
TOTALTOTAL DESLIHEAP A16NAVIGATORSSBGTANFNHNTANFCSBGTribal Heating AssistanceSSBG
Transport
ITEMBASISCOSTCOSTCOSTCOSTCostCostCostCOSTCOST
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
TOTAL TRAVEL$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00- 0
5.SPACE
TOTALTOTAL DESLIHEAP A16NAVIGATORSSBGTANFNHNTANFCSBGTribal Heating AssistanceSSBG
Transport
ITEMBASISCOSTCOSTCOSTCOSTCOSTCostCostCostCOSTCOST
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00
TOTAL SPACE$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00- 0
6.EQUIPMENT
TOTALTOTAL DESLIHEAP A16NAVIGATORSSBGTANFNHNTANFCSBGTribal Heating AssistanceSSBG
Transport
ITEMBASISCOSTCOSTCOSTCOSTCOSTCostCostCostCOSTCOST
$0.00- 0
$0.00- 0
TOTAL EQUIPMENT$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00- 0
7.MATERIALS AND SUPPLIES
TOTALTOTAL DESLIHEAP A16NAVIGATORSSBGTANFNHNTANFCSBGSSBG
Tribal Heating AssistanceTransport
ITEMBASISCOSTCOSTCOSTCOSTCOSTCostCostCostCOSTCOST
$0.00- 0
$0.00- 0
TOTAL MATERIALS AND SUPPLIES$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00- 0
8.OPERATING SERVICES
TOTALTOTAL DESLIHEAP A16NAVIGATORSSBGTANFNHNTANFCSBGTribal Heating AssistanceSSBG
Transport
ITEMBASISCOSTCOSTCOSTCOSTCOSTCostCostCostCOSTCOST
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00
TOTAL OPERATING EXPENSES$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00- 0
9INDIRECT COSTS
TOTALTOTAL DESLIHEAP A16NAVIGATORSSBGTANFNHNTANFCSBGTribal Heating AssistanceSSBG
Transport
ITEMBASISCOSTCOSTCOSTCOSTCOSTCostCostCostCOSTCOST
$0.00$0.00- 0
$0.00
TOTAL INDIRECT COSTS$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00- 0

10 SUBTOTAL ADMIN COST $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 - 0

11.VOUCHERS
TOTALTOTAL DESLIHEAP A16NAVIGATORSSBGTANFNHNTANFCSBGTribal Heating AssistanceSSBG
Transport
ITEMCOSTCOSTCOSTCOSTCOSTCostCostCostCOSTCOST
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00$0.00
$0.00$0.00
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
$0.00- 0
TOTAL VOUCHERS$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00- 0
12.TOTAL SERVICE COST/DES TOTAL COST:$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00- 0
Note: Please ensure your Total Costs are more than or equal to your DES Costs. If the Total Costs light up red, your Total Costs need to be adjusted. See column AD
REVENUE SOURCES:
DES - DAAS$0.00
DES - DAAS - Intake Costs$0.00
DES-CSA$0.00
DES-CSBG CARES$0.00
TOTAL REVENUE:$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00

Note: Please ensure your Total Revenues equal your Total Service Costs. If the Total Revenue items light up red, your budget is not balanced, and the Costs/Revenues need to be adjusted.

Validation

TANF Admin & Intake - Maximum %TANF Calculation - Cheat Sheet
Category% Allowed% RequestedOver/UnderWaiver (Y/N)CategoryFormulaTotal TANF AwardedMAX Allowed
Admin15%ERROR:#DIV/0!ERROR:#DIV/0!NTANF AdminTotal TANF x 15%$ - 0
Intake15%ERROR:#DIV/0!ERROR:#DIV/0!NTANF Intake(Total TANF - TANF Admin) x 15%$ - 0$ - 0
Summary of Costs
CategoryTotalCombined
Total Case Management Cost$0.00$0.00
Total Case Management Intake Cost$0.00
Total Community Service Cost$0.00
Total DES Cost$0.00
Total Program Cost$0.00

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