ESBD_401736_1742825724803_Attachment H - Copy of USDE Indirect Cost Rate Template.xlsx

XLSX spreadsheet 297 KB Posted

Attached to
Indirect Cost Rate
Solicitation number
701-25-007-R
Issued by
Texas

About this file

Written by GovTribe AI ·

This document is an Excel-based United States Department of Education Indirect Cost Rate Template for a State Education Agency, designed to calculate and propose indirect cost rates for a fiscal year. The template provides a comprehensive framework for calculating both unrestricted and restricted indirect cost rates, with detailed schedules for tracking total costs, salaries, fringe benefits, unused leave, federal grants, subcontracts, and various administrative expenses. The document includes multiple worksheets for trend analysis, cost allocation, and carry-forward computations, with placeholders for input of specific financial data across different cost centers and departmental divisions.

The template is structured to help the state education agency compute indirect cost rates by meticulously breaking down direct and indirect costs, administrative charges, and various financial adjustments. Key components include schedules for federal grants and contracts, exclusions, and carry-forward calculations for both unrestricted and restricted rates. The document provides guidance through comments and instructions, with specific contact information for Andre Hylton from the U.S. Department of Education Indirect Cost Group, who can be reached at 202-245-7568 or andre.hylton@ed.gov for change requests or additional clarification on completing the indirect cost rate proposal.

View the file

Other files

File Type Posted
ESBD_401736_1742825941308_Cost Allocation Guide_September 2019.pdf PDF
ESBD_401736_1742825663121_701-25-007-R FINAL for ESBD.pdf PDF
ESBD_401736_1742825843309_How to Complete HSP.pdf PDF
ESBD_401736_1742825843863_FORM--HUB Subcontracting Plan (HSP).pdf PDF
ESBD_401736_1742831517156_Addendum 1.pdf PDF
ESBD_401736_1742831478575_701-25-007 TEA Bonfire ESBD Notification.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Cover Page

State Education Agency Name
Indirect Cost Proposal
Fiscal Year: XX/XX/XXXX
Instructions:
Please use the templates provided by the United States Department of Education Indirect Cost Group to complete
the indirect cost rate proposal. There are comments (red triangles) within the cells that will guide your agency
on how to complete the required schedules. The blue cells require input . Protected cells require pre-approval from the United States
Department of Education Indirect Cost Group. Please contact Andre Hylton via phone 202-245-7568, email andre.hytlon@ed.gov. or click change request.
Change Request
State Education Agency NameFiscal Year: XX/XX/XXXX
Contact Person:Telephone Number: XXX-XXX-XXXX
ContentsSubmitted
X or N/A
Statement of Total Costs - UnrestrictedX
Statement of Total Costs - RestrictedN/A
Occupancy Treatment Certification
Statewide Cost Allocation Plan (SWCAP) Schedule
Trend Analysis - Indirect
Trend Analysis - Direct
Schedule of Salaries and Fringe Benefits (Option 1 or 2)
Schedule of Fringe Benefits
Schedule of Unused Leave
Restricted Rate Calculation ( Option 1 or 2)
Schedule of Federal Grants and Contracts
Schedule of Subcontracts
Schedule of Exclusions
Carry Forward Schedule Unrestricted
Carry Forward Schedule Restricted
Statement of Indirect Costs
Email AttachmentsSubmittedX
X or N/A
State Wide Cost Allocation Plan (SWCAP)XN/A
Cost Policy Statement
Certificate of Indirect Costs
Depreciation Schedule
Expenditure Reports / Reconcilation
Organization Chart
Indirect Cost Pool General Ledger Detail (excel)
Occupancy (Space Related Costs Study)

Proposal Summary Summary

UnrestrictedCurrent YearPrior Year 1Prior Year 2
$ - 0=ERROR:#DIV/0!$ - 0=ERROR:#DIV/0!$ - 0=ERROR:#DIV/0!
$ - 0$ - 0$ - 0
RestrictedCurrent YearPrior Year 1Prior Year 2
$ - 0=ERROR:#DIV/0!$ - 0=ERROR:#DIV/0!$ - 0=ERROR:#DIV/0!
$ - 0$ - 0$ - 0
OtherCurrent YearPrior Year 1Prior Year 2
$ - 0=ERROR:#DIV/0!$ - 0=ERROR:#DIV/0!$ - 0=ERROR:#DIV/0!
$ - 0$ - 0$ - 0

Summary Please provide a summary of any organization changes or major expenditures that affect the current or future indirect cost rates.

mailto:andre.hylton@ed.gov Stmt. of Total Costs-Unrest

HomeState Education Agency Name
Statement of Total Costs
Fiscal Year: XX/XX/XXXX
( a )( b )Direct Costs ( c )Indirect Costs ( d )
(a) = (b)+(c)+(d)
Cost Centers #Cost CentersTotal CostsExcluded/

Unallowed

CostsSalaries
& Fringe BenefitsOtherTotalSalaries
& Fringe BenefitsOtherTotal
$ -$ -$ -$ -$ -$ -$ -$ -
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-

Sub-Total Unrestricted Costs - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0

Unrestricted Rate Adjustment(s):Total Costs Adjustment(s)Excluded/Unallowed Costs Adjustment(s)Salaries
& Fringe BenefitsOtherDirect Cost Adjustment(s)Salaries
& Fringe BenefitsOtherIndirect Cost Adjustment(s)
1) SWCAP$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0
2) Depreciation- 0- 0- 0- 0- 0- 0- 0- 0
3) Unused Leave- 0- 0- 0- 0- 0- 0- 0- 0
4) Other- 0- 0- 0- 0- 0- 0- 0- 0
5) Unrestricted Carryforward Adjustment- 0- 0- 0- 0- 0- 0- 0- 0

