Create Forecast based on Sales and Quantity on Hand

[Hiten Vakharia]

Hi,

I would like to create a reorder point (min/max) for the items sold for last three months using sales data bearing in mind quantity on hand so I never run out of my inventory.

For eg If I have sold 100 units of a particular item between Jan and March, I would like to predict the stock level for next two weeks.

Thanks in advance.

Regards,
Hiten