Lighting, LEDs & Electrical Fixtures worked example

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

This worked example runs the sku variant complexity numbers for a tougher week than the baseline: severity if wrong fixture variant ships of 2.5 score (1-10) instead of the typical 5 score (1-10). Score the operational risk of LED fixture SKU proliferation using a severity, occurrence, and detection framework. Helps product managers and production teams decide whether current controls are adequate for the number of active fixture variants (wattage, color temperature, optic, voltage, and finish combinations).

The inputs for this scenario

  • Severity if wrong fixture variant ships: 2.5 score (1-10) (the input this scenario stresses; the baseline uses 5)
  • How often variant mix-ups occur on the line: 4 score (1-10) (held at the documented default)
  • Difficulty of catching the wrong variant before shipment: 3 score (1-10) (held at the documented default)

Working through the calculation

  • The calculation starts from the formula this tool documents: SKU complexity risk score = severity x occurrence x detection.
  • SKU complexity risk score works out to 3.15 score at these inputs, and this is the headline figure for the scenario.
  • Variant mix-up severity works out to 2.5 score at these inputs.
  • Variant error occurrence works out to 4 score at these inputs.
  • Detection difficulty works out to 3 score at these inputs.

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 24.1% below the baseline at 3.15 score.
  • Use it during SKU rationalization reviews, new-variant introduction gates, or after a variant mix-up escape to prioritize containment. A result at this level usually justifies acting on the stressed input before touching anything else, because every other figure in the table is downstream of it.

Results at a glance

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

Run it with your numbers

  • To rerun this with your own numbers, open the live SKU Variant Complexity calculator, set severity if wrong fixture variant ships to your actual value, and adjust the remaining inputs to match your operation.

Last reviewed 2026-05-12.