Re: [GENERAL] Supply Chain Calcs

2011-11-21 Thread Jason Long
Thanks for the reply. Weeks of Supply(WOS) is not exactly what I am looking for, but might lead to a solution. Here is a better description of the problem. I know the following: Delivery dates and quantities for items on order or in transit. A manager will forecast manually what the pending ite

Re: [GENERAL] Supply Chain Calcs

2011-11-21 Thread Peter Geoghegan
On 21 November 2011 18:18, Jason Long wrote: > 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. Take a look at http://en.wikipedia.org/wiki/Newsvendor_model -- P

Re: [GENERAL] Supply Chain Calcs

2011-11-21 Thread Henry Drexler
google 'weeks of supply' On Mon, Nov 21, 2011 at 1:18 PM, Jason Long 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 i

[GENERAL] Supply Chain Calcs

2011-11-21 Thread Jason Long
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 f