Build a Tea Stall Profit Calculator

Build a Google Sheets model for tea stall profit and break-even sales.

Introduction

30 Second Summary

At month-end, a tea stall owner can see plenty of sales without knowing how much money the stall truly earned. Ingredients left on the shelf make that answer less obvious.

In this project, you will build a monthly profit calculator in Google Sheets for a fictional tea stall at an interstate bus stand. You will compare a quick cash-surplus estimate with an inventory-adjusted operating profit result.

What You'll Build

You will edit the stall's monthly figures and watch its profit result update automatically on one page.

By the end of this project, you would've learnt all these:

An editable monthly sales table that turns units sold and selling prices into visible revenue.
An inventory-adjusted profit result that separates ingredients used from ingredients purchased.
A decision view showing profit margin plus break-even sales for the sample month.
Secret Mission: Estimate the operating profit for a quieter month with lower passenger footfall.

Are there any prerequisites?

None. You only need your existing Google account and web browser.

Every formula is explained from a blank spreadsheet.

Before We Start

Before you build the calculator, define the monthly business question it needs to answer. This keeps every figure focused on helping the tea stall owner understand one month's profit.

Set Up Your Tea Stall Workbook

Your business question defines the month this calculator represents. The workbook now needs a clear structure that keeps every figure inside that same monthly period.

A single Google Sheets workbook gives every monthly figure a shared home. In this step, you'll create that workbook. You'll mark the four sections that guide the rest of the model.

In this step, get ready to:

Create a blank Google Sheets workbook in your browser.
Give the workbook a clear identity using the same title in two places.
Organize the worksheet with four section labels.

Create a blank spreadsheet

A blank spreadsheet gives you one place for the month's sales, stock, expenses, and results. Starting from an empty grid also keeps the calculator focused on the tea stall's business question.

Enter sheets.google.com in your browser's address bar.
Complete your Google account sign-in if Google asks for it.
Click New to create a blank spreadsheet.

You're in. You'll see a blank grid with Untitled spreadsheet in the upper-left corner.

Why Google Sheets?

A paper ledger records one set of figures at a time. Google Sheets can recalculate formulas whenever you edit an input.

A custom calculator would add programming setup to this project. The spreadsheet keeps your attention on understanding monthly profit.

🙋‍♀️ Blank spreadsheet not opening?

Check that your browser has an internet connection.
Complete your Google account sign-in if the spreadsheet page returns to the account screen.
Reload the page if the spreadsheet grid remains blank.

Still stuck? Help me troubleshoot why Google Sheets is not opening a blank spreadsheet.

Name the workbook and add its title

A descriptive workbook name makes the calculator easy to find later. Repeating the title in the first cell also makes the worksheet's purpose clear when someone opens it.

Click the Untitled spreadsheet name in the upper-left corner.
Replace the existing name with Tea Stall Monthly Profit Calculator.
Press Enter to apply the new workbook name.
Enter Tea Stall Monthly Profit Calculator in cell A1.

You've got the first piece in place. The same title now identifies the workbook from the browser view and the worksheet grid.

How Does Saving Work?

Google Sheets saves your online changes automatically as you type. The named workbook is stored in your Google Drive, so you do not need to look for a save button.

Add the workbook sections

Section labels turn the blank grid into a map for the monthly model. Each label reserves a clear area for one type of financial information.

Enter Sales in cell A3.
Enter Inventory in cell A10.
Enter Operating Expenses in cell A15.
Enter Results in cell A24.

Before you check the finished structure, can you picture where each of the four sections should appear in the worksheet?

Confirm the workbook name in the upper-left corner reads Tea Stall Monthly Profit Calculator.
Confirm cell A1 contains Tea Stall Monthly Profit Calculator.
Confirm cells A3, A10, A15, and A24 contain their matching section labels.

You'll see the workbook title at the top of the sheet. Below it, the labels Sales, Inventory, Operating Expenses, and Results divide the worksheet into four visible areas.

Section Label in the Wrong Cell?

