cancel
Showing results for 
Search instead for 
Did you mean: 

Forecast Consumption Alert

Former Member
0 Kudos

Hi,

Our business need a requirement for alerts. they want to view the forecast consumpion alert in DP planning book

but how to create the macro based on this requirement. how to create the read color cell if alerts is generated in planning book.

A monthly actual sales vs forecast pro-rated to the elapsed days alert.

This alert should run in the monthly.Threshold for alerts are <80% or >120%.

requirement is (1 Calculate the number of days in the month and divide the active forecast by this to get a pro rata daily forecast.

2 Calculate how many days into the month the current date is. (e.g., today 4th Feb is 4 days into the month).

3 multiply the daily pro rata forecast (step1) by the number of days into the month so far.



Could you please ex plane the how we will create the macro based on above requirement.




Thanks

RK

Accepted Solutions (0)

Answers (1)

Answers (1)

RahulHanda
Active Contributor
0 Kudos

Rakesh,

Though your requirement is still not clear but will still try on a high level (as per my understanding of your requirement):

  • First of all, I hope you are talking about forecast accuracy i.e. comparison of actual sales to forecast.
  • To divide the data, create a planning book with daily bucket and dis-aggregation will be automatic.
  • Capture forecast & actual sales in this planning book on daily bucket.
  • Put two key figures in this planning book; cumulative forecast and cumulative actual sales.
  • Compare cumulative numbers for the previous/current day through macro (create database alert)

Regards

Rahul