Total Unrestricted Expenditures Proposed $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Negotiators' Adjustment(s):Total Costs Adjustment(s)Excluded/Unallowed Costs Adjustment(s)Salaries
& Fringe BenefitsOtherDirect Cost Adjustment(s)Salaries
& Fringe BenefitsOtherIndirect Cost Adjustment(s)
1)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
2)- 0- 0- 0- 0- 0- 0- 0- 0
Total Unrestricted Costs Negotiated$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

PROPOSED UNRESTRICTED RATE CALCULATION :

PROPOSED TOTAL UNRESTRICTED INDIRECT COST$ -=ERROR:#DIV/0!
PROPOSED UNRESTRICTED MTDC BASE$ -

NEGOTIATED UNRESTRICTED RATE CALCULATION :

NEGOTIATED TOTAL UNRESTRICTED INDIRECT COST$ -=ERROR:#DIV/0!
NEGOTIATED UNRESTRICTED MTDC BASE$ -

Stmt. of Total Costs-Rest

HomeState Education Agency Name
Statement of Total Costs
Fiscal Year: XX/XX/XXXX
( a )( b )Direct Costs ( c )Indirect Costs ( d )
(a) = (b)+(c)+(d)
Cost Centers #Cost CentersTotal CostsExcluded/

Unallowed

CostsSalaries
& Fringe BenefitsOtherTotalSalaries
& Fringe BenefitsOtherTotal
$ -$ -$ -$ -$ -$ -$ -$ -
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-
- 0-- 0- 0-- 0- 0-

Sub-Total Unrestricted Costs - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0

Restricted Rate Adjustment(s):Total Costs Adjustment(s)Excluded/Unallowed Costs Adjustment(s)Salaries
& Fringe BenefitsOtherDirect Cost Adjustment(s)Salaries
& Fringe BenefitsOtherIndirect Cost Adjustment(s)
1) SWCAP ( Unrestricted )$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
2) SWCAP Occupancy and Space Related Costs (Restricted)- 0- 0- 0- 0- 0- 0- 0- 0
3) Depreciation- 0- 0- 0- 0- 0- 0- 0- 0
4) Other- 0- 0- 0- 0- 0- 0- 0- 0
5) Restricted Rate Adjustment 34 CFR 76.564 - 76.568- 0- 0- 0- 0- 0- 0- 0- 0
7) Restricted Unused Leave Adjustment- 0- 0- 0- 0- 0- 0- 0- 0
8) Restricted Carryforward Adjustment- 0- 0- 0- 0- 0- 0- 0- 0

Total Restricted Expenditures Proposed $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Negotiators' Adjustment(s):Total Costs Adjustment(s)Excluded/Unallowed Costs Adjustment(s)Salaries
& Fringe BenefitsOtherDirect Cost Adjustment(s)Salaries
& Fringe BenefitsOtherIndirect Cost Adjustment(s)
1)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
2)- 0- 0- 0- 0- 0- 0- 0- 0

Total Restricted Costs Negotiated $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

PROPOSED RESTRICTED RATE CALCULATION :

PROPOSED TOTAL RESTRICTED INDIRECT COST$ -=ERROR:#DIV/0!
PROPOSED RESTRICTED MTDC BASE$ -

NEGOTIATED RESTRICTED RATE CALCULATION :

NEGOTIATED TOTAL RESTRICTED INDIRECT COST$ -=ERROR:#DIV/0!
NEGOTIATED RESTRICTED MTDC BASE$ -

Occupancy Treatment Cert

HomeState Education Agency Name
Occupancy Classification Certification

Hylton, Andre: Please input the fiscal year of the Statement of Total Costs Unrestricted/Restricted.

Fiscal Year: XX/XX/XXXX Fiscal Year: XX/XX/XXXX Hylton, Andre: Please input the fiscal year ending of the actual data provided.

Occupancy Costs

Occupancy Costs include office and/or facility space rental, depreciation or building use allowance, utilties, custodial services, buildings and
ground services, security services, and other costs related to occupancy of the space used by the recipient. There are several methodologies
for charging occupancy costs.Recipient needs to specifically establish and identify the one used. Any methodology used should provide an
equitable distribution.

Methodology A

All occupancy costs in the "Unrestricted" indirect cost pool. If so, no occupancy costs are charged as direct on any federal awards. When
converting from an unrestricted indirect cost rate to a resticted indirect cost rate, the only allowable indirect occupancy costs for the
Restricted Rate are those applicable to employees treated as indirect when computing the Restricted Rate. These costs must be supported
by a space usage study or equivalent documentation per EDGAR 76.568 (b). The remaining occupancy costs are treated as Direct for
Restricted Rate computation purposes. In a Restricted Rate setting, none of the disallowed occupancy costs are charged as direct federal
awards.

Methodology B

Occupancy costs charged to direct and indirect activities based on a distribution such as square footage occupied by the employees. The areas
, and are treated occupied by the direct employees are charged as direct costs to the employees are charged as direct costs to the employees'
respective activities as base costs when computing the indirect cost rate. The areas occupied by allowable indirect employees are part of the
indirect cost pool. The exception would be "Restricted Rate" awards in which direct occupancy costs are not allowed as direct charges to
Federal programs unless the recipient needs the additional space to conduct the project.

Alternative Methodology

SWCAP

State Education Agency
Statewide Cost Allocation Plan (SWCAP) Schedule
Fiscal Year 20XX

State Wide Cost Allocation Plan (SWCAP)

SWCAP costs that are approved by the Department of Health and Human
Services and arereasonable, allowable, and allocable are allowable in the
indirect cost pool when calculating the Unrestricted Indirect Cost rate.
For the purpose of calculating the Restricted Indirect Cost rate, occupancy
and space related costs * are taken out of the pool but not added to the base.
Cost (Inputs from approved agreement)
Building Rental$ - 0*
Building Depreciation- 0*
Fiscal and ITD- 0
Purchasing and Support- 0
Capitol Security- 0*
Administration- 0
Financial Accountability- 0

Unrestricted Indirect Cost Rate SWCAP $ - 0

