concept demoAsset 360 Platform · Asset Inventory Studio
From parts inventory to a purchase plan, in minutes.
MRO inventory is sized by the criticality and reliability of each asset. The right part available when the asset needs it, without capital sitting idle in the storeroom.
inventory.datamint.com.br · Itabira Mine
Asset Inventory StudioItabira Mine · MRO inventoryFR
STEPS
CONTEXT
Sector
Objective
SKUs
Currency
Project setup
Sector and objective set the defaults for the remaining steps.
Itabira Mine · MRO inventory
INDUSTRIAL SECTOR
ENERGY
EnergyGeneration, transmission and distribution.AUTOMOTIVE
AutomotiveFabrication and assembly.MINING
Mining819 parts · 12 locations · 11 suppliersMANUFACTURING
ManufacturingShift-based operation.LOGISTICS
LogisticsTransport and warehouses.OTHER
OtherGlobal defaults.MAIN OBJECTIVE
MODE I
Critical availabilityminimum α 98% in class AMODE II
Minimum capitalInvestment ceiling activeMODE III
Service × cost balancesingle target α of 95%MODE IV
ReplenishmentReorder point and lot sizeData upload
Parts, locations and suppliers. All three datasets are required.
Parts and SKUsLocationsSuppliers
parts_itabira.xlsx
Replace file819 rows read · 3 errors, 12 warnings
3 duplicate SKUs · the row with the highest stock will be kept.
12 rows without unit cost · the family's average cost will be used.
Fix automaticallySkip rows with errors
3 duplicates resolved and 12 costs filled with the family average
SKUDESCRIPTIONCLASSCOSTSTOCK
SFM-ESC-0002Bucket hydraulic cylinder · ExcavatorAR$ 199,6960
SFM-ESC-0005Bucket teeth (GET tips) · ExcavatorBR$ 29,5330
SFM-ESC-0004Slew ring · ExcavatorCR$ 3,26117
Network definition
The topology defines how safety stock is pooled across the 12 locations.
CENTRAL HUB
Central hubOne storeroom supplies every point.HIERARCHICAL
HierarchicalCentral + 3 hubs + 8 points of use.SINGLE POINT
Single pointNo pooling across locations.NETWORK LEVELS
3central, hubs and pointsNODES WITH SAFETY STOCK
4of 12 locationsRISK POOLING
62%within each hubIMPACT ON SAFETY STOCK
−24%vs. the current scenarioLocation map12 locations
Method setup
The preview on the right recalculates with every change.
QuickBalancedCustom
Target service level 95,0%
Class A gets +3 p.p. and class C −5 p.p. with criticality differentiation.
Demand and consumption24-month window
h and K costs25% per year · R$ 100 per order
Lead timetypical × 1.00 per supplier
PLAN PREVIEW
659parts to buy
R$ 44.8Minvestment
R$ 1.5Mcapital released
94,9%average α after plan
Preview across the 819 loaded parts.
Review and run
Check the setup and run the optimization.
PROJECT
Mining · Mode III
DATA
819 parts · 12 locations · 11 suppliers
NETWORK
Hierarchical · pooling on
METHOD
SL 95.0% · h 25% · K R$ 100
Running optimizationbase scenario
[00:00] Run started · 819 SKUs, 12 locations[00:01] Validating data integrity…[00:02] Estimating demand per SKU (819)…[00:03] Computing effective lead time per supplier…[00:04] Solving optimal levels by criticality…[00:05] Applying risk pooling across locations…[00:06] Consolidating action plan…[00:07] Run complete.
Action plan
819 parts analyzed · target service level 95.0% · service × cost balance
Immediate action · 102 critical parts uncovered
View all 102Zero stock on class A equipment or service level below the minimum.
659Buy · R$ 44.8M
117Release · R$ 1.5M freed
43Adequate stock
94,9%Service level
SKUDESCRIPTIONSTOCKOPTIMALCURRENT αIMPACT
SFM-BMP-0467Cartridge bearing · Slurry pumpPit control0340,0%↑ R$ 811k
SFM-MOI-0724Trunnion bearing · Ball millTubarão Port depot0262,3%↑ R$ 534k
SFM-BMP-0486Mechanical seal · Slurry pumpBH office · Purchasing0342,5%↑ R$ 530k
SFM-TRC-0381EP630 conveyor beltPrimary crushing storeroom0264,3%↑ R$ 476k
Service × capital and orders
Pick the point on the frontier and turn the plan into orders.
Service × capital frontier
Orders by supplier
SUPPLIERITEMSVALUELEAD TIMEACTION
Bearing supplier38 itemsR$ 9.6M21 daysCreate order
Seal supplier24 itemsR$ 4.1M14 daysCreate order
Belt supplier17 itemsR$ 6.3M30 daysCreate order
3 orders created · s and Q parameters ready for the ERP