Item Master Register & Stock Balances
Real-time inventory levels across project sites, warehouse bins, reorder
thresholds, and valuation (FIFO/Moving Average).
| Item Code | Item Name & Specification | Category | UOM | Costing Method | On Hand Qty | Reorder Level | Unit Cost (AED) | Total Valuation (AED) | Status | Action | |
|---|---|---|---|---|---|---|---|---|---|---|---|
MAT-STEEL-001 |
Deformed Steel Rebar 16mm (Grade B500B)
BS 4449 · Mill Certified · Palm Yard B
|
Structural Steel | MT | Weighted Avg | 185.00 | 50.00 | 3,120.00 | 577,200.00 | Healthy | Ledger | |
MAT-STEEL-002 |
Deformed Steel Rebar 25mm (Grade B500B)
Heavy column reinforcement · Marina Site
|
Structural Steel | MT | Weighted Avg | 35.00 | 60.00 | 3,150.00 | 110,250.00 | Below Reorder | Auto-PR | |
MAT-CONC-001 |
Ready-Mix Concrete C50/60 Microsilica
Direct batching pour · JIP compliant
|
Concrete | cu.m | FIFO | 850.00 | 200.00 | 340.00 | 289,000.00 | Healthy | Ledger | |
MAT-FAC-001 |
Unitized Double Glazed Curtain Wall (L-01)
Thermal acoustic spec · Shading coeff 0.28
|
Façade & Glazing | sqm | Standard Cost | 950.00 | 150.00 | 1,550.00 | 1,472,500.00 | Healthy | Ledger | |
MAT-MEP-001 |
Chilled Water Plant Variable Speed Pump 45kW
Primary chilled water circuit · Grundfos NBE
|
MEP & HVAC | Sets | Specific ID | 4.00 | 2.00 | 59,500.00 | 238,000.00 | Healthy | Ledger | |
MAT-MEP-002 |
Main Low Voltage Switchboard Panel 2500A
DEWA Approved Form 4 Type 2
|
MEP Electrical | Units | Specific ID | 2.00 | 1.00 | 242,500.00 | 485,000.00 | Healthy | Ledger | |
MAT-TILE-001 |
Porcelain Floor Tiles 60x120cm Polished Calacatta
Luxury residential units interior
|
Finishes | sqm | Weighted Avg | 320.00 | 500.00 | 185.00 | 59,200.00 | Below Reorder | Auto-PR | |
MAT-CABLE-001 |
XLPE Armoured Copper Cable 4C x 240mm²
Ducab Manufactured · 11kV Feeder
|
MEP Electrical | Meters | Weighted Avg | 1,450.00 | 300.00 | 355.00 | 514,650.00 | Healthy | Ledger | |
| Grand Total Inventory Asset Valuation (AED): | 3,745,800.00 | GL Link: Account 10500 | |||||||||