Occupancy and space related costs *

Restricted Indirect Cost Rate SWCAP $ - 0

* Office and/or facility space rental, depreciation, amortization, utilties,
custodial services, buildings and ground services, security services,
and other costs related to occupancy of the space used by the recipient.
EDGAR 34 CFR 76.568
Examples of space and occupancy related amortization are lease payments, lease hold improvements,
and other occupancy and space related costs that require regular installment payments.

Trend Analysis - Indirect Home

State Education Agency Name
Trend Analysis - Indirect
(based on actual data for fiscal year ended XX/XX/XXXX)

(1) (2) (3) (4) (5) (6)

201X201X201X201X to 201XFY 201X % TO BASE
INDIRECTINDIRECTINDIRECT$ VARIANCE% VARIANCE
Cost Centers #Cost CentersCOSTSCOSTSCOSTS( 3-2 )( 4 / 2 )
$ -$ -$ -$ -ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0-ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0-ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0-ERROR:#DIV/0!ERROR:#DIV/0!
ERROR:#DIV/0!
TOTAL INDIRECT COSTS$ -$ -$ -$ -ERROR:#DIV/0!

TOTAL DIRECT COSTS $ - $ - $ - $ - ERROR:#DIV/0!

INDIRECT COST RATE ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

TOTAL COSTS $ - $ - $ - $ - ERROR:#DIV/0!

&"Times New Roman,Bold"&24G

Trend Analysis - Direct Home

State Education Agency Name
Trend Analysis - Direct
(based on actual data for fiscal year ended XX/XX/XXXX)

(1) (2) (3) (4) (5) (6)

201X201X201X201X to 201XFY 201X % TO BASE
DIRECTDIRECTDIRECT$ VARIANCE% VARIANCE
Cost Centers #Cost CentersCOSTSCOSTSCOSTS( 3-2 )( 4 / 2 )
$ -$ -$ -$ -ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
- 0- 0- 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
-ERROR:#DIV/0!ERROR:#DIV/0!
-ERROR:#DIV/0!ERROR:#DIV/0!
-ERROR:#DIV/0!ERROR:#DIV/0!
-ERROR:#DIV/0!ERROR:#DIV/0!
-ERROR:#DIV/0!ERROR:#DIV/0!
-ERROR:#DIV/0!ERROR:#DIV/0!
-ERROR:#DIV/0!ERROR:#DIV/0!
-ERROR:#DIV/0!ERROR:#DIV/0!
-ERROR:#DIV/0!ERROR:#DIV/0!
ERROR:#DIV/0!
TOTAL INDIRECT COSTS$ -$ -$ -$ -ERROR:#DIV/0!

TOTAL DIRECT COSTS $ - $ - $ - $ - ERROR:#DIV/0!

INDIRECT COST RATE ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

TOTAL COSTS $ - $ - $ - $ - ERROR:#DIV/0!

&"Times New Roman,Bold"&24G

Sch of Sal & Fring Opt 1

HomeState Education Agency NameIndirect
Schedule of Salaries and Fringe BenefitsSplit
Option 1Split/Direct
Fiscal Year: XX/XX/XXXXDirect
Position ClassificationDepartment/Division #Department/Division
Hylton, Andre: Please indicate the Department the employee is assigned.Department/Division FunctionEmployee NameNumber of EmployeesPosition TitleTotal Salaries & Fringe BenefitsIndirect SalariesIndirect Fringe BenefitsDirect SalariesDirect Fringe Benefits
IndirectA1.AA$ - 0$ - 0$ - 0$ - 0$ - 0
IndirectA1.AA-- 0-- 0-
IndirectA1.AA-- 0-- 0-
IndirectA1.AA-- 0-- 0-
IndirectA2.AA-- 0-- 0-
IndirectA2.BB-- 0-- 0-
IndirectA2.BB-- 0-- 0-
IndirectA2.BB-- 0-- 0-
IndirectA2.BB-- 0-- 0-
IndirectA2.BB-- 0-- 0-
IndirectA2.C1-- 0-- 0-
IndirectA2.C1-- 0-- 0-
IndirectA2.C1-- 0-- 0-
IndirectA2.C1-- 0-- 0-
IndirectA2.C1-- 0-- 0-
IndirectA2.C3-- 0-- 0-
IndirectA2.C3-- 0-- 0-
SplitA2.C4-- 0-- 0-
SplitA2.C5-- 0-- 0-
IndirectA2.C6-- 0-- 0-
SplitA2.C6-- 0-- 0-
IndirectA7.BB-- 0-- 0-
IndirectA7.BB-- 0-- 0-
IndirectA7.BB-- 0-- 0-
IndirectA7.BB-- 0-- 0-
IndirectA7.BB-- 0-- 0-
IndirectA7.BB-- 0-- 0-
IndirectA7.BB-- 0-- 0-
DirectA2.AA---- 0-
Split/DirectA2.C3---- 0-
DirectA2.C4---- 0-
DirectA2.C5---- 0-
Split/DirectA2.C6---- 0-
DirectA2.C7---- 0-
DirectA2.C8---- 0-
DirectA2.EE---- 0-
DirectA6.AA---- 0-
DirectA6.BB---- 0-
DirectA6.CC---- 0-
DirectA6.DD---- 0-
DirectA6.EE---- 0-
DirectA6.FF---- 0-
DirectA7.AB---- 0-
DirectA7.AC---- 0-
DirectA7.BC---- 0-
$ - 0$ - 0$ - 0$ - 0$ - 0
Summary of Salaries and Fringe Benefits
Total Indirect Salaries and Fringe Benefits$ - 0(Column K + L)
Total Direct Salaries and Fringe Benefits$ - 0(Column M + N)
$ - 0

Sch of Sal & Fring Opt 2

