Lighting, LEDs & Electrical Fixtures worked example

SKU Variant Complexity with severity if wrong fixture variant ships of 13 score (1-10): a worked example

This scenario runs the sku variant complexity calculation on the strong side: severity if wrong fixture variant ships of 13 score (1-10), with every other input held at its documented default. Use this when reviewing whether your current SKU count is creating unacceptable production, inventory, or quality risk, prioritizing SKU rationalization decisions, or presenting a case for reducing variant complexity to leadership.

The inputs for this scenario

  • Severity if wrong fixture variant ships: 13 score (1-10) (raised for this scenario; the documented default is 5)
  • How often variant mix-ups occur on the line: 4 score (1-10) (unchanged)
  • Difficulty of catching the wrong variant before shipment: 3 score (1-10) (unchanged)

Working through the calculation

  • Applying the documented formula (SKU complexity risk score = severity x occurrence x detection) to the inputs above produces each figure below.
  • At this operating point the engine returns 7.35 score for sku complexity risk score, the number this scenario is built around.
  • At this operating point the engine returns 13 score for variant mix-up severity.
  • At this operating point the engine returns 4 score for variant error occurrence.
  • At this operating point the engine returns 3 score for detection difficulty.

How this compares with the baseline

  • Against the tool's baseline example, where severity if wrong fixture variant ships sits at 5 score (1-10) and the headline result is 4.15 score, this scenario comes in 77.11% above the baseline at 7.35 score.
  • Use it during SKU rationalization reviews, new-variant introduction gates, or after a variant mix-up escape to prioritize containment. Treat this as a target state: the delta against the baseline quantifies what the improvement is worth before you commit to chasing it.

Results at a glance

  • SKU complexity risk score: 7.35 score (headline result)
  • Variant mix-up severity: 13 score
  • Variant error occurrence: 4 score
  • Detection difficulty: 3 score

Run it with your numbers

  • Every input above is editable in the live SKU Variant Complexity calculator, which recalculates instantly and can be shared with the inputs intact.

Last reviewed 2026-05-12.