Weighted evaluation criteria
Enter weights as whole numbers that total 100 and scores from 1 to 5. The CSV totals row calculates each vendor's weighted score out of 5 (SUMPRODUCT of weight and score, divided by 100). Example results: A 3.95, B 4.10, C 3.75.
| Criterion | Weight % | Vendor A (1-5) | Vendor B (1-5) | Vendor C (1-5) | Evidence / notes |
|---|---|---|---|---|---|
| Core functional fit to must-haves | 25 | 4 | 5 | 3 | C lacks multi-entity approvals |
| ERP / GL integration | 15 | 5 | 3 | 4 | B sync is nightly batch only |