Month end pack · October 2026
Bearings, drives and fluid power. Six sites.
Figures are year to date to the end of October 2026, read straight from the general ledger. Stock positions are the current position in the system, as at 08 November 2026.
7 things in the data crossed a threshold worth a conversation. They are ordered by what they are costing, not by where they sit in the accounts. Each one opens to the lines behind it.
| Stock code | Description | Revenue | Gross profit |
|---|---|---|---|
| C-00659 | Consumables item 00659 | R 3 120 720 | R -345 000 |
| C-00655 | Consumables item 00655 | R 2 509 806 | R -291 153 |
| C-00632 | Consumables item 00632 | R 2 594 106 | R -286 669 |
| C-00681 | Consumables item 00681 | R 1 070 118 | R -179 770 |
| C-00673 | Consumables item 00673 | R 1 161 839 | R -141 982 |
| C-00653 | Consumables item 00653 | R 1 299 662 | R -118 374 |
| C-00643 | Consumables item 00643 | R 1 666 670 | R -76 528 |
| C-00642 | Consumables item 00642 | R 809 528 | R -64 399 |
| Stock code | Description | Revenue | Gross profit |
|---|---|---|---|
| F-00458 | Fasteners item 00458 | R 6 548 572 | R -207 853 |
| F-00486 | Fasteners item 00486 | R 1 432 052 | R -93 286 |
| F-00438 | Fasteners item 00438 | R 807 216 | R -72 297 |
| F-00452 | Fasteners item 00452 | R 2 209 871 | R -53 969 |
| F-00422 | Fasteners item 00422 | R 1 175 029 | R -50 658 |
| F-00476 | Fasteners item 00476 | R 814 738 | R -49 402 |
| F-00431 | Fasteners item 00431 | R 1 138 227 | R -48 130 |
| F-00475 | Fasteners item 00475 | R 545 389 | R -38 320 |
| Stock code | Description | Site | On back order | Value | In transit | Lead time |
|---|---|---|---|---|---|---|
| DC-00243 | Drive Components item 00243 | Main Plant Finished Goods | 10 821 | R 410 657 | 0 | 11 |
| DC-00243 | Drive Components item 00243 | Johannesburg DC | 8 443 | R 320 412 | 2 750 | 11 |
| F-00451 | Fasteners item 00451 | Main Plant Finished Goods | 11 789 | R 101 268 | 0 | 38 |
| F-00451 | Fasteners item 00451 | Johannesburg DC | 11 680 | R 100 331 | 0 | 38 |
| E-00544 | Electrical item 00544 | Johannesburg DC | 545 | R 26 378 | 465 | 30 |
| E-00544 | Electrical item 00544 | Main Plant Finished Goods | 444 | R 21 490 | 0 | 30 |
| HF-00045 | Hydraulic Fittings item 00045 | Johannesburg DC | 210 | R 1 224 | 0 | 9 |
| HF-00045 | Hydraulic Fittings item 00045 | Main Plant Finished Goods | 115 | R 670 | 0 | 9 |
| Stock code | Description | Value held | Days cover |
|---|---|---|---|
| E-00501 | Electrical item 00501 | R 4 472 009 | 194 |
| DC-00319 | Drive Components item 00319 | R 919 469 | 219 |
| DC-00243 | Drive Components item 00243 | R 681 709 | 223 |
| F-00458 | Fasteners item 00458 | R 662 364 | 224 |
| HF-00031 | Hydraulic Fittings item 00031 | R 618 411 | 277 |
| E-00550 | Electrical item 00550 | R 595 517 | 264 |
| E-00517 | Electrical item 00517 | R 574 760 | 292 |
| P-00586 | Pneumatics item 00586 | R 465 177 | 215 |
| B-00220 | Bearings item 00220 | R 433 165 | 191 |
| HF-00102 | Hydraulic Fittings item 00102 | R 433 035 | 202 |
| Stock code | Description | Group | Value held | Sites |
|---|---|---|---|---|
| P-00609 | Pneumatics item 00609 | PNEUMATICS | R 2 922 915 | 6 |
| P-00598 | Pneumatics item 00598 | PNEUMATICS | R 1 032 460 | 6 |
| P-00588 | Pneumatics item 00588 | PNEUMATICS | R 840 040 | 6 |
| B-00229 | Bearings item 00229 | BEARINGS | R 796 810 | 6 |
| SAG-00351 | Seals And Gaskets item 00351 | SEALS AND GASKETS | R 779 972 | 6 |
| HF-00103 | Hydraulic Fittings item 00103 | HYDRAULIC FITTINGS | R 582 307 | 6 |
| HF-00066 | Hydraulic Fittings item 00066 | HYDRAULIC FITTINGS | R 567 574 | 6 |
| HF-00018 | Hydraulic Fittings item 00018 | HYDRAULIC FITTINGS | R 449 159 | 6 |
| HF-00009 | Hydraulic Fittings item 00009 | HYDRAULIC FITTINGS | R 427 069 | 6 |
| B-00132 | Bearings item 00132 | BEARINGS | R 416 628 | 6 |
| HF-00107 | Hydraulic Fittings item 00107 | HYDRAULIC FITTINGS | R 350 621 | 6 |
| C-00698 | Consumables item 00698 | CONSUMABLES | R 344 596 | 6 |
| DC-00306 | Drive Components item 00306 | DRIVE COMPONENTS | R 301 122 | 6 |
| HF-00068 | Hydraulic Fittings item 00068 | HYDRAULIC FITTINGS | R 299 389 | 6 |
| E-00525 | Electrical item 00525 | ELECTRICAL | R 290 078 | 6 |
Built from stored period balances in the general ledger, not from re-aggregated transactions, so it agrees with what the ERP itself reports. Favourable variances are green whichever direction that is for the line.
| Month | Year to date | |||||
|---|---|---|---|---|---|---|
| R 000 | Actual | Budget | Variance | Actual | Budget | Variance |
| Revenue | 49 416 | 58 429 | -9 012 | 359 359 | 406 808 | -47 449 |
| Cost of sales | 36 833 | 42 831 | -5 998 | 267 710 | 288 966 | -21 256 |
| Gross profit | 12 583 | 15 597 | -3 014 | 91 648 | 117 842 | -26 193 |
| Gross margin | 25.5% | 26.7% | -1.2% | 25.5% | 29.0% | -3.5% |
| Employment costs | 4 071 | 4 606 | -535 | 30 173 | 32 878 | -2 705 |
| Occupancy | 1 168 | 1 380 | -212 | 8 507 | 9 296 | -789 |
| Distribution | 1 713 | 2 001 | -289 | 12 736 | 14 203 | -1 467 |
| Operations | 707 | 791 | -84 | 5 056 | 5 453 | -397 |
| Selling costs | 213 | 640 | -426 | 3 237 | 4 348 | -1 111 |
| Administration | 796 | 934 | -138 | 5 889 | 6 304 | -414 |
| Depreciation | 594 | 692 | -97 | 4 315 | 4 810 | -495 |
| Total operating expenses | 9 261 | 11 044 | -1 783 | 69 913 | 77 292 | -7 379 |
| Operating profit | 3 322 | 4 553 | -1 231 | 21 735 | 40 550 | -18 815 |
| Operating margin | 6.7% | 7.8% | -1.1% | 6.0% | 10.0% | -3.9% |
| Finance costs | 930 | 1 004 | -74 | 6 240 | 6 517 | -277 |
| Profit before tax | 2 392 | 3 549 | -1 157 | 15 495 | 34 033 | -18 538 |
Twelve trading periods of the current financial year against budget and against the same months last year.
Actual stops at October 2026, the last closed period. Hover any month for the three figures.
Gross margin by product group and turnover by site, both year to date and both excluding freight and miscellaneous charge lines, which do not belong in a margin calculation.
Year to date. Bars show gross margin percent.
Company gross margin, 25.5%
Year to date turnover, with each site's gross margin.
Share of year to date turnover by account. Concentration is not a problem until it is the only problem.
Year to date. Bars show each account's percent of turnover.
Stock is the largest number on the balance sheet and the one with the least daily attention. Three views: where it is sitting, what is not moving, and what has run out.
Stock at cost over average daily cost of sales, trailing twelve months. Cost on both sides.
Median across the sites, 67 days
No invoice in 12 months. Value at standard cost.
| Stock code | Description | Value |
|---|---|---|
| P-00609 | Pneumatics item 00609 | R 2 922 915 |
| P-00598 | Pneumatics item 00598 | R 1 032 460 |
| P-00588 | Pneumatics item 00588 | R 840 040 |
| B-00229 | Bearings item 00229 | R 796 810 |
| SAG-00351 | Seals And Gaskets item 00351 | R 779 972 |
| HF-00103 | Hydraulic Fittings item 00103 | R 582 307 |
| HF-00066 | Hydraulic Fittings item 00066 | R 567 574 |
| HF-00018 | Hydraulic Fittings item 00018 | R 449 159 |
On or below zero with open back orders against them.
| Stock code | Site | Back order | Value |
|---|---|---|---|
| DC-00243 | Main Plant Finished Goods | 10 821 | R 410 657 |
| DC-00243 | Johannesburg DC | 8 443 | R 320 412 |
| F-00451 | Main Plant Finished Goods | 11 789 | R 101 268 |
| F-00451 | Johannesburg DC | 11 680 | R 100 331 |
| E-00544 | Johannesburg DC | 545 | R 26 378 |
| E-00544 | Main Plant Finished Goods | 444 | R 21 490 |
| HF-00045 | Johannesburg DC | 210 | R 1 224 |
| HF-00045 | Main Plant Finished Goods | 115 | R 670 |
Three checks run every time the pack builds, and the result is printed whether it passes or not. A pack that cannot show the ledger agreeing with the sales ledger is an opinion.