AnsweredAssumed Answered

Results Optimization

Question asked by yomango on Apr 16, 2015
Latest reply on Apr 17, 2015 by yomango


Results Optimization


Hello, fellow forists. My question: I have a historic database with buying orders, each order has one or many products, each product has its own sku and qty. I want to be able to optimize future purchase quantities based on the historic data, so I can see what are the, let's say, first 100 SKUs. some one suggested Montecarlo Optimization but those formulas are for rocket scientists, not for me. Is there a way to optimize those fnumbers? So far I can find how many Sku's were used in how many orders and what is their percentage against the historic data, but that isn't optimizing, I do not think.Besides, how one optimizes an SKU that was used with other SKU's in the same order. Thanks