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 <kdfox@xxxxxxxxxxxxx> wrote:
From: Kevin Fox <kdfox@xxxxxxxxxxxxx>
Subject: [MAPICS-L] Available to Promise
To: "'MAPICS ERP System Discussion'" <mapics-l@xxxxxxxxxxxx>
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@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
