Materials Management (MM) Dashboard
ECC T-Codes: MMBE / MD04 / ME2MRaw Active Pharmaceutical Ingredients (APIs), excipients, primary blister foil, and supplier purchase orders.
Total Material Valuation:₱121.2M PHP
Days of Inventory (DOI)
42.8 Days-2.1d
Imported APIs buffer35-45d
PO Cycle Time
14.2 Days-1.8d
PR approval to vendor<15d
Critical Low Alerts
1 Item+1
Hard Blister Foil 25mcLimit: 0
Vendor Lead Time
94.6%+1.5%
48 active API vendors>92%
Total API Stock Value
₱90.5M+4.2%
Paracetamol, Amox, MetfOptimal
Open Purchase Orders
28 POs-3
Active procurementOn-Track
Goods Receipts Today
4 Lots+2
Dock receiving bayPending QC
Safety Stock Level
98.2%+0.4%
Critical excipients>95%
Inventory Valuation & Stock Distribution by Material Class
Distribution across active APIs, excipients, and primary packaging
Material Master Inventory & Stock Valuation
(7 Items)| Material Code | Description | Category | Stock On Hand | Min Safety Stock | Lead Time | Valuation (PHP) | Stock Status |
|---|---|---|---|---|---|---|---|
| API-PARA-001 | Paracetamol Micronized Powder USP | API (Active) | 14,500 kg | 5,000 kg | 24 Days | ₱43,500,000 | In Stock |
| API-AMOX-004 | Amoxicillin Trihydrate Compacted BP | API (Active) | 3,200 kg | 4,000 kg | 32 Days | ₱28,800,000 | Reorder Warning |
| EXC-MCC-102 | Microcrystalline Cellulose (Avicel PH-102) | Excipient | 22,800 kg | 10,000 kg | 14 Days | ₱11,400,000 | In Stock |
| PKG-ALU-025 | Hard Aluminum Blister Foil 25mc Printed | Primary Packaging | 180 rolls | 250 rolls | 45 Days | ₱6,750,000 | Critical Low |
| API-METF-009 | Metformin Hydrochloride Pure Grade EP | API (Active) | 9,100 kg | 4,500 kg | 21 Days | ₱18,200,000 | In Stock |
| PKG-VIAL-010 | Sterile Type I Glass Vials 10ml Amber | Primary Packaging | 125,000 pcs | 80,000 pcs | 30 Days | ₱7,500,000 | In Stock |
| EXC-PVK-030 | Polyvinylpyrrolidone (PVP K-30) Binder | Excipient | 4,200 kg | 3,000 kg | 18 Days | ₱5,040,000 | In Stock |