Plant Switch Port Budget Worksheet
Port counts are the cheapest thing to plan and the most annoying to get wrong. This worksheet gives each plant area a ports-required figure, switch count and spare capacity, so the next cell or camera does not become a project of its own.
| Area or closet | Main device types | Devices today | Growth allowance (%) | Uplink and stack ports | Ports per switch | Ports required | Switches needed | Installed capacity | Spare ports | |
|---|---|---|---|---|---|---|---|---|---|---|
87 | 2 | 96 | 9 | |||||||
25 | 3 | 36 | 11 | |||||||
38 | 2 | 48 | 10 | |||||||
21 | 1 | 24 | 3 | |||||||
26 | 2 | 48 | 22 |
Add PoE budget separately: total PoE watts per switch must cover cameras, access points and phones. Keep OT and IT on separate VLANs or switches, and record uplink speeds in your asset inventory.
Optional network inventory review
Send your completed worksheet and we will flag closets with thin spare capacity. No obligation.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Add one row per closet, cell or area. Count the wired devices that actually need a port today, including printers, scales, barcode stations, PLCs, HMIs, cameras and access points. Enter a growth allowance based on how fast that area changes, then uplink and stack ports and the port count of the switch model you use. The sheet computes required ports, number of switches, installed capacity and spare ports. Export to Excel for purchasing and as-built records.
- Walk the area, do not trust old diagrams
- Use higher growth for lines being expanded
- Keep 20 percent spare as a starting policy
The calculation
Ports required is devices times one plus the growth percentage, rounded up, plus uplink ports. Switches needed is ports required divided by ports per switch, rounded up, because you cannot buy half a switch. Installed capacity is switches times ports per switch, and spare ports is capacity minus ports required. The summary shows spare share overall, which tells you if the whole plant is running too tight.
Reading the results
A spare share under about 10 percent means almost any change will force new hardware. Very high spare means you may be over-buying. Pay attention to areas with a single switch and one uplink, which are single points of failure. In cells with PLCs, consider managed industrial switches with rings or redundancy, and plan for DIN-rail power and environment ratings rather than office-grade gear.
Common mistakes
Ignoring PoE power budgets, mixing OT and IT traffic on a flat network, forgetting ports for temporary equipment and vendor laptops, and not recording what each port connects to. Pair this sheet with a segmentation plan and a patching schedule, and update the counts whenever a line is moved or a new machine is commissioned.
Frequently Asked Questions
How many spare ports should I keep?
Many teams keep 15 to 25 percent spare per closet. Fast-changing areas like new assembly lines may need more, and static offices less. Revisit after each expansion.
Do uplinks count against the switch ports?
Yes, if uplinks use the same front-panel ports. Some switches have dedicated uplink ports. Enter only the uplink ports that consume ports from the total you are counting.
How do I plan PoE?
Add up the maximum watts of each PoE device and compare it to the switch PoE budget, not the port count. Cameras and access points can use 10 to 30 watts each, so budget can run out before ports do.
Should OT devices share switches with office devices?
Generally no. Separate switches or at least separate VLANs with controlled routing between them, in line with a segmentation approach such as the Purdue model, reduce risk and troubleshooting time.
If port, device and asset data lives in separate spreadsheets, Netray can help turn it into one searchable inventory your team can query in plain language.
Related Tools
Server Room UPS Runtime and Sizing Calculator
Check whether your UPS is sized for the ERP and MES servers it protects, how many minutes of battery you really have, and how much battery you are short of your target.
Industry TemplatesServer Room Cooling Load BTU Calculator
Add up IT load, UPS losses, people and lighting to get the heat you must remove, in BTU per hour, kW and tons, with a safety margin.
ERP OperationsERP WAN Bandwidth Sizing Calculator
Estimate the circuit size a plant or branch needs for ERP sessions, report downloads, voice and replication, with burst, overhead and utilization targets.
ERP OperationsPlant IT Change Request (CAB) Form Template
A change request form that covers scope, risk, rollback, production impact and approvals for IT changes that touch ERP, MES or shop floor systems.
More Industry Templates tools
See all- OEE Improvement A3 Charter Template
- Customer Order Change Request Form Template
- Plant Network Segmentation Checklist (Purdue Model)
- Ransomware Downtime Cost Calculator for Manufacturers
- Industrial Protocol and Plant IT TCP/UDP Ports Reference
- Plant Network VLAN and IP Addressing Plan Worksheet
- UPS Runtime and Sizing Calculator for Server Rooms
- Manufacturer Ransomware Readiness Assessment
- Manufacturing Cyber Incident Response Plan Template
Keep exploring
Free tools
- Industrial Protocol and Plant IT TCP/UDP Ports ReferenceA searchable table of default ports for industrial protocols and the IT services a plant depends on, built for firewall rule requests and conduit reviews.
- Africa Major Ports and UN/LOCODE ReferencePort names, countries, UN/LOCODE values and the inland corridors each port serves, for freight quotes, shipping master data and ERP location tables.
- OT Network Change Request Form TemplateA change request form for firewall rules, switch configs and new devices on the plant network, with risk, rollback and production safety approval.
ERP fixes and how-tos
- How to Change Division in Infor M3Change company and division in Infor M3: switch at runtime in H5, set the default in MNS150, and fix the authority problems that block a division change.
- How to Set Up Budgets and Budget vs Actual in NetSuiteCreate budgets in NetSuite by account, department, class or location, import them by CSV, and run Budget vs Actual reports to track spend against plan.
- Sage X3 Syracuse Service Won't Start: Troubleshooting GuideTroubleshoot a Sage X3 Syracuse service that will not start or serve the login page: MongoDB, ports, certificates, runtime connection and log files to check.
Guides
- Epicor vs Infor: Should You Switch ERP Platforms?Compare Epicor Kinetic vs Infor CloudSuite for manufacturing. Functional analysis, migration costs, and decision framework for switching platforms.
- Infor LN Budget Management Setup and Forecasting ConfigurationSet up budgeting and forecasting in Infor LN with budget structures, version control, budget checking rules, and integration with financial planning tools.
- Infor LN Implementation Cost: A Realistic 2026 Budget GuideInfor LN implementation cost typically runs $500K to $5M+. See budget breakdowns by phase, license-to-services ratios, and the cost drivers for 2026 projects.
Troubleshooting
- Why your vLLM server won't start, and how to diagnose the real causevLLM startup failures trace to four causes: port conflict, missing HF auth, insufficient VRAM, or unsupported architecture. Diagnose and fix each in minutes.
- Why Ollama says connection refused, and how to fix itConnection refused on port 11434 means the Ollama service is not running, bound to the wrong interface, or blocked by a firewall. Fix each case here.