Re-enter any misplaced label in its required cell.
Compare each label with the spelling shown above.
Remove any duplicate label left in the wrong row.

Need a hand? Help me fix the section labels in my Google Sheets workbook.

You have turned a blank grid into a clear monthly workspace. Next up, you'll add sample sales and expenses to produce the first cash-surplus estimate.

Calculate Sales and a First Cash Surplus

Your labelled Google Sheets workbook now gives every monthly figure a clear home. The four sections are ready for data.

This step turns units sold into sales revenue. It subtracts ingredient purchases plus operating expenses to produce a simple cash surplus.

In this step, get ready to:

Calculate monthly revenue for each product plus total sales.
Record inventory inputs plus monthly operating expenses.
Test the simple cash surplus with a closing-stock change.

Calculate monthly sales

Each product earns revenue from its monthly units sold at a set price. A formula calculates that revenue whenever either input changes.

Enter the following values across A4:C5. Use Product, Monthly Units Sold, and Price per Unit (₹) in row 4. Use Milk Tea, 4200, and 12 in row 5.
Enter =B5*C5 in D5.

You should see 50400 in D5 for Milk Tea revenue.

Enter Coffee, 450, and 15 across A6:C6.
Enter =B6*C6 in D6.

You should see 6750 in D6 for Coffee revenue.

Enter Packaged Snacks, 900, and 10 across A7:C7.
Enter =B7*C7 in D7.

You should see 9000 in D7 for Packaged Snacks revenue.

Enter Revenue (₹) in D4.
Enter Total Sales in A8.
Enter =SUM(D5:D7) in D8.

Your first total is working. The three product rows now produce monthly sales of 66150 rupees.

How do the sales formulas work?

The formulas in D5:D7 multiply monthly units sold by the price per unit.
The SUM formula in D8 adds the three product revenues into one monthly sales figure.

🙋‍♀️ Sales total looks different?

Check that the unit counts are in column B. Check that the prices are in column C.

Make sure each formula starts with = and uses the row containing that product.

Still stuck? Help me troubleshoot my sales formulas.

Record inventory and operating expenses

Inventory records ingredients available at the start of the month. It also records purchases plus stock remaining at the end.

Enter these label-value pairs across A11:B13. Use Opening Ingredient Stock with 3000, Ingredient Purchases with 24000, and Closing Ingredient Stock with 4000.
Review cells B11:B13.

You should see 3000, 24000, and 4000 in the three inventory rows.

Enter these label-value pairs across A16:B21. Use Stall Fee / Rent with 8000, Wages with 12000, and Fuel with 3000.
Enter Electricity and Water with 1200 in A19:B19.
Enter Transport and Cleaning with 1500 in A20:B20.
Enter Local Licences and Permits with 0 in A21:B21.

The six operating-expense rows should now run from A16:B21.

Why is the permits value zero?

The 0 value is an editable teaching input. It leaves local fees open for verified records from the stall owner.

Enter Total Operating Expenses in A22.
Enter =SUM(B16:B21) in B22.

You should see total operating expenses of 25700 in B22.

Expense total looks wrong?

Check that all six amounts sit in cells B16:B21. Text entered in the amount column cannot contribute to the total.

Check that B22 contains =SUM(B16:B21).

Need another pair of eyes? Help me fix my operating-expense total.

Test the simple cash surplus

The simple cash surplus subtracts ingredient purchases plus total operating expenses from total sales. The figure covers only those recorded amounts.

Enter Simple Cash Surplus in A25.
Enter =D8-B12-B22 in B25.

Before you look at the result, what cash surplus do you expect after subtracting purchases plus expenses from total sales?

Check the result in B25.

That first monthly estimate is working. You should see 16450 in B25.

Before you change the stock figure, do you expect B25 to move?

Enter 5000 in B13.
Check the result in B25 again.

You will still see 16450. The stock change leaves this first estimate untouched.

What did the stock test reveal?

The formula in B25 references total sales in D8, ingredient purchases in B12, and operating expenses in B22.

