INDIRECT COST CALCULATION EMPG.XLS

Maricopa County — Formal (2015-10-07)

View PDF Item 35 Meeting page

Extracted text (via pymupdf_layout) 5446 characters
Grant Agenda Indirect Cost Calculation
Allowable/Unallowable
11.900% Departmental Indirect Cost Rate (FY 200_)
0.000% Department's County Wide Indirect Cost Rate (FY 200_)
11.900% Department's Combined Indirect County-Wide Rate (FY 200_)
n Indirect Cost Exemption Granted (Y/N)
0.000% Indirect Cost Exemption Rate
10.000% Grant's ALLOWABLE Indirect Cost Rate
10.000% Grant's Indirect Cost Rate CHARGED with EXEMPTION Waiver (If Applicable)
0.000% Grant's Indirect Cost Rate WAIVED with EXEMPTION Waiver
1.900% Grant's UNALLOWABLE Indirect Cost Rate
11.900% Department's Combined Indirect County-Wide Rate
10.000% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
10.000% Department's Combined Indirect County-Wide Rate
732,665.37 Total Grant Award ( Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
Estimated Subreceiptient Expenses
66,605.94 Indirect Costs
666,059.43 Indirect Cost Base
11.90% Indirect Cost Rate
79,261.07 Total Indirect Costs
66,605.94 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
66,605.94 Estimated ALLOWABLE Indirect Costs
66,605.94 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
0.00 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
66,605.94 Estimated ALLOWABLE Indirect Costs to be CHARGED
12,655.13 Estimated UNALLOWABLE Indirect Costs

Grant Agenda Indirect Cost Calculation
Allowable
11.900% Departmental Indirect Cost Rate (FY 200_)
0.000% Department's County Wide Indirect Cost Rate (FY 200_)
11.900% Department's Combined Indirect County-Wide Rate (FY 200_)
N Indirect Cost Exemption Granted (Y/N)
0.000% Indirect Cost Exemption Rate
11.900% Grant's ALLOWABLE Indirect Cost Rate
11.900% 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
11.900% Department's Combined Indirect County-Wide Rate
11.900% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
11.900% Department's Combined Indirect County-Wide Rate
30,000.00 Total Grant Award ( 26,809.65 Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
0.00 Estimated Subreceiptient Expenses
3,190.35 Indirect Costs
26,809.65 Indirect Cost Base
11.90% Indirect Cost Rate
3,190.35 Total Indirect Costs
3,190.35 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
3,190.35 Estimated ALLOWABLE Indirect Costs
3,190.35 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
0.00 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
3,190.35 Estimated ALLOWABLE Indirect Costs to be CHARGED
0.00 Estimated UNALLOWABLE Indirect Costs

Unallow
Grant Agenda Indirect Cost Calculation
Unallowable
11.900% Departmental Indirect Cost Rate (FY 200_)
0.000% Department's County Wide Indirect Cost Rate (FY 200_)
11.900% 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
11.900% Grant's UNALLOWABLE Indirect Cost Rate
11.900% 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
30,000.00 Total Grant Award ( 30,000.00 Total Direct Costs )
Less:
Estimated Equipment Expenses (Only LGFS "900s" object codes)
Estimated Subreceiptient Expenses
0.00 Indirect Costs
30,000.00 Indirect Cost Base
11.90% Indirect Cost Rate
3,570.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
3,570.00 Estimated UNALLOWABLE Indirect Costs
Page 3

Waiver
Grant Agenda Indirect Cost Calculation
Prepared
11.900% Departmental Indirect Cost Rate (FY 200_)
0.000% Department's County Wide Indirect Cost Rate (FY 200_)
11.900% Department's Combined Indirect County-Wide Rate (FY 200_)
n Indirect Cost Exemption Granted (Y/N)
Indirect Cost Exemption Rate
10.000% Grant's ALLOWABLE Indirect Cost Rate
10.000% Grant's Indirect Cost Rate CHARGED with EXEMPTION Waiver (If Applicable)
0.000% Grant's Indirect Cost Rate WAIVED with EXEMPTION Waiver
1.900% Grant's UNALLOWABLE Indirect Cost Rate
11.900% Department's Combined Indirect County-Wide Rate
10.000% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
10.000% 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
11.90% 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