Supply Chain Calcs
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.
google 'weeks of supply'
On Mon, Nov 21, 2011 at 1:18 PM, Jason Long
<mailing.lists@octgsoftware.com>wrote:
Show quoted text
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.
On 21 November 2011 18:18, Jason Long <mailing.lists@octgsoftware.com> 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
--
Peter Geoghegan http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services
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 items will be customized
with and a date this will happen.
This might very well change and will not be based on any historical
information. There is also a 30-45 day delay in delivery since all
components come from over seas and must come via ship.
This is meant to point out where manually foretasted productions will fail
due to lack of specific parts.
On Mon, Nov 21, 2011 at 12:23 PM, Henry Drexler <alonup8tb@gmail.com> wrote:
Show quoted text
google 'weeks of supply'
On Mon, Nov 21, 2011 at 1:18 PM, Jason Long <
mailing.lists@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.