Re: Reorder point based on last order date

food for thought... err drink...

seriously off the top of my head...For fifo date control, I think you'd have to set up lot control for the part number in question as well as fifo date control. Each Lot would have a different date.

you would have to monitor the shelf life, expiration date via report to ensure a reorder in enought time (lead time) before the last gal expires.


A simplier approach, though general in approach would be to set the ROP at 3 or 4 gal. to be sure to replenish before all is expired. ? Maybe extend your replenishment (vendor time) by some 'x' days of potential expiration to set the ROP.

Nothing in MRP will address any better that I know of. you have Safety stock and shrinkage, etc I guess you could entertain.

I guess it's a cost/benefit analysis. Just a few 'out of the box' thoughts.....may be worth modeling.

I've been consulting in Mapics XA for over 20 yrs, I do not know of a clear cut answer to the exact qry.

Hope this helps a bit..

Jeff Snyder, CPIM
Guide Technologies, LLC

Date: Thu, 12 Jun 2008 16:46:22 -0700> From: TEStieger@xxxxxxxxxxxx> To: mapics-l@xxxxxxxxxxxx> Subject: [MAPICS-L] Reorder point based on last order date> > List-> > We have some product that has a shelf life of 90 days. We order it 5 gallons at a time. Currently we have our reorder point set at 1 gallon and are using IM-> Reorder Recomendations not MRP for reordering.> > We want to make sure to reorder it before the product expires or when our on-hand stock gets below 1 gallon.> > Any thoughts or suggestions on how to do this would be helpful. If MRP is helpful for this please suggest that too. Also, we are currently using an uncontrolled warehouse for this item.> > Thanks.> > -Tom Stieger> California Fine Wire> > _______________________________________________> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list> To post a message email: MAPICS-L@xxxxxxxxxxxx> To subscribe, unsubscribe, or change list options,> visit: http://lists.midrange.com/mailman/listinfo/mapics-l> or email: MAPICS-L-request@xxxxxxxxxxxx> Before posting, please take a moment to review the archives> at http://archive.midrange.com/mapics-l.>