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
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
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
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