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.





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-2021 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.