Options

Requisition Worksheet doesn't take into account item lead times

CharlehCharleh Member Posts: 44
Hi all, I'm running the req. worksheet with a single item (for testing) which is set to the following planning params:

Max Inv: 1000
Reorder Point: 800
Order Multiple: 4

I'm using a production forecast in order to project expected sales since we have a 3 month (90D) lead time on the vendor (the items are being shipped from overseas)

When I run the req. worksheet, I always see that it suggests the receipt of the goods 3 months after the demand (even if the first demand is in 3 months time).

At the moment due to seasonal variation this may result in us being out of stock - we are keeping 3 months stock (+ an additional 20%) to account for the lead time, but occasionally demand is higher than projected.

Is there any way to get the req. worksheet to schedule the delivery to meet the demand instead of proceed it by the lead time? Interestingly, if we run a lot-for-lot schedule, the receipts match the demand exactly, however, there is no "buffer" inventory level, NAV tries to keep the inventory level at 0.

Any ideas?
Charleh

Answers

Sign In or Register to comment.