# Subcontract and Outside Processing Cost Worksheet > Source: https://netray.co/tools/subcontract-outside-processing-cost-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Cost each outside operation with price per piece, vendor minimum charge and freight, and see the true cost per part. ## Category cost-finance ## Industry Discrete Manufacturing ## Audience - Estimator - Buyer - Controller ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Operation **Key:** op **Type:** text #### Process **Key:** process **Type:** select **Options:** - Heat treat - Anodize - Plating - Paint or powder coat - Passivation - NDT - Grinding - Other #### Vendor **Key:** vendor **Type:** text #### Lot qty **Key:** qty **Type:** number #### Price per piece **Key:** unit_price **Type:** number **Format:** currency #### Vendor minimum **Key:** min_charge **Type:** number **Format:** currency #### Freight both ways **Key:** freight **Type:** number **Format:** currency #### Lot cost **Key:** lot_cost **Type:** number **Expr:** max(qty * unit_price, min_charge) + freight **Format:** currency #### Cost per part **Key:** per_part **Type:** number **Expr:** lot_cost / qty **Format:** currency #### Lead time (days) **Key:** lead_days **Type:** number **Rows:** **Op:** Op 40 **Process:** Heat treat **Vendor:** Valley Thermal **Qty:** 100 **Unit price:** 1.8 **Min charge:** 250 **Freight:** 60 **Lead days:** 7 **Op:** Op 50 **Process:** Anodize **Vendor:** Clearline Finishing **Qty:** 100 **Unit price:** 3.4 **Min charge:** 150 **Freight:** 45 **Lead days:** 5 **Op:** Op 60 **Process:** NDT **Vendor:** Inspect Labs **Qty:** 100 **Unit price:** 6.5 **Min charge:** 400 **Freight:** 30 **Lead days:** 4 **Op:** Op 40 **Process:** Heat treat **Vendor:** Valley Thermal **Qty:** 20 **Unit price:** 1.8 **Min charge:** 250 **Freight:** 60 **Lead days:** 7 **Totals:** #### Total outside processing **Key:** lot_cost **Agg:** sum **Format:** currency #### Longest lead time **Key:** lead_days **Agg:** max **Summary:** #### Average cost per operation line **Key:** avg_lot **Expr:** sum_lot_cost / count **Format:** currency **Primary:** true **Notes:** Lot cost uses the greater of piece price times quantity and the vendor minimum, plus freight. Compare the last row to the first: the same process at 20 pieces costs far more per part because the minimum charge dominates. ## Content **Intro:** Outside processing is where small lots lose money, because minimum charges and freight do not scale with quantity. This worksheet costs each operation properly, so a 20-piece order shows its real price per part. Edit the rows and export the sheet to Excel. **Sections:** #### How to use the worksheet **Body:** Enter one row per outside operation and lot. Type the lot quantity, the vendor's price per piece, their minimum lot charge and your freight in and out. The sheet picks the larger of piece price times quantity and the minimum, adds freight, and shows lot cost and cost per part. Duplicate a row at a different quantity to see where the minimum stops mattering. Use the lead time column to find which operation sets your schedule. **Bullets:** - Add certification and test report fees as a separate row - Include packaging or masking charges in freight or price - Use the vendor's quote date in your notes #### The logic behind it **Body:** A typical special process vendor charges the greater of a per piece price or a lot minimum. Below the break point, quantity does not change the bill, so cost per part falls sharply as lots grow. The break point is the minimum divided by the piece price. In the example, the heat treat minimum of 250 at 1.80 per piece is reached at about 139 pieces, so a 100 piece lot pays the minimum. Knowing that number tells you whether to consolidate lots. #### Reading the result **Body:** Look at cost per part against your quoted price for that operation. If minimum charges drive it, consider combining orders, grouping parts that share a process, or negotiating a blanket minimum across part numbers. The longest lead time is a floor on the delivery you can promise, since outside operations usually do not overlap. For a multi-operation routing, sum the lot costs and add lead times in sequence. #### ERP notes and mistakes **Body:** In most ERPs the outside operation is a purchase order line tied to a routing step, with cost posting to work in process on receipt. Estimators often forget the second freight leg, certification charges and scrap at the vendor. Also check whether the vendor price includes masking, racking and test coupons. Record the vendor, price date and minimum in your item or vendor price master so the next estimate starts from current data. **Cta:** If outside processing quotes arrive by email, we can help extract vendor prices and minimums into your ERP so estimates use current numbers. **Faq:** #### How do I find the quantity where the vendor minimum stops mattering? **Answer:** Divide the vendor minimum charge by the price per piece. Below that quantity you pay the minimum regardless of count. Above it, the piece price rules. Use that number to decide whether to batch orders across work orders. #### Should freight be included in part cost? **Answer:** Yes if you pay for it. Include both legs when you ship to and from the vendor. Spread it over the lot for per part cost, and handle it as a landed cost allocation in the ERP where possible. #### What about scrap at the vendor? **Answer:** Add a scrap or loss allowance to the lot quantity or the price, based on history for that process. Some processes, such as plating of tight tolerance parts, lose more than others. Use actual yield data where you have it. #### Can I use this for several operations on one part? **Answer:** Yes. Enter one row per operation, then sum the lot costs. Add lead times in sequence for total delay, because outside operations normally run one after another. ## Search terms outside processing cost worksheet, subcontract cost estimate excel, heat treat plating anodize cost per part, vendor minimum charge calculator, outside operation costing template, subcontract operations quote, special process cost estimating --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json