Command center home. Shows 5 KPI cards, Before/After stock distribution chart, top 10 highest-value transfers, and site Inbound/Outbound summaries. All cards are clickable.

Full sortable/filterable table of all transfer orders. Filter by site, pre-status (Zero Stock / Near Zero / Critical / Buffer), or minimum SAR value. Paginated at 50 rows. Click column headers to sort.

Filtered view showing only Life Saving Item transfers. Red badge shows count. Use for emergency prioritization and clinical governance reporting.

Redistribution-focused view: items with near-expiry quantities (Near Exp Qty > 0) that can be transferred to sites actively consuming them. Distribution charts by site and top 5 SKUs by near-expiry count. Exportable to CSV.

Items with no consumption in last 3 months (Stock Status-3M = NO REQUEST). Charts by site and top 5 non-moving SKUs by stock value. Use to identify slow-moving stock before it converts to dead stock.

Live table of all 18,500+ inventory rows from R2 SCM DataBase. Shows AMU 3M/12M, three stock-status readings, near-expiry qty, Life Saving flag. Filter by site, status, or Life Saving. Export as CSV.

Upload fresh inventory Excel files per site (KFMC, PMAH, R2). After loading ≥2 sites the Run Engine button activates. Download templates here first. Load all 3 for full network analysis.

Opens with 3 Live Site Status cards (R2/KFMC/PMAH) showing live availability%, zero/critical stock, life-saving items at risk, near-expiry value and a top recommended action — click a card to jump to that site's Status tab. Below that, the original strategic insight cards ranked by severity, plus the Prioritized Action Plan table.

Controls which sidebar tabs Viewers and Managers can see, manages Announcements for the header ticker, and (new) App Defaults — ABC/XYZ Pareto cutoffs, Risk Rating score thresholds, and Safety Stock calculator defaults.

Real-time terminal showing engine operations, file parse results, computation steps, and errors. Use to trace activity or diagnose loading issues. Shows row counts, computation time, and any skipped SKUs.

Complete documentation for all dashboard features, formulas, data requirements, export options, and all 9 Risk tabs with examples — this page. Updated with every release.

A/B/C by cumulative share of inventory value (Pareto). X/Y/Z by demand variability (coefficient of variation across AMU Last M / 3M / 12M from the KFMC AMU Trend sheet, joined by KFMC Code). "Unclassified" means no KFMC Code match — usually an R2/PMAH-only item. Cutoffs are configurable in Settings → App Defaults.

Bias % = (Planning AMU ÷ Actual Ordered 3M − 1) × 100 — positive means the plan runs above what departments actually ordered. Scoped to the KFMC AMU Trend sheet, the only source with a true plan-vs-actual split.

Interactive calculator: set lead time (days) and service level (90/95/98/99%), and it computes Safety Stock and Reorder Point per item, flagging anything currently below its ROP. Defaults come from Settings → App Defaults.

Near-expiry quantity × unit price, by site and Main Category. Overall_Status only carries a near-expiry quantity, not batch expiry dates, so this ranks value-at-risk rather than showing a day-by-day calendar.

Flags rows with missing Description, AMU, Unit Price, or Main Category, and duplicate NUPCO codes — issues that quietly break the math on other tabs. Click an issue chip to filter the table.

A composite LOW/MEDIUM/HIGH/CRITICAL badge (stock status + life-saving + near-expiry + AMU-needs-review + over-stock) appears on Overall_Status, Life Saving Status, Non Move Last 3M, and every Risk Dashboard's Top Risk Items table. Score cutoffs are configurable in Settings → App Defaults.

Any Announcements a superuser has posted scroll first (colored NOTICE/WARNING/URGENT tags), then live per-site tags for R2, PMAH and KFMC — availability%, inventory value, zero stock, near-expiry, and each site's Stock Status breakdown (critical/buffer/safe/over). Followed by a CLUSTER tag (combined SKUs/value/zero-stock across all 3 sites) and an OVERALL tag (cross-site life-saving/PICU/NICU counts from Overall_Status), then open tickets and the latest weekly R2 snapshot delta.

