WorksheetFree to print
Costing sheet template: work out cost, price and break-even
The cost of one unit, your monthly costs, break-even and price.
How to use it
Before you write
One sheet per product
Start with your best seller.
Use slips, not memory
Collect a week of receipts first if you can.
Include the small costs
Transport, packaging, gas and airtime are the ones people forget.
Put in a wage for yourself
Decide a monthly amount and write it in section B.
Prints on one A4 page. Your phone can also save it as a PDF from the print screen. Nothing you write is sent to ADA.
The three formulas on this sheet
- Cost of one unit = total cost of the batch ÷ units in the batch.
- Break-even units a month = total monthly costs ÷ (price − cost of one unit).
- Selling price from a margin = cost ÷ (1 − margin). From a markup = cost × (1 + markup). A 40% margin and a 40% markup are not the same price. The guide How to price a product shows both with an example.
Product or service
One batch makes (units)
A. What goes into one batch
Item (stock, materials, transport, packaging, gas)Cost N$
Total for the batch
Cost of one unit (total ÷ units)
B. What you pay every month anyway
Monthly cost (rent or stand, airtime, electricity, wages, loan)Cost N$
Your own wage
Total each month, including your wage
C. Break-even
Price of one unit
Minus cost of one unit
= left from each one
Total each month ÷ left from each one = units to sell a month
÷ selling days = units a day
D. Try another price
New price
= left from each one
Units to sell a day
If the business cannot pay your wage, it is not making a profit. It is using your time for free.
Tell us what you are trying to decide.
You do not need a business plan to talk to us. Say what the business is, what you want from it and what is in the way. A Business Check-up costs N$199 and comes off any other service you book within 30 days.
