Skip to content
flowss
Start freeChecking your session
Decision matrix (weighted / Pugh) templates

Decision Matrix — Distribution Centre Site Selection

Four distribution-centre sites compared on modelled drive time, lease cost, labour pool and grid capacity, plus scored flood, expansion and planning risk on a 1–10 scale. Site C's 3.2 MVA supply fails the 4 MVA must-have; Site A ranks first at 7.22 of 10, 0.67 ahead of Site D, and stays ahead unless the weight on lease cost rises from 20% to 25.6%. Illustrative values.

Decision matrix (weighted / Pugh)Operations & OpsDecision matrix (weighted / Pugh) syntax docs
Template previewDecision matrix (weighted / Pugh)
Northern distribution centre — site selectionNorthern distribution centre — site selectionFour shortlisted sites, measured where possible and scored 1–10 where notWeighted scoringScale 1–107 criteria4 optionsCRITERIONWEIGHTSite A ·motorway parkRECOMMENDEDSite B ·port-sideSite C ·greenfieldEXCLUDEDSite D ·brownfieldretrofitMean drive time to storesmeasured, min · lower is better25%74 minscore 1096 minscore 181 minscore 7.188 minscore 4.3Lease and business ratesmeasured, £k/yr · lower is better20%£2,340k/yrscore 1£1,860k/yrscore 6.3£2,050k/yrscore 4.2£1,520k/yrscore 10Labour pool within 30 minutesmeasured, k people15%410 k peoplescore 10265 k peoplescore 4.1190 k peoplescore 1335 k peoplescore 6.9Grid power availablemeasured, MVA · must ≥ 4 MVA10%6.5 MVAscore 7.28 MVAscore 103.2 MVAscore 15 MVAscore 4.4Flood risk (1 = negligible)lower is better10%2613Room to expand10%6493Planning risk (1 = low)lower is better10%3572Weighted scoreΣ weight × score, of 107.2272.2% of max4.6146.1% of max5.1751.7% of max6.5565.5% of maxRankhighest score first1st3rdexcluded2ndWeighted totalsEach bar is split into its criteria's weighted contributions (colours match the dots in the table); ranked best first.012345678910Site A · motorway park7.2272.2%Site D · brownfield retrofit6.5565.5%Site B · port-side4.6146.1%Site C · greenfield5.1751.7%excluded — fails a must-haveFINDINGS & SENSITIVITYMODERATESite A · motorway park ranks first at 7.22 of 10 (72.2%), 0.67 ahead of Site D · brownfield retrofit.Sensitivity (moderate): Site D · brownfield retrofit draws level with Site A · motorway park if the weight on “Lease and businessrates” rises from 20% to 25.6% (+5.6 points), the other weights rescaled in proportion — the smallest single-weight change that changesthe winner.Site D · brownfield retrofit would draw level by scoring 9.73 instead of 3 on “Room to expand” — the smallest single-score change thatwould.Site C · greenfield is excluded — it fails a must-have (“Grid power available” is 3.2 MVA, must be ≥ 4 MVA), so its total of 5.17 is notranked.Illustrative data for a fictional grocery retailer; drive times are modelled to its 142 stores.

Make it your own.

title "Northern distribution centre — site selection"
subtitle "Four shortlisted sites, measured where possible and scored 1–10 where not"
scale 1-10
note "Illustrative data for a fictional grocery retailer; drive times are modelled to its 142 stores."

options "Site A · motorway park" | "Site B · port-side" | "Site C · greenfield" | "Site D · brownfield retrofit"

"Mean drive time to stores"     weight 25 unit "min" lower      : 74 96 81 88
"Lease and business rates"      weight 20 unit "£k/yr" lower    : 2,340 1,860 2,050 1,520
"Labour pool within 30 minutes" weight 15 unit "k people"       : 410 265 190 335
"Grid power available"          weight 10 unit "MVA" must >= 4  : 6.5 8 3.2 5
"Flood risk (1 = negligible)"   weight 10 lower                 : 2 6 1 3
"Room to expand"                weight 10                       : 6 4 9 3
"Planning risk (1 = low)"       weight 10 lower                 : 3 5 7 2