HomeState Education Agency NameIndirect
Schedule of Salaries and Fringe BenefitsMixed
Option 2
Fiscal Year: XX/XX/XXXXDirect
Position ClassificationDepartment/Division #Department/DivisionDepartment/Division FunctionEmployee NameNumber of EmployeesPosition TitleTotal Salaries & Fringe BenefitsIndirect Salaries and Fringe BenefitsDirect Salaries and Fringe Benefits
Indirect$ - 0$ - 0$ - 0
Indirect---
Indirect---
Indirect---
Indirect---
Indirect---
Indirect---
Indirect---
Indirect---
Indirect---
Indirect---
Indirect---
Indirect---
Indirect---
Indirect---
Indirect---
Indirect---
Mixed---
Mixed---
Indirect---
Mixed---
Indirect---
Indirect---
Indirect---
Indirect---
Indirect---
Indirect---
Indirect---
Direct---
Mixed/Direct---
Direct---
Direct---
Mixed/Direct---
Direct---
Direct---
Direct---
Direct---
Direct---
Direct---
Direct---
Direct---
Direct---
Direct---
Direct---
Direct---
$ - 0$ - 0$ - 0

Schedule of Fringe Benefits

State Education Agency NameIndirect
Schedule of Fringe BenefitsMixed
Fiscal Year: XX/XX/XXXXDirect
Fringe Benefit
Hylton, Andre: Please use this schedule to report fringe benefit costs.Total Fringe BenefitsIndirect Fringe BenefitsDirect Fringe Benefits
Payroll Taxes- 0- 0- 0
Health Insurance- 0- 0- 0
Dental Insurance- 0- 0- 0
Retirement Plan- 0- 0- 0
Social Security- 0- 0- 0
Unemployment- 0- 0- 0
Other- 0- 0- 0
Other- 0- 0- 0
Other- 0- 0- 0
- 0- 0- 0
Total SalariesIndirect SalariesDirect Salaries
- 0- 0- 0
Total Salaries & Fringe BenefitsIndirect Salaries & Fringe BenefitsDirect Salaries & Fringe Benefits
$ - 0$ - 0$ - 0
Fringe Benefit Rate
Fringe Benefits ( Indirect + Direct)$ - 0=ERROR:#DIV/0!
Total Salaries ( Indirect + Direct)$ - 0

Schedule of Unused Leave

HomeState Education Agency Name
Schedule of Unused Leave
Fiscal Year: XX/XX/XXXX
UnrestrictedRestricted
Department/DivisionEmployee NameEmployee PositionIndirect Charged Employee(s)Direct Charged Employee(s)Indirect Employees' Unused Leave PaymentsDirect Employees' Unused Leave PaymentsTotal UnrestictedUnused Leave PaymentsIndirect Restricted Employee Unused Leave PaymentsDirect Restricted Employee Unused Leave PaymentsTotal Resticted Unused Leave PaymentsTotal Unused Leave Payments
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 03
- 0- 0- 0- 0- 0- 004
- 0- 0- 0- 0- 0- 003
- 0- 0- 0- 0- 0- 001
- 0- 0- 0- 0- 0- 002
- 0- 0- 0- 0- 0- 002
- 0- 0- 0- 0- 0- 003
- 0- 0- 0- 0- 0- 002
- 0- 0- 0- 0- 0- 001
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
- 0- 0- 0- 0- 0- 00
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Seperating employees' unused leave (termination benefits) are treated as indirect costs when computing Restricted and Unrestricted indirect cost rates with one exception.
When computing the Restricted indirect cost rate, unused leave (termination benefits) payments to employees who are indirect for the Unrestricted Rate, but are
indirect for the Unrestricted Rate, but direct for the Restricted Rate (i.e. superintendent and their office), are considered direct cost payments for rate calculation
purposes only.

Uniform Guidance FAQ Exerpt

.431-2 Charging Payments of Unused Leave to Employees Terminating or Retiring *

In accordance with section 200.431(b)(3)(i), can the state, local and Indian Tribal governments
using the cash basis of accounting with unfunded/unrecorded leave liabilities charge unused leave
(payments to employees that retire or are terminated) directly to Federal programs?
No. Charging all unused leave costs for separating employees in the same manner as it had charged
the employees’ salary costs (i.e., directly to the activities on which the employees were working
at the time of their separation) would result in inequitable distribution of the unused leave
costs, because the leave costs were accumulated over the entire period of employment while working
on various programs. In addition, having the last program bear the burden of these unbudgeted costs
creates an unfair distribution of costs to this program. Therefore, any state, Local or Tribal government
using the cash basis of accounting should allocate payments for unused leave, when an employee retires or
terminates employment, in the year of payment as a general administrative expense to all activities of
the governmental unit or component or, with the approval of the cognizant agency for indirect costs,
the costs can be included in fringe benefit rates.

Adjustment Scenarios

Unrestricted
Unrestricted employee's unused leave payments are to be classified in the indirect cost pool for both the unrestricted and restricted indirect cost rate calculations .
1 - The employee's unused leave payment was paid from the direct cost base there is an adjustment from the direct cost base to the indirect cost pool .
2 - The employee's' unused leave payment was paid from the indirect cost pool there is no adjustment required.
Restricted
Restricted employee's unused leave payments are to be classified in the direct cost base for the calculation of the restricted indirect cost rate .
3 - The employee's unused leave payment was paid from the indirect cost pool there is an adjustment from the indirect cost pool to the direct cost base.
4 - The employee's unused leave payment was paid from the direct cost base, but for the unrestricted indirect cost rate this payment is adjusted to the indirect cost pool.

* Split Charge Employees indicate which fund the unsed leave payments were made from.

The Unused Leave Adjustment(s) Summary below reports the adjustments from scenarios 1 and 3 above. Scenarios 2 and 4
do not require adjustments.
Unused Leave Adjustment(s) Summary
IndirectDirect
Unresitrcted Indirect Cost Rate$0$0
Restricted Indirect Cost Rate$0$0

Restricted Rate Actual

