local_phone(877) 456-7632 local_post_officeinfo@msxgroup.com
Message Boards
Sign up Latest Topics

Poll Results
 Was this post helpful?
 Yes 0 0%
 No 0 0%
Total votes: 0   Please or sign up to vote.

  Author   Comment  

Posts: 117
Reply with quote  #1 

One quick way to project or forecast actuals for the remainder of the year is to take the average of year-to-date actuals and post those balances to each future month, at least as a starting point. Your budget managers could then adjust those balances as needed on input screens in Forecaster.

How do I do this in Forecaster?

In Forecaster, a GLOBAL calculation and TASK can quickly and easily populate future months (periods) with the average of year-to-date actuals. You will need to create the Calculation Set with the GLOBAL calculations to populate the future Periods (the Periods must be POSTING on the PERIOD worksheet). You will then need to create a GLOBAL CALCULATION TASK to run the calculations against all CENTERs, ACCOUNTs and other Forecaster segments.

The Calculation Set will use “G” for the Type field of each formula. The formulas will only reference Period ID’s such as F201308=AY201307/7.

The TASK will be a GLOBAL Task using this Calculation Set.

Some clients will prefer to populate forecasted actuals into the ACTUAL Periods (i.e. A201308). Other might use FORECAST Periods (i.e. F201308)

The GLOBAL Task would look similar to:  “GLOBAL(FORECAST_ACTUALS)” with FORECAST_ACTUALS being the name of the Calculation Set.

Noah C. Moseley
MSX Group Senior Consultant and Certified Instructor

Email me if you need help installing, implementing or just need training on Microsoft Forecaster, Management Reporter or FRx. Plus, Prospero for Financial Reporting and Budgeting is now available. See our introductory video at http://msxgroup.com/prospero_video_introduction

Management Reporter | Prospero | Forecaster | FRx
Training | Consulting Services | Software Support
Previous Topic | Next Topic

Quick Navigation:

Easily create a Forum Website with Website Toolbox.