# Hoshin Kanri X-Matrix Worksheet > Source: https://netray.co/tools/hoshin-kanri-x-matrix-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A table-based policy deployment worksheet: link long-term objectives to annual goals, improvement priorities, metrics and owners. ## Category manufacturing ## Industry Discrete Manufacturing ## Audience - Plant manager - COO - Continuous improvement lead ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Breakthrough objective (3-5 yr) **Key:** breakthrough **Type:** text #### Annual objective **Key:** annual **Type:** text #### Improvement priority **Key:** priority **Type:** text #### Metric **Key:** metric **Type:** text #### Owner **Key:** owner **Type:** text #### Baseline **Key:** baseline **Type:** number #### Annual target **Key:** target **Type:** number #### Current **Key:** current **Type:** number #### Gap to target **Key:** gap **Type:** number **Expr:** target - current **Format:** decimal #### Progress from baseline **Key:** progress **Type:** number **Expr:** if(eq(target, baseline), 0, (current - baseline) / (target - baseline) * 100) **Format:** percent #### Review status **Key:** review **Type:** select **Options:** - On track - Behind - Ahead - Not started **Rows:** **Breakthrough:** Zero harm workplace **Annual:** Cut recordable rate by half **Priority:** Machine guarding audit and fixes **Metric:** Recordables per year **Owner:** EHS manager **Baseline:** 8 **Target:** 4 **Current:** 6 **Review:** Behind **Breakthrough:** Customer delivery leader **Annual:** On-time delivery to 97% **Priority:** Finite scheduling at bottleneck **Metric:** On-time delivery % **Owner:** Production manager **Baseline:** 88 **Target:** 97 **Current:** 93 **Review:** On track **Breakthrough:** Customer delivery leader **Annual:** On-time delivery to 97% **Priority:** Supplier delivery performance **Metric:** Supplier on-time % **Owner:** Purchasing manager **Baseline:** 82 **Target:** 92 **Current:** 86 **Review:** Behind **Breakthrough:** Best cost position **Annual:** Reduce scrap cost by 30% **Priority:** Process capability on top 5 parts **Metric:** Scrap % of cost **Owner:** Quality manager **Baseline:** 3.5 **Target:** 2.5 **Current:** 3 **Review:** On track **Breakthrough:** Capable and engaged team **Annual:** Fill all supervisor roles internally **Priority:** Supervisor development program **Metric:** Internal fill rate % **Owner:** HR partner **Baseline:** 40 **Target:** 100 **Current:** 60 **Review:** On track **Totals:** #### Improvement priorities **Key:** priority **Agg:** count **Format:** integer #### Average progress **Key:** progress **Agg:** avg **Format:** percent **Notes:** Progress is measured from baseline to target, so it works for metrics that should go down (scrap) and up (delivery). Limit the plan to three to five breakthrough objectives. Hoshin Kanri works through catchball: owners negotiate targets up and down the organization before they are locked. ## Content **Intro:** Hoshin Kanri, or policy deployment, links a few long-term objectives to the annual priorities, metrics and owners that deliver them. This worksheet lays that out as a table you can edit and review monthly. **Sections:** #### How to use the worksheet **Body:** Start from the left. Write three to five breakthrough objectives for the next three to five years. For each, define one or two annual objectives. Then list the improvement priorities that will deliver them, with a metric, an owner, a baseline and an annual target. Update the current value monthly and mark review status. The sheet calculates the gap and progress so reviews focus on what is behind. Export to Excel for the wall display or leadership review. **Bullets:** - Three to five breakthrough objectives only - Every priority has a metric and one owner - Baseline and target must be numbers - Review monthly, not yearly #### The X-matrix idea **Body:** A traditional X-matrix is a single page with four sides: long-term objectives, annual objectives, improvement priorities and metrics, with correlation marks in the corners showing which items support which. This worksheet captures the same content in rows, which is easier to filter and calculate in Excel. A good plan has no orphans: every priority supports an objective, and every objective has at least one priority and metric. Catchball means owners discuss and adjust targets with their teams, so commitments are realistic and understood. #### Common mistakes **Body:** Plans fail when they list too many priorities, when targets are set top down without discussion, or when reviews are skipped after the first quarter. Another mistake is mixing business as usual with strategic priorities. Keep daily operations in your daily management system and use Hoshin for the few changes that matter. Make sure metrics come from a trusted source so reviews do not turn into data arguments. **Bullets:** - Do not exceed what the team can resource - Negotiate targets with owners - Keep routine work out of the plan - Use trusted data for the monthly review **Cta:** If your Hoshin metrics come from ERP and MES data, Netray can help automate a private, read-only feed so reviews start with current numbers. **Faq:** #### What is the difference between Hoshin Kanri and OKRs? **Answer:** Both cascade goals. Hoshin Kanri emphasizes a few multi-year objectives, catchball negotiation and a regular PDCA review, and is common in lean manufacturing. OKRs are typically quarterly and more flexible. Many plants use one or blend elements of both. #### How many priorities should we have? **Answer:** Keep the total to what your leaders can actively drive, usually five to ten annual priorities across three to five objectives. If everything is a priority, nothing gets focus, and the monthly review becomes a status report. #### How is progress calculated? **Answer:** Progress is (current minus baseline) divided by (target minus baseline), shown as a percent. It works whether the metric should rise or fall. If target equals baseline the formula shows zero to avoid division errors. #### How often should we review? **Answer:** Monthly at the leadership level, with a deeper quarterly review and an annual reset. Each review should ask what is behind, why and what the countermeasure is, in the PDCA sense. ## Search terms hoshin kanri template excel, x matrix template, policy deployment worksheet, hoshin planning manufacturing, strategy deployment x matrix, annual plan lean hoshin, catchball hoshin template --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json