Inventory Intelligence

AKI's aged inventory is highly concentrated and largely preventable. Your top 20 items drive 30% of all aging (18.8M AED), and over half the total aging came from reorders placed on already-overstocked items. 32.7M AED sits on supplier books with active return clauses — this is the fastest path to capital recovery. Immediate action on the top 50 SKUs, combined with a 6-month coverage ceiling policy, would reduce aging by 80%+ within one quarter.

AKI currently holds 62.4M AED in aged inventory — 15.3% of your 407.2M AED total stock position. 21.6M AED has been sitting for over 12 months. This view shows where that aging is concentrated.

Key Metrics

Total Stock Value

407.2M

AED

Sum of Total column across all rows in dec25_aging_item_detail.csv (Base sheet from DEC25.xlsx) (6,294 rows)

Total Aging

62.4M

15.3% of stock

Sum of Ageing column in dec25_aging_item_detail.csv (Base sheet from DEC25.xlsx). Stock sitting >6 months in warehouse.

Aging > 12 Months

21.6M

High write-off risk

Sum of > 12 Mths column in dec25_aging_item_detail.csv (Base sheet from DEC25.xlsx)

Expiry Risk

15.0M

Expired + expiring <6mo

Total AED value of lots with Expiry Date ≤ Sep 2026, from stock_on_hand_lot_detail_2026_03_03.csv (from SOH 03.03.2026.xlsx) (17,544 lots). Snapshot: Mar 3, 2026.

Over 6mo Coverage

3,857

items / 51.5M AED

Distinct item codes where Mths > 6 in dec25_aging_item_detail.csv (Base sheet from DEC25.xlsx), with their combined aging value.

Data quality note: 2,589 items (4.7M AED in aging) have a coverage value of 999.9 months — this is Oracle's formula cap when average monthly movement is zero or negative. These items are included in aging totals, expiry risk, and supplier responsibility, but excluded from coverage-based calculations (coverage ceiling slider, Over 6mo Coverage KPI) to avoid inflating those numbers. Some are true dead stock with no sales; others are active sellers where the per-org formula broke due to returns exceeding sales.

Aging by Item Status

dec25_aging_summary_by_status.csv (PIVOT sheet from DEC25.xlsx) — 5 status categories with aged and total stock values.

Your top 20 items account for 30% of all aging (18.8M AED). This is a short-list problem, not a catalog-wide one.

Aggregated by item code from dec25_aging_item_detail.csv (Base sheet from DEC25.xlsx), sorted by Ageing descending, top 20 summed.

Top 10 Aging Items

Item	Description	Aging (AED)	Coverage	Status

Same aggregation as top 20 — dec25_aging_item_detail.csv (Base sheet from DEC25.xlsx) grouped by item code, sorted by aging descending.

A significant portion of AKI's current aging was preventable. 229 items with reliable coverage data received new stock in the last 6 months while already carrying more than 6 months of supply — accounting for 11.7M AED in aging. The controls below let you model what happens when you change the rules.

How we know this: Every item in customized_stock_ageing_report.csv (Customized Stock Ageing sheet from Low coverage OOS items.xlsx) was checked for three conditions: (1) Stock Months > 6 and < 999 (excluding Oracle formula caps), (2) Last Receipt Month ≥ Sep 2025 — received a new shipment in the last 6 months, and (3) Ageing V > 0. 229 items with reliable coverage data matched all three.

Examples: TEGOZOL 100 MG had 40.2 months of coverage and still received new stock in Feb 2026 (423K AED in aging). HALURAN 250ML had 8.3 months of coverage and received stock in Feb 2026 (407K AED in aging). These items already had months of supply on hand and kept getting reordered.

Manual Autopilot

Week 0 of 52

Item names, aging values, coverage, and supplier responsibility are real data from AKI's CSVs. Timing, weekly reduction rates (6%, 8%, 25%), policy tightening schedule, and the 3.2M AED/month new aging inflow are modeled assumptions.

Policy Controls

Block reorders when coverage exceeds

Items with more than X months of stock on hand would not receive new orders.

Off

No limit applied

customized_stock_ageing_report.csv (Customized Stock Ageing sheet from Low coverage OOS items.xlsx) (~15K rows). Items flagged where Stock Months > ceiling AND Last Receipt Month ≥ Sep 2025 AND Ageing V > 0.

Recoverable % of supplier-responsible aging

32.7M AED in aging is on your suppliers' books (PRINCIPAL). 9.2M AED is pending approval.

Include "Depends on Approval" bucket

No returns applied

