GRANTSUMMARYAGENDA.XLSX

Maricopa County — Formal (2015-01-21)

View PDF Item 18 Meeting page

Extracted text (via pymupdf_layout) 14903 characters
Juvenile Probation FY15 Combined Grant Agenda
Indirect
Cost Rate FY15
Indirect Cost Allowed Current Original Change Total Match Portion of
Grant Award Personnel Operating Remaining Passthrough Base Dept by Recoverable Unrecoverable Budget Budget Requested Amount Grant
Grantor Grant Program (Entity-wide #) & ERE Capital Amount New Budgets Budgets Rate = 41.5% Grantor Indirect Costs Indirect Costs Interest Amount Adopted Budgeted Match Notes
700 800 900 615 645/800
FY15 Grants
- - - -
AZ DOE/Fed National School Breakfast/Lunch Program GJFFB5/GJFFL5 446,000 446,000 446,000 446,000 185,090 446,000 446,000 -
Fed/AZ Governor J.A.B.G. GJABG16 341,643 41,040 382,683 357,830 - 357,830 191,342 166,488 42,522 31,081 1
AZ Suprm Crt Diversion - Consequences GJDCR5 433,501 92,065 525,566 525,566 525,566 - 218,110 100 525,666 521,207 4,459 -
AZ Suprm Crt GED Program - Durango GJGDD5 - 7,500 7,500 7,500 7,500 - 3,112 100 7,600 9,000 (1,400)
AZ Suprm Crt GED Program - SEF GJGDS5 - 7,500 7,500 7,500 7,500 - 3,112 100 7,600 9,000 (1,400)
AZ DOE Safe Schools GJJ1R5 268,681 268,681 268,681 268,681 - 111,503 268,681 484,697 (216,016) - -
AZ Suprm Crt Juvenile Probation Services GJJTR5 629,348 66,101 695,449 695,449 695,449 - 288,611 100 695,549 538,424 157,125
AZ Suprm Crt Diversion - Intake GJPAR5 1,498,884 - 1,498,884 1,498,884 1,498,884 - - 622,037 160,980 1,659,864 1,592,992 66,872
Federal Prison Rape Elimination Act GJPRE4 86,790 210,039 296,829 4,600 - 4,600 4,600 2
Title IV-E Funds (Carry forward & possible FY14
AZ Suprm Crt disbursement) GJTIV3 7,003 - 7,003 7,003 - - - - 100 7,103 6,458 645 1
AZ Attny Gen Victims' Rights GJVRR5 141,900 141,900 141,900 141,900 - 58,889 100 142,500 142,500 -
Fed Justice Assistance Grant (JAG)-2013 GJJAG4 56,985 56,985 8,137 - - 8,137 56,985 (48,848) - - 1
Fed Justice Assistance Grant (JAG)-2014 GJJAG5 62,836 62,836 62,836 62,836 - - 26,077 100 62,936 - 62,936 - - 3
Family Counseling (Funds spent by grantor on grantee's
AZ Suprm Crt behalf.) n/a - - - - - - - - - - - - - 92,625 92,625
- - - -
- - - -
- -
- -
Interest balance carryforward 162,260 162,260 -
3,527,571 870,245 - 4,397,816 3,654,316 377,570 - 3,654,316 - - 1,516,541 161,680 4,356,326 4,160,865 195,461 135,147 123,706
- - - - -
Note 1-No indirect cost computations made as grants were approved via previous board agendas for prior years
6/28/2020 4:22 PM

Grant Agenda Indirect Cost Calculation
Allowable/Unallowable
Grant: GJFFB5 & GJFFL5
10.800% Departmental Indirect Cost Rate (FY 2015)
30.700% Department's County Wide Indirect Cost Rate (FY 2015)
41.500% Department's Combined Indirect County-Wide Rate (FY 2015)
N Indirect Cost Exemption Granted (Y/N)
0.000% Indirect Cost Exemption Rate
0.000% Grant's ALLOWABLE Indirect Cost Rate
0.000% Grant's Indirect Cost Rate CHARGED with EXEMPTION Waiver (If Applicable)
0.000% Grant's Indirect Cost Rate WAIVED with EXEMPTION Waiver
41.500% Grant's UNALLOWABLE Indirect Cost Rate
41.500% Department's Combined Indirect County-Wide Rate
0.000% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
0.000% Department's Combined Indirect County-Wide Rate
446,000.00 Total Grant Award ( 446,000.00 Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
0.00 Estimated Subrecipient Expenses
0.00 Indirect Costs
446,000.00 Indirect Cost Base
41.50% Indirect Cost Rate
185,090.00 Total Indirect Costs
0.00 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
0.00 Estimated ALLOWABLE Indirect Costs
0.00 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
0.00 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
0.00 Estimated ALLOWABLE Indirect Costs to be CHARGED
185,090.00 Estimated UNALLOWABLE Indirect Costs

Grant Agenda Indirect Cost Calculation
Allowable/Unallowable
Grant: GJABG6
10.800% Departmental Indirect Cost Rate (FY 2015)
30.700% Department's County Wide Indirect Cost Rate (FY 2015)
41.500% Department's Combined Indirect County-Wide Rate (FY 2015)
N Indirect Cost Exemption Granted (Y/N)
0.000% Indirect Cost Exemption Rate
5.000% Grant's ALLOWABLE Indirect Cost Rate
5.000% Grant's Indirect Cost Rate CHARGED with EXEMPTION Waiver (If Applicable)
0.000% Grant's Indirect Cost Rate WAIVED with EXEMPTION Waiver
36.500% Grant's UNALLOWABLE Indirect Cost Rate
41.500% Department's Combined Indirect County-Wide Rate
5.000% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
5.000% Department's Combined Indirect County-Wide Rate
382,683.00 Total Grant Award ( 364,460.00 Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
0.00 Estimated Subrecipient Expenses
18,223.00 Indirect Costs
364,460.00 Indirect Cost Base
41.50% Indirect Cost Rate
151,250.90 Total Indirect Costs
18,223.00 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
18,223.00 Estimated ALLOWABLE Indirect Costs
18,223.00 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
0.00 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
18,223.00 Estimated ALLOWABLE Indirect Costs to be CHARGED
133,027.90 Estimated UNALLOWABLE Indirect Costs
45,389.00

258515.8

Grant Agenda Indirect Cost Calculation
Allowable/Unallowable
Grant: GJDCR4
10.800% Departmental Indirect Cost Rate (FY 2015)
30.700% Department's County Wide Indirect Cost Rate (FY 2015)
41.500% Department's Combined Indirect County-Wide Rate (FY 2015)
N Indirect Cost Exemption Granted (Y/N)
0.000% Indirect Cost Exemption Rate
0.000% Grant's ALLOWABLE Indirect Cost Rate
0.000% Grant's Indirect Cost Rate CHARGED with EXEMPTION Waiver (If Applicable)
0.000% Grant's Indirect Cost Rate WAIVED with EXEMPTION Waiver
41.500% Grant's UNALLOWABLE Indirect Cost Rate
41.500% Department's Combined Indirect County-Wide Rate
0.000% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
0.000% Department's Combined Indirect County-Wide Rate
525,566.00 Total Grant Award ( 525,566.00 Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
0.00 Estimated Subrecipient Expenses
0.00 Indirect Costs
525,566.00 Indirect Cost Base
41.50% Indirect Cost Rate
218,109.89 Total Indirect Costs
0.00 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
0.00 Estimated ALLOWABLE Indirect Costs
0.00 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
0.00 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
0.00 Estimated ALLOWABLE Indirect Costs to be CHARGED
218,109.89 Estimated UNALLOWABLE Indirect Costs

Grant Agenda Indirect Cost Calculation
Allowable/Unallowable
Grant: GJGDD5 & GJGDS5
($7,500 each)
10.800% Departmental Indirect Cost Rate (FY 2015)
30.700% Department's County Wide Indirect Cost Rate (FY 2015)
41.500% Department's Combined Indirect County-Wide Rate (FY 2015)
N Indirect Cost Exemption Granted (Y/N)
0.000% Indirect Cost Exemption Rate
0.000% Grant's ALLOWABLE Indirect Cost Rate
0.000% Grant's Indirect Cost Rate CHARGED with EXEMPTION Waiver (If Applicable)
0.000% Grant's Indirect Cost Rate WAIVED with EXEMPTION Waiver
41.500% Grant's UNALLOWABLE Indirect Cost Rate
41.500% Department's Combined Indirect County-Wide Rate
0.000% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
0.000% Department's Combined Indirect County-Wide Rate
7,500.00 Total Grant Award ( 7,500.00 Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
0.00 Estimated Subrecipient Expenses
0.00 Indirect Costs
7,500.00 Indirect Cost Base
41.50% Indirect Cost Rate
3,112.50 Total Indirect Costs
0.00 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
0.00 Estimated ALLOWABLE Indirect Costs
0.00 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
0.00 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
0.00 Estimated ALLOWABLE Indirect Costs to be CHARGED
3,112.50 Estimated UNALLOWABLE Indirect Costs

Grant Agenda Indirect Cost Calculation
Allowable/Unallowable
Grant: GJJ1R5
10.800% Departmental Indirect Cost Rate (FY 2015)
30.700% Department's County Wide Indirect Cost Rate (FY 2015)
41.500% Department's Combined Indirect County-Wide Rate (FY 2015)
N Indirect Cost Exemption Granted (Y/N)
0.000% Indirect Cost Exemption Rate
0.000% Grant's ALLOWABLE Indirect Cost Rate
0.000% Grant's Indirect Cost Rate CHARGED with EXEMPTION Waiver (If Applicable)
0.000% Grant's Indirect Cost Rate WAIVED with EXEMPTION Waiver
41.500% Grant's UNALLOWABLE Indirect Cost Rate
41.500% Department's Combined Indirect County-Wide Rate
0.000% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
0.000% Department's Combined Indirect County-Wide Rate
268,681.00 Total Grant Award ( 268,681.00 Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
0.00 Estimated Subrecipient Expenses
0.00 Indirect Costs
268,681.00 Indirect Cost Base
41.50% Indirect Cost Rate
111,502.62 Total Indirect Costs
0.00 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
0.00 Estimated ALLOWABLE Indirect Costs
0.00 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
0.00 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
0.00 Estimated ALLOWABLE Indirect Costs to be CHARGED
111,502.62 Estimated UNALLOWABLE Indirect Costs

Grant Agenda Indirect Cost Calculation
Allowable/Unallowable
Grant: GJJTR4
10.800% Departmental Indirect Cost Rate (FY 2015)
30.700% Department's County Wide Indirect Cost Rate (FY 2015)
41.500% Department's Combined Indirect County-Wide Rate (FY 2015)
N Indirect Cost Exemption Granted (Y/N)
0.000% Indirect Cost Exemption Rate
0.000% Grant's ALLOWABLE Indirect Cost Rate
0.000% Grant's Indirect Cost Rate CHARGED with EXEMPTION Waiver (If Applicable)
0.000% Grant's Indirect Cost Rate WAIVED with EXEMPTION Waiver
41.500% Grant's UNALLOWABLE Indirect Cost Rate
41.500% Department's Combined Indirect County-Wide Rate
0.000% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
0.000% Department's Combined Indirect County-Wide Rate
695,449.00 Total Grant Award ( 695,449.00 Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
0.00 Estimated Subrecipient Expenses
0.00 Indirect Costs
695,449.00 Indirect Cost Base
41.50% Indirect Cost Rate
288,611.34 Total Indirect Costs
0.00 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
0.00 Estimated ALLOWABLE Indirect Costs
0.00 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
0.00 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
0.00 Estimated ALLOWABLE Indirect Costs to be CHARGED
288,611.34 Estimated UNALLOWABLE Indirect Costs

Grant Agenda Indirect Cost Calculation
Allowable/Unallowable
Grant: GJPAR4
10.800% Departmental Indirect Cost Rate (FY 2015)
30.700% Department's County Wide Indirect Cost Rate (FY 2015)
41.500% Department's Combined Indirect County-Wide Rate (FY 2015)
N Indirect Cost Exemption Granted (Y/N)
0.000% Indirect Cost Exemption Rate
0.000% Grant's ALLOWABLE Indirect Cost Rate
0.000% Grant's Indirect Cost Rate CHARGED with EXEMPTION Waiver (If Applicable)
0.000% Grant's Indirect Cost Rate WAIVED with EXEMPTION Waiver
41.500% Grant's UNALLOWABLE Indirect Cost Rate
41.500% Department's Combined Indirect County-Wide Rate
0.000% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
0.000% Department's Combined Indirect County-Wide Rate
1,498,884.00 Total Grant Award ( 1,498,884.00 Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
0.00 Estimated Subrecipient Expenses
0.00 Indirect Costs
1,498,884.00 Indirect Cost Base
41.50% Indirect Cost Rate
622,036.86 Total Indirect Costs
0.00 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
0.00 Estimated ALLOWABLE Indirect Costs
0.00 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
0.00 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
0.00 Estimated ALLOWABLE Indirect Costs to be CHARGED
622,036.86 Estimated UNALLOWABLE Indirect Costs

Grant Agenda Indirect Cost Calculation
Allowable/Unallowable
Grant: GJVRR5
10.800% Departmental Indirect Cost Rate (FY 2015)
30.700% Department's County Wide Indirect Cost Rate (FY 2015)
41.500% Department's Combined Indirect County-Wide Rate (FY 2015)
N Indirect Cost Exemption Granted (Y/N)
0.000% Indirect Cost Exemption Rate
0.000% Grant's ALLOWABLE Indirect Cost Rate
0.000% Grant's Indirect Cost Rate CHARGED with EXEMPTION Waiver (If Applicable)
0.000% Grant's Indirect Cost Rate WAIVED with EXEMPTION Waiver
41.500% Grant's UNALLOWABLE Indirect Cost Rate
41.500% Department's Combined Indirect County-Wide Rate
0.000% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
0.000% Department's Combined Indirect County-Wide Rate
141,900.00 Total Grant Award ( 141,900.00 Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
0.00 Estimated Subrecipient Expenses
0.00 Indirect Costs
141,900.00 Indirect Cost Base
41.50% Indirect Cost Rate
58,888.50 Total Indirect Costs
0.00 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
0.00 Estimated ALLOWABLE Indirect Costs
0.00 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
0.00 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
0.00 Estimated ALLOWABLE Indirect Costs to be CHARGED
58,888.50 Estimated UNALLOWABLE Indirect Costs

Grant Agenda Indirect Cost Calculation
Allowable/Unallowable
Grant: GJJAG4
10.800% Departmental Indirect Cost Rate (FY 2015)
30.700% Department's County Wide Indirect Cost Rate (FY 2015)
41.500% Department's Combined Indirect County-Wide Rate (FY 2015)
N Indirect Cost Exemption Granted (Y/N)
0.000% Indirect Cost Exemption Rate
0.000% Grant's ALLOWABLE Indirect Cost Rate
0.000% Grant's Indirect Cost Rate CHARGED with EXEMPTION Waiver (If Applicable)
0.000% Grant's Indirect Cost Rate WAIVED with EXEMPTION Waiver
41.500% Grant's UNALLOWABLE Indirect Cost Rate
41.500% Department's Combined Indirect County-Wide Rate
0.000% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
0.000% Department's Combined Indirect County-Wide Rate
62,836.00 Total Grant Award ( 62,836.00 Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
0.00 Estimated Subrecipient Expenses
0.00 Indirect Costs
62,836.00 Indirect Cost Base
41.50% Indirect Cost Rate
26,076.94 Total Indirect Costs
0.00 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
0.00 Estimated ALLOWABLE Indirect Costs
0.00 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
0.00 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
0.00 Estimated ALLOWABLE Indirect Costs to be CHARGED
26,076.94 Estimated UNALLOWABLE Indirect Costs