Tool

Inventory Risk Heatmap — Item Assessment & Action Planner

An interactive item-level worksheet that helps teams score inventory criticality and supplier lead-time variability, classify items into heatmap quadrants, and capture ownerable actions (kanban, dual sourcing, safety stock policy, supplier development) with timelines and follow-up notes. Designed for monthly S&OP reviews and supplier development worklists.

Interactive Tool

Inventory Risk Heatmap - Item Assessment & Action Planner

This interactive worksheet helps you assess one inventory item at a time, place it on a risk heatmap, and record concrete actions to reduce risk while protecting on-time delivery. Score criticality and lead-time variability using the guidance below, choose a suggested quadrant, and capture ownerable actions with timelines. Save each item assessment so your team can export or review the list as a heatmap or action register during S&OP.

How to score

  • Criticality (1–5): Rate how harmful a stockout is to production or customer delivery. 1 = convenience / easy substitution. 5 = stops production or breaks a high-priority customer promise.
  • Lead-time variability (1–5): Rate supplier delivery consistency and predictability. 1 = consistently on-time and stable lead time. 5 = highly variable or unpredictable lead times.

Quadrant mapping

  • High criticality + High variability → Develop supplier / urgent actions.
  • High criticality + Low variability → Buffer (protect service, optimize safety stock or kanban).
  • Low criticality + High variability → Monitor and improve forecasting or order policies.
  • Low criticality + Low variability → Reduce inventory / consolidate or defer.

Use this form monthly in S&OP. For bulk work, consider exporting assessments and creating a heatmap visualization in your analytics tool.

Use the supplier SKU or internal part number for consistent reporting.
Optional: brief part description or function.
Rate how severe the impact of a stockout would be. Consider production stoppage, customer service level, regulatory impact, or safety.
1.0 10.0
Explain key reasons: primary process, alternative parts, customer SLA, safety impact.
Rate how consistent supplier lead times are. Use historical delivery spread, standard deviation, or OTP as inputs.
1.0 10.0
Typical lead time from order placement to receipt. Useful for safety stock calculations.
Percent of deliveries arriving within agreed lead time window. Lower values suggest higher variability.
Current inventory expressed in days of demand.
Existing policy expressed in days, if any.
Select the quadrant that best matches your scores. Use the guidance above if unsure.
Practical treatments that match the quadrant. Multiple choices are common.
Describe the action: e.g., 'Set min/max kanban for 2 cards, supplier audit to reduce lead-time by 30%, pilot dual-source with local vendor.' Be specific about deliverables.
Who is accountable for implementing and following up on the action? Use role/title if names rotate.
Expected time to complete the primary action. Shorter timelines for hot spots.
Use this to help triage S&OP focus.
Date for next review or status update. Use ISO format for consistent exports.
Links to PO history, forecast assumptions, supplier contact, audit reports, or spreadsheets.
You can explore this tool now. Sign in or create an account to save your responses and return to them later.
Sign In to Save Create an Account
Make this tool part of your work

Save a personal copy, bring it to your team, or tailor the questions and workflow to fit what you are hungry to improve.

Member customization and team collaboration are coming soon.
Discuss Ask the Librarian

Discussion

Comments and conversation will live here.