IBM Support

Understanding Maximo Inventory Related Terminology

Technote (FAQ)


Are there any terms that would help in the understanding of Maximo inventory functionality?


Yes, understanding inventory terminology is essential for working with Maximo.
Here are a few of the key terms that you need to understand in order to take advantage of the robust inventory related functionality in Maximo:

Safety Stock: This is the minimum stock balance that you want to have on hand at all times. The actual value will be heavily based on how critical the inventory item is to your operation.

Reorder Point (ROP): Reorder point is the balance level at which you want your inventory reorder to take place for the given item. The calculation is a forecast of demand over lead time plus a calculation of safety stock.

The ROP is used to trigger the reorder process for the item based on the following calculation:

Available Balance + Stock on Order =< (Equal to or less than)

(Available balance is the current balance - reserved quantity (reserved quantity is the quantity on all approved WO's referencing that item in the given storeroom) - expired stock)
(Stock on order is the quantity on all PR's and PO's for that item at that storeroom where PO/PR status is not closed or cancelled)

Note that when the work order has the "Required by Date" populated for the item the reorder process will not reorder if the SYSDATE + LEADTIME < REQUIREDBYDATE.

Setting the ROP to 0 will still reorder the item if the Available Balance + Stock on Order drops to 0.

Economic Order Quantity (EOQ): From a Maximo reorder point of view, this is the quantity that will be reordered once the reorder process has been triggered for the item.

EOQ refers to the optimum ordering quantity to keep inventory investments to a minimum. In other words, smaller ordering quantities would keep the inventory down, but would generate higher costs alternatively larger ordering quantities keep costs down but increase the cost of keeping the item in stock.

How this all comes together....

Once safety stock levels are set, the ROP should then be considered.

You can use various inventory reports to gain this information.

Lead Time is the time between approval of the PO for a given item and its receipt date.

Lead time demand is usage during lead time.

"A" is the average number of days in a month = 30.44

(1/1.6)th is the 1.6th root. 1.6 root (2 * Std Dev of Lead Time * (Lead Time/A))

Once the ROP is set the next value to be considered is the EOQ.

EOQ = sqrt( 2AS / IQ )
sqrt is Square Root of
A = Default Unit Issue Cost picked up from the Inventory Control Main screen as defined from Application Setup-Inventory Options-Defaults Costs-Issue Costs
S= Ordering Cost (This is inputted into the report)
I = Carrying Cost ( A Carrying Cost percent is prompted - Carrying costs are calculated at this percent value * Default Issue Cost )
Q = Total usage for the last 365 days.

To calculate EOQ for reordering to the maximum. If you wish to
reorder to the maximum level, you can write an EOQ report to set the EOQ
according to the MAXIMUM value as follows:

Quantity to be purchased (EOQ) = (MAXIMUM - ROP + Availability ) / conversion
rounded EOQ up to the nearest integer
where MAXIMUM = MAXIMUM value to replenish CONSIDERING conversion
AVAILABILITY = (Current Balance + On Order - Reservations - Expired)
Example: ROP = 5, EOQ = 5, Current Balance = 3,
Availability = 3, conversion = 1
TO reorder to MAXIMUM of 10...
EOQ = (10 - 5 + 3)/1 rounded up = 8

If the reorder routine were run, it would take ROP (5) - AVAIL (3) = 2 in
multiples of EOQ (8) according to conversion (1) to replenish above the ROP
(5), which would be 1 multiple of 8.

The final amount in the storeroom would be the MAXIMUM of 10 (2 + 8 = 10)

Some Additional Organization related definitions and options:

Inventory Defaults:

Type A,B,C Breakpoint Table.Column:   MAXVARINPUT.A_BREAKPOINT, MAXVARINPUT.B_BREAKPOINT, MAXVARINPUT.C_BREAKPOINT = Percentage of inventory items associated with ABC Type A, B, or C used in ABC inventory analysis. For example, enter 30 to specify thirty percent for one of the fields.

Update Cost/Currency Variances on Inventory Costs Table.Column:   MAXVARINPUT.UPDATEINVENTORY Specifies whether the system copies the cost and currency differences (INVOICETRANS) to the variance accounts for the storeroom. If the check box is selected, the system copies the cost and currency differences. If the check box is cleared, the system does not copy them.

Negative Current Balance Table.Column:   MAXVARINPUT.NEGATIVECURBAL Specifies whether Maximo will allow users to issue or transfer items with a negative current balance. If Allow Negative Balance is selected, users can issue items with a negative balance. If Disallow Negative Balance is selected (the default), users cannot issue such items. NOTE: Maximo checks balances at the Bin level, not the Storeroom level.

Inventory Reorder:

External Request Creation Table.Column:   MAXVARINPUT.AUTOPOEXT Specifies the type of purchase requisition or purchase order that Maximo creates when a reorder request uses external vendors. Choose one of the four options. The default is an unapproved purchase requisition.

Internal Request Creation Table.Column:   MAXVARINPUT.AUTOPOINT Specifies the type of purchase requisition or purchase order that Maximo creates when a reorder request uses internal vendors. Choose one of the four options. The default is an approved purchase order.

Maximum Number of Reorder Lines per PO/PR Table.Column:   MAXVARINPUT.MAXPRLINES Specifies the maximum number of reorder lines that can appear on a purchase order or purchase requisition. The default is 40.

Inventory Costs:

Issue Cost Table.Column:   MAXVARINPUT.DEFISSUECOST For the selected site, specifies whether Maximo uses standard cost (the default) or average cost when an item is issued.

Non-capitalized Rotating Table.Column:   MAXVARINPUT.COSTFROMASSET For the selected site, specifies whether Maximo uses issue cost (the default) or asset cost when a non-capitalized rotating asset is issued. The setting applies only to the selected site.

Available in version 7.5:

LIFO: (Last in first out) This costing method uses the receipt cost of the items that were most recently purchased and are the newest in the storeroom.

FIFO: (First in first out) This costing method uses the receipt cost of the items that are the oldest in the storeroom.

These costing methods allow for greater flexibility when deciding how to value your inventory.

Understanding these terms and some of the calculations involved should help you to effectively use Maximo inventory functionality.

Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management Tivoli Asset Management for IT All
Systems and Asset Management Maximo Asset Management Essentials All

Document information

More support for: Maximo Asset Management

Software version: 5.1, 5.2, 6.0, 6.1, 6.2, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6, 6.2.7, 6.2.8, 7.1, 7.1.1, 7.1.2, 7.5, 7.6

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1384733

Modified date: 24 March 2010