Icare S&OP Monthly Pack

Demand · Jan–Oct usage

301.4M

EGP invoiced · Oct alone 39.1M

MAP 2026 achievement

57.8%

299.3M vs 518.2M target, ex-Optaline, corrected

Open purchase orders

97 / 142

42 not invoiced · 47 invoiced-not shipped · 8 at customs

Total lead time

155.5 days

Customs → receipt alone is 81.7 days

Inventory · 19 Oct

134.4M

EGP snapshot total

Dead stock

35.1%

47.2M EGP · 341 SKUs

Receivables · 18 Oct

138.0M

EGP · DSO 145.7 days

Government DSO

263 days

58.5% of all receivables

1 · Executive — the month on one page

Read this first, then argue about the details in the sections below.

Block	Headline	Figure
Demand	Jan–Oct invoiced usage; October was a strong month but the year is 57.8% of MAP target	301,372,131
Supply	97 open POs; 10 of 11 watch-list SKUs have no inbound at all	97 open
Inventory	Healthy stock covers only 2.9 months at average usage — total cover of 4.5 months flatters, because 35% is dead	87,261,691
Cash	Receivables 138.0M at a 145.7-day DSO; Government overdue >30 days alone is 41.8M	138,025,152

Balance check: demand is running at ~30.1M EGP a month, healthy inventory covers 2.9 of those months, and 97 POs are somewhere in a 155.5-day pipeline. The binding constraints this month are customs clearance (MX60E) and the 10 watch-list SKUs with nothing coming — not total stock, which looks comfortable only because dead stock inflates it.

2 · Demand — invoiced usage and plan vs actual

Monthly invoiced usage from the KPI series (Odoo exports, 19 Oct 2026). April is negative because of late credit notes, not negative demand.

Monthly invoiced usage, 2026 (EGP)

Jan

34,520,864

Feb

11,742,722

Mar

67,320,409

Apr

−2,616,947

May

23,516,384

Jun

56,890,435

Jul

7,947,189

Aug

44,768,897

Sep

18,178,270

Oct

39,103,908

Jan–Oct total: 301,372,131 EGP · Monthly average: 30,137,213 EGP. September was revised down 398,646 from the first cut (late credit notes). October is month-in-progress — real October invoices in the export. Memo, not forecasts: invoices already carrying Nov dates 24,805,106 EGP and Dec dates 16,965,472 EGP.

MAP 2026 plan vs actual, by division

Division	2026 target	Actual to date	Achievement
B+L Surgical (ex-TPV)	344,282,102	204,368,010	59.4%
TPV	88,857,669	58,141,645	65.4%
Others (LM / Espansione / SBM)	23,118,727	13,619,780	58.9%
Pharma	61,920,912	26,161,410	42.2%
Total (ex-Optaline)	518,179,410	302,290,845	58.3%
Corrected total (less Sirius Plus double count, 2,980,000)	518,179,410	299,310,845	57.8%

Quarterly actuals: Q1 82,048,427 · Q2 85,672,240 · Q3 56,276,564 · Q4* 78,293,614. Pharma actual is 84.5% of its realistic target (30,960,456, i.e. 50% of its full target). Optaline target 79,267,087 is excluded — its actuals were never filled.

Q4 caveat: Q4 is not a closed quarter — the sales sheet already carried large Q4 values with 2.5 months of the quarter remaining at 15 Oct 2026. Confirm whether Q4 is actuals-to-date, future-dated invoices, or a forecast before treating 57.8% as final (decision 9).

3 · Supply — pipeline, lead times, and what will run out

Inbound pipeline file, 19 Oct 2026: 331 lines across 142 POs. Recorded values are as recorded in the file — it does not label a currency, so none is assumed here.

Pipeline by stage

Stage	POs	Lines	Qty (units)	Recorded value
Not yet invoiced	42	99	78,607	1,523,044
Invoiced — not shipped	47	127	3,047	1,711,335
In transit	0	0	0	0
At customs	8	19	35,131	328,770
Received in warehouse	45	86	17,581	1,541,701
Total	142	331	134,366	5,104,850

Open pipeline = 97 POs, 245 lines. Bausch + Lomb is 239 of 331 lines (72%). By supplier recorded value: B+L 3,983,494 · LightMed 228,425 · Pharma 227,654 · CSO 119,696 · Sometech 104,000 · SBM 53,100 · supplier not recorded 388,482.