Filtered to life-saving items only. For each site, shows how many life-saving items are flagged with a critical recommended action (WRITE OFF / URGENT ORDER / ORDER NOW) and the single most urgent one by name — the same rule-based recommendation engine used on every item's detail card.

A "Main Category" button opens a checklist of every category with its SKU count — tick one or more to show only matching items. Selecting no categories shows everything.

Three checkboxes read straight from the sheet's combined "Life Saving Item" checkbox field (e.g. "✅ Life_Saving ⬜ PICU ⬜ NICU"). Check any combination to filter to items matching at least one — e.g. check PICU and NICU to see items flagged with either.

Every filter on these tabs — Main Category, Life_Saving/PICU/NICU, Exclude Inactive 12M, search, and the Activity/Stock Status/Requested/Flags chips — now updates the KPI tiles and every chart, not just the table. The one exception: clicking a chart segment to drill in still only filters the table, so the chart itself stays showing the full picture.

Total SKUs, Over Stock (count + SAR tied up), Zero Stock with active demand, Critical <1 month coverage, Slow-Move, No-Move, Near Expiry (count + SAR at risk), and Double Risk (Over Stock and Near Expiry together — the highest write-off exposure).

Click any KPI tile and the Top Risk Items table below filters to just that category, with a "filtered to X · clear" indicator. Click the tile again to go back to the combined view. The table shows every flagged item, 50 per page — use Sort (Value at Risk / Qty) and Prev/Next to page through the full list.

A Risk Category Breakdown bar chart and Near-Expiry-by-Category doughnut, both by Main Category, plus an Inventory Health Scorecard comparing each metric's current % of the formulary against a benchmark target (On Target / Above Target).

Every item flagged Over Stock, Slow-Move, No-Move or Near Expiry, deduplicated and sorted by value at risk, with a badge for each flag it carries. A red Double-Risk alert banner appears whenever any items are both Over Stock and Near Expiry.

Command center for the full risk picture. Shows 9 live KPI cards (Total Risk, Over Stock, Slow/No Move, Near Expiry, Double Risk, On-Hand Units, Zero Stock, Critical Coverage, Unplanned Active), two alert banners, Inventory Health Scorecard vs benchmarks, and 28 dynamic Expert Recommendations ranked CRITICAL → LOW.

Full table of all Over Stock items (stockStatus = "Over Stock"). Filter chips at top: All / Pharmaceutical / Medical Supply / Non-Medical / Also Near Expiry. Planner dropdown for planner-specific view. Category breakdown table shows OS, SM, and NE counts per main category.

Items with no or limited demand history. Filter chips: All / Dead Stock (no request last 12M) / Slow Moving (requested last 12M but not last 3M). Both types are included in the combined Slow/No-Move KPI (1,215 items in Jun-26). Dead Stock sub-count: 347.

Items flagged by NUPCO as Near_Expiry_Batch — batch expires in <90 days. Shows 160 items in Jun-26 across Pharmaceutical (105) and Medical Supply (54). Click any row to open the item detail panel.

Items simultaneously classified as Over Stock AND Near Expiry — the most critical tier. Every item here has excess units that are also approaching expiry within 90 days. Requires immediate vendor return or inter-cluster transfer. Escalate button on each row.

Items where the system confirms stockStatus='Zero Stock' AND there is active clinical demand (requested in last 3M). Sorted by AMU descending — highest-demand items first. Top 50 carry an EMG badge for emergency procurement prioritization.

Items with some physical stock remaining but will reach zero within 30 days at current usage rates. Formula: Coverage = onHand ÷ AMU < 1.0 months. Sorted by coverage ascending (most urgent first). Three urgency tiers: URGENT (<0.25mo) / WARNING (0.25–0.5mo) / MONITOR (0.5–1mo).

