INDIRECT COST CALCULATION FY 15 EMPG.XLS

Maricopa County — Formal (2015-04-08)

View PDF Item 39 Meeting page

Extracted text (via pymupdf_layout) 5451 characters
Grant Agenda Indirect Cost Calculation
Allowable/Unallowable
14.000% Departmental Indirect Cost Rate (FY 200_)
0.000% Department's County Wide Indirect Cost Rate (FY 200_)
14.000% Department's Combined Indirect County-Wide Rate (FY 200_)
n Indirect Cost Exemption Granted (Y/N)
0.000% Indirect Cost Exemption Rate
14.000% Grant's ALLOWABLE Indirect Cost Rate
14.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
14.000% Department's Combined Indirect County-Wide Rate
14.000% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
14.000% Department's Combined Indirect County-Wide Rate
657,866.00 Total Grant Award ( Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
Estimated Subreceiptient Expenses
80,790.56 Indirect Costs
577,075.44 Indirect Cost Base
14.00% Indirect Cost Rate
80,790.56 Total Indirect Costs
80,790.56 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
80,790.56 Estimated ALLOWABLE Indirect Costs
80,790.56 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
0.00 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
80,790.56 Estimated ALLOWABLE Indirect Costs to be CHARGED
0.00 Estimated UNALLOWABLE Indirect Costs

Grant Agenda Indirect Cost Calculation
Allowable
14.000% Departmental Indirect Cost Rate (FY 200_)
0.000% Department's County Wide Indirect Cost Rate (FY 200_)
14.000% Department's Combined Indirect County-Wide Rate (FY 200_)
N Indirect Cost Exemption Granted (Y/N)
0.000% Indirect Cost Exemption Rate
14.000% Grant's ALLOWABLE Indirect Cost Rate
14.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
14.000% Department's Combined Indirect County-Wide Rate
14.000% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
14.000% Department's Combined Indirect County-Wide Rate
657,866.00 Total Grant Award ( 577,075.44 Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
0.00 Estimated Subreceiptient Expenses
80,790.56 Indirect Costs
577,075.44 Indirect Cost Base
14.00% Indirect Cost Rate
80,790.56 Total Indirect Costs
80,790.56 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
80,790.56 Estimated ALLOWABLE Indirect Costs
80,790.56 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
0.00 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
80,790.56 Estimated ALLOWABLE Indirect Costs to be CHARGED
0.00 Estimated UNALLOWABLE Indirect Costs

Unallow
Grant Agenda Indirect Cost Calculation
Unallowable
13.500% Departmental Indirect Cost Rate (FY 200_)
0.000% Department's County Wide Indirect Cost Rate (FY 200_)
13.500% 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
13.500% Grant's UNALLOWABLE Indirect Cost Rate
13.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
73,300.00 Total Grant Award ( 73,300.00 Total Direct Costs )
Less:
Estimated Equipment Expenses (Only LGFS "900s" object codes)
Estimated Subreceiptient Expenses
0.00 Indirect Costs
73,300.00 Indirect Cost Base
13.50% Indirect Cost Rate
9,895.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
9,895.50 Estimated UNALLOWABLE Indirect Costs
Page 3

Waiver
Grant Agenda Indirect Cost Calculation
Prepared
13.500% Departmental Indirect Cost Rate (FY 200_)
0.000% Department's County Wide Indirect Cost Rate (FY 200_)
13.500% Department's Combined Indirect County-Wide Rate (FY 200_)
n Indirect Cost Exemption Granted (Y/N)
Indirect Cost Exemption Rate
13.800% Grant's ALLOWABLE Indirect Cost Rate
13.800% Grant's Indirect Cost Rate CHARGED with EXEMPTION Waiver (If Applicable)
0.000% Grant's Indirect Cost Rate WAIVED with EXEMPTION Waiver
-0.300% Grant's UNALLOWABLE Indirect Cost Rate
13.500% Department's Combined Indirect County-Wide Rate
13.500% Departmental Indirect Cost Rate
0.300% Department's County Wide Indirect Cost Rate
13.800% Department's Combined Indirect County-Wide Rate
Total Grant Award ( 0.00 Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
0.00 Estimated Subreceiptient Expenses
0.00 Indirect Costs
0.00 Indirect Cost Base
13.50% 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
Page 4