Exhibit_B_-_Itemized_Service_Budget__ISB_.xlsx

XLSX spreadsheet 32 KB Posted

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

About this file

This document is an Itemized Service Budget (ISB) spreadsheet template for a government contract, with multiple funding sources and cost categories. The document appears to be a financial planning tool for an organization that receives funding from various government programs, 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.

The spreadsheet is structured to track and allocate costs across 12 primary expense categories, including personnel, employer-related expenses, professional services, travel, space, equipment, materials and supplies, operating services, indirect costs, and vouchers. Each category can be broken down by specific funding source, with validation checks to ensure that DES costs do not exceed total costs and that total revenues match total service costs. The document includes a section for calculating administrative and intake cost percentages for TANF funding, with built-in error checking and compliance monitoring. Despite the detailed template, the current document appears to be a blank form with no actual financial data entered.

View the file

Other files

Show all 12

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 .