| WEIGHTED DECISION MATRIX |
|---|
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. |
| Decision | Which forklift to buy for the warehouse (sample) |
|
| Criterion | Weight (1–5) | Weight % | Option A — Diesel 3 t | Option B — Electric 2.5 t | Option C — LPG 3 t | Option D — Used diesel | | |
| Purchase price (lower is better) | 5 | IF(N(B6)=0,"",B6/SUM($B$6:$B$17)) | 3 | 2 | 3 | 5 | | |
| Running cost per hour | 4 | IF(N(B7)=0,"",B7/SUM($B$6:$B$17)) | 2 | 5 | 3 | 2 | | |
| Lift capacity vs need | 3 | IF(N(B8)=0,"",B8/SUM($B$6:$B$17)) | 5 | 4 | 5 | 4 | | |
| Indoor use (fumes, noise) | 4 | IF(N(B9)=0,"",B9/SUM($B$6:$B$17)) | 1 | 5 | 3 | 1 | | |
| Service available nearby | 3 | IF(N(B10)=0,"",B10/SUM($B$6:$B$17)) | 4 | 3 | 4 | 2 | | |
| Warranty | 2 | IF(N(B11)=0,"",B11/SUM($B$6:$B$17)) | 4 | 4 | 3 | 1 | | |
| Resale value | 1 | IF(N(B12)=0,"",B12/SUM($B$6:$B$17)) | 3 | 3 | 3 | 2 | | |
| | IF(N(B13)=0,"",B13/SUM($B$6:$B$17)) | | | | | | |
| | IF(N(B14)=0,"",B14/SUM($B$6:$B$17)) | | | | | | |
| | IF(N(B15)=0,"",B15/SUM($B$6:$B$17)) | | | | | | |
| | IF(N(B16)=0,"",B16/SUM($B$6:$B$17)) | | | | | | |
| | IF(N(B17)=0,"",B17/SUM($B$6:$B$17)) | | | | | | |
| WEIGHTED SCORE (out of 5) | 22 | SUM(C6:C17) | IF(D5="","",ROUND(SUMPRODUCT($C$6:$C$17,D6:D17),2)) | IF(E5="","",ROUND(SUMPRODUCT($C$6:$C$17,E6:E17),2)) | IF(F5="","",ROUND(SUMPRODUCT($C$6:$C$17,F6:F17),2)) | IF(G5="","",ROUND(SUMPRODUCT($C$6:$C$17,G6:G17),2)) | | |
| Rank | | | IF(D18="","",RANK(D18,$D$18:$I$18)) | IF(E18="","",RANK(E18,$D$18:$I$18)) | IF(F18="","",RANK(F18,$D$18:$I$18)) | IF(G18="","",RANK(G18,$D$18:$I$18)) | | |
| Criteria scored 1 or less (deal-breakers?) | | | 1 | 0 | 0 | 2 | | |
|
| "Best option: "&INDEX($D$5:$I$5,MATCH(MAX($D$18:$I$18),$D$18:$I$18,0))&" — "&TEXT(MAX($D$18:$I$18),"0.00")&" of 5" | | | | | | | | |
| IF(COUNTIF($D$18:$I$18,MAX($D$18:$I$18))>1,"Tie at the top — add a criterion or adjust weights","Runner-up gap: "&TEXT(MAX($D$18:$I$18)-LARGE($D$18:$I$18,2),"0.00")) | | | | | | | | |
|
| Scores: 1 = poor, 3 = acceptable, 5 = excellent. For "lower is better" criteria (price, cost) give the cheapest option the highest score — or use the Scale sheet. |
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. |
| © Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers. |