HomeState Education Agency
RESTRICTED RATE CALCULATION
Option 1 (Actual Associated Costs Heads of Components)
FISCAL YEAR ENDING: XX/XX/XXXX
DivisionDivision NameExecutive Personnel Names
Hylton, Andre: Please Input the Executive Staff's Name.Position
Hylton, Andre: Please input the staff position.Indirect Salaries & Fringes
Hylton, Andre: Please input the staff's indirect salary.Direct Salaries & Fringes
Hylton, Andre: Please input the staff's indirect salary.Total Indirect Adjusted Amounts

Hylton, Andre: This is a formula column.

It calculates the adjustment amounts for Executive Staff, Head of Components, and Associated Costs.

$ - 0$ - 0
- 0- 0
- 0- 0
- 0- 0
- 0- 0
- 0- 0
Executives' Personnel Total Indirect Salaries & Fringe Benefits$ - 0$ - 0$ - 0A
DivisionDivision NameHeads of Components Names:
Hylton, Andre: Please input the Head of Component Name.Position
Hylton, Andre: Please input the staff position.Indirect Salaries & Fringes
Hylton, Andre: Please input the staff's indirect salary.Direct Salaries & Fringes

Hylton, Andre: Please input the staff's indirect salary.

Hylton, Andre: Please Input the Executive Staff's Name.

Hylton, Andre: Please input the staff position.

Hylton, Andre: Please input the staff's indirect salary.

Hylton, Andre: Please input the staff's indirect salary.

Hylton, Andre: This is a formula column.

It calculates the adjustment amounts for Executive Staff, Head of Components, and Associated Costs.

Hylton, Andre: Please input the Head of Component Name.$ - 0$ - 0
- 0- 0
- 0- 0
- 0
- 0- 0
- 0- 0

Heads of Components Total Indirect Salaries & Fringe Benefits $ - 0 $ - 0 $ - 0 B

Total Indirect Salaries & Fringe Benefits Restricted Rate Adjustment A + B

DivisionDivision NameAssociate Cost CategoriesTotal Associated CostsIndirect Associated CostsDirect Associated Costs
$ - 0$ - 0$ - 0
- 0- 0-
- 0- 0-
- 0- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
Office of the Superintendent Total$ - 0$ - 0$ - 0$ - 0C
Supplies$ - 0$ - 0$ - 0
Utilities - Electric--
Utilities - Water--
Telephone Expense--
Membership Dues--
Professional Services--
Travel In-State--
Travel Out of State--
Private Auto Expense--
Postal Services--
Publications--
Printing Services--
Training Expenses--
Computer Software--
Computer Hardware--
Maintenance Repair--
Maintenance Repair - Hardware--
Maintenance Repair - Software--
Investigation Fees--
Rent Building--
Chief of Staff Total$ - 0$ - 0$ - 0$ - 0D
A2.BBAgency Personnel ServicesSupplies$ - 0$ - 0$ - 0
Utilities - Electric-- 0- 0
Utilities - Water-- 0- 0
Telephone Expense-- 0- 0
Membership Dues-- 0- 0
Professional Services-- 0- 0
Travel In-State-- 0- 0
Travel Out of State-- 0- 0
Private Auto Expense-- 0- 0
Postal Services-- 0- 0
Publications-- 0- 0
Printing Services-- 0- 0
Training Expenses-- 0- 0
Computer Software-- 0- 0
Computer Hardware-- 0- 0
Network Server-- 0- 0
Maintenance Repair-- 0- 0
Maintenance Repair - Hardware-- 0- 0
Maintenance Repair - Software-- 0- 0
Investigation Fees-- 0- 0
Rent Building-- 0- 0
Agency Personnel Services Total$ - 0$ - 0$ - 0$ - 0E
A2.C1Agency Financial ResourcesSupplies$ - 0$ - 0$ - 0
Utilities - Electric---
Utilities - Water---
Telephone Expense---
Membership Dues---
Professional Services---
Travel In-State---
Travel Out of State---
Private Auto Expense---
Postal Services---
Publications---
Printing Services---
Training Expenses---
Computer Software---
Computer Hardware---
Network Server---
Maintenance Repair---
Maintenance Repair - Hardware---
Maintenance Repair - Software---
Investigation Fees---
Rent Building--
Agency Financial Resources Total$ - 0$ - 0$ - 0$ - 0F
A7.BBInformation Tech ServicesSupplies$ - 0$ - 0$ - 0
Utilities - Electric---
Utilities - Water---
Telephone Expense---
Membership Dues---
Professional Services---
Travel In-State---
Travel Out of State---
Private Auto Expense---
Postal Services---
Publications---
Printing Services---
Training Expenses---
Computer Software---
Computer Hardware---
Network Server---
Maintenance Repair---
Maintenance Repair - Hardware---
Maintenance Repair - Software---
Investigation Fees---
Rent Building---
##Information Tech Services Total$ - 0$ - 0$ - 0$ - 0G
XXXSupplies$ - 0$ - 0$ - 0
Utilities - Electric---
Utilities - Water---
Telephone Expense---
Membership Dues---
Professional Services---
Travel In-State---
Travel Out of State---
Private Auto Expense---
Postal Services---
Publications---
Printing Services---
Training Expenses---
Computer Software---
Computer Hardware---
Maintenance Repair---
Maintenance Repair - Hardware---
Maintenance Repair - Software---
Investigation Fees---
Rent Building---
Total$ - 0$ - 0$ - 0$ - 0H
XXXSupplies$ - 0$ - 0$ - 0
Utilities - Electric---
Utilities - Water---
Telephone Expense---
Membership Dues---
Professional Services---
Travel In-State---
Travel Out of State---
Private Auto Expense---
Postal Services---
Publications---
Printing Services---
Training Expenses---
Computer Software---
Computer Hardware---
Maintenance Repair---
Maintenance Repair - Hardware---
Maintenance Repair - Software---
Investigation Fees---
Rent Building---
Total$ - 0$ - 0$ - 0$ - 0I
XXXSupplies$ - 0$ - 0$ - 0
Utilities - Electric---
Utilities - Water---
Telephone Expense---
Membership Dues---
Professional Services---
Travel In-State---
Travel Out of State---
Private Auto Expense---
Postal Services---
Publications---
Printing Services---
Training Expenses---
Computer Software---
Computer Hardware---
Maintenance Repair---
Maintenance Repair - Hardware---
Maintenance Repair - Software---
Investigation Fees---
Rent Building---
Total$ - 0$ - 0$ - 0$ - 0J
XXXSupplies$ - 0$ - 0$ - 0
Utilities - Electric---
Utilities - Water---
Telephone Expense---
Membership Dues---
Professional Services---
Travel In-State---
Travel Out of State---
Private Auto Expense---
Postal Services---
Publications---
Printing Services---
Training Expenses---
Computer Software---
Computer Hardware---
Maintenance Repair---
Maintenance Repair - Hardware---
Maintenance Repair - Software---
Investigation Fees---
Rent Building---
Total$ - 0$ - 0$ - 0$ - 0K
XXXSupplies$ - 0$ - 0$ - 0
Utilities - Electric-- 0-
Utilities - Water-- 0-
Telephone Expense-- 0-
Membership Dues-- 0-
Professional Services-- 0-
Travel In-State-- 0-
Travel Out of State-- 0-
Private Auto Expense-- 0-
Postal Services-- 0-
Publications-- 0-
Printing Services-- 0-
Training Expenses-- 0-
Computer Software-- 0-
Computer Hardware-- 0-
Maintenance Repair-- 0-
Maintenance Repair - Hardware-- 0-
Maintenance Repair - Software-- 0-
Investigation Fees-- 0-
Rent Building-- 0-
Total$ - 0$ - 0$ - 0$ - 0L
XXXSupplies$ - 0$ - 0$ - 0
Utilities - Electric-- 0-
Utilities - Water-- 0-
Telephone Expense-- 0-
Membership Dues-- 0-
Professional Services-- 0-
Travel In-State-- 0-
Travel Out of State-- 0-
Private Auto Expense-- 0-
Postal Services-- 0-
Publications-- 0-
Printing Services-- 0-
Training Expenses-- 0-
Computer Software-- 0-
Computer Hardware-- 0-
Maintenance Repair-- 0-
Maintenance Repair - Hardware-- 0-
Maintenance Repair - Software-- 0-
Investigation Fees-- 0-
Rent Building-- 0-
Total$ - 0$ - 0$ - 0$ - 0M
XXXSupplies$ - 0$ - 0$ - 0
Utilities - Electric---
Utilities - Water---
Telephone Expense---
Membership Dues---
Professional Services---
Travel In-State---
Travel Out of State---
Private Auto Expense---
Postal Services---
Publications---
Printing Services---
Training Expenses---
Computer Software---
Computer Hardware---
Maintenance Repair---
Maintenance Repair - Hardware---
Maintenance Repair - Software---
Investigation Fees---
Rent Building---

