Demand variation0%
Stock value
R$ 356,130.00
Expires within 90 days
R$ 207,090.00
Includes expired
Projected loss
R$ 100,590.50
Stock that will not be used in time
Lots that need action
11
of 20
Stock value by expiry band
Projected loss by location
- Southeast DCR$ 53,280.00
- Northeast DCR$ 24,876.50
- South DCR$ 22,434.00
Lots Sorted by projected loss
Simplified rules for demo purposes. In real life, transfers and disposal follow health regulations.
| Product | Expiry | Qty | Coverage (days) | Leftover (units) | Projected loss | Band | Suggested action | Status |
|---|---|---|---|---|---|---|---|---|
Pain reliever 500 mg box 20 AN500 · L2405 · Southeast DC | Nov 29, 2026 25 days | 4,000 | 66.7 | 2,500 | R$ 21,250.00 | Up to 30 days | Transfer 1,050 units to South DC | |
Vitamin C 1 g box 30 VC1G · L1120 · Southeast DC | Dec 19, 2026 45 days | 2,500 | 83.3 | 1,150 | R$ 21,160.00 | 31 to 60 days | Commercial action: discount or campaign | |
Healing ointment 30 g PM30 · L7203 · South DC | Jan 13, 2027 70 days | 1,500 | 150 | 800 | R$ 12,480.00 | 61 to 90 days | Commercial action: discount or campaign | |
Children's syrup 120 mL XA120 · L6612 · Northeast DC | Feb 7, 2027 95 days | 1,800 | 120 | 555 | R$ 11,821.50 | Over 90 days | Review the SKU purchase plan | |
Antibiotic 875 mg box 14 AB875 · L5501 · Southeast DC | Dec 29, 2026 55 days | 700 | 87.5 | 260 | R$ 8,320.00 | 31 to 60 days | Transfer 260 units to South DC | |
Antihistamine 10 mg box 10 AA10 · L3302 · South DC | Nov 22, 2026 18 days | 900 | 45 | 540 | R$ 6,966.00 | Up to 30 days | Transfer 410 units to Northeast DC | |
Children's syrup 120 mL XA120 · L6604 · Northeast DC | Nov 16, 2026 12 days | 450 | 30 | 270 | R$ 5,751.00 | Up to 30 days | Book the loss and plan disposal | |
Vitamin C 1 g box 30 VC1G · L1135 · Northeast DC | Nov 24, 2026 20 days | 500 | 41.7 | 260 | R$ 4,784.00 | Up to 30 days | Book the loss and plan disposal | |
Lubricant eye drops 10 mL CL10 · L8809 · South DC | Mar 4, 2027 120 days | 600 | 150 | 120 | R$ 2,988.00 | Over 90 days | Transfer 120 units to Southeast DC | |
Pain reliever 500 mg box 20 AN500 · L2401 · Southeast DC | Oct 29, 2026 expired 6 days ago | 300 | 5 | 300 | R$ 2,550.00 | Expired | Block and discard | |
Saline solution 500 mL SF500 · L0907 · Northeast DC | Oct 20, 2026 expired 15 days ago | 600 | 7.5 | 600 | R$ 2,520.00 | Expired | Block and discard | |
Lubricant eye drops 10 mL CL10 · L8801 · Southeast DC | Dec 2, 2026 28 days | 350 | 23.3 | 0 | R$ 0.00 | Up to 30 days | Monitor: demand covers the lot | |
Saline solution 500 mL SF500 · L0915 · Northeast DC | Dec 9, 2026 35 days | 2,000 | 25 | 0 | R$ 0.00 | 31 to 60 days | Monitor: demand covers the lot | |
Saline solution 500 mL SF500 · L0920 · South DC | Jan 18, 2027 75 days | 1,500 | 60 | 0 | R$ 0.00 | 61 to 90 days | Monitor: demand covers the lot | |
Lubricant eye drops 10 mL CL10 · L8806 · Southeast DC | Jan 28, 2027 85 days | 900 | 60 | 0 | R$ 0.00 | 61 to 90 days | Monitor: demand covers the lot | |
Pain reliever 500 mg box 20 AN500 · L2409 · South DC | Mar 24, 2027 140 days | 1,200 | 13.3 | 0 | R$ 0.00 | Over 90 days | Monitor: demand covers the lot | |
Vitamin C 1 g box 30 VC1G · L1128 · Southeast DC | Apr 13, 2027 160 days | 3,000 | 100 | 0 | R$ 0.00 | Over 90 days | Monitor: demand covers the lot | |
Antihistamine 10 mg box 10 AA10 · L3310 · Northeast DC | May 23, 2027 200 days | 400 | 8.9 | 0 | R$ 0.00 | Over 90 days | Monitor: demand covers the lot | |
Antibiotic 875 mg box 14 AB875 · L5507 · South DC | Jun 2, 2027 210 days | 300 | 20 | 0 | R$ 0.00 | Over 90 days | Monitor: demand covers the lot | |
Healing ointment 30 g PM30 · L7211 · South DC | Aug 31, 2027 300 days | 1,000 | 100 | 0 | R$ 0.00 | Over 90 days | Monitor: demand covers the lot |
- Up to 30 daysPain reliever 500 mg box 20L2405 · Southeast DC
- Expiry
- Nov 29, 2026 (25 days)
- Qty
- 4,000
- Coverage
- 66.7 days
- Leftover
- 2,500
- Loss
- R$ 21,250.00
- 31 to 60 daysVitamin C 1 g box 30L1120 · Southeast DC
- Expiry
- Dec 19, 2026 (45 days)
- Qty
- 2,500
- Coverage
- 83.3 days
- Leftover
- 1,150
- Loss
- R$ 21,160.00
- 61 to 90 daysHealing ointment 30 gL7203 · South DC
- Expiry
- Jan 13, 2027 (70 days)
- Qty
- 1,500
- Coverage
- 150 days
- Leftover
- 800
- Loss
- R$ 12,480.00
- Over 90 daysChildren's syrup 120 mLL6612 · Northeast DC
- Expiry
- Feb 7, 2027 (95 days)
- Qty
- 1,800
- Coverage
- 120 days
- Leftover
- 555
- Loss
- R$ 11,821.50
- 31 to 60 daysAntibiotic 875 mg box 14L5501 · Southeast DC
- Expiry
- Dec 29, 2026 (55 days)
- Qty
- 700
- Coverage
- 87.5 days
- Leftover
- 260
- Loss
- R$ 8,320.00
- Up to 30 daysAntihistamine 10 mg box 10L3302 · South DC
- Expiry
- Nov 22, 2026 (18 days)
- Qty
- 900
- Coverage
- 45 days
- Leftover
- 540
- Loss
- R$ 6,966.00
- Up to 30 daysChildren's syrup 120 mLL6604 · Northeast DC
- Expiry
- Nov 16, 2026 (12 days)
- Qty
- 450
- Coverage
- 30 days
- Leftover
- 270
- Loss
- R$ 5,751.00
- Up to 30 daysVitamin C 1 g box 30L1135 · Northeast DC
- Expiry
- Nov 24, 2026 (20 days)
- Qty
- 500
- Coverage
- 41.7 days
- Leftover
- 260
- Loss
- R$ 4,784.00
- Over 90 daysLubricant eye drops 10 mLL8809 · South DC
- Expiry
- Mar 4, 2027 (120 days)
- Qty
- 600
- Coverage
- 150 days
- Leftover
- 120
- Loss
- R$ 2,988.00
- ExpiredPain reliever 500 mg box 20L2401 · Southeast DC
- Expiry
- Oct 29, 2026 (-6 days)
- Qty
- 300
- Coverage
- 5 days
- Leftover
- 300
- Loss
- R$ 2,550.00
- ExpiredSaline solution 500 mLL0907 · Northeast DC
- Expiry
- Oct 20, 2026 (-15 days)
- Qty
- 600
- Coverage
- 7.5 days
- Leftover
- 600
- Loss
- R$ 2,520.00
- Up to 30 daysLubricant eye drops 10 mLL8801 · Southeast DC
- Expiry
- Dec 2, 2026 (28 days)
- Qty
- 350
- Coverage
- 23.3 days
- Leftover
- 0
- Loss
- R$ 0.00
- 31 to 60 daysSaline solution 500 mLL0915 · Northeast DC
- Expiry
- Dec 9, 2026 (35 days)
- Qty
- 2,000
- Coverage
- 25 days
- Leftover
- 0
- Loss
- R$ 0.00
- 61 to 90 daysSaline solution 500 mLL0920 · South DC
- Expiry
- Jan 18, 2027 (75 days)
- Qty
- 1,500
- Coverage
- 60 days
- Leftover
- 0
- Loss
- R$ 0.00
- 61 to 90 daysLubricant eye drops 10 mLL8806 · Southeast DC
- Expiry
- Jan 28, 2027 (85 days)
- Qty
- 900
- Coverage
- 60 days
- Leftover
- 0
- Loss
- R$ 0.00
- Over 90 daysPain reliever 500 mg box 20L2409 · South DC
- Expiry
- Mar 24, 2027 (140 days)
- Qty
- 1,200
- Coverage
- 13.3 days
- Leftover
- 0
- Loss
- R$ 0.00
- Over 90 daysVitamin C 1 g box 30L1128 · Southeast DC
- Expiry
- Apr 13, 2027 (160 days)
- Qty
- 3,000
- Coverage
- 100 days
- Leftover
- 0
- Loss
- R$ 0.00
- Over 90 daysAntihistamine 10 mg box 10L3310 · Northeast DC
- Expiry
- May 23, 2027 (200 days)
- Qty
- 400
- Coverage
- 8.9 days
- Leftover
- 0
- Loss
- R$ 0.00
- Over 90 daysAntibiotic 875 mg box 14L5507 · South DC
- Expiry
- Jun 2, 2027 (210 days)
- Qty
- 300
- Coverage
- 20 days
- Leftover
- 0
- Loss
- R$ 0.00
- Over 90 daysHealing ointment 30 gL7211 · South DC
- Expiry
- Aug 31, 2027 (300 days)
- Qty
- 1,000
- Coverage
- 100 days
- Leftover
- 0
- Loss
- R$ 0.00
Data
Everything runs in your browser. Nothing goes to a server.
How it works
- 1FEFO: for each SKU and location, the lot that expires first is used first.
- 2Leftover is the quantity daily demand cannot reach before expiry.
- 3Projected loss is the leftover times the unit cost.