# Item Planning Parameter Review Worksheet > Source: https://netray.co/tools/item-planning-parameter-review-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Audit lot sizing, lead time and safety stock per item and see safety stock in days of cover. Edit rows and export to Excel. ## Category supply-chain ## Audience - MRP controller - Master data owner - Production planner ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Item **Key:** item **Type:** text #### Planner code **Key:** planner **Type:** text #### Lot rule **Key:** lot_rule **Type:** select **Options:** - Lot for lot - Fixed quantity - Period of supply - Min/max - Order multiple #### Lead time **Key:** lead **Type:** number **Unit:** days #### Safety stock **Key:** safety **Type:** number #### Minimum order qty **Key:** min_qty **Type:** number #### Monthly usage **Key:** monthly **Type:** number #### Safety cover **Key:** cover **Type:** number **Expr:** safety / (monthly / 30) **Format:** days #### Lead time demand **Key:** lead_cover **Type:** number **Expr:** monthly / 30 * lead **Format:** number #### Review result **Key:** status **Type:** select **Options:** - OK - Raise safety - Lower safety - Change lot rule - Check lead time **Rows:** **Item:** PN-48213 **Planner:** P02 **Lot rule:** Lot for lot **Lead:** 35 **Safety:** 40 **Min qty:** 20 **Monthly:** 160 **Status:** OK **Item:** PN-51002 **Planner:** P01 **Lot rule:** Fixed quantity **Lead:** 12 **Safety:** 0 **Min qty:** 200 **Monthly:** 220 **Status:** Raise safety **Item:** PN-60110 **Planner:** P02 **Lot rule:** Period of supply **Lead:** 21 **Safety:** 900 **Min qty:** 500 **Monthly:** 600 **Status:** Lower safety **Item:** PN-77120 **Planner:** P03 **Lot rule:** Min/max **Lead:** 28 **Safety:** 30 **Min qty:** 10 **Monthly:** 90 **Status:** Check lead time **Totals:** #### Average safety cover **Key:** cover **Agg:** avg **Format:** days #### Total lead time demand **Key:** lead_cover **Agg:** sum **Format:** number #### Total safety stock units **Key:** safety **Agg:** sum **Format:** number **Notes:** Safety cover in days = safety stock divided by daily usage (monthly usage over 30). Compare it with supplier reliability and demand variability before changing a value. Use your own policy for which cover is acceptable. ## Content **Intro:** Many MRP problems are really master data problems: a stale lead time, a lot rule nobody remembers choosing, a safety stock that was right three years ago. This worksheet gives you a structured review of the parameters planning actually uses. **Sections:** #### How to use it **Body:** Export a sample of items from your ERP, for example your top spend, your most frequent exceptions or one planner's list. Enter lot rule, lead time, safety stock, minimum order and average monthly usage. The sheet computes safety stock in days of cover and the demand during lead time. Pick a review result per item and use Excel export as the change request list for master data. **Bullets:** - Start with the items that generate the most exceptions - Compare ERP lead time with actual receipts - Record who approved each change - Re-run the sheet after a policy change #### What the numbers tell you **Body:** Safety cover well above lead time suggests excess stock; cover of a few days on an erratic item suggests exposure. Lead time demand shows how much stock flows through during the replenishment period, so a minimum order far above it signals potential overstock. These are screening tools, not decisions. A rarely used critical spare may rightly hold many months of cover, and a make-to-order item may rightly hold none. #### Mistakes and ERP notes **Body:** Avoid changing many parameters at once, since you then cannot tell which change moved the exception count. Check the MRP type in SAP (MARC fields such as lot size, planned delivery time and safety stock), the planning policy in Epicor part planning, and the order policy in SyteLine. Beware planner groups copied from old items, rounding values that silently inflate quantities, and lead times entered in the wrong unit. **Cta:** Netray can help compare ERP planning parameters against actual receipt and usage history using read-only access. **Faq:** #### How many items should I review at once? **Answer:** Start with 20 to 50 items that drive the most exceptions or spend. A small, documented change set is easier to validate than a mass update across the whole item master. #### How do I choose the right lot rule? **Answer:** Lot for lot suits expensive or low volume items; fixed quantity or minimum suits items with real setup or supplier minimums; period of supply suits regular usage. Test with your own cost data. #### Is safety cover the same as a service level? **Answer:** No. Cover in days is a simple ratio. A service level approach also uses demand variability and lead time variability. Use a safety stock calculator for that. #### Can I load the results back into the ERP? **Answer:** Export to Excel, then use your ERP's normal mass change or import tool with approval. Always test on a small set first. ## Search terms item planning parameters review, mrp master data audit template, safety stock days of cover spreadsheet, item master planning data check, lot size rule review excel, planning parameter cleanup worksheet, mrp parameter health check --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json