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.
Section 01: How to use it
-
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.
-
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.
-
Read the ranking, the working (weight × score) and the weights at which the site ranked first would change.
-
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
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.
The tool could not start in this browser. Everything below is the worked example as it was prepared, with its results.
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 ranking
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 A | Site B | Site C |
|---|---|---|---|
| Cost of land and buildings × 3 | 12 (4) | 18 (6) | 27 (9) |
| Labour costs × 4 | 12 (3), a low score | 20 (5) | 36 (9) |
| Skilled welders nearby × 5 | 40 (8) | 40 (8) | 35 (7) |
| Lead time to the assembly line × 4 | 40 (10) | 24 (6) | 8 (2), a low score |
| Transport links × 3 | 24 (8) | 27 (9) | 15 (5) |
| Government grants and incentives × 2 | 10 (5) | 14 (7) | 12 (6) |
| Low political and currency risk × 3 | 27 (9) | 24 (8) | 12 (4) |
| Weighted total | 165 | 167 | 145 |
| Rank | 2 | 1 | 3 |
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
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
Arjun Agrawal | The Business Brief, https://the-business-brief-dun.vercel.app/operations-floor/location-assessment/. Original teaching material, not an IB publication. The organizations in the teaching cases are fictional unless a case says otherwise.