Closing ingredient stock in B13 sits outside the formula. This simple estimate therefore treats every ingredient purchase as part of the month’s outgoings.

Restore B13 by entering 4000.
Check D8.
Check B22.
Check B25.

You should see 66150 in D8, 25700 in B22, and 16450 in B25. Closing ingredient stock in B13 should be back to 4000.

Cash surplus changes with closing stock?

Check that B25 contains exactly =D8-B12-B22. A reference to B13 would make this first estimate respond to closing stock.

Check that the closing-stock value is in B13.

Still seeing a different result? Help me troubleshoot my simple cash-surplus formula.

You now have a working first estimate plus proof of its limitation. Next, you will make the profit calculation respond to ingredients still in stock.

Correct the Profit with Inventory

Your first result in Google Sheets showed a simple cash surplus of ₹16450. Changing closing stock left that result untouched.

That estimate charges every ingredient purchase to this month, including stock still on hand. The matching principle subtracts closing stock so the workbook reflects the ingredients consumed this month.

In this step, get ready to:

Calculate the inventory-adjusted cost of ingredients used.
Calculate gross profit from sales and ingredient consumption.
Test how closing stock changes monthly operating profit.

Calculate the cost of ingredients used

The inventory adjustment uses opening stock plus purchases minus closing stock. Closing stock is subtracted because those ingredients remain available for a later month.

Enter Cost of Ingredients Used in cell A26.
Calculate the ingredient cost in cell B26 by entering this formula:

=B11+B12-B13

What does this formula calculate?

Cell B11 brings opening ingredient stock into the current month.
Cell B12 adds ingredient purchases made during the month.
Cell B13 removes the ingredients still held as closing stock.

Apply the formula by pressing Enter.

That closes the inventory gap. You should see 23000 in cell B26.

Ingredient cost looks wrong?

Check that cells B11, B12, and B13 contain 3000, 24000, and 4000.

Confirm that the minus sign appears directly before B13 in the formula.

Still stuck? Help me troubleshoot my ingredient-cost formula.

Calculate gross profit

Gross profit shows what remains after subtracting the cost of ingredients used from sales. This keeps operating expenses separate for the next calculation.

Enter Gross Profit in cell A27.
Calculate gross profit in cell B27 by entering this formula:

=D8-B26

What does this formula calculate?

Cell D8 contains total sales. Cell B26 contains the inventory-adjusted ingredient cost.

Subtracting the second value from the first leaves the amount available to cover operating expenses and profit.

Apply the formula by pressing Enter.

Good progress. You should see 43150 in cell B27.

Gross profit does not show 43150?

Confirm that total sales in D8 still show 66150.

Check that the formula subtracts B26 from D8.

Need another pair of eyes? Help me check my gross-profit formula.

Calculate and test monthly operating profit

Monthly operating profit subtracts the listed operating expenses from gross profit. This is the corrected monthly result for the simplified model.

Enter Monthly Operating Profit in cell A28.
Calculate monthly operating profit in cell B28 by entering this formula:

=B27-B22

What does this formula calculate?

Cell B27 contains gross profit. Cell B22 contains total operating expenses.

The difference is the stall's monthly operating profit under the costs included in this workbook.

Apply the formula by pressing Enter.

Your corrected profit calculation is working. You should see 17450 in cell B28.

Operating profit does not show 17450?

Confirm that B27 shows 43150.

Confirm that B22 shows 25700.

Need help tracing the result? Help me troubleshoot my monthly operating profit.

Before you change the stock value, what do you expect to happen to monthly operating profit when more ingredients remain unused?

Enter 5000 in cell B13.

You should see cell B28 rise from 17450 to 18450. The higher closing stock reduces the ingredients charged to this month.

Restore 4000 in cell B13.

You have now proved that inventory flows through the corrected profit model. Cell B28 should return to 17450.

Your workbook now separates ingredients purchased from ingredients used. Next, you'll use the corrected profit to calculate margin and break-even sales.

Add Profit Margin and Break-Even Results

