This Schedule serves two purposes. One is to allow B&P and the Divisions to monitor total expenditures and modified direct costs for NSF regular funded programs. The information the Divisions provide will allow B&P to project revenues generated by the direct programs and compare that information with the spending levels in the indirect cost programs. By monitoring this closely, both B&P and the Divisions will be able to better manage the spending in the direct programs and reduce the possibility of a larger variance in the indirect program. The second purpose is to project carryover at year end and ensure that uncommitted carryover at year end does not exceed the new carryover guideline limits proposed by the NSF. This Schedule is a modification of Schedule 1 and will need to be updated by the Divisions nominally at mid year.
Column A: Account number. An account number is needed for all programs listed on Schedule 8. It is possible a program may appear on Schedule 8 and not on Schedule 1, because Schedule 8 includes prior year carryover and Schedule 1 does not. However, every program on Schedule 1 should be on Schedule 8. These account numbers should correspond to the numbers on the Chart of Accounts. Please review the Bitech numbers and make any changes if needed.
Column B: Program Name. This is the account title or account name. This should also correspond to the Chart of Accounts. Please review the program name and make any changes if needed.
Column C: Prior Year Committed Carryover: This number is the carryover number, by program, from the accounting system for committed carryover. This number includes applied overhead.
Column D: Prior Year Uncommitted Carryover: This number is the carryover number, by program, from the accounting system for your uncommitted carryover. This number includes applied overhead.
Column E: Total Prior Year Carryover: This column contains a formula.
Column F: Total New Funds (Including Overhead) (Schedule 1). This column comes directly from Schedule 1. This number should tie back to Schedule 1.
Column G: Estimated Total Transfers. Include in this column any estimated transfers in a particular programs. New funds transfers of prior year committed and uncommitted carryover should be included.
Column H: Total Funds Available. This column contains a formula that totals carryover, new funds and estimated transfers.
Column I: Estimated Direct Expenditures: This should be an estimate of the amount of expenses projected for the budget period. This number does not include overhead. This column should include all programs on Schedule 1, and any additional programs where there will be estimated expenses of carryover dollars. The total for this column may or may not tie back to Schedule 1.
Column J: Estimated Total Modified Direct Cost: This column contains a formula. It is the difference between the Estimated Direct Expenditures and the Total Exclusions from MDC, Schedule 8A.
Column K: Estimated Overhead. This column contains a formula. The amount of Estimated Total Modified Direct Cost is multiplied by the current applied overhead rate.
Column L: Total Estimated Expenditures. This column is the sum of direct expenditures and estimated overhead.
Column M: Estimated Committed Carryover for Next Year. This number should represent estimated committed carryover you will have going into the next fiscal year.
Column N: Estimated Uncommitted Carryover for Next Year. This number should represent estimated programmed but not committed funds carried over into the next fiscal year.
Column O: Total Estimated Carryover for Next Year. This column contains a formula that will total all carryover into the next fiscal year.
Column P: Check. This column contains a formula that takes the Total Funds available and subtracts Total Estimated Expenditures and Total Estimated Carryover going into Next Year. This column should be zero (or plus or minus 100, depending on rounding). This column is a verification that all funding for a program has been accounted for.