Lead time — 155.5 days end to end

EDA 22.5

Form 4 · 39.5

Customs → receipt · 81.7

Other 11.8

Customs → receipt is over half the total. The October watch uses a 90-day rule for its own projections — shorter than the measured 155.5 days. Reconcile the two before promising any date.

At customs — the two items that matter

PO	Item	Qty	Arrived	Days in stage
ICM.26.060	MX60E enVista IOL	1,719	14 Sep	35 — escalate
ICM.26.067	MX60E enVista IOL	1,629	14 Sep	35 — escalate
ICM.25.058	Aqualarm UP	31,680	4 Oct	15 — certificate being opened
Plus Oct-14 arrivals: Stellaris Elite systems (BL14455 / BL15455), packs, handpieces, cords — 5 days in stage.

October stockout watch — 11 SKUs

Average monthly sales and PO arrivals below are real (Nov-25–Sep-26 run-rate). The watch file's on-hand counts are samples and are deliberately not shown. Only one SKU has inbound:

SKU	Item	Avg monthly sales	Inbound
BL5115-2	Elite phaco pack with tip	378.8	350 in Oct + 250 in Dec — chase first
CC100SL	Ocucoat 2ml	104.0	None — order now, arrival ~Jan
E7930	Endo bipolar pen 23g	54.6	None — order now, arrival ~Jan
D8200	Exo bipolar forceps	40.0	None — order now, arrival ~Jan
D4600A	Air exchange line	36.5	None — order now, arrival ~Jan
E7928	Exo bipolar scleral pen	32.2	None — order now, arrival ~Jan
BL3318	1.8 straight tip	21.7	None — order now, arrival ~Jan
SE5523WVB	23g elite Biblade combined pack, wide field	23.3	None — order now, arrival ~Jan
MI60P	IOL MI60 (now Akreos AO)	394.5	None — order now, arrival ~Jan
cx9430	Bipolar cord	12.5	None — order now, arrival ~Jan
BL3318A	1.8 angled tip	4.5	None — order now, arrival ~Jan

MX60E backorder candidates — 17 diopters at zero on-hand, sold in September 2026

Negative reserved quantities are the backorder signal. Confirm in Odoo (delivered qty < ordered qty) and log real stockouts: +24.00 (−180 reserved, 61/mo) · +27.00 (−28, 23.3/mo) · +26.00 (−36, 18.3/mo) · +01.00 (−39, 17/mo) · +04.00 (−33, 16.7/mo) · +03.00 (−38, 16/mo) · −00.00 (−27, 15.3/mo) · +12.00 (−35, 15.3/mo) · +07.00 (−35, 15/mo) · +05.00 (−39, 14.3/mo) · +08.00 (−33, 13.7/mo) · +15.00 (−69, 13.7/mo) · +10.00 (−35, 12/mo) · +16.00 (−50, 12/mo) · +13.00 (−32, 10/mo) · +30.00 (−19, 6.7/mo) · +32.00 (−6, 1.7/mo). The 3,348 MX60E units at customs do not cover these until they clear — and 1,919 more units are not yet invoiced (placed 24 Jun 2026).

Oldest un-invoiced lines: Aqualarm UP 23,571 units (placed 28 Apr 2026) · Artelac Advanced UD 7,143 + Artelac MDO 7,143 + Recugel 3,572 (placed 24 May 2026) · MX60E 1,919 (placed 24 Jun 2026).

4 · Inventory — snapshot, dead stock, expiry, provision

19 Oct 2026 snapshot. 362 of 569 SKUs are costed — 149 dead SKUs have no unit cost, so dead value is understated.

Position	SKUs	Value (EGP)	Share
Total inventory	569	134,416,917	100%
Dead stock	341	47,155,226	35.1%
Healthy stock	—	87,261,691	64.9%

Healthy cover: 2.9 months at Jan–Oct average usage (30,137,213 EGP/month). Total cover is 4.5 months — but 35% of it is dead.

Dead stock split

Never sold in 11 months

39,619,375 · 299 SKUs

Sold before, zero last 6 mo

7,535,851 · 42 SKUs

