# Component Repair Quote Comparison Worksheet > Source: https://netray.co/tools/mro-component-repair-quote-comparison-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Compare vendor repair quotes on total landed cost including freight and downtime, with cost per warranty day and approval status, then export to Excel. ## Category aerospace-defense ## Industry Aerospace MRO ## Audience - Buyer - Component planner - Supplier quality ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Repair vendor **Key:** vendor **Type:** text #### Approval status **Key:** status **Type:** select **Options:** - Approved vendor - Pending approval - Not approved #### Repair price **Key:** price **Type:** number **Format:** currency #### Freight both ways **Key:** freight **Type:** number **Format:** currency #### Turn time (days) **Key:** tat **Type:** number #### Cost per day without part **Key:** loaner **Type:** number **Format:** currency #### Warranty (days) **Key:** warranty **Type:** number #### Total landed cost **Key:** total **Type:** number **Expr:** price + freight + tat * loaner **Format:** currency #### Cost per warranty day **Key:** per_wd **Type:** number **Expr:** total / warranty **Format:** currency #### Quote date **Key:** quoted **Type:** date **Rows:** **Vendor:** Vendor A Aerospace **Status:** Approved vendor **Price:** 18000 **Freight:** 650 **Tat:** 30 **Loaner:** 450 **Warranty:** 365 **Quoted:** 2026-10-05 **Vendor:** Vendor B Component Repair **Status:** Approved vendor **Price:** 15500 **Freight:** 900 **Tat:** 55 **Loaner:** 450 **Warranty:** 180 **Quoted:** 2026-10-06 **Vendor:** Vendor C OEM Service **Status:** Approved vendor **Price:** 24000 **Freight:** 400 **Tat:** 14 **Loaner:** 450 **Warranty:** 730 **Quoted:** 2026-10-07 **Vendor:** Vendor D Overseas Shop **Status:** Pending approval **Price:** 12000 **Freight:** 1800 **Tat:** 70 **Loaner:** 450 **Warranty:** 180 **Quoted:** 2026-10-08 **Totals:** #### Lowest total landed cost **Key:** total **Agg:** min **Format:** currency #### Average total landed cost **Key:** total **Agg:** avg **Format:** currency #### Fastest turn time (days) **Key:** tat **Agg:** min **Summary:** #### Spread between highest and lowest total **Key:** spread **Expr:** max_total - min_total **Format:** currency #### Spread as a share of lowest **Key:** spread_pct **Expr:** spread / min_total * 100 **Format:** percent **Notes:** Total landed cost = price + freight + turn days x cost per day without the part. Do not award to a vendor whose approval status is not cleared for the part number, whatever the price. ## Content **Intro:** The cheapest repair quote is rarely the cheapest repair. Turn time, freight and the length of the warranty change the real cost, and the vendor must be approved for the part. This worksheet puts every quote on the same basis and exports to Excel for your approval file. **Sections:** #### How to use the worksheet **Body:** Add one row per vendor quote. Enter the repair price, round trip freight, turn time and the cost you incur per day without the part, which could be a loaner fee or the carrying cost of a spare. Record the warranty days and the approval status. Total landed cost and cost per warranty day compute automatically, and the summary shows the spread between the best and worst offer. #### Why landed cost matters **Body:** A 12,000 dollar quote with 70 days turn time and 1,800 dollars of freight costs more than a 18,000 dollar quote that returns in 30 days once you value the days without the part. Warranty length is the other half of the story, and cost per warranty day gives a quick way to compare vendors who offer 180 days against those who offer two years. **Bullets:** - Include freight both ways and any customs or broker fees - Value turn time at a realistic daily cost - Check the quote covers test, not just evaluation - Confirm whether BER units incur an evaluation fee #### Approval and records **Body:** Only award repairs to organisations approved under your quality system and appropriate to the part and the release certificate you need. Keep the worksheet with the purchase order, and note the final choice and the reason, so the audit trail shows why a higher priced vendor was selected. #### Common mistakes **Body:** Comparing quotes from different scopes, such as test and evaluate against full overhaul, leaves you with unreliable conclusions. Another is ignoring time value when a part is on a critical path. Ask each vendor to quote the same scope and state their assumed BER handling. **Cta:** Netray can set up an agent over your purchasing history that pre-fills this worksheet with past quotes, actual turn times and BER outcomes for each vendor and part number. **Faq:** #### What daily cost should I enter? **Answer:** Use the loaner or pool fee if you rent a replacement. If you hold your own spare, use its daily carrying cost. If the aircraft is grounded, use your delay or AOG cost estimate instead. #### Why compute cost per warranty day? **Answer:** It normalises price against coverage. A slightly more expensive repair with twice the warranty may cost less per covered day, which matters for parts with a history of early removals. #### Can I add columns? **Answer:** The worksheet columns are fixed in this tool, but you can export to Excel and add your own columns such as incoterms, currency or part condition requirements. #### Does it handle different currencies? **Answer:** Convert all quotes to one currency before entering them, using the rate on the quote date, and note the rate in your file. ## Search terms repair quote comparison template, vendor repair comparison excel, component repair bid comparison, MRO vendor quote worksheet, repair vendor evaluation spreadsheet, aircraft component repair quote, total cost repair comparison, warranty cost comparison repair --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json