Operations Floor: Calculator

Weighted location assessment

Weighted scoring turns a location decision into numbers you can argue about. Choose the factors that matter, weight them, score each site, and the tool ranks the sites, shows the working, finds the weights that would change the answer, and flags the scores so low they might rule a site out whatever its total.

Back to 5.4 Location

Syllabus
5.4 Location
Status
SL and HLAO2, AO3
Worked example
Wrenhurst Cycles, a fictional bicycle maker

Section 01: How to use it

  1. Read the decision and the sites. Each score is out of 10, where 10 is best for the business, so the cheapest land scores highest on land cost.

  2. Weight each factor from 0 to 5 for how much it matters, and score every site on it. Rename, add or remove factors and sites to build your own assessment.

  3. Read the ranking, the working (weight × score) and the weights at which the site ranked first would change.

  4. Check the low scores, write your recommendation, and weigh what the numbers leave out. Your assessment is kept on this device; download it as JSON or CSV, or print it.

Where it sits in the course. Subtopic 5.4, Location (guide, p. 34), for SL and HL: the reasons for a specific location of production (AO2) and ways of reorganizing production nationally and internationally, namely outsourcing or subcontracting, offshoring, insourcing and reshoring (AO3). Weighted scoring is a decision-making method, not one of the guide's toolkit tools or formulas.

Calculator

Wrenhurst Cycles, a fictional bicycle maker

Source: Simulated data SL and HL

Wrenhurst buys its frames from a partner overseas, eight weeks away by sea, as the notes on production planning describe. Here it weighs making frames itself at one of three sites. The sites, scores and weights are simulated.

Your changes are kept in this browser, on this device only.

The decision

One delayed ship could stop Wrenhurst's assembly line, because every frame comes from a partner factory eight weeks away by sea. The directors are considering making frames themselves: insourcing the work, and reshoring it if the frames are made at home. Three sites are on the shortlist.

  • Site A Next to the assembly plant. The town has welders from an old engineering works, but wages and land are expensive.
  • Site B An industrial estate in a port city two hours away, with grants for new manufacturers.
  • Site C The partner's region overseas, in a factory Wrenhurst would own, which is offshoring. Cheapest, but frames still take eight weeks to arrive.

The factors, weights and scores

Weight each factor from 0 to 5 for how much it matters, and score each site from 0 to 10 on it. Rename, add or remove factors and sites to make the assessment your own.

FactorWeight, 0 to 5Remove a factor

This is the worked example. With JavaScript on, you can change any weight, score or name, and add or remove factors and sites.

The ranking

Weighted total for each siteWeighted totals out of a possible 240: Site B 167 (rank 1); Site A 165 (rank 2); Site C 145 (rank 3).060120180240Site B167 (first)Site A165Site C145Weighted total, out of 240
Chart Each site's weighted total: the sum of weight × score over the factors. The site ranked first is drawn darkest. Simulated teaching data.

Reading. Site B ranks first with 167 points, 2 ahead of Site A. The ranking is sensitive to the weights: at a weight of 2 on cost of land and buildings (now 3), Site A and Site B tie; at a weight of 3 on labour costs (now 4), Site A and Site B tie; at a weight of 5 on lead time to the assembly line (now 4), Site A ranks first; at a weight of 1 on transport links (now 3), Site A and Site B tie; at a weight of 1 on government grants and incentives (now 2), Site A and Site B tie; at a weight of 5 on low political and currency risk (now 3), Site A and Site B tie.

Implication. A close ranking means the decision rests on the weights, which are judgements about priorities. Agree the weights before seeing the totals, and check the qualitative factors the scores leave out.

The working: weight × score

Factor and weight Site ASite BSite C
Cost of land and buildings × 312 (4)18 (6)27 (9)
Labour costs × 412 (3), a low score20 (5)36 (9)
Skilled welders nearby × 540 (8)40 (8)35 (7)
Lead time to the assembly line × 440 (10)24 (6)8 (2), a low score
Transport links × 324 (8)27 (9)15 (5)
Government grants and incentives × 210 (5)14 (7)12 (6)
Low political and currency risk × 327 (9)24 (8)12 (4)
Weighted total165167145
Rank213

Each cell is weight × score, with the score in brackets. Scores of 3 or below are underlined.

Scores of 3 or below: could any rule a site out?

  • Site A: labour costs, 3 out of 10
  • Site C: lead time to the assembly line, 2 out of 10
Kept on this device with the assessment.

Section 02: What it leaves out

Every model simplifies. Say so in an answer, and say what else you would want to know.

  • Weights and scores are judgements. Two managers with the same facts can reach different totals, so agree the weights before seeing the results.
  • A high total can hide a fatal weakness. A site that scores 1 on access to skilled staff may be impossible whatever else it offers.
  • The method adds factors as if they were independent and could make up for each other, which they often cannot.
  • Qualitative factors, such as the views of staff and the community, ethics and the environment, are hard to score and easy to leave out.

Section 03: Read and practise next