Dead stock by category (top 8 + remainder)

Category	SKUs	Value (EGP)
Ref. Machines	3	8,561,198
Stellaris Spare Parts	47	8,308,696
Trade In	10	7,059,371
Stellaris Machines	3	6,343,600
Victus Spare Parts	30	4,943,528
Teneo Spare Parts	57	3,640,910
Lightmed Machines	6	2,332,450
CSO Machines	6	1,809,203
All other categories	179	4,156,270
Total dead	341	47,155,226

Top 10 dead lines are 60% of dead stock (28,188,167 EGP): VICTUS Platform 7,297,596 · TENEO 317 Rework 3,622,126 · Stellaris PC + Laser 2,859,459 · Stellaris Combined 2,671,543 · Higher Speed Vacuum Fluidics 2,520,726 · VCSEL kit 2,258,481 · Laser Source 2,126,099 · RETIMAX ADVANCED 1,700,261 · Database Server 1,687,731 · Kit UPS 1,444,145.

Expiry

37 lots expired — 1,374 units, 327,097 EGP costed, plus 5 lots with no unit cost. Of the expired value, 36,928 sits on dead stock (already counted there — never add it twice) and 290,169 sits on live stock. Near-expiry rows in the tracker are zero — a recording gap, not proof of zero risk.

Provision at suggested defaults — illustrative only, not approved policy

Bucket	Base (EGP)	Rate	Provision (EGP)
Expired (live stock only)	290,169	100%	290,169
Never sold	39,619,375	50%	19,809,688
Stale (zero last 6 months)	7,535,851	25%	1,883,963
Near-expiry	0	50%	0
Total provision	47,445,395	16.4% of inventory	21,983,819

Net inventory after provision: 112,433,098 EGP (on the 19-Oct base; the provision dashboard's 112,341,773 used the earlier end-Sep base of 134,325,592). Nothing here is booked — decision 5.

5 · Cash — receivables, DSO, and what Finance must bring

Invoice ledger at 18 Oct 2026, 291 days. DSO = receivables ÷ sales × 291. The finance team's own receivables definition is used throughout.

Receivables by segment

Segment	Sales 2026	Receivables	DSO (days)	Share of AR	Overdue >30d
Government	89,239,827	80,716,713	263.2	58.5%	41,788,165
Private hospitals & centres	140,073,681	40,101,288	83.3	29.1%	8,324,993
Clinics & doctors	17,631,086	5,699,248	94.1	4.1%	1,830,178
Distributors	1,772,350	520,541	85.5	0.4%	150,039
Pharma	26,913,625	10,987,361	118.8	8.0%	578,490
Total	275,630,569	138,025,152	145.7	100%	52,671,865

Government DSO of 263.2 days is the single biggest cash drag; private hospitals pay in 83.3 days. Segment sales and receivables foot to the official control totals.

UPA family (inside Government above)

Entity accounts gross: 110,528,560 EGP (~119 accounts, one per end-entity) · Unallocated collections: −33,012,195 EGP (cash received but not yet allocated) · Net: 77,516,364 EGP · UPA sales 2026: 84,722,201 EGP · Family DSO ≈ 266 days — use the family figure, not entity-level DSOs, which are gross of unallocated collections.

Other cash facts (memo — never add to receivables)

Post-dated cheques held: 31,746,793 EGP (already inside receivables — coverage only) · Bounced cheques: 822,799 EGP · Old debt, 127 accounts with a balance but no 2026 sales: 10,954,530 EGP · Instalment balances excluded from the receivables definition: ~9,660,000 EGP.

Missing inputs — Finance to bring (decision 10): no collections forecast exists in the source files (the cash-flow sheet's collection rows are blank), no supplier payment schedule exists, and no bank position is on file. Without them this cash block stays a position statement, not a plan.

6 · Decisions & owners

These are proposals, not decisions — the data raises them, the meeting settles them. Owners below are proposed by function; the meeting confirms or changes them and sets due dates in the Excel log.

1. Reconcile Aqualarm UP inbound — what is actually arriving, and when.
31,680 units at customs (arrived 4 Oct, certificate being opened) vs 23,571 units not yet invoiced (placed 28 Apr) vs the earlier reorder-risk flag — the pictures do not reconcile.

Proposed owner: Supply Chain