# NetSuite Routing Operation Cost Worksheet > Source: https://netray.co/tools/netsuite-routing-operation-cost-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Plan routing operations before keying them into NetSuite: setup and run times, work center rates, lot size and the cost per unit of each operation. ## Category netsuite ## Erp NetSuite ## Industry Discrete Manufacturing ## Audience - Manufacturing engineer - Cost accountant - NetSuite administrator ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Op seq **Key:** seq **Type:** number **Format:** integer #### Operation **Key:** operation **Type:** text #### Work center **Key:** work_center **Type:** text #### Setup time **Key:** setup_min **Type:** number **Format:** number **Unit:** min #### Run time per unit **Key:** run_min **Type:** number **Format:** decimal **Unit:** min #### Lot size **Key:** lot **Type:** number **Format:** integer #### Rate per hour **Key:** rate **Type:** number **Format:** currency #### Cost per unit **Key:** unit_cost **Type:** number **Expr:** (setup_min / lot + run_min) / 60 * rate **Format:** currency #### Hours per lot **Key:** lot_hours **Type:** number **Expr:** (setup_min + run_min * lot) / 60 **Format:** decimal **Rows:** **Seq:** 10 **Operation:** Saw cut **Work center:** SAW-01 **Setup min:** 20 **Run min:** 1.5 **Lot:** 100 **Rate:** 55 **Seq:** 20 **Operation:** CNC mill **Work center:** CNC-03 **Setup min:** 90 **Run min:** 8.5 **Lot:** 100 **Rate:** 95 **Seq:** 30 **Operation:** Deburr **Work center:** FIN-02 **Setup min:** 10 **Run min:** 2 **Lot:** 100 **Rate:** 40 **Seq:** 40 **Operation:** Inspect **Work center:** QC-01 **Setup min:** 15 **Run min:** 1.2 **Lot:** 100 **Rate:** 60 **Seq:** 50 **Operation:** Pack **Work center:** PAC-01 **Setup min:** 5 **Run min:** 0.8 **Lot:** 100 **Rate:** 35 **Totals:** #### Total conversion cost per unit **Key:** unit_cost **Agg:** sum **Format:** currency #### Total hours per lot **Key:** lot_hours **Agg:** sum **Format:** decimal **Summary:** #### Conversion cost per lot **Key:** cost_per_lot **Expr:** sum_unit_cost * 100 **Format:** currency **Notes:** Cost per unit spreads setup time across the lot size: (setup / lot + run per unit) / 60 x rate. The lot cost summary assumes a lot of 100, so change that figure in the summary if your lot differs. Use the worksheet to prepare data before entering it as Manufacturing Routing records. ## Content **Intro:** Before routings go into NetSuite, someone has to agree the operations, times and rates. This worksheet does the arithmetic so the numbers you enter are ones you have already checked. **Sections:** #### How to use the worksheet **Body:** List each operation in sequence with its work center, setup minutes, run minutes per unit, lot size and hourly rate. The sheet works out the conversion cost per unit and the hours per lot. Compare these figures to what your manufacturing cost templates or work center rates will produce in NetSuite. Export to Excel to review with the shop floor before loading data. **Bullets:** - Use run time per single unit, in minutes - Keep lot size the same as your standard build quantity - Use fully loaded hourly rates where you cost labor and overhead together - Re-check after any change in lot size #### The formula **Body:** Cost per unit for an operation equals (setup minutes divided by lot size, plus run minutes per unit) divided by 60, multiplied by the hourly rate. Setup is a fixed cost per lot, so small lots carry far more setup per unit. For a 90-minute setup and 100-unit lot, setup adds 0.9 minutes per unit. At 10 units it adds 9 minutes per unit, which can double an operation cost. #### Where this fits in NetSuite **Body:** NetSuite manufacturing routings hold operations that point to manufacturing work centers, with setup time, run rate and a manufacturing cost template for labor and machine costs. Check how your account defines run rate and whether times are per unit or per hour of output, because the unit of measure affects how you key values. Use this worksheet as a staging area for that data. #### Common mistakes **Body:** Mixing minutes and hours, entering run time for the whole lot as if it were per unit, and using one lot size for all quoted quantities. Also compare the totals to actual labor reported on closed work orders. Large gaps usually mean the routing times are optimistic or setup is under-recorded. **Cta:** If you want routing times compared with actual work order results in your NetSuite data, Netray can discuss a read-only analysis. **Faq:** #### Does this match NetSuite standard cost? **Answer:** It gives the conversion cost arithmetic only. NetSuite standard cost also includes materials and follows your cost template and roll-up settings. Use this sheet to check the operation portion before loading. #### Should setup be divided by lot size? **Answer:** For unit costing, yes. Setup happens once per lot, so its per-unit effect depends on lot size. For capacity planning use the Hours per lot column, which keeps setup as a single block. #### Can I add overhead? **Answer:** Fold overhead into the rate column, or add a row for it. Many shops use a loaded rate per work center that includes labor, machine and overhead. #### How do I get the data into NetSuite? **Answer:** Export to Excel, arrange the columns to match your import template and test the CSV import in a sandbox first. Confirm field names and required columns against your account. ## Search terms netsuite routing worksheet, netsuite manufacturing routing template, netsuite operation cost excel, netsuite work center rate worksheet, netsuite routing setup time run time, netsuite manufacturing cost template, routing cost calculation excel, netsuite routing import preparation --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json