Skip to content
Tutorials Center
My learning

Topics

Lesson 35 of 37 ยท Projects and Practice

Project: Break-Even for a Cafe

A step-by-step mini-project: build a break-even model for an invented cafe, test price and cost changes, and recommend a decision, with runnable code.

In this project you play the role of a business adviser. A friend, Maya, plans to open a small cafe called Corner Brew. She asks: "How many drinks must I sell each month to avoid a loss, and what if things change?" You will use break-even analysis to answer. All figures are invented for practice.

Step 1: Collect the facts

Maya gives you these estimates:

Item Amount
Average price per drink-and-snack order $6.50
Variable cost per order (coffee, milk, food, cup) $2.30
Rent per month $1,800
One part-time employee, per month $1,400
Utilities and insurance per month $450
Loan repayment per month $350
Advertising per month $200

First, separate fixed from variable. Fixed costs: rent, employee, utilities, loan, advertising. Variable cost: $2.30 per order. (Strictly, a part-time wage could vary with hours; we treat it as fixed here and note this assumption.)

Step 2: Calculate the basics

Fixed costs = 1,800 + 1,400 + 450 + 350 + 200 = $4,200. Contribution per order = 6.50 - 2.30 = $4.20. Break-even = 4,200 / 4.20 = 1,000 orders a month.

If the cafe opens 26 days a month, that is about 38.5 orders a day, so 39 whole orders a day.

Python Corner Brew break-even model

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Step 3: Compare with expected demand

Maya's market research suggests she can sell 1,300 orders a month. Then:

  • Margin of safety = 1,300 - 1,000 = 300 orders (about 23% of expected sales).
  • Profit = 1,300 ร— 4.20 - 4,200 = 5,460 - 4,200 = $1,260 a month.

This is before Maya takes any pay for herself. A thoughtful adviser would point that out.

Step 4: What-if scenarios

Test these changes one at a time:

  1. Rent rises by $300.
  2. Price rises to $7.00, but demand falls to 1,200 orders.
  3. A cheaper milk supplier cuts variable cost to $2.00.
  4. A big competitor opens nearby and demand falls to 900 orders.
Python What-if scenarios

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Read the table carefully. Which scenario is dangerous? When the number of orders falls below break-even, profit becomes negative (a loss). Scenario 4 loses money. Scenario 2 shows that a higher price does not always help, because fewer customers buy; here it still gives more profit than the base case, but only because the guess for demand was only slightly lower. A bigger fall in demand would reverse that.

Step 4b: How sensitive is profit?

A sensitivity analysis changes one input over a range to see how profit reacts. Here we vary the number of orders from 700 to 1,500.

JS Sensitivity of profit to demand

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Step 5: Write your recommendation

A good adviser's note is short and clear. For example:

  • Result: Corner Brew breaks even at 1,000 orders (about 39 per open day). Expected sales of 1,300 leave a margin of safety of 300 orders.
  • Risks: a new competitor or higher rent would reduce profit sharply; the model does not include Maya's own pay.
  • Advice: test demand before signing a long lease, negotiate rent, start with a smaller menu to control stock waste, and keep a cash reserve (see cash flow).
  • Limits: forecasts of sales are uncertain, and costs are assumed to be a straight-line.

Write your own version with different figures: change the price, rent and number of staff, then see how the break-even moves.

Check your understanding

Quick check ยท 3 questions

of 3 answered You scored / 3 ยท perfect!

  1. 1. Fixed costs are $4,200 and contribution per order is $4.20. What is the break-even number of orders?

    4,200 / 4.20 = 1,000.
  2. 2. If expected orders are 1,300 and break-even is 1,000, what is the margin of safety?

    1,300 - 1,000 = 300 orders.
  3. 3. What is a sensitivity analysis?

    It tests how results change when an assumption changes.

Summary

  • Separate fixed from variable costs, then compute contribution and break-even.
  • Use a margin of safety to judge risk.
  • Scenarios and sensitivity analysis test what could go wrong.
  • A recommendation should state results, risks, advice and limits.

Next: Project: A Six-Month Cash Flow Plan