ATTACHMENT GY18 RWPA HRSA INDIRECT COST CALCULATION WORKSHEET.XLSX
Extracted text (via pymupdf_layout)
5611 characters
Allowable/Unallowable Grant Agenda Indirect Cost Calculation Allowable/Unallowable 6.300% Departmental Indirect Cost Rate (FY 200_) 11.600% Department's County Wide Indirect Cost Rate (FY 200_) 17.900% Department's Combined Indirect County-Wide Rate (FY 200_) N Indirect Cost Exemption Granted (Y/N) 0.000% Indirect Cost Exemption Rate 17.900% Grant's ALLOWABLE Indirect Cost Rate 17.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 17.900% Department's Combined Indirect County-Wide Rate 6.300% Departmental Indirect Cost Rate 11.600% Department's County Wide Indirect Cost Rate 17.900% Department's Combined Indirect County-Wide Rate 10,050,916.00 Total Grant Award ( ########## Total Direct Costs ) Less: 0.00 Estimated Equipment Expenses (Only "900s" object codes) 8,696,288.00 Estimated Subrecipient Expenses 205,664.47 Indirect Costs 1,148,963.53 Indirect Cost Base 17.90% Indirect Cost Rate 205,664.47 Total Indirect Costs 205,664.47 Estimated Indirect Costs to be CHARGED 0.00 Estimated WAIVED Indirect Costs 205,664.47 Estimated ALLOWABLE Indirect Costs 72,384.70 Estimated DEPARTMENTAL Indirect Costs to be CHARGED 133,279.77 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED 205,664.47 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 Cost Calculation Allowable 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) 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 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 Unallowable Grant Agenda Indirect Cost Calculation Unallowable 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) 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 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 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