PANACEADEMO TOUR · SIMPLY BI
SIMPLY BI

PANACEA

Supply, demand and inventory in one place — so you know exactly when each medical product will run out, and when to reorder.

Import your reports

GULF SAHAR / GSTIC MEDICAL · 4 SOURCES · XLSX
▦
Inventory
Ending_Stock_Report.xlsx
✓ 1,184 ROWS
▦
Demand
Purchasing_Documents.xlsx
✓ 612 ROWS
▦
Supply
GSTIC_PO_Tracker.xlsx
✓ 388 ROWS
▦
Products
Item_Master.xlsx
↑ MAPPING…
Column mappingAUTO-DETECTED · CONFIRM
Item Id → item_code ✓ End Stock → on_hand ✓ Nupco Delivery Date → delivery_due ✓ Ordered Quantity → demand_qty ✓ Forcast Qty as per UOM → incoming_qty ✓ ETA → incoming_eta ✓ Unit Price → unit_price ✓ UOM / Packing → uom ✓
2,184 / 2,184
DATA

Data Sources

3 sources · 4 collections● 2,184 rows synced
InventoryDemandSupply
Item IdDescriptionUOMPackingOpening Bal.PurchasesSalesEnd Stock
A102252Qcare Incontinence Pads, 200pcs/ctnCTN200 Pcs/Ctn215,6000−200215,200
A102429Incontinence Pads — N.Code 4213210100200CTN480 Pcs/Ctn1,875,5760−4801,875,096
A103096Incontinence Pads — N.Code 4213210100200CTN480 Pcs/Ctn7,762007,762
A103238Vinyl Gloves — Small (4213220304900)CTN100pcs/pkt · 10pkt12,9105,520018,430
A103239Vinyl Gloves — Medium (4213220304800)CTN100pcs/pkt · 10pkt6,95013,240−3,50016,690
A103461Bag, Plastic, Big Mouth, Pill CrusherEA50pcs/bag · 200/ctn4,2000−1,8002,400
PO No.VendorMaterial DescriptionOrderedDeliveredRemainingDelivery DueStatus
4600150380Gulf Sahar TradingBrief, Wrap-Around, Waist 44" (Mediunion)6,0009715,02916/09/2026Approved
4600151207Gulf Sahar TradingVinyl Gloves — Medium (4213220304800)14,0003,50010,50030/07/2026Approved
4600149884Gulf Sahar TradingIncontinence Pads, 480pcs/ctn2,4004801,92028/08/2026Approved
4600150992Gulf Sahar TradingBag, Pill Crusher, Disposable9,00009,00005/07/2026Partial
4600148771Gulf Sahar TradingQcare Incontinence Pads, 200pcs/ctn18,00018,000012/06/2026Closed
NUPCO CodeItemDescriptionVendorPO QtyShippedForecast QtyETDETAStatus
4214160000000A103461Bag, Pill Crusher, Big MouthMEDIUNION3803809,00006/07/2606/08/26Arrived
4213220304800A103239Vinyl Gloves — MediumMediunion HC13,24013,24010,50018/07/2614/08/26In transit
4213220304900A103238Vinyl Gloves — SmallMediunion HC5,5205,5206,00002/08/2629/08/26In transit
4213210100200A102429Incontinence Pads, 480pcs/ctnMediunion HC2,40002,40010/09/2608/10/26Booked
4213210100200A102252Qcare Incontinence Pads, 200pcs/ctnMediunion HC18,000018,00022/09/2620/10/26Booked
PLANNING

Stock-out Forecast

