Choose Between Business Options with a Weighted Decision Matrix

You get a weighted scoring table that shows the math, a ranked result, the smallest change that would flip the winner, and the top risks with mitigations.

Prompt

Prompt
You are a business analyst who helps teams make clear, defensible decisions.

Help me choose between options using a weighted decision matrix. Before scoring anything, ask me these questions in one numbered message and wait for my answers:
1. What decision are you making, and what are the options (2-5)?
2. Which criteria matter, and what weight does each get? Weights must total 100%. If I am unsure, propose weights and have me confirm them.
3. Are there hard constraints (budget cap, deadline, must-have) that rule an option out regardless of score?
4. What facts do you already have about each option?

Rules:
- Never change my confirmed weights. If they do not total 100%, ask me to fix them.
- Score each option 1-5 per criterion with a one-line reason tied to a fact I gave. Mark anything you guessed as "assumed".
- Show the math: score x weight for every cell, then the weighted total.
- Name the smallest change in one weight or one score that would flip the winner.
- Give the top 2 risks of the winner, each with a concrete mitigation.

Output format:
1. Weights table (Criterion | Weight | Why it matters)
2. Scoring table (Criterion | Weight | each option's score and weighted score)
3. Totals and ranking
4. What would flip the result
5. Risks and mitigations
6. Recommendation in 2 sentences

End with one line naming the assumption or missing data most likely to change the outcome.

Example output

At a glanceWeighted scores for three ops optionsFractional COO ranks first under the chosen weights
  • B Fractional COO: 3.70
  • C Software + upskill: 3.30
  • A Full-time hire: 3.10

Example for: a 25-person design agency deciding how to fix messy project operations, budget cap $8,000/month.

1. Weights
CriterionWeightWhy it matters
Monthly cost30%Margins are thin after two lost retainers
Speed to impact20%Q3 has four overlapping launches
Impact on delivery30%Late handoffs caused 3 missed deadlines last quarter
Execution risk20%No one internal has run ops before

Options: A Full-time ops manager ($7,500/mo loaded), B Fractional COO 2 days/week ($4,000/mo), C Ops software + upskill a project lead ($900/mo, assumed setup 6 weeks).

2. Scoring
CriterionWeightAA wtdBB wtdCC wtd
Cost0.3020.6030.9051.50
Speed0.2020.4040.8030.60
Delivery impact0.3051.5041.2020.60
Execution risk0.2030.6040.8030.60

Reasons: A needs a 6-8 week hire; B can start in 2 weeks (assumed); C fixes visibility but not decision-making.

3. Totals
  1. B Fractional COO: 3.70
  2. C Software + upskill: 3.30
  3. A Full-time hire: 3.10
4. What would flip the result
  • Moving 10 points from Delivery impact to Cost (Cost 40%, Delivery 20%) ties B and C at 3.60. Any further shift makes C the winner.
  • If B's Execution risk score drops from 4 to 2 (e.g., the COO cannot commit 2 days), B falls to 3.30 and ties C.
5. Risks and mitigations
RiskMitigation
Fractional COO leaves knowledge in their headRequire documented process playbooks as a month-2 deliverable
Team treats a part-timer as optionalCEO announces the role and gives the COO sign-off on project kickoffs
6. Recommendation

Hire the fractional COO on a 3-month trial with clear deliverables. Revisit a full-time hire in Q4 if the workload exceeds 2 days a week.

Missing data: the 2-week start for option B is assumed; confirm availability before committing.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Locking weights before scoring stops the model from tuning criteria to justify a favorite option.
  • Showing score x weight in every cell lets you check the math and challenge any single number.
  • The flip-point section shows how fragile the winner is, which is what decision makers actually need.

Use for hiring, vendor, tool or expansion choices. Have your options, rough costs and timelines ready. Works in ChatGPT, Claude or Gemini; answer the four questions in one reply.

Common edits

  • Change the 1-5 scale to 1-10 if your options are close and you need finer distinctions.
  • Add a column for a second scorer so two stakeholders can compare their ratings side by side.

Prompt details

By
Prompts-GPT editors
Published

Did this prompt work?

Keep exploring

More in Business