Maximo Mentor Series: Inventory Management Certification Exam Session 2 - Mastering Maximo Stock Management: The Math and Mechanisms of Inventory Reordering
Continuing the Maximo Mentor Articles series! In my previous session, I laid the groundwork with Item Setup and the Inventory Lifecycle. Today, I’m shifting our focus to the engine room of the supply chain: Stock Management and Inventory Reordering.
If you are preparing for your IBM Maximo Inventory Certification, mastering this topic is non-negotiable. Understanding exactly how Maximo decides when to buy, how much to buy, and where to source from is the key to passing the exam and maintaining a lean, responsive supply chain.
This deep dive covers Section 2: Stock Management. Let’s break down the mechanics into 4 Key Pillars of Maximo's reorder engine:
1. The Triggers: ROP, Safety Stock, and the EOQ Rule
Before Maximo can automate anything, you must configure the rules of the game on the Reorder Details tab in the Inventory application.
- Reorder Point (ROP): This is your minimum line in the sand—the threshold that tells the system it is time to replenish stock.
- Safety Stock: Extra buffer stock to protect against stockouts during unexpected demand surges or delivery delays.
- Economic Order Quantity (EOQ): This setting dictates your order batch sizes, optimizing ordering frequency against holding costs.
The Golden Rule: For the math to work, the EOQ must be greater than or equal to 1. It can never be zero because Maximo relies on it as a multiplier to round up your final order quantity into clean, manageable batches.
2. Decoding the Reorder Formula
Do not let the calculations intimidate you. Maximo's internal math is highly logical. When the reorder process runs, it solves this formula:
Let's break down the variables:
- Why “+ 1”? Maximo adds 1 to the ROP to ensure your final order quantity actually pushes your balance above the reorder threshold, rather than just meeting it.
- Quantity on Order: The total sum of items on all active Purchase Requisitions (PRs) and Purchase Orders (POs)—essentially anything that is not canceled or closed.
- Available Balance: Your current physical balance on the shelf, minus any reserved quantities for work orders, minus expired quantities for lotted items.
- The Round-Up Mechanism: Once the base order quantity is determined, Maximo divides it by your EOQ and rounds up to the next whole integer. It then multiplies that integer by the EOQ to ensure you only purchase full, optimized batches.
For example: If the formula says you need 11 items, and your EOQ is 5, Maximo calculates 11/5 = 2.2. It rounds 2.2 up to 3, and multiplies by 5 to give a final order quantity of 15.
3. Dynamic Lead Time: Responsive, Not Rolling
Lead time represents the expected delay between PO approval and actual delivery. Maximo can use a static “best guess” value, or it can automatically calculate dynamic lead times based on real-world vendor performance using the Recent Lead Time Weight (%) field in the Storerooms application.
The Sequential Algorithm: A critical, highly testable detail is that the algorithm does NOT use a long-term rolling average. Instead, it operates on only one receipt at a time, in sequential order.
The formula used is:
(where diffInDays is the actual elapsed time between PO approval and receipt).
This sequential math keeps the system incredibly responsive to sudden vendor delivery shifts rather than smoothing them out over years of historical data.
4. Designing the Internal Supply Chain
You don't always have to buy from external vendors. Maximo allows you to configure internal supply chains and automated routing:
- Select Reorder Storeroom: This powerful action in the Storerooms application allows you to nominate a master warehouse to handle replenishment for satellite storerooms, even if they are in different sites. This automatically updates related inventory records to source replenishment internally via Internal POs.
- Special Order Items: For uncataloged, ad-hoc materials needed for specific work orders, you can use special orders. These bypass stocked inventory and automatically create an Item Master record in PENDING status. This keeps your main catalog clean by keeping the item invisible for future standard orders unless it is officially transitioned to active status.
Top Exam Tips
Links
- Maximo Mentor: Inventory Management Overview video — watch the series overview →
- Maximo Mentor: Inventory Management Section 1 — Items and Storerooms →
- Link to IBM Certification: IBM Certified Maximo Manage v9.1 Inventory Management — Associate