Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Unanswered

Demand Forecasting having the same value for all forecast buckets

Posted on by 30

Good day everyone.

I am tasked to implement Demand forecasting for a company with 11 legal entities.

One thing I noticed is that whenever I run the Generate Statistical Baseline Forecast, with a forecast bucket of Monthly and forecast horizon of 24, All values are the same month by month.

This is not even close to the Historical demand data that we import to D365. A product may have a one historical demand for 100 pcs in 2 years but the system interprets it as if there is a forecast for 100 pcs every month. 

I use Item allocation keys and have been modifying the forecast algorithm parameters but I always get the same outcome. I also tried using weeks as forecast bucket but I still got the same results.

pastedimage1623894336089v1.png

Is there a way to configure the parameters in such a way that the baseline forecast will closely resemble the historical demand? 

  • eric.canicosa Profile Picture
    eric.canicosa 30 on at
    RE: Demand Forecasting having the same value for all forecast buckets

    Hi Chris,

    Thank you for your reply. I hope everything is well on your end.

    If it is ok, I would like to ask some follow up questions:

    1. When we use Copy over historical demand, will it be able to cover, say for example historical demand for the last 3 or 4 years?

    2. Will it still incorporate the calculation of MAPE?

    3. Is it expected that since Azure ML uses time series forecasting, the forecast will be the same (almost) for all forecast buckets?

    Thank you so much and I really appreciate your feedback.

  • Chris Segurado Profile Picture
    Chris Segurado 612 on at
    RE: Demand Forecasting having the same value for all forecast buckets

    Hello,

    I hope you and your family are doing well.

    To import the historical external demand use ReqDemPlanHistoricalExternalDemandEntity data entity in Dynamics 365 Supply Chain Management. Make sure it is imported in correct format for accuracy of baseline forecast.

    When the forecast strategy is set to Copy over historical demand, the end of the historical horizon is ignored. The system copies the number of buckets specified in the Forecast horizon field to the forecast demand, starting from the date set in the From date field under Historical horizon. By copying historical demand from a certain date forward, production planners can make the plan for the next quarter in two ways:

    - By copying the demand from the same quarter last year.

    - By copying the demand from the previous quarter.

    pastedimage1623982787436v1.png

    You can make manual adjustment once and transfer them over moving forward. Manual adjustments made in previous demand forecasting iterations can be automatically applied to the new baseline forecast if the Transfer manual adjustments to the demand forecast check box is selected.

    Thank you!

    Best Wishes,

    Chris Segurado

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans