# Shop Resource Capacity and Load Calculator for Infor VISUAL > Source: https://netray.co/tools/visual-shop-resource-capacity-load-calculator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Find available capacity hours, load percentage and the number of machines needed for a work center, plus an efficiency sweep. ## Category mes-shop-floor ## Erp Infor VISUAL ## Audience - Production scheduler - Plant manager - Industrial engineer ## Tool **Kind:** calculator **Inputs:** #### Machines or resources in the work center **Key:** resources **Type:** number **Default:** 4 **Min:** 1 **Step:** 1 **Unit:** count #### Shifts per day **Key:** shifts **Type:** select **Default:** 2 **Options:** ##### 1 shift **Value:** 1 ##### 2 shifts **Value:** 2 ##### 3 shifts **Value:** 3 #### Hours per shift **Key:** hours_shift **Type:** number **Default:** 8 **Min:** 1 **Max:** 12 **Step:** 0.5 **Unit:** hours #### Working days per week **Key:** days **Type:** number **Default:** 5 **Min:** 1 **Max:** 7 **Step:** 1 **Unit:** days #### Efficiency **Key:** efficiency **Type:** slider **Default:** 85 **Min:** 40 **Max:** 100 **Step:** 1 **Unit:** % **Help:** Standard hours earned divided by clock hours worked. #### Planned downtime and maintenance **Key:** downtime **Type:** slider **Default:** 6 **Min:** 0 **Max:** 30 **Step:** 1 **Unit:** % #### Planned load this week **Key:** load_hours **Type:** number **Default:** 520 **Min:** 0 **Step:** 10 **Unit:** hours **Help:** Sum of setup plus run standard hours from released and planned orders. **Outputs:** #### Gross calendar hours **Key:** gross **Expr:** resources * shifts * hours_shift * days **Format:** hours #### Available standard hours **Key:** avail **Expr:** gross * (efficiency / 100) * (1 - downtime / 100) **Format:** hours **Primary:** true #### Load percentage **Key:** load_pct **Expr:** load_hours / avail * 100 **Format:** percent **Primary:** true #### Overload (hours) **Key:** gap **Expr:** max(0, load_hours - avail) **Format:** hours #### Available hours per resource **Key:** per_res **Expr:** avail / resources **Format:** hours #### Resources needed to carry the load **Key:** need_res **Expr:** ceil(load_hours / per_res) **Format:** integer **Chart:** #### Load percentage vs efficiency **Type:** line **X:** efficiency **From:** 50 **To:** 100 **Steps:** 26 **Series:** - load_pct **Disclaimer:** A planning aid only. Real capacity depends on routing mix, tooling, labor skills and bottleneck sequencing. ## Content **Intro:** Load against capacity is the first check a scheduler makes before promising dates. This calculator turns shift pattern, efficiency and downtime into available standard hours and compares them with the load from your work orders. **Sections:** #### How to use it **Body:** Enter the number of machines, shifts, shift length and days worked. Enter efficiency and planned downtime. Then enter the load hours for the week, taken from your scheduling report or work order operations as setup plus run standard hours. The result shows available hours, load percent, overload and how many resources would carry the plan. Run it for the constraint work center first. **Bullets:** - Use standard hours, not clock hours, for load - Apply efficiency only once - Test one-shift and two-shift scenarios - Check each week of the horizon, not just the average #### The formula behind it **Body:** Gross hours are resources times shifts times hours per shift times days. Available standard hours multiply that by efficiency and by one minus planned downtime. Load percent is load hours divided by available hours. Resources needed is load divided by the available hours of a single resource, rounded up. If efficiency is the earned-hours ratio, then load measured in standard hours compares correctly with the efficiency-adjusted capacity. #### Reading the result **Body:** Loads above 100% mean finite scheduling will push orders out, or overtime and outsourcing are needed. Between about 85% and 95% the shop is tight, and any breakdown creates late orders because queues grow quickly at high utilization. The chart shows how sensitive load is to efficiency: a few points lost can tip a stable week into overload. Use it to decide whether to chase efficiency, add a shift or move work. #### Common mistakes **Body:** A common mistake is double counting efficiency, once in the standards and again in the capacity. Another is using nameplate hours and ignoring breaks, changeovers and maintenance. Planners also average load across weeks and miss peaks that cause late orders. Finally, remember the constraint can move: after you fix one overloaded center the next one becomes the limit, so repeat the check on the downstream operations. **Cta:** If you want capacity and load reported automatically from live orders in your ERP, we can build that view without changing the scheduling setup. **Faq:** #### What efficiency should I enter? **Answer:** Use measured efficiency from recent history, earned standard hours divided by clock hours. If you lack data, begin with 75% to 85% for discrete machining and adjust once you have real numbers. #### Is load percent the same as utilization? **Answer:** Not quite. Load compares planned standard hours with capacity. Utilization is how much of the time the machine was actually running. They are related but come from different data. #### How do I handle several resources with different rates? **Answer:** Run the calculator per resource group, or use the average efficiency as an approximation. For mixed routings, a detailed finite schedule is more reliable than a single ratio. #### What load is too high? **Answer:** Anything over 100% cannot be delivered in the period. Above roughly 90% queue times rise sharply, so many planners treat that as the practical ceiling for a constraint work center. ## Search terms capacity load calculator, work center capacity calculation, visual manufacturing shop resource capacity, finite scheduling capacity hours, machine utilization efficiency calculation, weekly capacity planning excel, rough cut capacity planning --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json