# Component Cross Reference and Alternate Part Approval Worksheet > Source: https://netray.co/tools/component-cross-reference-approval-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Track alternate and second source parts, their approval status and the saving each could bring. Editable rows, exports to Excel. ## Category electronics ## Industry Electronics Manufacturing ## Audience - Component engineer - Electronics buyer - Supply chain planner ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Original MPN **Key:** orig **Type:** text #### Alternate MPN **Key:** alt **Type:** text #### Alternate manufacturer **Key:** alt_mfr **Type:** text #### Form fit function **Key:** fff **Type:** select **Options:** - Identical - Equivalent, needs test - Differences, engineering review - Not equivalent #### Approval status **Key:** status **Type:** select **Options:** - Proposed - Under evaluation - Approved - Rejected #### Original price **Key:** price_o **Type:** number **Format:** currency #### Alternate price **Key:** price_a **Type:** number **Format:** currency #### Saving per unit **Key:** saving **Type:** number **Expr:** price_o - price_a **Format:** currency #### Saving **Key:** saving_pct **Type:** number **Expr:** (price_o - price_a) / price_o * 100 **Format:** percent #### Annual quantity **Key:** qty **Type:** number **Unit:** pcs #### Annual benefit **Key:** annual **Type:** number **Expr:** (price_o - price_a) * qty **Format:** currency **Rows:** **Orig:** GRM188R71H104KA93D **Alt:** CL10B104KB8NNNC **Alt mfr:** Samsung Electro-Mechanics **Fff:** Identical **Status:** Approved **Price o:** 0.012 **Price a:** 0.009 **Qty:** 2400000 **Orig:** TPS54331DR **Alt:** LM2596SX-ADJ **Alt mfr:** Texas Instruments **Fff:** Differences, engineering review **Status:** Under evaluation **Price o:** 1.1 **Price a:** 1.45 **Qty:** 30000 **Orig:** RC0603FR-0710KL **Alt:** ERJ-3EKF1002V **Alt mfr:** Panasonic **Fff:** Identical **Status:** Approved **Price o:** 0.006 **Price a:** 0.007 **Qty:** 900000 **Orig:** SN74LVC1G08DBVR **Alt:** 74LVC1G08GW **Alt mfr:** Nexperia **Fff:** Equivalent, needs test **Status:** Proposed **Price o:** 0.14 **Price a:** 0.1 **Qty:** 120000 **Totals:** #### Total annual benefit **Key:** annual **Agg:** sum **Format:** currency #### Parts tracked **Key:** qty **Agg:** count **Format:** integer **Summary:** #### Average saving per unit **Key:** mean_saving **Expr:** avg_saving **Format:** currency **Notes:** Negative savings mean the alternate costs more, which can still be justified for supply security. Approval status here does not replace your formal change control: record the approved alternate in your ERP item or approved manufacturer list and update the BOM under ECN. ## Content **Intro:** Second sources protect you from shortages and allocation, but only if they are approved before the crisis. This worksheet keeps the candidate list, the approval status and the money in one table that can be exported and shared. **Sections:** #### How to use the worksheet **Body:** List the original part and each candidate alternate. Classify the form, fit and function match, then track the status through proposal, evaluation and approval. Enter both prices and the annual quantity so the sheet shows the saving per unit and the yearly benefit. Sort by status to see what engineering still needs to evaluate, or by annual benefit to prioritise the evaluations that pay back the most. Export to Excel for reviews with purchasing and engineering. **Bullets:** - Use manufacturer part numbers, not distributor numbers - Record reason for rejection in your own notes column - Negative savings are valid if supply security is the goal - Review the list every quarter against shortage data #### What form, fit and function means for components **Body:** Form is the physical package and footprint, fit is how it mounts and interfaces on the board, function is the electrical behavior over the operating range. Two parts that match on the headline specification can still differ in tolerance, temperature coefficient, startup behavior or noise. Passive parts such as capacitors may differ in DC bias derating. Treat anything other than a manufacturer-declared drop-in as requiring engineering review. #### Closing the loop in the ERP **Body:** An approved alternate that exists only in a spreadsheet does not help the buyer at 4pm on a shortage day. Once approved, load it into your item master as an approved manufacturer part, or into the alternate or substitute fields your ERP provides, and make sure purchase order and receiving checks accept it. Link the change to an ECN so the BOM and the history stay in sync. #### Common mistakes **Body:** Common mistakes include approving an alternate for one product but not recording that other products use the original, comparing price at different quantity breaks, and forgetting that a cheaper part with a longer lead time can cost more in expedite and stockout. Customers with controlled bills of materials may also require notification before you change source. **Cta:** Netray can help surface alternates already stored in your ERP and flag BOM lines with only a single approved source, for your engineers to review. **Faq:** #### How many alternates should I qualify per part? **Answer:** At least one for critical or single-source parts, especially in commodities with allocation history. For low-risk passives, an approved equivalent list is usually enough. Prioritise by risk and spend. #### Is a drop-in equivalent safe to use without testing? **Answer:** Not always. Manufacturer cross references are a good start but may be based on headline specifications. Test or review the datasheet differences for anything on a safety, timing or analog critical path. #### Do alternates need customer approval? **Answer:** It depends on your contract and industry. Aerospace, defense and medical customers often require notice or approval for component changes. Check your quality agreement before changing the source. #### Can I import this into my ERP? **Answer:** Export to Excel or CSV and map the columns to your ERP's approved manufacturer or alternate item import. Always load into a test company first and check unit of measure and packaging. ## Search terms component cross reference template, alternate part approval form, second source component tracking, approved manufacturer list excel, alternate MPN worksheet, form fit function comparison, component substitution log --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json