# EOQ and Lot Size Calculator for Infor VISUAL Parts > Source: https://netray.co/tools/visual-eoq-lot-size-setup-cost-calculator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Compute economic order quantity and see what your current lot size costs per year, with a sweep chart across lot sizes. ## Category manufacturing ## Erp Infor VISUAL ## Audience - Production planner - Buyer - Cost accountant ## Tool **Kind:** calculator **Currency:** $ **Inputs:** #### Annual demand **Key:** annual_demand **Type:** number **Default:** 12000 **Min:** 0 **Step:** 100 **Unit:** units #### Cost per order or setup **Key:** setup_cost **Type:** number **Default:** 85 **Min:** 0 **Step:** 5 **Unit:** $ **Help:** Setup labor plus machine downtime, or purchasing cost per PO. #### Unit cost **Key:** unit_cost **Type:** number **Default:** 14.5 **Min:** 0 **Step:** 0.5 **Unit:** $ #### Annual carrying cost rate **Key:** carry_pct **Type:** slider **Default:** 22 **Min:** 5 **Max:** 45 **Step:** 1 **Unit:** % **Help:** Capital, storage, insurance, obsolescence. #### Current lot size in use **Key:** current_lot **Type:** number **Default:** 500 **Min:** 1 **Step:** 50 **Unit:** units **Outputs:** #### Carrying cost per unit per year **Key:** carry_unit **Expr:** unit_cost * carry_pct / 100 **Format:** currency #### Economic order quantity **Key:** eoq **Expr:** sqrt(2 * annual_demand * setup_cost / carry_unit) **Format:** integer **Primary:** true #### Orders per year at EOQ **Key:** orders **Expr:** annual_demand / eoq **Format:** decimal #### Annual setup plus carrying cost at EOQ **Key:** tc_eoq **Expr:** annual_demand / eoq * setup_cost + eoq / 2 * carry_unit **Format:** currency #### Annual setup plus carrying cost at current lot **Key:** tc_current **Expr:** annual_demand / current_lot * setup_cost + current_lot / 2 * carry_unit **Format:** currency #### Annual saving moving to EOQ **Key:** saving **Expr:** tc_current - tc_eoq **Format:** currency **Primary:** true **Chart:** #### Annual setup plus carrying cost vs lot size **Type:** line **X:** current_lot **From:** 100 **To:** 3000 **Steps:** 30 **Series:** - tc_current **Disclaimer:** Classic EOQ assumes constant demand and instant replenishment. Treat the result as a starting point, then adjust for pack sizes, minimum buys and capacity. ## Content **Intro:** Lot size parameters sit in every VISUAL part record, and they are often left at whatever was set years ago. This tool shows the balance between setup cost and carrying cost and tells you what a different lot size is worth. **Sections:** #### How to use it **Body:** Enter annual demand, the cost of one setup or purchase order, unit cost and a carrying cost rate. Then enter the lot size currently used on the part. The tool returns the economic quantity, orders per year and the annual cost of both options. The chart sweeps the lot size so you can see the curve is flat near the minimum, which means a lot of practical rounding is cheap. **Bullets:** - Include only costs that vary with the lot - Use a realistic carrying rate, not just interest - Check the result against the machine's minimum run - Compare for A parts first, where savings matter #### The formula behind it **Body:** Total annual cost is demand divided by lot size times setup cost, plus half the lot size times annual carrying cost per unit. Setting the slope to zero gives the economic order quantity, the square root of two times demand times setup cost divided by carrying cost per unit. At that point setup cost and carrying cost are equal. Purchase price is left out because it does not change with lot size unless there are price breaks. #### Reading the result **Body:** If the saving is small, leave the lot alone. The cost curve is shallow, so a lot 20% off the optimum usually costs only a few percent more. A large saving suggests a setup cost that fell or a carrying rate that rose since the lot was last reviewed. A very high EOQ against demand can mean setup cost is overstated. Reducing setup time with SMED effort moves the optimum down far more than refining the formula does. #### Common mistakes **Body:** Teams often include fixed overhead in setup cost, which inflates lots. Others use a 10% carrying rate that ignores space, handling and obsolescence. Another trap is applying EOQ to parts with lumpy or project demand, where lot-for-lot planning is better. Remember that pack size, tooling life and shelf life can override the calculated quantity. Finally, update the setup cost when processes change, because stale values quietly distort planned orders. **Cta:** If you want lot sizes and setup costs checked across the whole part master from your ERP, we can build a read-only analysis for you. **Faq:** #### Does EOQ apply to manufactured parts? **Answer:** Yes, the same logic gives an economic run quantity when setup cost replaces ordering cost. Use the cost of one changeover. If the machine is a bottleneck, include the value of lost capacity in that cost. #### What carrying cost rate is realistic? **Answer:** Many manufacturers land between 15% and 30% a year once capital cost, storage, handling, insurance and obsolescence are counted. Use your finance team's figure when you have it. #### How do quantity discounts change this? **Answer:** Compute total cost including purchase price at each price break quantity and compare. EOQ alone ignores the price effect and can point at the wrong lot when discounts are steep. #### Should I use it for every part? **Answer:** Start with high-value or high-volume parts. For cheap low-volume parts the savings rarely justify the analysis, and a simple min and max rule is enough. ## Search terms eoq calculator, economic order quantity setup cost, visual manufacturing lot size, fixed order quantity visual part, economic run quantity calculator, lot sizing what if, setup cost carrying cost tradeoff --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json