Exhibit_B_-_Itemized_Service_Budget__ISB_.xlsx

XLSX spreadsheet 32 KB Posted

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

About this file

This document is an Itemized Service Budget (ISB) spreadsheet, seemingly related to a government contract or grant funding. The document appears to involve multiple funding sources including DES (Department of Economic Security), LIHEAP (Low Income Home Energy Assistance Program), SSBG (Social Services Block Grant), TANF (Temporary Assistance for Needy Families), and Tribal Heating Assistance Program. While no specific state is definitively identified, the spreadsheet is structured to track budgetary allocations across various social service and assistance programs.

The spreadsheet is a comprehensive budget template with 12 primary cost categories, including personnel, employer-related expenses, professional services, travel, space, equipment, materials and supplies, operating services, indirect costs, and vouchers. All budget line items are currently showing $0.00, suggesting this is a template or draft document. The document includes detailed tracking for multiple funding sources and program-specific cost allocations, with built-in validation checks to ensure budget balance and compliance with administrative cost limits, such as a 15% cap on TANF administrative and intake expenses.

View the file

Other files

Show all 19

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 .