Plan & Source
Demand Planning, S&OP and MRP
Statistical, AI and commercial forecasts reconciled through the monthly S&OP cycle, then exploded through BOMs into net material requirements.
Forecast accuracy (MAPE)
12.4%
-2.1pp
SKUs below 30-day cover
8
Material shortage lines
6
Capacity utilisation
87%
Line 1 constrained
Planned batches (next 30 d)
34
Forecast: actual vs statistical vs AI
AI detected seasonality on antibiotics, a promotion-driven spike in June and two stockout periods that were removed from history before fitting the statistical baseline.
S&OP cycle
- 1Demand Review
- 2Inventory Review
- 3Supply Review
- 4Capacity Review
- 5Financial Review
- 6Executive S&OP
Scenario planning
- Revenue
- EGP 2.14B
- Service level
- 96.2%
- Stock cover
- 118 days
- Cash
- EGP 310M
Low
MRP — net material requirements
| Material | Required | Available | Incoming | Shortage | Lead time | Action |
|---|---|---|---|---|---|---|
Paracetamol API (Micronized) API · Anhui Fine Chem | 150.0K kg | 82.0K | 30.0K | 38.0K | 75 d | |
Lactose Monohydrate 200M Excipient · DFE Pharma | 96.0K kg | 41.0K | 12.0K | 43.0K | 45 d | |
Maize Starch BP Excipient · Roquette | 38.0K kg | 44.0K | 0 | 0 | 30 d | Covered |
Magnesium Stearate Excipient · Peter Greven | 4.2K kg | 1.1K | 800 | 2.3K | 60 d | |
Amoxicillin Trihydrate API · Sandoz GmbH | 62.0K kg | 22.0K | 25.0K | 15.0K | 90 d | |
PVC/PVDC Blister Film Packaging · Klöckner | 480.0K m² | 512.0K | 0 | 0 | 25 d | Covered |
Aluminium Lidding Foil Packaging · Amcor | 410.0K m² | 180.0K | 90.0K | 140.0K | 35 d | |
Printed Carton — 10x10 Packaging · Ghabbour Print | 1.20M pcs | 940.0K | 200.0K | 60.0K | 20 d |
SKUs at stockout risk (next 30 days)
- Omeprazole 10 mg/5 ml Eye Drops12 d coverStock 27.8KDemand 71.3K/mo
- Omeprazole 1 g Eye Drops22 d coverStock 65.3KDemand 89.5K/mo
- Diclofenac 20 mg Cream18 d coverStock 48.6KDemand 82.6K/mo
- Losartan 250 mg Tablets19 d coverStock 55.5KDemand 87.4K/mo
- Azithromycin 20 mg Sachet2 d coverStock 3.6KDemand 49.6K/mo
- Diclofenac 10 mg/5 ml Tablets13 d coverStock 44.3KDemand 106.0K/mo
- Diclofenac 20 mg Oral Suspension8 d coverStock 5.1KDemand 18.5K/mo
- Metformin 1 g Oral Suspension21 d coverStock 55.6KDemand 79.2K/mo
Records & transactions
Demand forecast override · S&OP scenario · Manufacturing order
No records posted in this module yet. Use “New record” to create one — it is saved to the shared database with an audit entry, recomputed into the KPIs and alarms, and fed to the AI agents as live context.