Total $ - 0 $ - 0 $ - 0 $ - 0 N

Total Associated Expenditures $ - 0 $ - 0 $ - 0 $ - 0 Sum of C - N

Total Restricted Rate AdjustmentERROR:#VALUE!Sum of A - N
##Unhide to expand Cost Centers H-N

Restricted Rate Percentage

HomeState Education Agency
RESTRICTED RATE CALCULATION
Option 2 (Percentage Associated Costs Heads of Components)
FISCAL YEAR ENDING: XX/XX/XXXX
DivisionDivision NameExecutive Personnel Names
Hylton, Andre: Please Input the Executive Staff's Name.Position
Hylton, Andre: Please input the staff position.Indirect Salaries & Fringes
Hylton, Andre: Please input the staff's indirect salary.Direct Salaries & Fringes
Hylton, Andre: Please input the staff's indirect salary.Total Adjusted Amounts

Hylton, Andre: This is a formula column.

It calculates the adjustment amounts for Executive Staff, Head of Components, and Associated Costs.

$ - 0$ - 0
- 0- 0
- 0- 0
- 0- 0
- 0- 0
- 0- 0
Executives' Personnel Total Indirect Salaries & Fringe Benefits$ - 0$ - 0$ - 0A
DivisionDivision NameHeads of Components Names:
Hylton, Andre: Please input the Head of Component Name.Position
Hylton, Andre: Please input the staff position.Indirect Salaries & Fringes
Hylton, Andre: Please input the staff's indirect salary.Direct Salaries & Fringes

Hylton, Andre: Please input the staff's indirect salary.

Hylton, Andre: Please Input the Executive Staff's Name.

Hylton, Andre: Please input the staff position.

Hylton, Andre: Please input the staff's indirect salary.

Hylton, Andre: Please input the staff's indirect salary.

Hylton, Andre: This is a formula column.

It calculates the adjustment amounts for Executive Staff, Head of Components, and Associated Costs.$ - 0$ - 0
- 0- 0
- 0- 0
- 0
- 0- 0
- 0- 0

Heads of Components Total Indirect Salaries & Fringe Benefits $ - 0 $ - 0 $ - 0 B

Total Indirect Salaries & Fringe Benefits Restricted Rate Adjustment $ - 0 A + B

DivisionDivision NameAssociate Cost CategoriesTotal Associated CostsIndirect Associated CostsDirect Associated Costs
$ - 0$ - 0$ - 0
- 0- 0-
- 0- 0-
- 0- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
-- 0-
Total$ - 0$ - 0$ - 0$ - 0C
$ - 0$ - 0$ - 0
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--
--

Total $ - 0 $ - 0 $ - 0 $ - 0 D

Associated Costs Allocation Head Of Components

Total Indirect Salaries & Fringe Benefits Restricted Rate Adjustment$ - 0
Total Indirect Salaries & Fringes

