Re: Available to Promise

Kevin, 

This is what I have...

How MPSP calculates available to promise
The system calculates ATP quantities in three steps:
1. Calculate projected ending inventory (PEI) for each day. This quantity appears
as Projected Inventory on displays AMVATP03 and AMVATP05.
2. Calculate the future unmet demand (FUD) for each day. This quantity appears as
Future Unmet Demand on display AMVATP03.
3. Calculate ATP quantity for each day.
The calculation uses the following kinds of information:
This table shows a full set of ATP information and calculated results for a horizon of
ten days. The item has a past due of 325 and no on-hand inventory.
On hand = 0
Type of information Description
Demand The total customer backlog and manufacturing allocations
due each day. It can also include generated demand from
MRP, if requested.
Expected receipts/Supply Total expected receipts each day including open schedules,
requisitions, firm planned orders, planned orders, and
intersite orders.
Projected 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.
Type
Past
Due           1  2   3   4    5      6      7     8    9   10
Demand 325 ---  ---  ---   20    ---    ---    30 840  ---  6
Supply   400 ---  ---  --- 345    ---    ---   843   ---  ---
PEI(-325) 75 75 75  55 400  400  370  373 373 367
RSI         <0  0 20  20   <0     33   33     3    6     6
FUD        20 20 20   0   33     33     3     6    6     0
ATP        55 55 55  55  367  367  367 367 367 367

(I hope the table comes through lined up correctly, as it looks before I press "Send").


Dale (Cork) Gindlesperger 

"Education is not training but rather the process 
that equips you to entertain yourself, your friends, and an idea."

--- On Tue, 5/18/10, Kevin Fox <[email protected]> wrote:

From: Kevin Fox <[email protected]>
Subject: [MAPICS-L] Available to Promise
To: "'MAPICS ERP System Discussion'" <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]>
Date: Tuesday, May 18, 2010, 11:39 AM

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-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
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-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.