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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.