Predictive Cash Forecasting: Exclude Weekends/Holidays from Daily Statistical Prediction output
Summary:
We are implementing Predictive Cash Forecasting (PCF) and are mainly interested in Daily Cash Forecasting, using the Statistical Prediction Forecast Method for many of the Line Items, in addition to some Manual Input. We are loading bank activity for three banks on a daily basis, excluding weekends and bank holidays when there is no activity. There is no ERP integration.
What we’re trying to understand is: what is the best way to exclude weekends and bank holidays from the Predictions?
Content (please ensure you mask any confidential information):
Bank activity occurs 5 days/week, Actuals are loaded from their daily statements the following day. Saturday, Sunday and Bank holidays have no data. We’re looking to have the forecast do the same thing (project only for weekdays), but so far we haven’t come across a configuration in Predictive Planning / IPM that will achieve that.