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