Your inventory adjustment now gives the tea stall a monthly operating profit of ₹17450. The calculation reflects the ingredients consumed during the month.

Next, you will use formulas in Google Sheets to calculate profit margin. You will also estimate break-even sales.

A profit amount alone cannot show the efficiency of the month. The break-even result identifies the minimum sales needed to cover the listed operating expenses.

In this step, get ready to:

Calculate the monthly profit margin.
Build a contribution-based break-even percentage.
Calculate the sales level needed to break even.

Calculate the profit margin

Profit margin compares operating profit with total sales. It shows how much operating profit remains from each ₹100 of sales.

Enter Profit Margin (%) in cell A29.
Calculate the profit margin in cell B29 by entering this formula:

=B28*100/D8

What Does This Formula Calculate?

Cell B28 supplies monthly operating profit.
Cell D8 supplies total sales.
Multiplying the ratio by 100 expresses the result as a percentage.

Press Enter to apply the formula.
Confirm cell B29 shows a value close to 26.38.

You now have the month's efficiency measure: about ₹26.38 of operating profit for every ₹100 of sales.

Does the Margin Look Different?

Confirm cell B13 contains 4000.
Confirm cell B28 contains 17450.

Still seeing a different result? Help me troubleshoot the profit margin formula.

Calculate contribution and break-even percentage

Contribution is the portion of sales left after variable ingredient cost. This simplified model treats the listed operating expenses as fixed for the month.

The break-even percentage measures those expenses against contribution.

Enter Contribution in cell A30.
Calculate contribution in cell B30 by entering this formula:

=D8-B26

What Does This Formula Calculate?

Cell D8 supplies total sales.
Cell B26 supplies the cost of ingredients used.
Subtracting ingredient cost leaves the amount available to cover the listed operating expenses.

Press Enter to apply the formula.
Confirm cell B30 shows 43150.

The workbook now shows ₹43150 available to cover the listed operating expenses.

Is Contribution Incorrect?

Confirm cell D8 contains total sales of 66150.
Confirm cell B26 contains ingredient cost of 23000.

Need another pair of eyes? Help me troubleshoot the contribution formula.

Enter Break-Even Percentage (%) in cell A31.
Calculate the break-even percentage in cell B31 by entering this formula:

=B22*100/B30

How Does This Find the Break-Even Percentage?

Cell B22 supplies total operating expenses.
Cell B30 supplies contribution.
Multiplying the ratio by 100 expresses the break-even point as a percentage of current sales.

Press Enter to apply the formula.
Confirm cell B31 shows a value close to 59.56.

Your listed operating expenses equal about 59.56% of the month's contribution.

Is the Percentage Off?

Confirm cell B22 contains 25700.
Confirm cell B30 contains 43150.

Still stuck? Help me troubleshoot the break-even percentage.

Calculate break-even sales

Break-even sales converts the percentage in B31 into a rupee sales target. The result estimates the monthly sales needed to cover the listed operating expenses.

Enter Break-Even Sales (₹) in cell A32.

Before you enter the formula, make a quick prediction about whether break-even sales will sit below or above total sales.

Calculate break-even sales in cell B32 by entering this formula:

=B31*D8/100

How Does This Find Break-Even Sales?

Cell B31 supplies the break-even percentage.
Cell D8 supplies total sales.
Dividing by 100 converts the percentage calculation into a rupee amount.

Press Enter to apply the formula.
Confirm cell B28 shows 17450.
Confirm cell B29 shows approximately 26.38.
Confirm cell B30 shows 43150.
Confirm cell B31 shows approximately 59.56.
Confirm cell B32 shows approximately 39399.

You should see break-even sales below total sales: approximately ₹39399 compared with ₹66150. Your calculator now connects monthly profitability to a clear sales target.

How Should You Read These Results?

The sample month generates an operating profit of ₹17450. Its profit margin is approximately 26.38%.

Sales of approximately ₹39399 cover the listed operating expenses under this simplified fixed-cost model. The current sales total sits above that threshold.