Items with active clinical demand (requested last 3M) but no assigned planner (planner = Not_Planned). These items have no procurement plan, no reorder trigger, and no accountability. 36 items in Jun-26 — 23 Medical Supply, 12 Pharmaceutical, 1 Non-Medical.

One row per planner: Over Stock, Slow Moving, Dead Stock, Near Expiry, Double Risk, Total Risk Items, On-Hand Units. Sorted by total risk descending. Click any row or "View OS" button to filter the Over Stock table to that planner's items only.

Tracks month-over-month improvement across 10 KPIs: Over Stock, Dead Stock, Near Expiry, Double Risk, the three rates, Unplanned Items, Zero Stock, and Critical Coverage. Live column shows current data vs. previous snapshot. Auto-snapshot fires on day 7 each month — or use 📷 Save Snapshot to capture manually.

Located on the Risk Dashboard home page. Compares 11 live KPIs against targets with status badges: ✅ On Track / ⚠ Monitor / 🟥 Critical. Includes the 3 new categories — Zero Stock, Critical Coverage, Unplanned Active all have a target of 0 (must be fully eliminated).

This system monitors inventory line items across KFMC, PMAH, and R2 clusters where the Near_exp_Qty column is greater than 0. This critical view prevents medical waste and optimizes shelf-life utilization.

• Distribution Chart: View stock count contribution ratios of near-expiry inventory by site.
• Top 5 Hazard SKUs: A bar chart highlighting the specific NUPCO items with the highest quantity of near-expiry stock.
• Action Plan: Filter, search, and target specific near-expiry batches to initiate priority transfer orders or vendor returns.

Located in the header configuration block, this simulator allows you to adjust the average monthly usage (AMU) from -90% to +300% and dynamically modify the Min/Max Months of Stock (MOS) targets.

• Min MOS Slider: Set the replenishment trigger point (default is 6 months). Receivers below this target are prioritized for inbound transfers.
• Sender keeps / Receiver to: the giving site always keeps 6 months of its own demand (only stock above that can move), and a receiving site below 6 months is filled up to 6 months. Both can be changed next to Run Engine.
• Demand Adjuster (%): Adjust cluster-wide demand (AMU) to simulate market contractions, epidemics, or seasonal consumption shifts.

Total SAR value: Σ (Qty × Unit Price). Capital mobilized from internal surplus — no new procurement spend.

Total count of recommended stock movements. Each order = one unique SKU moved between two sites.

Net increase in SKU-site pairs reaching Optimum Stock (6–8 months). Shows absolute +Δ items and % uplift.

Distinct NUPCO codes still at zero stock at any site after full redistribution. Cannot be resolved internally — procurement escalation required.

Items at >24 months coverage post-redistribution. Tied capital with high expiry risk — review for return-to-vendor or disposal.

Triggers the redistribution algorithm on current loaded data (from Pull Data or uploaded files). Re-run after data changes to refresh all results.

Fetches the live inventory CSV directly from the COPY TO MASTER EVERY TIME R2 SCM DataBase. Parses all rows across KFMC, PMAH and R2 automatically, then runs redistribution. Sheet must be shared as Anyone with the link can view.

Scans loaded data for quality issues: missing AMU, duplicate codes, zero-price items. Results shown in the Log tab.

Resets dashboard to initial seed state. Clears all uploads and returns to the built-in sample dataset.

Real-time search by NUPCO code or description. Filters the All Transfers table as you type.

❓ Why are some Zero Stock SKUs still unresolved after running the engine?

When no site holds surplus stock (>8 months) for a given SKU, the engine cannot generate a transfer. The dashboard flags these as a Critical procurement alert. Recommended: Issue an emergency purchase request to NUPCO or explore cross-cluster sourcing from Riyadh First or Third clusters.

