Matrix for Media

Monarch – Top Down Forecast

As a manager you need to adjust the forecast roll up to corporate. This report allows you to view your Forecast compared to the Top Down Budgets.

Please follow the below steps to ensure accurate, useful forecasting information. 

TOPDOWN FORECAST 

The Top Down Budget Attributes (Outlet – Office – Rev Type) must match your Top Down Forecast Attributes (Outlet – Office – Rev Type) to ensure accuracy for Digital, Local, National & Political. You can find your TopDown Forecast (Formerly known Forecast Adjustment) on the Navigation Pane on the left side under “TOPDOWN FORECAST”.

Enter in your forecast number into each month. No more calculations or negative numbers! For example, if your Salespeople are saying it’s going to be $2 million in June for Digital, but really you think it’s going to be $1.75 million then you simply just need to enter in $1.75 million in June for Digital.

There should only be four total budget rows for each Outlet matching the below Offices and Rev Types.

When you click on each month, you can see how your forecast compares to the TopDown Budget Values and the Bottom Up Forecast Values. You can view the Total by Quarter as well as view the Grand Total for the entire calendar year. Below numbers are for illustration only and do not represent real totals.




Did you find it helpful? Yes No