# SAP MRP Order Quantity Calculator with Rounding Value > Source: https://netray.co/tools/sap-mrp-rounding-value-lot-size-calculator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Predicts the quantity MRP will propose after assembly scrap, minimum lot size, rounding value and maximum lot size, and shows the excess it creates. ## Category sap ## Erp SAP S/4HANA ## Audience - SAP MM consultant - MRP controller - Buyer ## Tool **Kind:** calculator **Inputs:** #### Net requirement **Key:** net_req **Type:** number **Default:** 1730 **Min:** 0 **Step:** 10 **Unit:** units **Help:** Shortage found by the MRP run in the planning bucket. #### Assembly scrap **Key:** scrap_pct **Type:** number **Default:** 3 **Min:** 0 **Max:** 50 **Step:** 0.5 **Unit:** % **Help:** Field Assembly scrap (%) in MRP 4, mainly for components. #### Minimum lot size **Key:** lot_min **Type:** number **Default:** 500 **Min:** 0 **Step:** 50 **Unit:** units #### Rounding value **Key:** rounding_value **Type:** number **Default:** 250 **Min:** 1 **Step:** 25 **Unit:** units **Help:** Order is rounded up to a multiple of this value, such as a pallet or box size. #### Maximum lot size **Key:** lot_max **Type:** number **Default:** 5000 **Min:** 1 **Step:** 100 **Unit:** units **Help:** Larger proposals are split into several orders. **Outputs:** #### Requirement after assembly scrap **Key:** gross **Expr:** net_req / (1 - scrap_pct / 100) **Format:** integer #### Rounded up to rounding value **Key:** rounded **Expr:** ceil(gross / rounding_value) * rounding_value **Format:** integer #### Proposed order quantity **Key:** proposed **Expr:** if(gt(net_req, 0), max(lot_min, rounded), 0) **Format:** integer **Primary:** true #### Number of proposals after splitting **Key:** orders **Expr:** ceil(proposed / lot_max) **Format:** integer #### Excess over net requirement **Key:** excess **Expr:** proposed - net_req **Format:** integer **Primary:** true #### Excess as share of requirement **Key:** excess_pct **Expr:** excess / net_req * 100 **Format:** percent **Chart:** #### Proposed quantity vs net requirement **Type:** line **X:** net_req **From:** 0 **To:** 5000 **Steps:** 50 **Series:** - proposed - gross **Disclaimer:** Simplified: SAP applies lot sizing, minimum, maximum and rounding in a defined sequence that also depends on rounding profiles and the lot size procedure. Use this to estimate, then confirm with an MRP run in a test client. ## Content **Intro:** Planners are often surprised that MRP proposes 2,000 pieces when the shortage is 1,730. The difference comes from assembly scrap, minimum lot size, rounding value and maximum lot size in the material master. This tool shows each step and the excess it creates. **Sections:** #### How to use the calculator **Body:** Enter the net requirement MRP found, the assembly scrap percentage, the minimum and maximum lot sizes and the rounding value. The calculator increases the requirement for scrap, rounds it up to a multiple of the rounding value, applies the minimum lot size and tells you how many proposals result if the maximum lot size forces splitting. The chart sweeps the net requirement so you can see the staircase created by the rounding value. **Bullets:** - Find the fields in MRP 1 and MRP 4 views - Match the rounding value to supplier pack size - Check whether a rounding profile overrides it #### Method and order of operations **Body:** Assembly scrap inflates the requirement so that the usable quantity still covers demand: gross equals net divided by one minus the scrap rate. Rounding up to a multiple takes the ceiling of gross divided by the rounding value, times the rounding value. The minimum lot size sets a floor, and the maximum lot size splits larger quantities into several orders. A requirement of 1,730 with 3 percent scrap becomes about 1,784, which rounds up to 2,000 with a rounding value of 250. #### Reading the output **Body:** Excess is the stock you create on purpose to satisfy pack sizes and minimums. Small excess on cheap items is fine. Large excess on expensive items points to a rounding value or minimum lot that is too large for the demand pattern, or a case for negotiating smaller pack sizes. If many proposals appear because of the maximum lot size, check whether that limit still reflects equipment or transport capacity. #### Common mistakes **Body:** A common mistake is setting a rounding value equal to the minimum lot, which hides real demand signals. Another is entering assembly scrap on finished goods, where it inflates dependent requirements for no reason. Also remember that rounding values in the info record or purchasing view can differ from the plant level setting. **Bullets:** - Keep one source of truth for pack sizes - Review scrap rates against actual yield - Do not apply scrap twice in BOM and material master **Cta:** Netray can compare MRP proposals with real requirements across your materials and list where rounding and minimums create the most excess stock. **Faq:** #### Where is the rounding value maintained? **Answer:** In the MRP 1 view of the material master as Rounding value (MARC-BSTRF), and optionally through a rounding profile. The info record can also hold a rounding setting for purchasing. #### What is assembly scrap in SAP MRP? **Answer:** A percentage maintained in the MRP 4 view for components. MRP increases the dependent requirement of the component so that after expected loss in assembly the right quantity is available. #### How does maximum lot size work? **Answer:** If the calculated lot is larger than the maximum, MRP splits it into several procurement proposals no larger than the maximum, with the same availability date or staggered by the lot size settings. #### Does rounding apply to all lot size procedures? **Answer:** Rounding value applies with most dynamic procedures. For fixed lot size, the fixed quantity is already the unit of procurement, and multiple lots are generated until the requirement is covered. ## Search terms sap rounding value mrp, sap minimum lot size, sap assembly scrap mrp, sap maximum lot size splitting, sap mrp order proposal quantity, sap rounding profile, mrp rounding value calculator --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json