ATTACHMENT GY20 RWPA HRSA INDIRECT COST CALCULATION WORKSHEET.XLSX
Extracted text (via pymupdf_layout)
5612 characters
Allowable/Unallowable Grant Agenda Indirect Cost Calculation Allowable/Unallowable 8.800% Departmental Indirect Cost Rate (FY 200_) 10.400% Department's County Wide Indirect Cost Rate (FY 200_) 19.200% Department's Combined Indirect County-Wide Rate (FY 200_) N Indirect Cost Exemption Granted (Y/N) 0.000% Indirect Cost Exemption Rate 19.200% Grant's ALLOWABLE Indirect Cost Rate 19.200% 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 19.200% Department's Combined Indirect County-Wide Rate 8.800% Departmental Indirect Cost Rate 10.400% Department's County Wide Indirect Cost Rate 19.200% Department's Combined Indirect County-Wide Rate 10,566,291.00 Total Grant Award ( ########## Total Direct Costs ) Less: 0.00 Estimated Equipment Expenses (Only "900s" object codes) 8,896,522.00 Estimated Subrecipient Expenses 268,956.08 Indirect Costs 1,400,812.92 Indirect Cost Base 19.20% Indirect Cost Rate 268,956.08 Total Indirect Costs 268,956.08 Estimated Indirect Costs to be CHARGED 0.00 Estimated WAIVED Indirect Costs 268,956.08 Estimated ALLOWABLE Indirect Costs 123,271.54 Estimated DEPARTMENTAL Indirect Costs to be CHARGED 145,684.54 Estimated CENTRAL SERVICE Indirect Costs to be CHARGED 268,956.08 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