EQMSOPSZB2QR_2024-12-04 - PC 1134 -INDIRECT-COST-CALCULATOR (2).XLSX

Maricopa County — Formal (2025-01-29)

View PDF Item 134 Meeting page

Extracted text (via pymupdf) 5892 characters
Allowable/Unallowable
Grant Agenda Indirect Cost Calculation
Allowable/Unallowable
Departmental Indirect Cost Rate (FY 200_)
Department's County Wide Indirect Cost Rate (FY 200_)
0.000% Department's Combined Indirect County-Wide Rate (FY 200_)
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 
0.000% Grant's UNALLOWABLE Indirect Cost Rate
0.000% 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
Total Grant Award
( 0.00
Total Direct Costs  )
Less:
0.00
Estimated Equipment Expenses (Only "900s" object codes)
0.00
Estimated Subrecipient Expenses
0.00
Indirect Costs
0.00 Indirect Cost Base
0.00% Indirect Cost Rate
0.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
0.00 Estimated UNALLOWABLE Indirect Costs
Cells allowed to modify
all other cells are locked

Allowable
Grant Agenda Indirect Co
Allowable
0.000%
0.000%
0.000%
N
0.000%
0.000%
0.000%
0.000%
0.000%
0.000%
0.000%
0.000%
0.000%
0.00
0.00
0.00
0.00
0.00
0.00%
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Or if you were going to include direct ma
0.00%

Allowable
0.00%

Allowable
Departmental Indirect Cost Rate (FY 200_)
Department's County Wide Indirect Cost Rate (FY 200_)
Department's Combined Indirect County-Wide Rate (FY 200_)
Indirect Cost Exemption Granted (Y/N)
Indirect Cost Exemption Rate
Grant's ALLOWABLE Indirect Cost Rate
Grant's Indirect Cost Rate CHARGED with EXEMPTION Waiver (If Applicable)
Grant's Indirect Cost Rate WAIVED with EXEMPTION Waiver 
Grant's UNALLOWABLE Indirect Cost Rate
Department's Combined Indirect County-Wide Rate
Departmental Indirect Cost Rate
Department's County Wide Indirect Cost Rate
Department's Combined Indirect County-Wide Rate
Total Grant Award
(
Less:
Estimated Equi
Estimated Subr
Indirect Costs
Indirect Cost Base
Indirect Cost Rate
Total Indirect Costs
Estimated Indirect Costs to be CHARGED
Estimated WAIVED Indirect Costs
Estimated ALLOWABLE Indirect Costs
Estimated DEPARTMENTAL Indirect Costs to be CHARGED
Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
Estimated ALLOWABLE Indirect Costs to be CHARGED
Estimated UNALLOWABLE Indirect Costs
all other cells ar
Departmental Indirect Cost Rate (FY 200_)
ost Calculation
Cells allowed to modify
materials to the equipment exclusion then the calculator is essentially taking indirect on travel
Allowable

Allowable
Department's County Wide Indirect Cost Rate (FY 200_)

Allowable
0.00
Total Direct Costs  )
ipment Expenses (Only "900s" object codes)
recipient Expenses
re locked

Allowable

Unallowable
Grant Agenda Indirect Cost Calculation
Unallowable
36.800% Departmental Indirect Cost Rate (FY 2025)
0.000% Department's County Wide Indirect Cost Rate (FY 200_)
36.800% Department's Combined Indirect County-Wide Rate (FY 200_)
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 
36.800% Grant's UNALLOWABLE Indirect Cost Rate
36.800% 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,687,795.00 Total Grant Award
(
1,687,795.00
Total Direct Costs  )
Less:
50,000.00
Estimated Equipment Expenses (Only "900s" object codes)
1,462,677.00
Estimated Subrecipient Expenses
0.00
Indirect Costs
175,118.00 Indirect Cost Base
36.80% Indirect Cost Rate
64,443.42 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
64,443.42 Estimated UNALLOWABLE Indirect Costs
Cells allowed to modify
all other cells are locked

Waiver
Grant Agenda Indirect Cost Calculation
Prepared 
0.000% Departmental Indirect Cost Rate (FY 200_)
0.000% Department's County Wide Indirect Cost Rate (FY 200_)
0.000% Department's Combined Indirect County-Wide Rate (FY 200_)
n Indirect Cost Exemption Granted (Y/N)
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 
0.000% Grant's UNALLOWABLE Indirect Cost Rate
0.000% 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
0.00 Total Grant Award
(
0.00
Total Direct Costs  )
Less:
0.00
Estimated Equipment Expenses (Only "900s" object codes)
0.00
Estimated Subrecipient Expenses
0.00
Indirect Costs
0.00 Indirect Cost Base
0.00% Indirect Cost Rate
0.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
0.00 Estimated UNALLOWABLE Indirect Costs
Cells allowed to modify
all other cells are locked