Hylton, Andre: Please input the total Indirect Salaries and Fringe to compute an associated costs ratio. If the exact costs associated with the Executive Office and Head of Components is available calculating the ratio is not necessary. The general ledgers are required to support the exact associated costs claimed by the restricted rate staff.

Hylton, Andre: Please input the Head of Component Name. $ - 0

Allocation % apply to Operational Expenses ERROR:#DIV/0!

DivisionDivision NameAssociate Cost CategoriesTotal Associated CostsAllocation %Indirect Costs
$ - 0
-
-
-
-
6,000
2,750
-
-
650
-
-
3,425
-
-
-
-
-
-
4,000
3,500
Total$ 20,325ERROR:#DIV/0!ERROR:#DIV/0!E
$ 2,500
1,450
1,250
4,500
3,000
64,500
5,000
1,500
500
2,000
1,500
5,500
6,500
-
8,300
15,000
5,000
15,000
13,500
-
8,500
Total$ 165,000ERROR:#DIV/0!ERROR:#DIV/0!F
$ 5,000
2,250
600
950
75
144,000
2,100
-
-
200
75
-
-
100,000
117,250
118,000
-
-
-
-
9,500
##Total$ 500,000ERROR:#DIV/0!ERROR:#DIV/0!G
XXXSupplies$ - 0
Utilities - Electric-
Utilities - Water-
Telephone Expense-
Membership Dues-
Professional Services-
Travel In-State-
Travel Out of State-
Private Auto Expense-
Postal Services-
Publications-
Printing Services-
Training Expenses-
Computer Software-
Computer Hardware-
Maintenance Repair-
Maintenance Repair - Hardware-
Maintenance Repair - Software-
Investigation Fees-
Rent Building-
Total$ - 0ERROR:#DIV/0!ERROR:#DIV/0!H
XXXSupplies$ - 0
Utilities - Electric-
Utilities - Water-
Telephone Expense-
Membership Dues-
Professional Services-
Travel In-State-
Travel Out of State-
Private Auto Expense-
Postal Services-
Publications-
Printing Services-
Training Expenses-
Computer Software-
Computer Hardware-
Maintenance Repair-
Maintenance Repair - Hardware-
Maintenance Repair - Software-
Investigation Fees-
Rent Building-
Total$ - 0ERROR:#DIV/0!ERROR:#DIV/0!I
XXXSupplies$ - 0
Utilities - Electric-
Utilities - Water-
Telephone Expense-
Membership Dues-
Professional Services-
Travel In-State-
Travel Out of State-
Private Auto Expense-
Postal Services-
Publications-
Printing Services-
Training Expenses-
Computer Software-
Computer Hardware-
Maintenance Repair-
Maintenance Repair - Hardware-
Maintenance Repair - Software-
Investigation Fees-
Rent Building-
Total$ - 0ERROR:#DIV/0!ERROR:#DIV/0!J
XXXSupplies$ - 0
Utilities - Electric-
Utilities - Water-
Telephone Expense-
Membership Dues-
Professional Services-
Travel In-State-
Travel Out of State-
Private Auto Expense-
Postal Services-
Publications-
Printing Services-
Training Expenses-
Computer Software-
Computer Hardware-
Maintenance Repair-
Maintenance Repair - Hardware-
Maintenance Repair - Software-
Investigation Fees-
Rent Building-
Total$ - 0ERROR:#DIV/0!ERROR:#DIV/0!K
XXXSupplies$ - 0
Utilities - Electric-
Utilities - Water-
Telephone Expense-
Membership Dues-
Professional Services-
Travel In-State-
Travel Out of State-
Private Auto Expense-
Postal Services-
Publications-
Printing Services-
Training Expenses-
Computer Software-
Computer Hardware-
Maintenance Repair-
Maintenance Repair - Hardware-
Maintenance Repair - Software-
Investigation Fees-
Rent Building-
Total$ - 0ERROR:#DIV/0!ERROR:#DIV/0!L
XXXSupplies$ - 0
Utilities - Electric-
Utilities - Water-
Telephone Expense-
Membership Dues-
Professional Services-
Travel In-State-
Travel Out of State-
Private Auto Expense-
Postal Services-
Publications-
Printing Services-
Training Expenses-
Computer Software-
Computer Hardware-
Maintenance Repair-
Maintenance Repair - Hardware-
Maintenance Repair - Software-
Investigation Fees-
Rent Building-
Total$ - 0ERROR:#DIV/0!ERROR:#DIV/0!M
XXXSupplies$ - 0
Utilities - Electric-
Utilities - Water-
Telephone Expense-
Membership Dues-
Professional Services-
Travel In-State-
Travel Out of State-
Private Auto Expense-
Postal Services-
Publications-
Printing Services-
Training Expenses-
Computer Software-
Computer Hardware-
Maintenance Repair-
Maintenance Repair - Hardware-
Maintenance Repair - Software-
Investigation Fees-
Rent Building-

Total $ - 0 ERROR:#DIV/0! ERROR:#DIV/0! N

Total Associated Expenditures $ 685,325 ERROR:#DIV/0! Sum of C - N

Total Restricted Rate AdjustmentERROR:#DIV/0!Sum of A - N
##Unhide to expand Cost Centers H-N

Schedule of Fed Grants Contract

HomeState Education Agency Name
Schedule of Federal Grants and Contracts 20XX
CFDA Number/ Alpha
Andre Hylton : Please input the CFDA # or Contract # of the Federal Award.Program Title

Andre Hylton : Pllease input the grant or contract description.

Please use the program title.

Grant Period
Andre Hylton : Please input the grant or contract award period.Total Award Amount
Andre Hylton : Please input the total grant or contract award amount.Current Fiscal Year Expenditures

Andre Hylton : Input current fiscal year expenditure.

Exclusions
Hylton, Andre: Please input the unallowable and exclusion amounts applicable to the awards.MTDC BaseProgram Type

Hylton, Andre: Please input the program type whether Unrestricted or Restricted

