# Business Central Routing and Production BOM Cost Worksheet > Source: https://netray.co/tools/business-central-routing-and-bom-cost-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Plan routing operations with setup time, run time, lot size and work center rate, and see operation cost per unit before you set up routings in BC. ## Category microsoft-dynamics ## Erp Microsoft Dynamics 365 Business Central ## Industry Discrete Manufacturing ## Audience - Manufacturing engineer - BC manufacturing consultant - Cost accountant ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Operation No. **Key:** op_no **Type:** text #### Work center **Key:** work_center **Type:** text #### Description **Key:** desc **Type:** text #### Setup time (min) **Key:** setup **Type:** number **Format:** number #### Run time per unit (min) **Key:** run **Type:** number **Format:** decimal #### Lot size **Key:** lot **Type:** number **Format:** integer #### Rate per hour **Key:** rate **Type:** number **Format:** currency **Help:** Direct unit cost plus overhead for the work center #### Cost per unit **Key:** unit_cost **Type:** number **Expr:** (setup / lot + run) * rate / 60 **Format:** currency #### Cost per lot **Key:** lot_cost **Type:** number **Expr:** (setup + run * lot) * rate / 60 **Format:** currency **Rows:** **Op no:** 10 **Work center:** SAW-01 **Desc:** Cut bar stock **Setup:** 15 **Run:** 0.8 **Lot:** 200 **Rate:** 48 **Op no:** 20 **Work center:** CNC-LATHE-02 **Desc:** Turn and drill **Setup:** 45 **Run:** 3.5 **Lot:** 200 **Rate:** 85 **Op no:** 30 **Work center:** DEBURR-01 **Desc:** Deburr and clean **Setup:** 5 **Run:** 0.6 **Lot:** 200 **Rate:** 38 **Op no:** 40 **Work center:** INSP-01 **Desc:** Final inspection **Setup:** 10 **Run:** 0.5 **Lot:** 200 **Rate:** 55 **Totals:** #### Total operation cost per unit **Key:** unit_cost **Agg:** sum **Format:** currency #### Total cost per lot **Key:** lot_cost **Agg:** sum **Format:** currency #### Total setup minutes **Key:** setup **Agg:** sum **Format:** number **Summary:** #### Total run minutes per unit **Key:** run_total **Expr:** sum_run **Format:** decimal #### Average cost per operation **Key:** avg_op **Expr:** sum_unit_cost / count **Format:** currency **Primary:** true **Notes:** Cost per unit = (setup / lot size + run time per unit) x hourly rate / 60. This excludes scrap, material and subcontract cost; add those in your BC cost roll-up. Rates should match the work center unit cost you plan to enter in BC. ## Content **Intro:** Before you enter routings in Business Central, work out the numbers in a sheet. This worksheet computes the cost per unit and per lot for each operation from setup time, run time, lot size and work center rate, then totals the routing. **Sections:** #### How to use it **Body:** Add one row per routing operation. Enter the work center code, setup time and run time per unit in minutes, the lot size and the hourly rate for the work center. The sheet shows cost per unit and per lot, and totals the routing. Change the lot size in a row to see how setup is amortised: small lots make setup dominate the unit cost, large lots make run time dominate. #### How it maps to Business Central **Body:** In BC a routing is a header with routing lines, each line pointing to a work center or machine center and carrying setup time, run time, wait time and move time with their units of measure. Work centers hold the unit cost, overhead rate and capacity. A production BOM holds the component lines; the routing holds the operations. When you certify both and attach them to the item, the standard cost roll-up combines material, capacity and overhead cost. This sheet reproduces the capacity part so you can check the result. **Bullets:** - Run time in BC is per unit of the routing base quantity, so confirm the unit of measure - Wait time and move time affect lead time but not capacity cost - Scrap percentages increase material and capacity needs #### Reading the results **Body:** Compare cost per unit across operations to find the expensive steps. In the example, turning dominates because both the run time and rate are high. If one operation has a large setup, look at lot size or setup reduction before negotiating rates. Use the total per lot to sanity check against the standard cost you expect on the item card. #### Common mistakes **Body:** Mixing minutes and hours is the most common error; BC stores a unit of measure per time field, so verify each. Another mistake is entering a rate that includes only direct labour when the work center should carry overhead as well, understating the standard cost. Also remember that capacity constraints and calendars affect scheduling, which this sheet does not model. **Cta:** Netray can compare planned routings against actual capacity ledger data in your ERP and flag drift. Ask if you want routing accuracy reviewed. **Faq:** #### Does this replace the BC standard cost roll-up? **Answer:** No. It is a planning check for the capacity cost of routing operations. The BC roll-up also includes materials, subcontracting, scrap and overhead rules from your setup. Use this sheet to validate inputs before you certify routings. #### How should I handle machine centers and work centers? **Answer:** Treat each machine center as its own row with its own rate and times if cost differs. Work centers group machine centers and capacity. Use whichever level your routing lines reference in Business Central. #### What lot size should I use? **Answer:** Use the typical production order quantity or the lot size defined for planning. Setup cost per unit depends on it, so test a few values to see sensitivity. Costing in BC uses the routing quantity logic in your cost setup. #### Can I include scrap? **Answer:** Add scrap as an adjustment outside this sheet or increase run time to reflect yield loss. In BC you can set scrap percent on routing lines and BOM lines; it increases required quantities and affects expected cost. ## Search terms business central routing template, business central production bom excel, business central routing cost calculation, dynamics 365 business central manufacturing setup, work center rate worksheet, business central setup time run time --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json