Madison Budget Office

Current Year Forecast

Forecast Training Resources

Forecast Training Divisional Data & Training Material located in Box

Forecast Divisional Training Overview

Forecasting PowerPoint End User Training Documentation

 

 

PlanUW Current Year Forecasting project uses the foundational budget functions implemented in Phase 1 of the project. The design, development, testing and implementation to provide Forecasting functionality began in January 2020. The forecasting process provides transparent reporting to divisional leaders; improves the quality of actual, budget and forecast data; and allows divisions to course-correct throughout the year.

This is an accordion element with a series of buttons that open and close related content panels.

Timeline & Important Dates

FY21 – Revised Current Year Forecast Due Dates

December 7, 2020
April 7, 2021

FY22

Q1 – due November 6, 2021
Q2 – due February 5, 2022
Q3 – due May 7, 2022

Forecasting Cycles

Forecast Cycle Date Forecast is Expected to be Open/Available Actual Data Seeded Forecast Data Forecast Adjustment
**November Forecast (used for 12/7/20 submission to central campus) 10-Nov July – October November – June November – June
December Forecast 15-Dec July – November December – June December – June
FY22

Forecasting Cycles

wdt_ID Forecast Cycle Date Forecast is Open/Available Actual Data Seeded Forecast Data
1 August Forecast September 15 July August - June
2 September Forecast September 15 July - August September - June
3 October Forecast (Q1 all funds) October 15 July - September October - June
4 November Forecast November 15 July - October November - June
5 December Forecast December 15 July - November December - June
6 January Forecast (Q2 all funds) January 15 July - December January - June
7 February Forecast February 15 July - January February - June
8 March Forecast March 15 July - February March - June
9 April Forecast (Q3 all funds) April 15 July - March April - June
10 May Forecast May 15 July - April May - June

Forecasting Process

Coming soon.

Forecasting Dimensions & Mapping

Forecasting Dimensions

wdt_ID Category (Dimension) PlanUW Requirement
1 Level of Detail: Department Sub Department (i.e. MSN_482000)
2 Level of Detail: Fund All Funds Available, Entry by Fund
3 Level of Detail: Program Total Program (Roll up all Programs)
4 Level of Detail: Project Projects are available but need to be manually entered by MBO
5 Level of Detail: Account Forecast Account (see mapping file)

Note: While all forecasts are built at the sub department level, that does not mean that every sub department needs a forecast. Lump sum forecasts can be loaded to a single sub department within a Department or Division.

Forecast Account Mapping

Quick Reference Guide, Documents & Tutorials

Resources to assist:

The Madison Budget Office has a developed a collection of resources to assist departments and divisions in completing their forecast for the current fiscal year. These resources are located here in the PlanUW webpages with more division-specific resources located in Box.

Current Year Forecasting – Quick Reference Guide

Forecast Account Mapping

Budget Only Department IDs

Access Box for additional Divisional Data and Training Materials

Video Tutorials are accessible in Box

Contacts & Open Lab Sessions

Your first point of contact will be your MBO analyst, they are suited to answer your questions, provide guidance, as well as complete additional data analysis to make PlanUW Forecasting a helpful and accurate tool.

Open Lab sessions will also be available for additional support. Please reach out to your analyst if you would like to join an Open Lab.