🙋‍♀️ Does Break-Even Sales Look Wrong?

Confirm cell B31 contains a value close to 59.56.
Confirm cell D8 contains 66150.

Need help tracing the calculation? Help me troubleshoot the break-even sales formula.

✔️ Awesome, I've got everything!

Your Results section now contains the complete profit margin plus break-even model. Google Sheets saves these changes automatically while you work online.

ⓧ I'd like to double check the full code

Compare your workbook with this complete cell layout.

Tea Stall Monthly Profit Calculator

Sales
Product	Monthly Units Sold	Price per Unit (₹)	Revenue (₹)
Milk Tea	4200	12	=B5*C5
Coffee	450	15	=B6*C6
Packaged Snacks	900	10	=B7*C7
Total Sales			=SUM(D5:D7)

Inventory
Opening Ingredient Stock	3000
Ingredient Purchases	24000
Closing Ingredient Stock	4000

Operating Expenses
Stall Fee / Rent	8000
Wages	12000
Fuel	3000
Electricity and Water	1200
Transport and Cleaning	1500
Local Licences and Permits	0
Total Operating Expenses	=SUM(B16:B21)

Results
Simple Cash Surplus	=D8-B12-B22
Cost of Ingredients Used	=B11+B12-B13
Gross Profit	=D8-B26
Monthly Operating Profit	=B27-B22
Profit Margin (%)	=B28*100/D8
Contribution	=D8-B26
Break-Even Percentage (%)	=B22*100/B30
Break-Even Sales (₹)	=B31*D8/100

How to Compare the Workbook

Each line represents the matching row in your spreadsheet. Empty tab positions represent cells that remain blank.

Secret mission

Test a Low-Footfall Month

Use the completed month as a baseline for a quieter month at the bus stand. You will estimate ingredient cost and operating profit from a lower sales figure without changing the original results.

Clean Up Your Resources

Your Google Sheets workbook is stored in Google Drive at no additional cost. Choose whether to keep the calculator ready for real records, pause your work, or delete the workbook.

Resources you used:

One Tea Stall Monthly Profit Calculator workbook containing the baseline calculations and Low-Footfall Scenario.

Keep everything running

No action is needed. Choose this option if you want to keep testing different months or start using verified stall records.

Keep the Tea Stall Monthly Profit Calculator workbook in Google Drive.
Replace the fictional inputs with one month of verified sales records or supplier quotations when you are ready.
Retain the Low-Footfall Scenario so you can compare alternative monthly sales figures without changing the baseline results.

Pause - I'll come back to this later

Close the workbook when you want to pause. Google Sheets automatically saves your online changes as you type.

Confirm that your completed baseline results and Low-Footfall Scenario remain visible in the workbook.
Close the browser tab containing the Tea Stall Monthly Profit Calculator workbook.
Return to the workbook from Google Drive when you are ready to continue.

Delete - I don't want to use this again

Moving the workbook to Trash can feel final. Google Drive keeps it there for 30 days unless you empty Trash sooner.

Open a new browser tab.
Go to drive.google.com.
Find the Tea Stall Monthly Profit Calculator workbook in Google Drive.
Right-click the workbook.
Click Move to Trash.
Leave the workbook in Trash if you want the 30-day recovery window.
Click Empty trash only if you intend to permanently delete every item in Trash.

Nice Work!

That calculator is complete! Your Google Sheets workbook now turns a month of tea stall records into an inventory-adjusted profit estimate with a break-even target.

You've learned how to:

Build a monthly sales table that converts units sold at set prices into total revenue.
Calculate the cost of ingredients used from opening stock, purchases, plus closing stock before deriving gross profit.
Turn monthly operating profit into a profit margin plus a break-even sales target for monthly decisions.
Secret Mission: Modelled a low-footfall month with the baseline ingredient-cost ratio to estimate scenario operating profit.

Use this workbook as a learning and planning model. Verify every fictional amount against business records before making a real decision.

Ready to quiz yourself?