New "Planning and Projections" Tool
The Planning and Projections tool is a new online capability within the IBM Cognos TM1 software that supports the management of funds at USC through financial forecasting. This tool offers a financial projection modeling system upon which budget and planning scenario models can be built, providing visibility into available funding across fiscal years for the purposes of financial decision support.
The Planning and Projections tool is being made available to principal investigators, departments, centers, and schools for the purpose of creating financial cost projections for a portfolio of accounts. Core features include structured projection templates, flexible projection sheets, and customizable reports, as well as a feature to create personalized scenarios (conservative, moderate, aggressive) that can be shared as appropriate.
The Planning and Projections tool is being implemented in phases. In the first phase, we implemented projection functionality for current unrestricted, gift, and endowment funds in a top-down, trend-based approach. This functionality became available on 5/22/2018, with additional enhancements introduced on 6/21.
The second phase will create research, effort, payroll, and budget reallocation models for sponsored and restricted funds in a bottom-up approach. Phase 2 will be rolled out in installments, with the following planned go-live dates:
- Phase 2.0 Research: Nov 12, 2018
- Phase 2.1 Payroll: Mar 30, 2019
- Phase 2.2 Gifts and Endowments, plus
Income and Expense: May 11, 2019
To obtain more information about the new Planning and Projections tool, submit your inquiries via email to email@example.com