Back to homeEconomics and Business Administration · High School Year 3 · Social Sciences · Change subject
Start for free
Prep 3 SS · Economics and Business Administration
Business strategy and analytical methods: case studies · Decision-making and the business plan

Decision-Making and Simulation

A bakery in Guadalajara has a full workshop and turns down orders every weekend. It can expand the shop, open a second workshop, or subcontract production. Choosing by gut feeling or following an orderly process doesn't just change the chance of getting it right: it also determines whether the owner will later be able to explain, with data, why she chose what she chose.

The decision-making process

Flowchart with the seven consecutive stages of the decision-making process, from defining the problem to monitoring the result. Define Information Alternatives Evaluate Choose Implement Monitor
Practice★☆☆Not started
List and describe the stages of the decision-making process: define the problem, gather information, generate alternatives, assess them, choose, implement, and monitor.

List and describe the stages of the decision-making process: define the problem, gather information, generate alternatives, assess them, choose, implement, and monitor.

Solve
Practice★☆☆Not started
Distinguish between strategic decisions (long-term, hard to reverse) and operational decisions (day-to-day, reversible), and classify these four: opening a new shop,…

Distinguish between strategic decisions (long-term, hard to reverse) and operational decisions (day-to-day, reversible), and classify these four: opening a new shop, changing opening hours, launching online sales, and changing coffee supplier.

Solve

Risk: expected value and the decision tree

Decision tree with an initial square node for deciding whether to open and a circular risk node with probabilities for calculating the expected value. decision open don't open: 0 pesos success (p): +G failure (1−p): −P expected value = p·G + (1−p)·(−P)
Practice★☆☆Not started
The diagram shows a decision tree: a company is undecided whether to open a second location and, if it opens, the outcome depends on demand. Calculate the expected value…

The diagram shows a decision tree: a company is undecided whether to open a second location and, if it opens, the outcome depends on demand. Calculate the expected value of opening and explain whether, based on those data, it is advisable to open or not.

decision open do not open $0 ? success 60%: +$40 000 failure 40%: −$15 000
Solve
Practice★★☆Not started
A company is considering launching a product: if successful (60% probability) it will gain $\$1\,000\,000$, and if it fails (40% probability) it will lose $\$400\,000$.…

A company is considering launching a product: if successful (60% probability) it will gain $\$1\,000\,000$, and if it fails (40% probability) it will lose $\$400\,000$. a) Calculate the expected value of the launch as the sum of each outcome weighted by its probability. b) Reason whether the expected value is sufficient to make a decision or if more data are needed.

Solve

Uncertainty: the optimistic, pessimistic, and Laplace criteria

Range of outcomes of three crops: wheat is fixed, corn varies moderately, and the tropical crop varies a lot. wheatalways 8,000 pesos corn4,000 to 14,000 pesos tropical−4,000 a 28,000 the wider the range of outcomes, the more the chosen criterion matters
Practice★★★Not started
"Dulces Artesanos" operates at 100% capacity in its single workshop and turns away orders every weekend. Management is debating three expansion alternatives: A1) Expand…

"Dulces Artesanos" operates at 100% capacity in its single workshop and turns away orders every weekend. Management is debating three expansion alternatives: A1) Expand the current premises by renting the adjacent ground-floor unit (high fixed investment and building work, but direct control over artisan quality); A2) Outsource the base dough to an industrial factory and only perform the final baking in-house (minimal fixed costs and fast delivery, but risk of losing exclusivity and reputation); A3) Open a large central workshop in an industrial estate to supply this and future shops (requires a substantial bank loan that jeopardises short-term liquidity). Design a multi-criteria decision matrix: define three justified quantitative or qualitative criteria, assign a coherent percentage weighting to each, and explain which alternative the company should choose if its immediate strategic priority is to protect its brand image without taking on a high risk of insolvency.

Solve

"What if...?" simulation and the business plan

Diagram of a simulation where the input cells (price, units, and costs) feed the profit formula. inputs price units costs formula forprofit

The business plan

The business plan is a simulation of the whole company before it starts up. Each part answers a question:

