Current Year Forecast

Forecast Training Resources

Forecast Training Divisional Data & Training Material located in Box

Forecast Divisional Training Overview updated with new CYF due dates for FY21

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.

Timeline & Important Dates

FY21 – Revised Current Year Forecast Due Dates

December 7, 2020

April 30, 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.