Confectionery — SKU Stock Valuation
Per-SKU stock on hand and valuation.
| SKU | On Hand | Cost | Sell | Stock @ Cost | Stock @ Selling | Potential GP | GP % | Stock Days |
|---|---|---|---|---|---|---|---|---|
| White Bread 700g | 30 | R 12.00 | R 11.04 | 360 | 288 | -72 | -25.0% | 5 |
| Brown Bread 700g | 83 | R 19.30 | R 23.55 | 1,602 | 1,700 | 98 | 5.8% | 7 |
| UHT Milk 1L | 136 | R 26.60 | R 33.52 | 3,618 | 3,964 | 347 | 8.7% | 9 |
| Fresh Milk 2L | 189 | R 33.90 | R 44.07 | 6,407 | 7,243 | 836 | 11.5% | 9 |
| Butter 500g | 242 | R 41.20 | R 55.21 | 9,970 | 11,618 | 1,648 | 14.2% | 10 |
| Cheddar Cheese 800g | 295 | R 48.50 | R 66.93 | 14,308 | 17,169 | 2,862 | 16.7% | 10 |
| Eggs Large 18s | 348 | R 55.80 | R 79.24 | 19,418 | 23,979 | 4,560 | 19.0% | 10 |
| Bananas /kg | 401 | R 63.10 | R 74.46 | 25,303 | 25,964 | 661 | 2.5% | 10 |
| Tomatoes /kg | 454 | R 70.40 | R 85.89 | 31,962 | 33,908 | 1,946 | 5.7% | 11 |
| Onions 2kg | 507 | R 77.70 | R 97.90 | 39,394 | 43,161 | 3,767 | 8.7% | 11 |
| Apples Pink Lady 1.5kg | 560 | R 85.00 | R 110.50 | 47,600 | 53,809 | 6,209 | 11.5% | 11 |
| Potatoes 7kg | 613 | R 12.30 | R 11.32 | 7,540 | 6,034 | -1,506 | -25.0% | 11 |
| Total | 3,858 | 207,481 | 228,836 | 21,355 | 9.3% |