Part Question it answers
Idea and team What problem are we solving and who will do it?
Market analysis Who are the customers and the competition? Is there enough demand?
Marketing plan How will we make the product known, at what price, and where will we sell it?
Operations plan How do we produce or provide the service: suppliers, premises, staff?
Economic and financial plan How much money is needed, where does it come from, and is it profitable?

An investor or a bank usually looks at the financial part first: if the numbers don't add up, the project is not viable. But they also check that the other parts are realistic and consistent with one another.

Practice★★☆Not started
A spreadsheet allows you to simulate 'what if...?' scenarios. Explain what this type of simulation is and design, by describing it, a simple spreadsheet for a coffee…

A spreadsheet allows you to simulate 'what if...?' scenarios. Explain what this type of simulation is and design, by describing it, a simple spreadsheet for a coffee shop that wants to see how its profit changes if it increases the price of coffee by 10% and sales fall by 5%.

Solve
Practice★★☆Not started
List the basic parts of a business plan (idea and team, market analysis, marketing plan, operations plan, and financial plan) and explain what question each part answers.

List the basic parts of a business plan (idea and team, market analysis, marketing plan, operations plan, and financial plan) and explain what question each part answers.

Solve
Practice★★★Not started
An electric mobility startup applies for a 200 pesos 000 loan from a bank and submits a business plan containing the following assumptions: Marketing plan: projects…

An electric mobility startup applies for a 200 pesos 000 loan from a bank and submits a business plan containing the following assumptions:

  • Marketing plan: projects doubling subscription sales every month during the first year based solely on spontaneous word-of-mouth on social media, with an advertising budget of 0. pesos

  • Operations plan: outsources 100% of scooter assembly to a single overseas supplier with sea freight delivery times of 60 days, with no safety stock planned in Spain.

  • Financial plan: projects a net profit margin of 35% starting from the second month and includes no provision for working capital requirements or credit lines for contingencies.

  1. a) Identify and explain the inconsistencies and feasibility flaws that exist among these three sections of the business plan.
  2. b) If you were the bank's risk analyst, justify whether you would approve or reject the loan application, and identify which two sections you would review in greater detail to assess the actual debt repayment capacity.
Solve

Simulating a decision in a spreadsheet

Phases for modeling a decision in a spreadsheet: data with formulas, scenarios and sensitivity, and decision with its limits. Verifiable data → formulas with references Base case → scenarios → sensitivity Numerical result → decision and limits

Biases that ruin decisions

Diagram of three biases that distort decisions: anchoring, overconfidence, and sunk cost, and how to correct them. anchoring over-confidence sunk cost they are corrected by comparing several options and scenarios, and by looking only at the future, not at what's already spent

Techniques for reducing them: ask for at least three quotes before fixating on one (anchoring); prepare a pessimistic scenario and consult someone who will play devil's advocate (overconfidence); ask yourself "if I were starting from scratch today, would I invest in this?" (sunk cost).

Practice★★★Not started
Analyse the following statements made during the management committee meeting of a textile company: 1. Expansion Director: "The first consultant estimated that entering…

Analyse the following statements made during the management committee meeting of a textile company:

  1. Expansion Director: "The first consultant estimated that entering the French market would cost 500 pesos 000. Although subsequent, more detailed reports raise that figure to 800,000, pesos we must stick to the initial 500 pesos 000 because that was the agreed benchmark."

  2. Production Director: "Our team never misses deadlines; there is no need to budget contingency funds or take out delay insurance on the new assembly line."

  3. Managing Director: "We have already invested 200 pesos 000 in developing our own sales platform. Even though customers prefer to buy through third-party distributors and our own website fails to attract traffic, cancelling the project now would be throwing that money in the bin; we need to contribute another 50 pesos 000."

  1. a) Identify and justify the cognitive bias distorting each executive's stance, explaining the potential economic harm to the company.
  2. b) Design a specific decision-making protocol or technique to neutralise each of these three biases in future committee meetings.
Solve

Back to the beginning: if the Guadalajara bakery defines its problem well, compares several alternatives, simulates each one in a spreadsheet, and avoids the biases, it will be able to choose with data and explain why it decided as it did.

Summary

See all the exercises in this section