Rate Application Unrestricted
Andre Hylton : Please input a "X" if the grant or contract award is unrestricted.Rate Application Restricted
Andre Hylton : Please input a "X" if the grant or contract award is unrestricted.Other Indirect Cost Rate (e.g. DDS)
Hylton, Andre: Please Input Whether there is a DDS Rate applicable.No Indirect Cost Allowed
Hylton, Andre: Please input an "X" if there is no indirect cost allowed.Indirect Cost Limitations (i.e Rate Caps)

Andre Hylton : Please input any indirect cost limitations pertaining to grant(s) or contract(s).

If there are no limitations then input N/A.Administrative CapProject #
10/1/12-9/30/17585,656,390- 0- 0- 0
10/1/12-9/30/16146,472,774- 0- 0- 0HD14
10/1/12-9/30/17399,313,932- 0- 0- 0HC13/HF13
10/1/12-9/30/15455,803,244- 0- 0- 0HC14/HF14
10/1/12-9/30/1778,256,816- 0- 0- 0HH13/HP13
10/1/12-9/30/16373,728,047- 0- 0- 0HH14/HP14
10/1/12-9/30/18552,059,719- 0- 0- 0
10/1/12-9/30/17223,872,784- 0- 0- 0HB12
10/1/12-9/30/16764,164,086- 0- 0- 0HB13
10/1/12-9/30/16573,653,380- 0- 0- 0HB14
10/1/12-9/30/16$ 502,029,287- 0- 0- 0
07/1/12-09/30/15644,713,556- 0- 0- 0HQ13
07/1/12-09/30/16436,401,811- 0- 0- 0HQ14
07/1/12-09/30/14521,657,095- 0- 0- 0EESI
07/1/12-09/30/14273,788,603- 0- 0- 0CB11Refund of Prior Year Federal Expense - No Indirect Cost Charged
07/1/12-09/30/14529,392,133- 0- 0- 0CB12
07/1/13-09/30/142,777,687,130- 0- 0- 0CB13
08/01/01-08/31/16405,171,846- 0- 0- 0CB14
10/01/13 - 09/31/182,500,000,000- 0- 0- 0CF12
09/01/13-08/31/17700,570,559- 0- 0- 0CF13
07/01/12-09/30/16471,697,812- 0- 0- 0CF14
07/01/12-09/30/16216,106,849- 0- 0- 0CC12
07/01/2012-09/30/17572,110,426- 0- 0- 0CC13
07/01/12/12 - 09/30/17255,915,073- 0- 0- 0CC14
07/01/12 - 09/30/16214,938,361- 0- 0- 0LL8Refund of Prior Year Federal Expense - No Indirect Cost Charged
07/01/12 - 09/30/16606,345,063- 0- 0- 0LL9Refund of Prior Year Federal Expense - No Indirect Cost Charged
07/01/12 - 09/30/16383,932,427- 0- 0- 0LL10Refund of Prior Year Federal Expense - No Indirect Cost Charged
06/01/09 - 05/31/17118,220,017- 0- 0- 0LL11
03/01/12-02/28/18477,176,882- 0- 0- 0LL12
08/01/13-07/31/14476,427,359- 0- 0- 0LL13
02/14/09-09/30/17783,625,223- 0- 0- 0LL14No Indirect Cost Charged
07/01/12-09/30/16214,168,710- 0- 0- 0RA12
07/01/10-06/30/17130,659,991- 0- 0- 0RA13
09/27/10-12/31/14210,698,696- 0- 0- 0RA14
02/14/09-09/30/17362,634,629- 0- 0- 0CK12
07/01/12-09/30/16321,114,005- 0- 0- 0CK13
Total$ 18,674,508,325

Andre Hylton : This is a formula cell.

The cell sums grant(s) and contract(s) awards.

Andre Hylton : Please input a "X" if the grant or contract award is unrestricted. $ - 0 Andre Hylton : This is a formula cell.

The cell sums current grant(s) and contract(s) fiscal year expenditures.

Hylton, Andre: Please Input Whether there is a DDS Rate applicable. $ - 0 Hylton, Andre: This is a formula it sums that exclusion amounts.

Hylton, Andre: Please input an "X" if there is no indirect cost allowed.

Andre Hylton : Please input any indirect cost limitations pertaining to grant(s) or contract(s).

If there are no limitations then input N/A. $ - 0 $ - 0 Andre Hylton : This is a formula cell.

The cell sums current fiscal year unrestricted grant(s) and contract(s) expenditures. $ - 0 Andre Hylton : This is a formula cell.

The cell sums current fiscal year restricted grant(s) and contract(s) expenditures.$ - 0
Hylton, Andre: This is a formula cell.$ - 0

Hylton, Andre: This is a formula cell.

Statement of Indirect Costs

State Education Ageny Name
Statement of Indirect Costs
Fiscal Year: 2018
(based on actual costs Fiscal Year 20XX)
Account DescriptionOffice of the SuperintendentChief of StaffAgency Personnel ServicesAgency Financial ResourcesAgency Financial ServicesAudit Manag. & ResolutionInformation Tech ServicesTotal
Full Time- Salaries and Wages$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Full Time- Fringe Benefits--------
Part Time Salaries and Wages--------
Part Time Fringe Benefits--------
Overtime Pay - Salary and Wages--------
Overtime Pay - Fringe Benefits--------
Total Personnel-------$ - 0
Supplies--------
Utilities - Electric--------
Utilities - Water--------
Telephone Expense--------
Membership Dues--------
Professional Services--------
Travel In-State--------
Travel Out of State--------
Private Auto Expense--------
Postal Services--------
Publications--------
Printing Services--------
Training Expenses--------
Computer Software--------
Computer Hardware--------
Network Server--------
Maintenance Repair--------
Maintenance Repair - Hardware--------
Maintenance Repair - Software--------
Investigation Fees--------
Rent Building--------

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .