# Engineering Change Open Stock Disposition Worksheet > Source: https://netray.co/tools/engineering-change-open-stock-disposition-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer List every affected part with on-hand, WIP and on-order quantities, pick a disposition, and see the cost exposure of the change. ## Category engineering-plm ## Industry Discrete Manufacturing ## Audience - Engineering manager - Planner - Purchasing manager ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Part number **Key:** part **Type:** text #### Old rev **Key:** rev **Type:** text #### On hand **Key:** onhand **Type:** number #### In WIP **Key:** wip **Type:** number #### On order **Key:** onorder **Type:** number #### Unit cost **Key:** cost **Type:** number **Format:** currency #### Disposition **Key:** disp **Type:** select **Options:** - Use up - Rework - Scrap - Return to vendor - Cancel PO - Hold #### Total affected qty **Key:** total_qty **Type:** number **Expr:** onhand + wip + onorder #### Value at risk **Key:** exposure **Type:** number **Expr:** (onhand + wip + onorder) * cost **Format:** currency #### Owner **Key:** owner **Type:** text **Rows:** **Part:** WSH-0206 **Rev:** B **Onhand:** 4200 **Wip:** 800 **Onorder:** 5000 **Cost:** 0.04 **Disp:** Use up **Owner:** Planning **Part:** BLT-6030 **Rev:** C **Onhand:** 1500 **Wip:** 300 **Onorder:** 2000 **Cost:** 0.31 **Disp:** Cancel PO **Owner:** Purchasing **Part:** BRK-1001 **Rev:** D **Onhand:** 120 **Wip:** 40 **Onorder:** 0 **Cost:** 18.5 **Disp:** Rework **Owner:** Mfg Eng **Part:** HSG-2204 **Rev:** A **Onhand:** 36 **Wip:** 12 **Onorder:** 60 **Cost:** 142 **Disp:** Return to vendor **Owner:** Purchasing **Part:** LBL-0099 **Rev:** A **Onhand:** 900 **Wip:** 0 **Onorder:** 0 **Cost:** 0.12 **Disp:** Scrap **Owner:** Quality **Totals:** #### Total affected qty **Key:** total_qty **Agg:** sum **Format:** number #### Total value at risk **Key:** exposure **Agg:** sum **Format:** currency **Summary:** #### Average value per part **Key:** avg_exposure **Expr:** sum_exposure / count **Format:** currency #### Largest single exposure **Key:** biggest **Expr:** max_exposure **Format:** currency **Notes:** Value at risk is the total cost of every unit affected, not the write-off. The actual loss depends on the disposition chosen: use up has near zero loss, scrap loses the full value, and vendor returns depend on restocking terms. Add a column for expected recovery if your finance team needs it. ## Content **Intro:** Every released engineering change leaves old-revision stock somewhere: on the shelf, on the floor and on open purchase orders. This worksheet lists those parts, assigns a disposition and shows the value at risk before the change is cut in. **Sections:** #### How to use the worksheet **Body:** Pull the affected parts from the ECN, then add on-hand, WIP and on-order quantities from your ERP inventory and purchasing reports. Choose a disposition for each line and an owner. The calculated columns add the quantities and multiply by unit cost so you can sort by value and focus on the lines that matter first. **Bullets:** - Sort by value at risk and decide the largest lines first. - Use up is only valid if the old and new revisions are interchangeable. - Cancel open purchase orders before the supplier ships, not after. - Record the owner so each line has one person closing it. #### The disposition options **Body:** Use up consumes old stock until it runs out and then switches to the new revision, often the cheapest choice for non-critical changes. Rework brings old parts to the new revision. Scrap and return to vendor write off or recover value. Cancel PO stops inbound old parts. Hold freezes stock pending an engineering or customer decision. The right option depends on interchangeability, safety and cost. #### Reading the totals **Body:** Total value at risk is the exposure before decisions. A large number with mostly use-up lines is manageable, while the same total mostly in scrap needs management approval. Compare the figure to the benefit of the change; if the one-time cost wipes out the savings, revisit effectivity. #### Common mistakes **Body:** Forgetting WIP and open purchase orders, ignoring stock held at suppliers or in consignment, and assuming interchangeability without engineering sign-off are the main traps. Also remember spare parts stock and service kits, which are often outside the production ERP view. **Cta:** If gathering on-hand, WIP and on-order data takes hours in your ERP, we can build a read-only agent that assembles it for each ECN. **Faq:** #### What does effectivity mean for old stock? **Answer:** Effectivity defines from which date, lot, serial number or work order the new design applies. The disposition of old stock follows from it: if effectivity is at depletion, old stock is used up first. #### Who decides to scrap old inventory? **Answer:** Engineering decides whether stock is still usable, quality confirms condition and finance approves the write-off according to your policy. The change board is a good place to record the agreement. #### How do I handle stock at the supplier? **Answer:** Ask the supplier for on-hand finished goods and raw material tied to your parts, and add them as lines with a note in the owner column. Many cost surprises come from supplier-held stock. #### Can I export this to Excel? **Answer:** Yes, the worksheet exports to Excel with the calculated columns, so you can share it with purchasing and finance. ## Search terms engineering change open stock disposition, ECO inventory disposition worksheet, ECN use up or scrap inventory, engineering change inventory impact excel, obsolete stock engineering change, ECO affected parts disposition, change effectivity inventory worksheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json