# Engineer to Order Machine Quote Worksheet > Source: https://netray.co/tools/engineer-to-order-machine-quote-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Line-by-line cost build-up for a one-off machine quote with a risk allowance per line and the resulting price at 20 to 35 percent gross margin. ## Category industry-templates ## Industry Industrial Machinery ## Audience - Estimator - Sales engineer - OEM project manager - Controller ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Cost item **Key:** item **Type:** text #### Category **Key:** category **Type:** select **Options:** - Engineering - Purchased parts - Fabrication - Assembly - Controls - Software - Test and FAT - Install and SAT - Freight - Contingency #### Qty or hours **Key:** qty **Type:** number #### Unit cost or rate **Key:** unit_cost **Type:** number **Format:** currency #### Base cost **Key:** ext **Type:** number **Expr:** qty * unit_cost **Format:** currency #### Risk allowance % **Key:** risk_pct **Type:** number **Unit:** % **Help:** Higher for unproven design, long lead items or new suppliers. #### Risk cost **Key:** risk_cost **Type:** number **Expr:** ext * risk_pct / 100 **Format:** currency #### Line total **Key:** total **Type:** number **Expr:** ext + risk_cost **Format:** currency **Rows:** **Item:** Mechanical design and detailing **Category:** Engineering **Qty:** 420 **Unit cost:** 95 **Risk pct:** 15 **Item:** Servo motion axes and drives **Category:** Purchased parts **Qty:** 4 **Unit cost:** 6800 **Risk pct:** 5 **Item:** Welded frame and guarding **Category:** Fabrication **Qty:** 1 **Unit cost:** 24500 **Risk pct:** 8 **Item:** Mechanical assembly labor **Category:** Assembly **Qty:** 360 **Unit cost:** 62 **Risk pct:** 10 **Item:** PLC, HMI and panel build **Category:** Controls **Qty:** 1 **Unit cost:** 31800 **Risk pct:** 6 **Item:** PLC and HMI programming **Category:** Software **Qty:** 260 **Unit cost:** 105 **Risk pct:** 20 **Item:** In-house FAT with customer witness **Category:** Test and FAT **Qty:** 80 **Unit cost:** 85 **Risk pct:** 10 **Item:** Crating, freight and rigging **Category:** Freight **Qty:** 1 **Unit cost:** 9200 **Risk pct:** 10 **Totals:** #### Base cost **Key:** ext **Agg:** sum **Format:** currency #### Risk allowance **Key:** risk_cost **Agg:** sum **Format:** currency #### Total cost with risk **Key:** total **Agg:** sum **Format:** currency **Summary:** #### Risk as percent of base cost **Key:** risk_share **Expr:** if(gt(sum_ext,0), sum_risk_cost / sum_ext * 100, 0) **Format:** percent #### Quote price at 25% gross margin **Key:** price_25 **Expr:** sum_total / 0.75 **Format:** currency **Primary:** true #### Quote price at 30% gross margin **Key:** price_30 **Expr:** sum_total / 0.70 **Format:** currency #### Quote price at 35% gross margin **Key:** price_35 **Expr:** sum_total / 0.65 **Format:** currency **Notes:** Margin is applied as a share of price (price = cost / (1 - margin)), not as a markup on cost. A 25 percent margin needs a 33 percent markup. Replace the example rows with your own and add a row per sub-assembly if you need more detail. ## Content **Intro:** An engineer to order quote is a cost estimate for a machine that does not exist yet. This worksheet lets you build it up line by line, add a risk allowance where the design or supply chain is uncertain, and see the price at the margin you target. **Sections:** #### How to use the worksheet **Body:** Start with the scope you can defend from the customer specification: engineering hours, purchased components, fabrication, assembly, controls, software, factory test, installation and freight. Enter quantity (or hours) and a unit cost or labor rate for each line. The base cost computes itself. Then set a risk allowance on every line that carries uncertainty instead of hiding one big contingency at the bottom. Add or delete rows freely, and export the sheet to Excel to attach to your internal approval. **Bullets:** - Use fully loaded labor rates, not wage rates. - Quote engineering hours from a task list, not a percentage of hardware. - Keep freight and rigging as their own line; they are often missed. - Include FAT witness time and travel if the contract requires customer witnessing. #### Why risk goes on each line **Body:** A single contingency percentage hides where the danger actually is. Software that depends on an unproven vision inspection is not the same risk as a catalog servo axis. Putting risk on each line makes the estimate auditable: a reviewer can challenge the 20 percent on programming without arguing about the whole machine. The summary shows total risk as a share of base cost. For first-of-a-kind machines a share of 8 to 15 percent is common; for repeat designs with small changes it should be lower. If your share is near zero, the estimate is probably optimistic. #### Reading the price outputs **Body:** The three price lines divide total cost by one minus the margin, which is how gross margin is defined. Compare them against the market and against your win history. If the customer budget only supports the 20 percent case, the useful conversation is about scope, not discounting: remove options, shift FAT to the customer site, or cut spares. Remember that gross margin must still cover warranty, sales commission, bank guarantees and cost of money on milestone payments, none of which are in this sheet unless you add them as lines. #### Common mistakes **Body:** The most frequent errors in ETO quoting are pricing from a similar past machine without re-checking component prices, forgetting integration and debug hours for controls, leaving out documentation and translations, and ignoring currency exposure on imported components. Another is quoting with lead-time-driven expediting costs missing. Treat the first quote as a hypothesis: once the order is won, the same lines become the project budget and should be loaded into your ERP project or job cost structure so actuals can be compared line by line. **Cta:** If your quotes live in spreadsheets while actual cost lives in the ERP, Netray can help compare quoted and actual cost by project automatically, on your own infrastructure. **Faq:** #### What is the difference between margin and markup? **Answer:** Markup is a percentage added to cost; margin is the percentage of the selling price that is profit. A 30 percent markup gives a price of 1.30 times cost and a 23 percent margin. To reach a 30 percent margin you divide cost by 0.70, which is what this worksheet does. #### How much risk allowance should I add? **Answer:** It depends on novelty. Catalog components with firm quotes may need 2 to 5 percent. New mechanical designs and software integration with unproven technology often carry 15 to 25 percent. Base the figure on your own history of overruns by category, not on a rule of thumb alone. #### Can I use this for repeat machines? **Answer:** Yes. For repeat designs, start from the last as-built cost, update component prices, reduce the risk allowances where the design is proven, and add only the engineering hours for the changes. Keep the structure identical so quotes remain comparable. #### Does the sheet handle multiple currencies? **Answer:** No, it assumes one currency. Convert imported component prices at a rate that includes a hedging or volatility buffer, or add a separate contingency line for currency exposure. You can change the currency symbol by editing the cost labels when you export to Excel. ## Search terms engineer to order quote template, ETO quote worksheet excel, custom machine cost estimate template, special machine quotation format, machine builder quote spreadsheet, ETO cost build up, capital equipment quote template, OEM project estimate worksheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json