❓ What does the “PMAH Structural Dependency” warning mean?

PMAH receives 56.6% of all redistributed value from KFMC and R2, indicating heavy reliance on inter-facility logistics. Strategic recommendation: Increase PMAH’s standalone procurement buffers for its top 20 consumed SKUs to reduce this dependency.

❓ How do we fix “No Forecast” items?

Items with AMU = 0 or blank are invisible to the engine. Action: Engage demand planning to establish monthly consumption baselines from the last 6 months of dispensing records, then update the AMU column before next upload cycle.

❓ How should we handle items with 300+ months of coverage?

Escalation path: (1) Redistribute internally first; (2) Request inter-cluster transfer to R1 or R3; (3) Negotiate return-to-vendor with NUPCO; (4) If expired/non-returnable — initiate formal disposal per MOH guidelines.

❓ How frequently should the redistribution engine be run?

Recommended: Monthly cycle aligned with your physical inventory count. For critical therapeutics (oncology, biologics, blood products) consider bi-weekly. Always re-run immediately after a major bulk delivery to capture the updated stock position.

❓ What is “Procurement Cost Avoidance”?

Financial savings achieved by fulfilling shortages through internal transfers rather than new purchase orders. Each SAR redistributed internally avoids the full procurement cost including lead time, admin overhead, and potential price escalation.

Average Monthly Usage — units consumed per month at a facility, from dispensing records.

Example: Consuming 1,200 units of a drug over 12 months equals an AMU of 100 units/month.

National Unified Procurement Company — Saudi government body assigning unique 13-digit catalogue codes.

Example: Code 1000123456789 uniquely maps to a specific brand/packaging of 500mg Paracetamol tablets.

Stock Keeping Unit — unique inventory item by NUPCO code. Can exist across multiple sites.

Example: A single NUPCO code for a pediatric antibiotic is tracked as separate SKUs at KFMC and PMAH.

Estimated months stock will last: Current Stock ÷ AMU.

Example: 400 units in stock with an AMU of 50 units/month gives 8.0 Months of Stock (MOS) coverage.

King Fahad Medical City — largest facility in the Riyadh Second Health Cluster network.

Example: Often acts as the primary provider of excess stock due to its large central purchasing power.

Prince Mohammed Al-Awwal Hospital — highest inbound redistribution dependency in the cluster.

Example: Receives targeted stock transfers from KFMC or R2 to prevent zero-stock depletion situations.

Riyadh Second cluster warehouse — major bulk stock holder, especially for commodity consumables.

Example: Central hub holding bulk quantities of high-demand items (e.g. syringes) for the cluster.

Optimization algorithm computing transfer recommendations to equalize coverage across all cluster sites.

Example: Engine triggers a transfer of 150 units from KFMC (14.0 MOS) to PMAH (1.0 MOS) to balance coverage to 8.0 MOS.

Clinical Service Level — % of critical shortage SKUs restored to Optimum Stock via redistribution.

Example: Restoring 90 out of 100 critical shortage drugs back to Optimum Stock level equals a 90.0% SLA.

SAR savings from fulfilling demand internally rather than issuing new procurement orders.

Example: Shifting 2,000 units of a SAR 50 drug avoids placing a new procurement order, saving SAR 100,000.

Annualized turnover rate (AMU × 12 / Avg Stock). Represents the frequency at which inventory is consumed and replaced annually. Mobilizing stagnant surplus assets via redistribution increases velocity (e.g. from 3.8x to 4.3x turns/year), preventing shelf-expiry, freeing locked-up capital, and boosting cluster-wide resource efficiency.

Example: A velocity of 4.3x means the cluster's average inventory pool is consumed and replenished 4.3 times per year.

Transfer between health clusters (e.g. R2 to Riyadh First) when internal redistribution is insufficient.

Example: Shipping excess items to Riyadh First Cluster when all R2 cluster sites are already fully stocked.