| roll-over forecast in Oracle [message #502639] |
Thu, 07 April 2011 14:31  |
 |
rtheis
Messages: 2
Registered: April 2011
|
Junior Member |
|
|
Say we have a 12 week time period. The forecast is for a demand of 100 units per week for the full 12 weeks, which equates to a total demand of 1200 units.
We use oracle as our software program.
Say our customer orders 100 units in week 1, 100 in week 2, 100 in week 3, 50 in week 4, 0 units in week 5, 0 in week 6, 0 in week 7, 0 in week 8, and then places an order for 550 units in week 9 (50 from week 4, the 100 units from week 5,6,7,8 and the 100 units they would normally consume in week 9).
The dilemma is that because only 50 units of the forecast was consumed in week 4, and 0 units were consumed in weeks, 5,6,7, and 8, our oracle system does not roll over the missing forecasted demand and drops to zero for those weeks. Oracle still only plans for the original 100 units of forecast a week. We are now 450 units short for our customer because Oracle did not roll over the "missing" demand.
Is there a step or tool we can use in Oracle to prevent the forecast from dropping to zero and continue rolling over the "unconsumed" forecast so that when the customer does place the "big" order for the units they should have purchased, we are not caught with a pants down?
I would assume we are not the only company with this issue and there is a away to circumvent the problem.
Any help would be appreciated.
|
|
|
|
| Re: roll-over forecast in Oracle [message #502640 is a reply to message #502639] |
Thu, 07 April 2011 14:41  |
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
|
What "oracle software program" are you talking about? Oracle the the RDBMS has no such built-in logic, it only executes the SQL or PL/SQL that you tell it to execute.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
