INDIRECT COST CALCULATION WORKSHEET EMPG 2018.XLS

Grant Agenda Indirect Cost Calculation
Allowable/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
13.500% Grant's ALLOWABLE Indirect Cost Rate
13.500% 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
13.500% Department's Combined Indirect County-Wide Rate
13.500% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
13.500% Department's Combined Indirect County-Wide Rate
838,976.00 Total Grant Award ( Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
Estimated Subreceiptient Expenses
99,790.10 Indirect Costs
739,185.90 Indirect Cost Base
13.50% Indirect Cost Rate
99,790.10 Total Indirect Costs
99,790.10 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
99,790.10 Estimated ALLOWABLE Indirect Costs
99,790.10 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
0.00 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
99,790.10 Estimated ALLOWABLE Indirect Costs to be CHARGED
0.00 Estimated UNALLOWABLE Indirect Costs

Grant Agenda Indirect Cost Calculation
Allowable
13.100% Departmental Indirect Cost Rate (FY 200_)
0.000% Department's County Wide Indirect Cost Rate (FY 200_)
13.100% Department's Combined Indirect County-Wide Rate (FY 200_)
N Indirect Cost Exemption Granted (Y/N)
0.000% Indirect Cost Exemption Rate
13.100% Grant's ALLOWABLE Indirect Cost Rate
13.100% 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
13.100% Department's Combined Indirect County-Wide Rate
13.100% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
13.100% Department's Combined Indirect County-Wide Rate
809,810.00 Total Grant Award ( 716,012.38 Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
0.00 Estimated Subreceiptient Expenses
93,797.62 Indirect Costs
716,012.38 Indirect Cost Base
13.10% Indirect Cost Rate
93,797.62 Total Indirect Costs
93,797.62 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
93,797.62 Estimated ALLOWABLE Indirect Costs
93,797.62 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
0.00 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
93,797.62 Estimated ALLOWABLE Indirect Costs to be CHARGED
0.00 Estimated UNALLOWABLE Indirect Costs

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

Waiver
Grant Agenda Indirect Cost Calculation
Prepared
16.400% Departmental Indirect Cost Rate (FY 200_)
0.000% Department's County Wide Indirect Cost Rate (FY 200_)
16.400% 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
2.600% Grant's UNALLOWABLE Indirect Cost Rate
16.400% Department's Combined Indirect County-Wide Rate
13.800% Departmental Indirect Cost Rate
0.000% Department's County Wide Indirect Cost Rate
13.800% Department's Combined Indirect County-Wide Rate
87,465.00 Total Grant Award ( 76,858.52 Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only LGFS "900s" object codes)
0.00 Estimated Subreceiptient Expenses
10,606.48 Indirect Costs
76,858.52 Indirect Cost Base
16.40% Indirect Cost Rate
12,604.80 Total Indirect Costs
10,606.48 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
10,606.48 Estimated ALLOWABLE Indirect Costs
10,606.48 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
0.00 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
10,606.48 Estimated ALLOWABLE Indirect Costs to be CHARGED
1,998.32 Estimated UNALLOWABLE Indirect Costs
Page 4