Thread: 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.
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:
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:
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.