Stocking Advisor
Recommended reorders, excess inventory, store transfers and supplier-delay exposure with revenue protected per action.
Reorder Recommendations
15
Excess Stock SKUs
0
Weeks cover > 6
Transfer Opportunities
4
Revenue Protected
R 2 397 698
Capital in Stock
R 3.0m
Stock Cover by SKU (weeks)
Stockout Risk × Revenue Impact
Each point sized by impact (R '000)
Inventory Value by Category
Recommended Order Quantities (Top 10)
Reorder Queue
Sorted by expected revenue protected
| SKU | Product | Stock | Reorder Pt | Forecast Units | Order Qty | Revenue Protected | Priority |
|---|---|---|---|---|---|---|---|
| RICE10 | Rice 10kg | 2200 | 1848 | 6799 | 6447 | R 413k | Soon |
| CHKN2 | Frozen Chicken IQF 2kg | 1950 | 936 | 5892 | 4878 | R 368k | Urgent |
| OIL2 | Sunflower Oil 2L | 2600 | 2496 | 7588 | 7484 | R 255k | Urgent |
| MINCE1 | Mince 1kg | 1400 | 672 | 4427 | 3699 | R 170k | Soon |
| BEEF1 | Beef Stew 1kg | 950 | 456 | 3051 | 2557 | R 162k | Urgent |
| MZM2.5 | Maize Meal 2.5kg | 4100 | 2460 | 13018 | 11378 | R 146k | Soon |
| EGG18 | Eggs 18 Pack | 2300 | 828 | 7122 | 5650 | R 128k | Soon |
| FISH1 | Frozen Fish 1kg | 1050 | 630 | 3358 | 2938 | R 126k | Soon |
| BROWNB | Brown Bread Loaf | 5400 | 648 | 15930 | 11178 | R 109k | Urgent |
| WASH2 | Washing Powder 2kg | 1600 | 1728 | 4990 | 5118 | R 99k | Soon |
| SUG2 | Sugar 2kg | 2900 | 2088 | 9159 | 8347 | R 96k | Soon |
| TP18 | Toilet Paper 18 Pack | 1400 | 1680 | 4380 | 4660 | R 95k | Plan |
| DIAPERS | Baby Diapers Pack | 800 | 864 | 2471 | 2535 | R 92k | Soon |
| MILK2 | Long Life Milk 2L | 3100 | 1488 | 9730 | 8118 | R 72k | Plan |
| COFFEE200 | Instant Coffee 200g | 1300 | 1248 | 4145 | 4093 | R 67k | Plan |
Excess Stock
| SKU | Product | Excess Units | Weeks Cover | Action |
|---|
Transfer Opportunities
| From | To | SKU | Qty | Expected Benefit |
|---|---|---|---|---|
| Naledi Soweto | Naledi Tembisa | CHKN2 | 1626 | R 147k protected |
| Naledi Tembisa | Naledi Midrand | OIL2 | 2494 | R 102k protected |
| Naledi Midrand | Naledi Randburg | BEEF1 | 852 | R 65k protected |
| Naledi Randburg | Naledi Soweto | BROWNB | 3726 | R 44k protected |