google 'weeks of supply' On Mon, Nov 21, 2011 at 1:18 PM, Jason Long <mailing.li...@octgsoftware.com>wrote:
> I have a custom inventory system that runs on PG 9.1. I realize this is > not a postgres specify question, but I respect the skills of the members of > this list and was hoping for some general advice. > > The system is not based on any ERP and was built from scratch. > > My customer requested some supply forecasting to see when there will be a > surplus or shortage of parts based on delivery dates and production dates > that will require these items. > > I need to identify which items will run out and when based on current > available inventory, orders, delivery dates, and production dates. > > Would someone please give me some keywords to google so I can track down a > few different ways of doing these calculations? > > Or links to any examples. I am really not trying to reinvent the wheel > here. >