Skip to content
Decision matrix (weighted / Pugh) templates

Decision Matrix — Infusion Pump Tender Evaluation

A most-economically-advantageous-tender evaluation for volumetric infusion pumps in four weighted groups (safety 35%, usability 25%, interoperability 20%, price 20%), scored 0–10 with programming steps and five-year cost measured. Bidder Y has the highest total at 7.62 but fails the dose-error-reduction must-have, so Bidder X ranks first at 7.09 of 10, 0.19 ahead of Bidder Z. Illustrative values.

Template previewDecision matrix (weighted / Pugh)
Volumetric infusion pump replacement — tender evaluationVolumetric infusion pump replacement — tender evaluationMost economically advantageous tender: quality 80%, price 20% · scored 0–10Weighted scoringScale 0–109 criteria4 options4 groupsCRITERIONWEIGHTBidder WBidder XRECOMMENDEDBidder YEXCLUDEDBidder ZPATIENT SAFETY35%8.207.856.157.95Dose-error reduction softwaremust ≥ 615.8%45% of group9758Free-flow & air-in-line protection10.5%30% of group8987Alarm design (IEC 60601-1-8)8.8%25% of group7869USABILITY25%4.207.209.406.40Steps to start a standard infusionmeasured, taps · lower is better10%40% of group14 tapsscore 011 tapsscore 69 tapsscore 1012 tapsscore 4Simulated-ward usability score15%60% of group7898INTEROPERABILITY20%7.606.806.608.60EHR auto-programming12%60% of group8679Asset tracking & remote updates8%40% of group7868PRICE20%2.005.899.003.945-year cost per channelmeasured, £ · lower is better15%75% of group£4,280score 0£3,640score 5.5£3,120score 10£3,980score 2.6Training & service cover5%25% of group8768Weighted scoreΣ weight × score, of 105.8458.4% of max7.0970.9% of max7.6276.2% of max6.8968.9% of maxRankhighest score first3rd1stexcluded2ndWeighted totalsEach bar is split into its criteria's weighted contributions (colours match the dots in the table); ranked best first.012345678910Bidder X7.0970.9%Bidder Z6.8968.9%Bidder W5.8458.4%Bidder Y7.6276.2%excluded — fails a must-haveFINDINGS & SENSITIVITYMODERATEBidder X ranks first at 7.09 of 10 (70.9%), 0.19 ahead of Bidder Z.Sensitivity (moderate): Bidder Z draws level with Bidder X if the weight on “EHR auto-programming” rises from 12% to 17.4% (+5.4points), the other weights rescaled in proportion — the smallest single-weight change that changes the winner.Bidder Z would draw level by scoring 9.24 instead of 8 on “Dose-error reduction software” — the smallest single-score change thatwould.Bidder Y is excluded — it fails a must-have (“Dose-error reduction software” is 5, must be ≥ 6), so its total of 7.62 is not ranked.Illustrative scores for fictional bidders; usability scores come from a simulated-ward trial with 24 nurses.

Make it your own.

title "Volumetric infusion pump replacement — tender evaluation"
subtitle "Most economically advantageous tender: quality 80%, price 20% · scored 0–10"
scale 0-10
note "Illustrative scores for fictional bidders; usability scores come from a simulated-ward trial with 24 nurses."

options "Bidder W" | "Bidder X" | "Bidder Y" | "Bidder Z"

group "Patient safety" weight 35%
  "Dose-error reduction software"    weight 45 must >= 6 : 9 7 5 8
  "Free-flow & air-in-line protection" weight 30         : 8 9 8 7
  "Alarm design (IEC 60601-1-8)"     weight 25           : 7 8 6 9
group "Usability" weight 25%
  "Steps to start a standard infusion" weight 40 unit "taps" lower : 14 11 9 12
  "Simulated-ward usability score"     weight 60                   : 7 8 9 8
group "Interoperability" weight 20%
  "EHR auto-programming"             weight 60 : 8 6 7 9
  "Asset tracking & remote updates"  weight 40 : 7 8 6 8
group "Price" weight 20%
  "5-year cost per channel" weight 75 unit "£" lower : 4,280 3,640 3,120 3,980
  "Training & service cover" weight 25 : 8 7 6 8