Open Forum

Expand all | Collapse all

Forecasting Question

  • 1.  Forecasting Question

    Posted Jul 08, 2016 11:06 AM

    We want our forecast to drill down to the component level instead of finished goods. We have loaded the Sales Forecast and Production Forecast in NAV. 


    Currently, we create Purchase Orders based on Production Orders, Firmed and Released.  Our goal is to see demand 3 to 6 months out from the current date. However, we can’t see past the date of the last Production Order entered. 


    To that end, we have these questions to ask.


    • What are others doing with NAV’s forecasting abilities to create demand for Production Orders?
    • What steps do we take in order to see a forecast at the BOM/component level?


    Eric Johnson
    Pearson Candy Company
    Saint Paul MN
    Academy - Online Interactive Learning from Experts

  • 2.  RE: Forecasting Question

    Posted Jul 08, 2016 02:37 PM


    There is quite a bit of set up work that  you will need to do that is probably too much to discuss on this forum.

    But what you are asking is clearly possible.

    I found this manual on line.

    Please let me know if you would like to discuss this further with me.


    Bob Bergman
    REB Dynamics Consulting
    Port Charlotte FL

    Academy - Online Interactive Learning from Experts

  • 3.  RE: Forecasting Question

    Posted Jul 11, 2016 07:30 AM

    There are a few fundamental things that you need to consider.

    • What is the longest leadtime for a purchased item (e.g. 12 weeks)?
    • Are you able to estimate/plan/forecast your Finished Good demand to match this leadtime?
    • If so, that could become your planning horizon. You will need to enter your Production Forecast for the Finished Good items to match that leadtime.
    • Once you have this information entered, then running MPS and MRP will allow you to create demand for your Raw Materials.

    The key to getting this to returning meaningful results is:

    • Correct leadtimes for your raw materials
    • Correct Planning Parameters for each item
    • Correct times in your Routing steps

    Ultimately, good master data will provide good results.

    Andrew Good
    Liberty Grove Software
    Oakbrook Terrace IL

    Academy - Online Interactive Learning from Experts

  • 4.  RE: Forecasting Question

    Posted 27 days ago
    Andrew stated it perfectly.  The system will do exactly what you need if you give it the data to support the calculation.  If you have properly defined the Finished Good, and the supporting data (raw materials) has accurate planning parameters the MRP engine will read it and run the calculation.  You need to make sure you have a large enough planning horizon to capture all purchases required.

    P.S. After running your MRP, you can filter on the Order Date to see what is needing to be ordered that day/week/etc.

    Ben Baxter
    Accent Software, Inc.
    carmel IN

    Academy - Online Interactive Learning from Experts

  • 5.  RE: Forecasting Question

    Posted 28 days ago
    Smart Demand Planner, aligns strategic business forecasting at any level of your product hierarchy with granular forecasts of the item mix to improve forecast accuracy. Check the Smart add-on for Dynamics.

    Xabier Lizartzategi
    Marketing Director
    Smart Software, Inc
    Belmont MA

    Academy - Online Interactive Learning from Experts

If you've found this thread useful, dive deeper into User Group community content by role