Exp resp field in dec25_aging_item_detail.csv (Base sheet from DEC25.xlsx). PRINCIPAL = 32.7M AED, Depends on Approval = 9.2M AED.

Rotate stock when one org has X months more coverage than another

25 items today have aged stock in PVT while the same SKU moves faster in INST.

Off

dec25_aging_item_detail.csv (Base sheet from DEC25.xlsx) grouped by item code across orgs. Compares coverage between PVT and INST warehouses.

Projected Aging After Changes

62.4M

AED

Impact Breakdown

Current

Projected

Autopilot Decision Log

12-Month Autopilot Summary

AED total value recovered & prevented

Aging prevented

Supplier returns

Stock rotated

The real value isn't a one-time cleanup — it's continuous prevention. Without active monitoring, AKI's ordering patterns generate ~3.2M AED in new aging every month. Autopilot blocks this at the source while continuously recovering existing aged stock.

Cumulative Value Over 12 Months

Based on 52-week simulation using real item data from CSVs. Reduction rates and timing are modeled assumptions.

With Autopilot vs. Without

"Without" line assumes 3.2M AED/month new aging (modeled estimate). "With" line is simulation output using real item data.

Without continuous monitoring, aging grows by ~3.2M AED/month from unchecked reorders on overstocked items. With Autopilot, the system blocks these at the source — the gap widens every month.

ROI Calculator

Annual system cost (AED)

—

Payback Period

—

12-Month Net Value

—

ROI Multiple

Key Metrics

Monthly Aging Prevented

—

AED/month

One-Time Recovery

—

AED

12-Month Total Value

—

AED

Decisions Automated

—

per year

Monthly Breakdown

Month	Decisions	Recovered (AED)	Prevented (AED)	Cumulative (AED)	Net Aging (AED)

810 items (44% of those with coverage data) already have more than 6 months of coverage, holding 95.1M AED in stock and 24.6M AED in aging. Use the filters below to find the items that need attention first.

All data from dec25_aging_item_detail.csv (Base sheet from DEC25.xlsx) — 6,294 rows across PVT/INST orgs. Filters: Org, Status, Exp resp, Mths. Values: Ageing, Total, AVGs.

Filtered Items

—

Total Aging

—

AED

Total Stock

—

AED

Avg Coverage

—

months

Top 15 Items by Aging Value (Filtered)

Item	Description	Org	Status	Exp Resp	Aging (AED)	Total (AED)	Coverage	Avg Monthly

5.4M AED in stock has already expired and is still sitting in your warehouse. Another 7.5M AED expires within 6 months. 35 high-value items need immediate action — do not reorder, and pursue supplier returns or liquidation.

Already Expired

5.4M

AED

Lots where Expiry Date < Mar 3 2026, from stock_on_hand_lot_detail_2026_03_03.csv (from SOH 03.03.2026.xlsx). 17,544 lot-level rows.

Expiring < 6 Months

7.5M

AED

Total at Risk

13.0M

AED

Expiry Timeline — Stock Value by Window

Each lot bucketed by days between Expiry Date and snapshot (Mar 3 2026): expired, 0-30d, 31-90d, 91-180d, 181-365d, 365d+. From stock_on_hand_lot_detail_2026_03_03.csv (from SOH 03.03.2026.xlsx).

Aging by Supplier Responsibility

Exp resp field from dec25_aging_item_detail.csv (Base sheet from DEC25.xlsx). Aging summed per responsibility category.

The "Depends on Approval" category — 9.2M AED, mostly GPC brand — represents an open negotiation opportunity. Every month of delay is more write-off risk.

32.7M AED (52%) is on your suppliers' books. Exercise return clauses on PRINCIPAL-responsible inventory before it ages further.

Action Items — High-Value Expiry Items

Cross-references two sources: expiry dates from stock_on_hand_lot_detail_2026_03_03.csv (from SOH 03.03.2026.xlsx) and financial responsibility from dec25_aging_item_detail.csv (Base sheet from DEC25.xlsx). Actions auto-derived from expired/expiring status × PRINCIPAL/ALPHAMED responsibility.

Action Legend

Supplier Return Expired + supplier-responsible — exercise return clause Write Off / Liquidate Expired + AKI-responsible — no return option Negotiate Return Expiring <6mo + supplier-responsible — act before expiry Accelerate Sell-Down Expiring <6mo + AKI-responsible — push through sales channels Resolve Agreement Pending approval — negotiate return terms

Item	Description	Org	Value (AED)	Expiry Date	Suggested Action

Inventory Intelligence

★ AI Advisor