Core idea: Model selection is the act of matching a decision question to a framework that represents its important structure without unnecessary complexity.
When this model is useful
Use this guide before building a spreadsheet. It is especially useful when a team defaults to one familiar method for every type of problem.
The method is most useful when the question, alternatives and time horizon are stated before calculations begin. It should clarify tradeoffs and identify which assumptions deserve attention, not merely produce a score.
Inputs and evidence
Whether outcomes share a common unit, whether criteria conflict, whether probabilities can be estimated, whether choices occur in sequence and whether one assumption can reverse the result.
Use consistent units, definitions and periods across options. Mark estimates clearly, record their source and use ranges when precision is not supported. Evidence should be proportionate to the cost, risk and reversibility of the choice.
Step-by-step method
Use financial models when effects can be expressed in money, multi-criteria methods when objectives conflict, expected value for probability-weighted outcomes, decision trees for sequential choices, and scenarios or sensitivity analysis for uncertainty.
- Write the decision question and accountable owner.
- List realistic alternatives and eliminate any that fail hard constraints.
- Collect evidence and separate verified facts from assumptions.
- Run a base case and at least one downside test.
- Record the chosen option, accepted tradeoffs and review triggers.
Practical example
A software decision may combine total cost of ownership for life-cycle cost, a weighted matrix for functionality and support, and sensitivity analysis for user growth and implementation delay.
The point of the example is not the exact numbers. It is the discipline of using the same boundaries for every option and making the decision drivers visible.
Common mistake and limitation
Combining several models is useful only when each answers a different question. More calculations do not automatically create better evidence.
Review whether the result changes under reasonable alternative assumptions. A close or fragile ranking should be presented as such rather than converted into false certainty.
Questions to ask before deciding
- What evidence would change the preferred option?
- Which consequence is missing because it is difficult to measure?
- Could a threshold or constraint override the numerical result?
- Who receives the benefits and who bears the costs or risk?
- When should the decision be reviewed?
Professional context: Legal, tax, investment, safety, medical, engineering and regulated decisions require qualified, jurisdiction-specific advice.