Skip to content
Structured Decision Making | Part 4 of 6

Compare the Options: Weighted Result, Cost and What Could Change It

How to compare alternatives with a weighted score, cost and benefit over five years, three cases and a sensitivity check, using one make or buy example.

Three options passed the must check in the plant: a 6 kW laser cell for all 420,000 blanks (B), a 3 kW cell for the thin sheet family with thick plate purchased (C), and a framework contract with a call-off store (D). Six weighted criteria are fixed. Now the options are compared in four steps.

Step 1: the weighted result

Each option is scored from 0 to 10 against each criterion. The result is the sum of weight times score.

Option Cost 30 % Delivery 23 % Flexibility 17 % Capital 13 % Quality 10 % Effort 7 % Result
B 6 kW cell 8 9 9 3 8 3 7.40
C 3 kW cell 10 7 7 6 7 6 7.70
D Framework 8 6 4 9 5 9 6.76

C leads, but by 0.30 points. A gap that small is a reason to look at the money and at the assumptions.

Step 2: cost and benefit over the same period

Every option gets the same five years, the same discount rate of 8 percent and the same volume. Only cash that differs between the options is counted.

Option Investment EUR Per year EUR Discounted EUR
A Stay as today (reference) 0 1,757,100 7,015,600
B 6 kW cell 740,000 1,501,200 6,733,900
C 3 kW cell 310,000 1,556,700 6,525,500
D Framework 60,000 1,682,500 6,777,700

All three beat doing nothing. B has the lowest annual cost, C the lowest total. When two options are this close, the totals stop helping. The useful question is narrower: what does the extra money buy? B costs EUR 430,000 more than C and saves EUR 55,500 per year against it. That is a payback of 7.7 years on the difference, against a horizon of five. How investments are calculated in detail is a subject of its own. For the decision, this one comparison was enough.

Step 3: three cases

One expected case is a forecast. The plant added two more, each with one driver changed from year two on: growth of 15 percent, following the program of its two largest customers, and a downturn of 20 percent, the worst twelve months of the last decade.

  • Expected, 420,000 blanks: C costs EUR 8,093,500 over five years, B EUR 8,246,000, D EUR 8,472,500.
  • Growth, 483,000 blanks: C EUR 8,880,700, B EUR 8,907,200, D EUR 9,470,900.
  • Downturn, 336,000 blanks: C EUR 7,043,900, D EUR 7,140,900, B EUR 7,363,600.

C is cheapest in all three. In the downturn it lies EUR 319,700 below B, because the smaller cell carries the smaller fixed block. In growth the gap shrinks to EUR 26,500, which is inside the error of the estimates.

Step 4: what would change the ranking

The most useful output of the sheet is not the winner. It is the list of things that would have to be different for the winner to change.

  • Weights. If cost falls from 30 to 20 percent and delivery rises from 23 to 33, B reaches 7.50 against 7.40 for C. The ranking rests on how much delivery reliability is worth.
  • Thick plate price. A rise of about 11 percent makes B and C cost the same per year.

The first point is a preference. The group looked at it and kept its weights. The second is a fact that can change, so it became a price clause in the purchase agreement and a written trigger to reopen the decision.

Reading the result

All three steps point to option C, and none of them decides. They tell the decider what the choice rests on: a cost advantage that holds in every case, and a lead in the score that depends on one weight. Whether the group scored honestly is a different question. The next part is about the traps a group sets for itself.

Newsletter

One Lean idea.
Every two weeks.