A.E Stainless

Reorder Planner

Demand-based reordering — the spreadsheet, built in
Demo 10 Sep 2026
Demand-based reorder plan
The static reorder point doesn't move as a product gets more popular. This reads the last 30 & 90 days of sales, recomputes each item's reorder point against supplier lead time, flags the ones that have outgrown their old level — then raises the POs. No export, no pivot table.
Below reorder now
15
needs action
Reorder points gone stale
31
demand has outgrown the set level
Lines to raise
18
across 7 suppliers
Suggested order value
$33,553.60
ex GST at cost
Stock levels · 58 items
PartItemOn hand Reorder pt
static
Sold /30d Trend Suggested pt
demand-based
Incoming Order qty Supplier Status
MS-1210 RAL7035 Mild Steel Enclosure 1200Hx1000Wx400D IP55
Enclosures
0 4 12 ▲ 29% 2 — 12 BlueScope Distribution Out of stock
ACC-LCK-3PT 3-point Swing Handle Lock
Accessories
0 4stale 28 ▲ 47% 7 13 — NHP Fastener Supply Out of stock
CON-DIN1M DIN Rail 35mm — 1m length
Consumables
181 95stale 156 ▲ 35% 344 — 156 Spelsberg GmbH OK
CON-CG25 Cable Gland M25 IP68 (pk 10)
Consumables
21 63stale 68 → +10% 131 — 68 Ensto Building Systems Below reorder
ENL300220P Polycarbonate Enclosure 300Hx220Wx120D Grey Lid IP66
Enclosures
88 130stale 100 → -9% 208 61 130 Baorun Enclosure Mfg (Shanghai) Below reorder
CON-CG20 Cable Gland M20 IP68 (pk 10)
Consumables
109 65stale 71 → +12% 157 — 71 Spelsberg GmbH OK
ENL120806C Polycarbonate Enclosure 120Hx80Wx55D Clear Lid IP65
Enclosures
102 61stale 63 → +6% 132 — 63 Baorun Enclosure Mfg (Shanghai) OK
ACC-HTR50 Enclosure Anti-condensation Heater 50W
Accessories
34 19stale 28 ▲ 31% 62 — 28 Spelsberg GmbH OK
SS316-1008 316 Stainless Enclosure 1000Hx800Wx300D IP66
Enclosures
30 13stale 30 ▲ 64% 48 — 30 Rittal Asia Sourcing OK
ENL121209P Polycarbonate Enclosure 120Hx120Wx90D Grey Lid IP65
Enclosures
138 69stale 105 ▲ 31% 219 69 105 Baorun Enclosure Mfg (Shanghai) OK
ACC-MP6040 Galvanised Mounting Plate 600x400
Accessories
2 4stale 45 ▲ 48% 11 — 45 NHP Fastener Supply Below reorder
PBS-316-2 316 Stainless Push Button Station — 2 hole IP66
Enclosures
6 10stale 7 ▼ 19% 14 — 10 Ensto Building Systems Below reorder
ACC-SSK6040 Sunshield Kit 600x400
Accessories
15 6stale 82 ▲ 66% 20 — 82 NHP Fastener Supply OK
SS304-3025 304 Stainless Enclosure 300Hx250Wx150D IP66
Enclosures
5 4stale 5 ▲ 36% 8 — 5 Rittal Asia Sourcing OK
ACC-LCK-QT Quarter-turn Lock — chrome
Accessories
16 6stale 77 ▲ 58% 19 — 77 NHP Fastener Supply OK
AL-2015 Aluminium Enclosure 200Hx150Wx100D IP66
Enclosures
23 13stale 15 ▲ 15% 24 — 15 Rittal Asia Sourcing OK
TB316-2020 316 Stainless Terminal Box 200Hx200Wx120D IP66
Enclosures
5 21 10 ▼ 37% 21 — 21 Baorun Enclosure Mfg (Shanghai) Below reorder
CON-LED LED Panel Lamp 240V
Consumables
5 20 6 ▼ 36% 14 — 20 Spelsberg GmbH Below reorder
CON-DLS Door Limit Switch
Consumables
2 20 15 ▼ 36% 3 — 28 Atlas Steels (Brisbane) Below reorder
SS304-5040 304 Stainless Enclosure 500Hx400Wx200D IP66
Enclosures
21 14stale 8 ▼ 20% 18 14 — Spelsberg GmbH OK
SS304-8060 304 Stainless Enclosure 800Hx600Wx300D IP66
Enclosures
42 17stale 15 → +7% 36 — — Fibox Enclosures (Finland) OK
SS316-2020 316 Stainless Enclosure 200Hx200Wx150D IP66
Enclosures
30 12stale 8 ▼ 17% 20 — — Fibox Enclosures (Finland) OK
SS316-3030 316 Stainless Enclosure 300Hx300Wx200D IP66
Enclosures
24 10stale 8 → +0% 17 — — Baorun Enclosure Mfg (Shanghai) OK
SS316-4030 316 Stainless Enclosure 400Hx300Wx200D IP66
Enclosures
17 7stale 7 ▲ 24% 16 — — Spelsberg GmbH OK
SS316-6040 316 Stainless Enclosure 600Hx400Wx250D IP66
Enclosures
4 15stale 18 ▲ 20% 29 60 — Rittal Asia Sourcing Below reorder
SS316-6060 316 Stainless Enclosure 600Hx600Wx250D IP67
Enclosures
20 9stale 8 → +0% 13 9 — Rittal Asia Sourcing OK
PBS-316-4 316 Stainless Push Button Station — 4 hole IP66
Enclosures
44 17stale 21 ▲ 26% 41 29 — Ensto Building Systems OK
TB316-1616 316 Stainless Terminal Box 160Hx160Wx90D IP66
Enclosures
19 10stale 9 ▲ 17% 19 — — Baorun Enclosure Mfg (Shanghai) OK
AL-3025 Aluminium Enclosure 300Hx250Wx120D IP66
Enclosures
47 23stale 14 ▼ 21% 30 13 — Baorun Enclosure Mfg (Shanghai) OK
CON-CG32 Cable Gland M32 IP68 (pk 10)
Consumables
107 62stale 50 → -9% 96 — — Ensto Building Systems OK
CON-EBOND Earth Bonding Kit
Consumables
49 20stale 20 ▲ 62% 39 — — Ensto Building Systems OK
GRP-6040 GRP Enclosure 600Hx400Wx230D IP66
Enclosures
20 8stale 9 → +4% 20 — — Spelsberg GmbH OK
ACC-IDK3030 Inner Door / Escutcheon Kit 300x300
Accessories
11 4stale 3 ▲ 80% 7 — — Spelsberg GmbH OK
ENL120806P Polycarbonate Enclosure 120Hx80Wx55D Grey Lid IP65
Enclosures
112 81stale 127 ▲ 31% 244 133 — Ensto Building Systems OK
ENL160809P Polycarbonate Enclosure 160Hx80Wx90D Grey Lid IP65
Enclosures
281 133stale 118 → +2% 246 54 — Baorun Enclosure Mfg (Shanghai) OK
SS316-8060 316 Stainless Enclosure 800Hx600Wx300D IP66
Enclosures
17 7 2 ▼ 50% 5 — — Fibox Enclosures (Finland) OK
ACC-HNG316 316 Stainless External Hinge (pair)
Accessories
7 4 16 → +7% 3 — — BlueScope Distribution OK
ACC-GP2 316 Stainless Gland Plate — large
Accessories
9 4 2 ▼ 40% 1 — — BlueScope Distribution OK
ACC-GP1 316 Stainless Gland Plate — small
Accessories
10 4 27 ▲ 62% 6 10 — Atlas Steels (Brisbane) OK
AL-4030 Aluminium Enclosure 400Hx300Wx150D IP67
Enclosures
13 10 1 ▼ 85% 3 — — Fibox Enclosures (Finland) OK
CON-CT300 Cable Ties 300mm (pk 100)
Consumables
52 20 12 → +9% 24 20 — Ensto Building Systems OK
CON-DIN2M DIN Rail 35mm — 2m length
Consumables
56 20 15 ▲ 22% 3 — — Atlas Steels (Brisbane) OK
ACC-THERM Enclosure Thermostat NC
Accessories
7 4 3 → +0% 1 — — Atlas Steels (Brisbane) OK
ACC-EXH148 Exhaust Filter 148x148
Accessories
5 4 10 ▼ 32% 3 32 — NHP Fastener Supply OK
ACC-FF148 Filter Fan Unit 148Hx148W IP54
Accessories
1 4 2 ▼ 50% 1 — — Atlas Steels (Brisbane) Below reorder
ACC-FF255 Filter Fan Unit 255Hx255W IP54
Accessories
2 4 4 ▼ 20% 1 — — NHP Fastener Supply Below reorder
GRP-4030 GRP Enclosure 400Hx300Wx200D IP66
Enclosures
8 4 2 ▼ 40% 4 — — Ensto Building Systems OK
ACC-MP3030 Galvanised Mounting Plate 300x300
Accessories
6 4 6 ▲ 38% 2 — — Atlas Steels (Brisbane) OK
ACC-IDK6040 Inner Door / Escutcheon Kit 600x400
Accessories
1 4 8 → +9% 2 6 — NHP Fastener Supply Below reorder
TBMS-1212 Mild Steel Terminal Box 120Hx120Wx80D IP66
Enclosures
2 4 5 ▲ 50% 1 — — BlueScope Distribution Below reorder
ENL161209C Polycarbonate Enclosure 160Hx120Wx90D Clear Lid IP65
Enclosures
156 129 75 ▼ 25% 156 348 — Baorun Enclosure Mfg (Shanghai) OK
ENL200160P Polycarbonate Enclosure 200Hx160Wx90D Grey Lid IP66
Enclosures
360 135 63 ▼ 36% 121 213 — Ensto Building Systems OK
MS-3030 RAL7035 Mild Steel Enclosure 300Hx300Wx200D IP66
Enclosures
6 4 8 ▼ 43% 2 — — Atlas Steels (Brisbane) OK
MSX15-6040 RAL7035 Mild Steel Enclosure 600Hx400Wx200D IP66
Enclosures
5 4 5 ▲ 25% 1 — — BlueScope Distribution OK
MS-6040 RAL7035 Mild Steel Enclosure 600Hx400Wx250D IP66
Enclosures
9 4 7 ▲ 31% 2 5 — Atlas Steels (Brisbane) OK
MS-8060 RAL7035 Mild Steel Enclosure 800Hx600Wx300D IP66
Enclosures
10 4 11 ▼ 28% 2 — — BlueScope Distribution OK
ACC-RH6040 Rain Hood / Canopy 600x400
Accessories
8 4 25 ▲ 42% 6 — — NHP Fastener Supply OK
CON-WD-BLU Wiring Duct 25x40 Grey — 2m
Consumables
2 82 42 ▼ 32% 81 82 — Ensto Building Systems Below reorder