PMI Knowledge base

Generic filters
Filter by Custom Post Type
Article contents (TOC)
Print

How is the month-to-date forecast and budget calculated in the Flash report?

Please Share Your Feedback
How Can We Improve This Article?

The MTD (month-to-date) forecast is the amount you should have by this point in the month/period, in order to reach your end-of-the-month forecast, given that your Live forecast for the rest of the month is correct.

The calculation is: ME (month-end) forecast divided by month-end Live forecast multiplied by MTD actuals.

In the example below, reflected in the screenshot:

A. ME Forecast: 58,571

B. ME Live forecast: 56,430

C. MTD Actual: 7,314

D. A (58,571) divided by B (56,430) multiplied by C (7,314) = MTD forecast (7,591)

 

Image description: The Flash report in PMI with method for calculating MTD forecast/budget

Note: If the MTD actual is higher than this amount you will exceed the forecast and vice versa. The Forecast index is calculated by taking the month-end figure and dividing it by the forecast figure.

The index indicates where you will end up at month-end compared to the forecast. Deviation is also displayed in local currency.

The above calculation works the same way for Budget: Month-end Budget divided by month-end Live forecast multiplied by MTD actuals.