Selling and marketing
Cookie Booth Inventory Sheet: Cost, Price, and Margin
A simple inventory sheet for your cookie booth that tracks costs and sales so you know your profit.
On this page
- What goes on your inventory sheet
- A worked example with real numbers
- Mistakes that cost you money
- How to price for a real margin
- What your leftovers tell you
- How to use your sheet after the market
- How to handle samples and broken cookies
- A free template you can use today
- What to check before your next booth
This sheet is your record of the day. It starts with what you baked and packed. It ends with what you sold and what you earned. A good cookie booth inventory sheet tells you which cookies are worth baking again. See more tools for selling your baked goods.
What to remember
- Track each cookie type’s batch cost and selling price.
- Record what you start with, what sells, and what is left.
- Use the data to see your real profit margin.
- Spot which cookies sell fast and which do not move.
What goes on your inventory sheet
Your sheet needs just a few columns. List each cookie type you are selling. For each type, note how many you made. Write down your cost for the whole batch. Write down your price per cookie or per dozen. Leave space to mark how many you sell. Keep everything on one page so you can scan it fast during a busy sale.
Column 1: Cookie type
List every variety you bring, like chocolate chip, snickerdoodle, or sugar cookie.
Column 2: Batch size
Write the total number of cookies you baked for that type.
Column 3: Batch cost
Put the total cost for that batch, including ingredients, packaging, and power.
Column 4: Selling price
Note your price per cookie or your price per dozen.
Column 5: Starting count
This is the same as your batch size when you first set up.
Column 6: Sold count
Tally each sale as it happens or count up at the end of the day.
Column 7: Ending count
Subtract sold from starting to see what is left.
A worked example with real numbers
Let us say you bake a batch of 36 chocolate chip cookies for the market. Your ingredients cost $4.50 and your packaging for the batch costs $1.50. Your labor for baking and packing is worth $8. Your overhead for the batch, including power, is $2. Your total batch cost is $16. You sell them for $2 each, or $24 per dozen.
Your sheet row would look like this. Cookie Type: Chocolate Chip. Batch Size: 36. Batch Cost: $16. Selling Price: $2 per cookie. Starting Count: 36. If you sell 28 cookies, your Sold Count is 28. Your Ending Count is 8. Your revenue is 28 times $2, which equals $56. Your profit is $56 minus $16, which equals $40. That is your true margin after ingredients, labor, and overhead.
Mistakes that cost you money
The biggest mistake is not tracking waste. Cookies that come home may be stale for the next market. You paid to make them but you cannot sell them. Your sheet must show those leftovers so you bake less next time.
Another mistake is guessing your batch cost. If you do not know your true cost, you cannot know your true profit. Use a detailed cookie recipe cost sheet first. Then transfer the final number to your booth sheet.
Forgetting packaging cost is common. A cellophane bag or a sticker adds up. That cost belongs on your inventory sheet in the batch cost column.
Leaving out overhead is another common mistake for new bakers. Power and other daily costs add up over time. Include them in your batch cost so your margin is real. A profit number without overhead is not true profit.
How to price for a real margin
Your price must cover every cost and still leave money in your pocket. Start with your batch cost from the inventory sheet. Add your labor and your overhead together. Divide by the number of cookies to find your break-even price. Sell above that number to make a real profit. Compare your price to your detailed pricing guide. Make sure your price covers all costs and leaves a fair margin. If a cookie does not sell, the price may be too high.
What your leftovers tell you
Every cookie that comes home at the end of the day cost you money. You paid for ingredients, packaging, labor, and power. Those leftovers are waste, not inventory for the next market. Your sheet must show them so you bake less next time. A high ending count tells you something important about that cookie. The price may be too high or the display may not catch the eye. Cut the batch size or change the price before the next market.
How to use your sheet after the market
Look at your sold counts. Which cookie type sold out first. Which one had the most leftovers. Compare the profit margin for each type. The cookie with the highest margin and fastest sales is your winner. Bake more of that next time.
Look at your ending counts. If you bring home a lot of one type, think about why. Was the price too high. Was it not eye catching. Use this to adjust your next booth. For more ideas, see cake booth ideas.
Check your total revenue against your total costs for the day. Did the market pay for your labor and your overhead. If not, adjust your prices or your bake list. A market that loses money is not worth your time.
How to handle samples and broken cookies
Note broken or sample cookies in a separate column on your sheet. They are part of your cost of doing business. Count them as waste, not as sales. This keeps your profit numbers honest at the end of the day. Samples can bring in buyers, but they still cost you money. Track them so you know the true cost of each market. Adjust your starting count down when you set out samples.
A free template you can use today
You can make this sheet in a notebook or on your phone. Draw seven columns with the headings listed above. Write your cookie types in the first column. Fill in your numbers before you go to the market.
If you use Google Sheets, set up the same columns. Use formulas to calculate ending count and total revenue. This saves you time when you are tired after a market day.
Print a few copies of the sheet so you have a backup. A dead phone battery should not stop your sales. Paper is simple and works when you need it most.
What to check before your next booth
Check your last sheet. Did you account for all your costs. Did you track every sale. Are your profit numbers realistic. Use your last sheet to plan your next bake list. Bake more of what sold and profited well.
Check your pricing. If a cookie did not sell, was the price the issue. Compare your price to your detailed cookie pricing sheet. Make sure your price covers all costs and leaves a fair margin.
Try the free bake pricing calculator
Free, no signup.
Common questions
Should I track inventory on paper or my phone?
Paper is simple and works when your phone battery dies. A phone spreadsheet can do the math for you. Choose the method you will use reliably during a busy sale.
How do I account for broken or sample cookies?
Note them in a separate column or as a reduction from your starting count. They are part of your cost of doing business. They should be counted as waste, not as sales.
What if I sell cookie trays or assortments?
Treat the whole tray as one item on your sheet. Calculate its total batch cost and set one selling price. Track it just like a single cookie type. For more on trays, see [cookie tray pricing](/blog/cookie-tray-pricing/).
Do I need this if I only sell at one market a month?
Yes. One market a month is still a business day. The sheet shows you if that day was worth your time. It helps you improve for the next market.
General business information, not legal or tax advice.