# Site Consolidation Decision Matrix Worksheet > Source: https://netray.co/tools/site-consolidation-decision-matrix-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Compare plants or footprint options against weighted criteria such as cost, capability, labor, customers and risk. Editable and exportable. ## Category manufacturing ## Industry Discrete Manufacturing ## Audience - COO - VP Operations - Plant manager - Finance controller ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Criterion **Key:** criterion **Type:** text #### Weight (%) **Key:** weight **Type:** number **Help:** Weights should sum to 100 #### Option A score (1-5) **Key:** a **Type:** number #### Option B score (1-5) **Key:** b **Type:** number #### Option C score (1-5) **Key:** c **Type:** number #### A weighted **Key:** wa **Type:** number **Expr:** weight * a / 100 **Format:** decimal #### B weighted **Key:** wb **Type:** number **Expr:** weight * b / 100 **Format:** decimal #### C weighted **Key:** wc **Type:** number **Expr:** weight * c / 100 **Format:** decimal #### Evidence / source **Key:** evidence **Type:** text **Rows:** **Criterion:** Total landed operating cost **Weight:** 25 **A:** 3 **B:** 4 **C:** 2 **Evidence:** Finance model, 3 year **Criterion:** Process capability and equipment fit **Weight:** 20 **A:** 5 **B:** 3 **C:** 3 **Evidence:** Capability study **Criterion:** Skilled labor availability **Weight:** 15 **A:** 2 **B:** 4 **C:** 4 **Evidence:** HR market data **Criterion:** Customer proximity and lead time **Weight:** 15 **A:** 4 **B:** 3 **C:** 2 **Evidence:** Ship-to analysis **Criterion:** Transition risk and cost **Weight:** 15 **A:** 4 **B:** 2 **C:** 3 **Evidence:** Project plan **Criterion:** Capacity for growth **Weight:** 10 **A:** 3 **B:** 5 **C:** 4 **Evidence:** Facility layout **Totals:** #### Total weight (should be 100) **Key:** weight **Agg:** sum **Format:** number #### Option A total **Key:** wa **Agg:** sum **Format:** decimal #### Option B total **Key:** wb **Agg:** sum **Format:** decimal #### Option C total **Key:** wc **Agg:** sum **Format:** decimal **Notes:** Rename Options A, B and C to your plants or scenarios after export. Use the matrix to structure the discussion, then back it with a full financial model, customer and quality qualification plan, and legal and employee review. This is a decision aid, not advice on closures or labor law. ## Content **Intro:** Footprint decisions are expensive and hard to reverse. A weighted decision matrix will not make the decision for you, but it forces the team to agree on criteria and evidence before debating the answer. **Sections:** #### How to use the matrix **Body:** Define the options first, such as keep both plants, consolidate into A, or consolidate into B. Agree criteria and weights with the leadership team before anyone sees scores, so weights do not get tuned to the answer someone prefers. Score each option from 1 to 5 for every criterion and record the evidence. The weighted columns and totals update automatically. Check that weights add to 100, then review which criteria drive the gap between options. **Bullets:** - Agree weights before scoring - One evidence note per row - Add or remove rows as needed - Run a sensitivity check by changing weights #### Criteria that matter **Body:** Cost is only one dimension. Capability matters because moving a process to a plant without the equipment, certifications or know-how risks quality escapes. Labor availability and retention affect the ramp. Customer proximity affects freight and lead time. Transition risk includes qualification time, such as first article or customer PPAP approvals, dual running inventory and the risk of lost customers. Capacity for growth keeps the decision valid for several years. Add regulatory items like export controls or customer-mandated sites where relevant. #### Common mistakes **Body:** The usual errors are scoring with no data, double counting a factor in two criteria, and treating a small score difference as decisive. If two options are within about half a point, the matrix cannot separate them, so look at the financials and risks directly. Also test results by changing the top two weights. If the winner flips, the decision is sensitive and needs more analysis before commitment. **Bullets:** - Avoid scoring from opinion alone - Do not double count a factor - Test the top two weights - Include customer qualification time **Cta:** If the cost, capacity and quality data behind a footprint review live across ERPs, Netray can help consolidate it privately for analysis. **Faq:** #### How many options can I compare? **Answer:** The worksheet has three option columns. If you need more, export to Excel and copy a column. Most real footprint decisions narrow to two or three realistic scenarios after a first screening round. #### How should I set the weights? **Answer:** Have leadership discuss and agree them before scoring, and write down why. A common approach is to give cost, capability and risk the largest weights. Run a sensitivity check afterward to see whether the winner changes. #### Is a higher score always better? **Answer:** Yes for every criterion as scored, so define the scale carefully. For cost and risk, a high score means a favorable result, such as low cost or low risk. State the scale in the evidence column to avoid confusion. #### Can this be used for choosing a new location? **Answer:** Yes. Replace the criteria with site selection factors such as incentives, utilities, logistics and talent pool. The weighted scoring approach is the same for greenfield selection and for consolidation. ## Search terms plant consolidation decision matrix, site selection scoring matrix excel, manufacturing footprint analysis template, plant closure evaluation criteria, facility consolidation weighted scoring, decision matrix manufacturing location, network optimization plant comparison --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json