I think this is getting closer.
Here are the formulas from the book: (COM - Available to Promise)
Demand: The total customer backlog and manufacturing allocations due each
day. It can also include generated demand from MRP/MPSP, if requested.
Expected receipts/Supply: Total expected receipts each day including open,
firm planned, and planned orders.
Period ending inventory (PEI): Beginning balance plus supply minus demand
for each day.
Required starting inventory (RSI): Demand minus supply plus the future unmet
demand (FUD). This is the amount of inventory needed to meet a specific
days demand plus any shortage in coverage against future demand. The
calculation for RSI for a day is demand minus supply plus FUD. The RSI a
day is the FUD of previous day.
Future unmet demand (FUD): The amount of demand that is not covered by
supply in future days. For a specific day, FUD is the RSI of the next day
Available to promise (ATP): Projected ending inventory (PEI) minus the
future unmet demand (FUD) for each day.
When I make this a simple formula I get.
Demand = Pick Requirements + IA + AL + Firm PLN, PLN
Supply = Open MO, Open PO, Firm MO, PO Req, FIRM PO, planned MO + Planned PO
PEI = First Date = On Hand + Supply - Demand
PEI = Next Days = Previous PEI + Supply - Demand
RSI = Demand - Supply + FUD or RSI = previous days FUD
FUD = next day's RSI
ATP = PEI - FUD
As you can see from the description, RSI = today - 1 + FUD = today + 1 +RSI
**THUS RSI = FUD = RSI....
Here is my problem. ATP is returning results that are unusable. For
example, an item shows negative ATP for the entire MRP horizon because I
have demand 2 years from now for which I have not released a PO. If the
demand is beyond the CMLT time fence, why would ATP not say...available.
For example: Suppose an item has 0 on hand, 0 demand, 0 supply, 0 atp and 0
unmet future demand. And a lead time of 60 days. I now get a customer
order for 100 units due 75 days from today, well beyond CMLT. Why does ATP
show -100 available and not OK if it is beyond CMLT?
Kevin
mobile (909) 762-1384
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Jeff Snyder
Sent: Tuesday, May 18, 2010 11:23 AM
To: mapics midrange
Subject: Re: [MAPICS-L] Available to Promise
Something to the effect by date:
Onhand - demand (customer, Allocations, or peg to demand) - Unmet future
demand
+ scheduled receipt (either MO PO, or planned order). Unmet demand is
aggregated up until the next scheduled receipt.
Hope this helps
Jeff
From: rstover@xxxxxxxxxxxxxxxxxxxxx
To: mapics-l@xxxxxxxxxxxx
Date: Tue, 18 May 2010 13:41:19 -0400
Subject: Re: [MAPICS-L] Available to Promise
Check the PDF documentation for IM. May have the same info.
Best regards, Dick
Richard (Dick) Stover
Consulting Manager
Guide Technologies LLC
(c) 215-499-8530
rstover@xxxxxxxxxxxxxxxxxxxxx
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Kevin Fox
Sent: Tuesday, May 18, 2010 11:39 AM
To: 'MAPICS ERP System Discussion'
Subject: [MAPICS-L] Available to Promise
All
We seem to be having a problem with the Available To Promise. Does anyone
have the calculation formulas? There used to be an excel sheet on
infor365,
but the link is broke.
Kevin
mobile (909) 762-1384
_______________________________________________
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.
_______________________________________________
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.
_______________________________________________
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.
midrange.com
