Exhibit_B_-_Itemized_Service_Budget__ISB_.xlsx

XLSX spreadsheet 32 KB Posted

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

About this file

This document is an Itemized Service Budget (ISB) spreadsheet, appearing to be a financial template for a multi-funded government contract involving various social service and assistance programs. The document contains budget line items across multiple funding sources, including LIHEAP (Low Income Home Energy Assistance Program), TANF (Temporary Assistance for Needy Families), SSBG (Social Services Block Grant), and other state and tribal assistance programs. While no specific state or agency is definitively named, the document suggests a comprehensive budgeting tool for social service contract administration.

The spreadsheet provides a detailed breakdown of potential costs across twelve major budget categories, including personnel, employer-related expenses, professional services, travel, space, equipment, materials and supplies, operating services, indirect costs, and vouchers. Each category allows for cost allocation across multiple funding sources, with specific attention to DES (Department of Economic Security) costs. The budget template includes validation checks for administrative and intake cost percentages, particularly for TANF funding, and requires that total revenues match total service costs. No specific contract amount or pricing terms are completed in this template, indicating it is a blank budgeting instrument prepared for future contract negotiations or reporting.

View the file

Other files

Show all 15

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 .