The scenario dimension is used to capture budget versions, actuals, and encumbrances. The meaning of a scenario can vary based on its context in a cube (e.g. cc_Employee vs. cc_Financials Exploded report). Each scenario has a start and end date attribute that will be used in order to limit the amount of date data that needs to be looped through for calculations in the TM1 models (e.g. employee by period work hours, employee by account work hours at day level). This start and end date is currently indicated in the scenario attributes. Below is a listing of the managed scenarios in the TM1 planning models. Scenarios may be calculated* or static snapshots copied from a calculated scenario. Most scenarios may have data in more than one budget type. This chart depicts how the scenarios are added together or subtracted from each other to come up with totals and variances. The "∑" symbol depicts aggregated scenarios, the "n" symbol depicts leaf level scenarios and a (1) or (-1) depicts whether the scenarios beneath it are added to or subtracted from the other.
| Scenario | Description | Source | Budget Type |
| ∑ Actual | |||
| n Incurred Actual | Actual expenses sourced nightly from SunGard (Bi-tech) IFAS for financial data and from iVantage for employee data | IFAS and iVantage | Undefined |
| ∑ IFAS Budget vs Actual Variance | Variance scenario with a negative weighting on Incurred Actuals to calculate variance between IFAS Budget (Authorized Funding) and Actual Expenses | ||
| n IFAS Budget (1) | Budget Sourced from IFAS reflecting Authroized Funding - includes all IFAS budget types (New Funds, Committed Carryover, Uncommitted Carryover, Budget Transfers) - known historically as the Working Budget | IFAS |
|
| n Incurred Actual (-1) | see above | see above | see above |
| ∑ IFAS Budget vs Actual MOE | Variance scenario showing difference between the authorized funds in IFAS and the actual expenditures as of the last month end. | ||
| n IFAS Budget (1) | see above | see above | see above |
| n Incurred Actual EOM YTD (-1) | Includes only actual expenditures from IFAS as of the last month end. | IFAS | Undefined |
| ∑ Working Plan vs Actual Variance | Variance scenario comparing a TM1 working plan to IFAS actuals. | ||
| n Working Plan* (1) | Current primary planning scenario containing planned expenses that may not be in the IFAS Budget Current. This scenario is used as a source for adding new account keys on time card and for pushing salary encumbrances to IFAS. | User-created |
|
| n Incurred Actual (-1) | see above | see above | see above |
| ∑ IFAS Budget vs Forecast | Comparative scenario showing differe between IFAS Budget and Forecast. A negative variance indicates you will be overspent if you continue to spend as planned in your Working Plan for future months since the last month end. Asjustments should be made to staff plans and non salary plans as necessary to bring this to a zero or positive variance. | ||
| n IFAS Budget (1) | see above | see above | see above |
| n Forecast (-1) | Incurred Actuals as of last month end and WOrking plan for all future months. | Incurred Actual and Working Plan |
|
∑ IFAS Budget vs Reforecast Total Interim Rate | A comparative scenario for seeing the impact of an interim rate change on the working plan so adjustments can be made to bring the working plan in line with the IFAS Budget if necessary. A negative variance indicates that you will be overspent if you do not make adjustmennts to your Working Plan for future months since last month end. |
| |
| n IFAS Budget (1) | See above | See above | See above |
∑ IR Forecast (-1) |
| ||
| n IR Working Plan (1) | Includes Working Plan as of the last month end and applies a new set of Interim overhead and benefit rates based on the quarterly entity budget office Interim Rate review process | Working Plam, Working Plan remaining |
|
| n IR Incurred Actual EOM YTD | Includes Incurred Actual expenses minus overhead and benefits and applied a new set of interim overhead and benefit rates based on the quarterly entity budget office Interim Rate review process | Incurred Actual MOE | Undefined |
| ∑ Total Expected Budget | Adds IFAS Budget to Expected Budget for a high-level projection of total expected funds |
| |
| n IFAS Budget (1) | see above | see above | see above |
| n Expected Budget (1) | For planners who do use a report or planning approach in which they do not want to designate items in the Working Plan scenario as Expected Funds using budget type. In reports this is added to IFAS Budget for a Total Expected Budget. | User-created |
|
| ∑ IFAS Budget vs Forecast | Variance scenario comparing IFAS Budget (Authorized Funding) with Actuals as of the last month end plus Working Plan fir future months |
| |
| n IFAS Budget (1) | see above | see above | see above |
| n Forecast (-1) | Actuals in months-to-date + working plan in future months - only makes sense to use with a view that is over time. |
|
|
| ∑ Forecast Remaining | Comparative scenario used as an indicator to determine if your Working Plan for future months need to be adjusted. A negative variance shows that you may already have a probolem if your Working Plan is equal to your authorized funding (IFAS Budget). | ||
| n Forecast (1) | see above | see above | see above |
| n Incurred Actual (-1) | see above | see above | see above |
| n What If* | sA second planning scenarion like Working Plan shared by all planners whocan do what-iffing in conjunction the the TM1 sandbox feature. Note that this scenario is not intended to roll up into an institution-wide scenario and does not feed time card or salary encumbrances. | user created |
|
| ∑ IFAS Funds Available | Variance scenario with a negative weighting on Incurred Actuals and encumbrances to calculate variance. Note that this scenario should be used with caution since salary encumbrances are onloy updated every 2 weeks and incurred actuals will not reflect an interim rate change within a fiscal year | ||
| n IFAS Budget (1) | see above | see above | see above |
| n Incurred Actual (-1) | see above | see above | see above |
| ∑ All Encumbrances | |||
| n IFAS Salary Encumbrance (-1) | sourced from WOrking Plan to IFAS every 2 weeks at pay period end | WP->IFAS | Undefined |
| n IFAS Non-SalaryEncumbrance (-1) | Non-Salary encumbrances sourced from IFAS I | IFAS | Undefined |