# Molded Part Quote Cost Build-Up and Margin Worksheet > Source: https://netray.co/tools/molded-part-quote-cost-buildup-margin-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer One row per part: enter weight, cavities, cycle time, resin price, press rate, tool cost and target margin. The sheet builds cost per 1,000 parts, quoted price and annual gross profit. ## Category cost-finance ## Industry Plastics and Injection Molding ## Audience - Estimator - Sales engineer - Plant controller - General manager ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Part **Key:** part **Type:** text #### Annual volume **Key:** volume **Type:** number **Unit:** parts #### Part weight **Key:** part_g **Type:** number **Unit:** g #### Cavities **Key:** cav **Type:** number #### Cycle time **Key:** cycle **Type:** number **Unit:** s #### Press efficiency **Key:** oee **Type:** number **Unit:** % #### Scrap **Key:** scrap **Type:** number **Unit:** % #### Resin price **Key:** resin **Type:** number **Unit:** $/lb #### Press rate **Key:** rate **Type:** number **Unit:** $/hr **Help:** Burdened rate including labor and overhead. #### Packaging per 1,000 **Key:** pack **Type:** number **Unit:** $ #### Mold cost **Key:** mold **Type:** number **Unit:** $ #### Amortization years **Key:** years **Type:** number #### Target margin **Key:** margin **Type:** number **Unit:** % #### Resin per 1,000 **Key:** resin_k **Type:** number **Expr:** part_g / 453.592 * resin / (1 - scrap / 100) * 1000 **Format:** decimal **Unit:** $ #### Good parts per hour **Key:** pph **Type:** number **Expr:** cav * 3600 / cycle * oee / 100 **Format:** integer #### Machine per 1,000 **Key:** mach_k **Type:** number **Expr:** rate / pph * 1000 **Format:** decimal **Unit:** $ #### Tool amortization per 1,000 **Key:** tool_k **Type:** number **Expr:** mold / (volume * years) * 1000 **Format:** decimal **Unit:** $ #### Total cost per 1,000 **Key:** cost_k **Type:** number **Expr:** resin_k + mach_k + pack + tool_k **Format:** decimal **Unit:** $ #### Quoted price per 1,000 **Key:** price_k **Type:** number **Expr:** cost_k / (1 - margin / 100) **Format:** decimal **Unit:** $ #### Annual revenue **Key:** rev **Type:** number **Expr:** price_k * volume / 1000 **Format:** currency #### Annual gross profit **Key:** gp **Type:** number **Expr:** (price_k - cost_k) * volume / 1000 **Format:** currency **Rows:** **Part:** Closure cap 28 mm, HDPE **Volume:** 8000000 **Part g:** 1.9 **Cav:** 32 **Cycle:** 7.5 **Oee:** 88 **Scrap:** 1.5 **Resin:** 0.95 **Rate:** 85 **Pack:** 4 **Mold:** 185000 **Years:** 5 **Margin:** 22 **Part:** Housing cover, PP **Volume:** 250000 **Part g:** 210 **Cav:** 2 **Cycle:** 38 **Oee:** 82 **Scrap:** 3 **Resin:** 1.05 **Rate:** 70 **Pack:** 55 **Mold:** 68000 **Years:** 4 **Margin:** 25 **Part:** Bracket, ABS **Volume:** 600000 **Part g:** 38 **Cav:** 4 **Cycle:** 26 **Oee:** 85 **Scrap:** 3 **Resin:** 1.6 **Rate:** 75 **Pack:** 18 **Mold:** 54000 **Years:** 5 **Margin:** 24 **Part:** Gear, PA66 **Volume:** 400000 **Part g:** 7.5 **Cav:** 8 **Cycle:** 22 **Oee:** 84 **Scrap:** 2.5 **Resin:** 2.4 **Rate:** 72 **Pack:** 12 **Mold:** 62000 **Years:** 5 **Margin:** 26 **Part:** Connector, PBT GF30 **Volume:** 1200000 **Part g:** 2.2 **Cav:** 16 **Cycle:** 14 **Oee:** 86 **Scrap:** 2 **Resin:** 2.1 **Rate:** 68 **Pack:** 9 **Mold:** 96000 **Years:** 5 **Margin:** 27 **Totals:** #### Total annual revenue **Key:** rev **Agg:** sum **Format:** currency #### Total annual gross profit **Key:** gp **Agg:** sum **Format:** currency **Summary:** #### Blended gross margin **Key:** blend_margin **Expr:** if(gt(sum_rev, 0), sum_gp / sum_rev * 100, 0) **Format:** percent #### Parts quoted **Key:** lines **Expr:** count **Format:** integer **Notes:** Resin cost per 1,000 = part weight / 453.592 x price per lb / (1 - scrap) x 1,000. Machine cost per 1,000 = press rate / good parts per hour x 1,000. Runner weight is not included, so add it to part weight for cold runner tools. Add secondary operations, inspection and freight as extra packaging cost if they are not in the press rate. ## Content **Intro:** Quoting a molded part is a short chain: resin, press time, packaging, tool payback, then margin. Doing it for a dozen parts in a spreadsheet with mixed units is where errors creep in. This worksheet keeps the chain consistent and shows the annual revenue and gross profit for the whole quote package. **Sections:** #### How to use it **Body:** Add a row per part and fill in the white columns: annual volume, part weight (include runner share for cold runner tools), cavities, cycle time, efficiency, scrap, resin price, burdened press rate, packaging per thousand, mold cost, amortization years and target margin. The grey columns calculate resin, machine and tool cost per thousand parts, total cost, quoted price per thousand, annual revenue and gross profit. Export to Excel to send or to adjust. #### The cost chain **Body:** Resin is part weight in pounds times price, grossed up for scrap. Machine cost divides the burdened press rate by good parts per hour, where good parts per hour is cavities times 3600 over cycle time, times efficiency. Tool amortization spreads mold cost over annual volume and the years you will recover it. Add packaging, then divide by one minus target margin to get price. Margin on price, not markup on cost, is the convention used here. **Bullets:** - Price = cost / (1 - margin %) - A 25 percent margin on price equals a 33 percent markup on cost - Amortization years should match the customer's committed program life #### Reading the output **Body:** High-volume closures live on machine time and tooling; the resin line is small. Engineering resins like nylon and PBT flip it: resin dominates and a few percent of scrap matters more than a shorter cycle. Scan the cost columns to see where each part's cost actually sits, then focus your negotiation or your process work there. The blended margin tells you whether a quote package meets the plant target, even if one line is thin. #### Common mistakes **Body:** Quoting the cycle time from the mold maker's estimate instead of a proven cycle, using a press rate that excludes labor, forgetting packaging and freight, and amortizing a tool over more years than the customer commits. Also check that the press rate reflects the actual press size, not an average of the plant. **Bullets:** - Include inserts, labels, secondary operations as extra cost - Keep a resin price tied to a dated supplier quote - Re-run the sheet when the resin index moves **Cta:** Netray can build a read-only agent over your ERP that pulls actual cycle times, scrap and resin cost per part so each quote starts from real history instead of an estimate. **Faq:** #### Is the target margin a markup or a margin? **Answer:** It is margin on selling price. A 25 percent margin means gross profit is 25 percent of price, which equals a 33 percent markup on cost. Mixing the two conventions is a frequent source of underpriced quotes. #### How do I handle a cold runner? **Answer:** Add the runner weight divided by cavities to the part weight. If you grind and reuse the runner, reduce the effective weight by the regrind you can really reuse. The resin impact calculator in this set handles regrind explicitly. #### What press rate should I use? **Answer:** Use a fully burdened hourly rate for the specific press size, including operator labor, power, maintenance, depreciation and overhead. The machine hourly rate calculator can produce one if you do not have it. #### Does the sheet include profit on tooling? **Answer:** It amortizes tool cost at no markup. If you charge the customer for tooling separately, set mold cost to zero and quote the tool as its own line. ## Search terms injection molding quote worksheet, molded part cost build up, plastic part quoting excel, injection molding price calculation, how to quote injection molded parts, custom molder quote template, plastic injection part cost estimate, injection molding margin calculator --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json