Horizon · Jun–Dec 2026
Predicted stock-outs (90d)
3
items reach zero
Reorder now
5
within lead time
Healthy
28
cover > 4 months
Open PO value
SAR 4.2M
incoming supply
Projected available stock — Vinyl Gloves Medium (A103239)
reorder point · 9,200 ↓ reorder by Jul 8 stock-out · early Oct Jun Jul Aug Sep Oct Nov Dec
projected on-hand with incoming supply reorder point stock-out
Critical items
Pill Crusher BagSTOCK-OUT JUL
on hand 2,4001.3 mo cover
Brief Wrap-Around 44"STOCK-OUT JUL
on hand 5,0290.8 mo cover
Vinyl Gloves MediumREORDER NOW
on hand 16,6901.8 mo cover
Vinyl Gloves SmallREORDER SOON
on hand 18,4302.9 mo cover
ItemDescriptionOn HandDemand / moIncoming (ETA)CoverStock-outStatusAction
A103461Bag, Pill Crusher2,4001,8009,000 · Aug 6 ✓1.3 moJul 2026Reorder nowPO required
B-WRAP44Brief, Wrap-Around 44"5,0296,000— forecast Sep0.8 moJul 2026Reorder nowPO required
A103239Vinyl Gloves — Medium16,6909,20010,500 · Aug 141.8 moOct 2026Reorder soonBy Jul 8
A103238Vinyl Gloves — Small18,4306,4006,000 · Aug 292.9 moNov 2026Reorder soonBy Aug 2
A102252Qcare Incontinence Pads 200215,20018,00018,000 · Oct 2011.9 mo2027Healthy—
A102429Incontinence Pads 4801,875,096195,0002,400 · Oct 89.6 mo2027Healthy—
ATTENTION

Expired Deliveries

● 6 POs overdue
Overdue purchase orders
6
past Nupco delivery date
Undelivered value at risk
SAR 1.07M
across overdue POs
Avg days overdue
34
oldest 96 days
PO No.VendorMaterialDelivery DueDays OverdueUndelivered QtyValue at RiskStatus
4600147120Gulf Sahar TradingIncontinence Pads, 480pcs/ctn18/03/2026963,400SAR 285,600Escalate
4600147998Mediunion HCVinyl Gloves — Medium02/04/2026812,100SAR 176,400Escalate
4600148540Gulf Sahar TradingBag, Pill Crusher, Disposable28/04/2026554,000SAR 240,000Chase
4600149102Mediunion HCVinyl Gloves — Small15/05/2026381,800SAR 108,000Chase
4600149557Gulf Sahar TradingQcare Incontinence Pads, 20030/05/202623900SAR 151,200Chase
4600149830Mediunion HCBrief, Wrap-Around 44"06/06/2026161,300SAR 109,200Chase
FINANCE

Cash Flow

Jun–Dec 2026● linked to PO calendar
Inflow (deliveries billed) vs Outflow (supplier payments) — SAR
Jun
Jul
Aug
Sep
Oct
Nov
Dec
inflow · billed deliveriesoutflow · supplier payments
Committed outflow (open POs)
SAR 4.20M
Advance due — 30 days
SAR 0.84M
Projected inflow — Q3
SAR 5.6M
Net position — Dec
+ SAR 1.4M
PO No.VendorNet Order ValuePayment Terms1st AdvanceFull PaymentLinked DeliveryStatus
PO-MD25-000004MEDIUNIONSAR 540,000Against B/L06/07/2606/08/26Aug 6 ✓Paid
4600150380Gulf Sahar TradingSAR 504,00030% adv · 70%due Jul 1on GRSep 16Advance due
4600151207Gulf Sahar TradingSAR 882,00030% adv · 70%due Jul 5on GRJul 30Advance due
4600149884Gulf Sahar TradingSAR 201,600Net 60—due Aug 28Aug 28Scheduled
4600150992Gulf Sahar TradingSAR 540,00050% adv · 50%paiddue Jul 5Jul 5Payment overdue

No surprise stock-outs. Reorder on time. Cash under control.

▦ → ▤

Three reports, one truth

Inventory, demand and supply spreadsheets are imported, mapped and reconciled into a single live model — no manual VLOOKUPs.

● ● ●

Red, orange, green

Every product is projected month by month. Panacea flags when it crosses the reorder point and when it hits zero, with the date to raise the PO.

↺ SAR

Deliveries & cash

Overdue deliveries surface automatically, and supplier payments line up against the PO calendar so cash is never caught short.

PANACEA · SIMPLY BI — REQUEST A DEMO ON YOUR DATA

01/14