INDIRECT COST CALCULATION WORKSHEET FOR 2016 GRANT PLUS CO.XLS

Allowable/Unallowable
Grant Agenda Indirect Cost Calculation
Allowable/Unallowable
9.700% Departmental Indirect Cost Rate (FY 200_)
12.100% Department's County Wide Indirect Cost Rate (FY 200_)
21.800% Department's Combined Indirect County-Wide Rate (FY 200_)
N Indirect Cost Exemption Granted (Y/N)
0.000% Indirect Cost Exemption Rate
21.800% Grant's ALLOWABLE Indirect Cost Rate
21.800% 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
21.800% Department's Combined Indirect County-Wide Rate
9.700% Departmental Indirect Cost Rate
12.100% Department's County Wide Indirect Cost Rate
21.800% Department's Combined Indirect County-Wide Rate
9,941,343.00 Total Grant Award ( ########## Total Direct Costs )
Less:
0.00 Estimated Equipment Expenses (Only "900s" object codes)
8,507,653.95 Estimated Subrecipient Expenses
256,604.44 Indirect Costs
1,177,084.61 Indirect Cost Base
21.80% Indirect Cost Rate
256,604.44 Total Indirect Costs
256,604.44 Estimated Indirect Costs to be CHARGED
0.00 Estimated WAIVED Indirect Costs
256,604.44 Estimated ALLOWABLE Indirect Costs
114,177.21 Estimated DEPARTMENTAL Indirect Costs to be CHARGED
142,427.24 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED
256,604.44 Estimated ALLOWABLE Indirect Costs to be CHARGED
0.00 Estimated UNALLOWABLE Indirect Costs
Cells allowed to modify all other cells are locked

Indirect Costs Calculation for 2015 Agenda Item ( See Attached Indirect Cost Calculation Worksheet)
Per Robert Harwood, the County approved indirect rate for our Program in 2014 is 16.7%
Total Request $ 9,081,224.00
Direct Expenses ( less In $ 9,684,738.56
Less Contracted Svcs $ (8,507,653.95)
Less Equipment $ -
Direct Base $ 1,177,084.61
Indirect @ 16.1% $ 196,573.13
Indirect@ 10.0% $ 117,708.46
Waived Amount $ 78,864.67 Note: Indirect is calculated by the county at 10 % of Direct ( Non Contracted and Non equip
Summary
Contracted Services $ 8,507,653.95
Admin, QM Direct Costs $ 1,177,084.61 $ 9,081,224.00 Agenda Amount
Indirect Costs $ 117,708.46 $ 7,719,040.40 Direct Services
Total Grant Amount $ - $ 908,122.40 Admin
$ 454,061.20 QM
$ 9,081,224.00 Total