JEDA SmartExcel Drinks & Yogurt Costing Calculator Template (Know Your Real Profit Per Bottle/Cup)

You make the drinks. You sell the yogurt. But do you actually know what each cup is costing you?

Most small drink and yogurt business owners price by instinct they look at what others are charging and copy it. The problem is your milk price, packaging cost, and labour aren't the same as theirs. You could be selling at a loss and not know it.

This template changes that in three steps.

Step 1 — Add your products. Enter your menu with their selling prices. Parfaits, sweetened yogurt, Zobo, smoothies, kunu Etc

Step 2 — Enter your raw materials. List all your ingredients and cost items: milk, fruits, sugar, gas, packaging cups, nylons, stickers, spoons, labour. Everything in one place.

Step 3 — Build your recipe. Select a product, enter the quantity you want to produce, pick the ingredients you used and how much of each cost per unit, and profit calculate automatically.

That's it. Three sheets. No formulas to touch. No Excel experience needed.

It also accounts for wastage automatically, so your numbers are always realistic, not optimistic.

What's inside the download: Two files are included one includes a summary page which will mean you will enable VBA in your excel, the instruction are in the pdf that comes with this excel and the other file comes without VBA

Who this is for: Yogurt makers and sellers, parfait businesses, Zobo producers, kunu and smoothie vendors, chin-chin and snack sellers, and anyone who makes a product to sell and wants to price it properly.

This is the simpler version. If you also run a full restaurant or catering operation with multiple complex meals, check out the JEDA Food Costing System, it includes a dashboard, daily production log, sales tracker, and more.

NOTE: Save a copy of your file after download on google drive before use.

After download, click on the whatsapp link to join the support group(3 Months access to support )