Exhibit_B_-_Itemized_Service_Budget__ISB_.xlsx

XLSX spreadsheet 32 KB Posted

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

About this file

The document is an Itemized Service Budget (ISB) spreadsheet, which appears to be a financial template for a government contract involving multiple funding sources and programs. The revenue sources include various Department of Economic Security (DES) allocations such as DAAS (Division of Aging and Adult Services), CSA, CSBG CARES, along with other program acronyms like LIHEAP, TANF, NHN, and SSBG. While no specific state or agency is definitively named, the document suggests a comprehensive budgeting tool for social services and assistance programs.

The spreadsheet is structured to track costs across 12 major budget categories, including personnel, employer-related expenses, professional services, travel, space, equipment, materials, operating services, and indirect costs. Notably, the document contains validation checks for TANF (Temporary Assistance for Needy Families) administrative and intake costs, with built-in percentage limitations. However, in this particular document, all line items are currently populated with zero dollar amounts, indicating it is likely a template or an unfinished budget preparation document. The revenue sources and cost allocations suggest this is a multi-funded program targeting various social service and community assistance initiatives.

View the file

Other files

Show all 17

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 .