Huh? Why would you want to optimize the next order for a product? Instead why don’t you determine a series of planned orders, well out into the future and share those with your supply chain partners. And update these planned orders as things change (like sales, for example). That’s the ticket to improvement…for everyone!
In the immortal words of Kenny Banyon, “that’s gold Jerry…gold!!”