Hello everyone,
I'm currently working on a project where we aim to replace our Excel-based demand forecasting process with a solution within Dynamics 365 Finance & Operations (D365 F&O). We have three warehouses across the US, with plans to expand to a fourth one, and deal with around 3000 product SKUs. Our parts are ordered monthly from suppliers based in India and China, with lead times of approximately 4 months (2 months to make parts ready, 2 months in transit).
For demand forecasting, we've been using a formula in Excel: Round(Median(Range)/2,0)*1.1, which takes into account historical sales data, current inventory levels, and pending purchase orders to predict future demand. We're looking to implement this formula or a similar approach within D365 F&O.
Additionally, we're also seeking guidance on supply forecasting, particularly in terms of assessing vendor capacity, lead times, and production capabilities to ensure our inventory levels meet anticipated demand.
Could anyone familiar with Dynamics 365 Finance & Operations provide insights or best practices on how we can achieve both demand and supply forecasting scenarios within the system? Any recommendations on modules, functionalities, or customizations that we should consider would be greatly appreciated.
Thank you in advance for your assistance!
