A product can sell well and still earn less than expected. For many home bakers, caterers, cafés, and small food sellers, the problem starts before the first order: the selling price was chosen without calculating the complete cost.

Ingredient cost is only the beginning

Flour, sugar, meat, vegetables, and other ingredients are easy to remember. Smaller costs are easier to miss. Packaging, labels, utilities, delivery preparation, platform fees, wastage, and the owner's time all affect the amount left after a sale.

A useful costing routine starts by converting every purchase into a consistent unit cost. If an ingredient is bought by kilogram but used by gram, calculate its cost per gram. Use the same approach for milliliters, pieces, packs, and trays. This makes recipes easier to update when supplier prices change.

Calculate the batch before the serving

After listing the ingredients, calculate the cost of one complete batch. Add reasonable amounts for labor, utilities, packaging, and other costs connected to producing that batch. Then divide by the number of portions that can actually be sold.

Use realistic yield, not the perfect yield written in an old recipe. Spillage, trimming, damaged pieces, and test portions can reduce what is available for customers.

A basic workflow is:

  1. Update ingredient purchase prices and quantities.
  2. Enter the amount of each ingredient used in one recipe.
  3. Add labor, utilities, packaging, wastage, and selling fees.
  4. Confirm the realistic number of sellable servings.
  5. Review cost per serving before choosing the final price.

Pricing needs both pesos and percentages

A target margin can guide pricing, but it should not replace judgment. Review the estimated peso profit per sale, the percentage margin, customer value, competitor pricing, and the capacity of the business. A price is more useful when the owner understands what is included in the calculation.

Actual sales and expenses should also be recorded. A costing estimate explains what should happen; a monthly dashboard helps show what did happen. Comparing the two can reveal frequent discounts, unexpected expenses, low-margin products, or ingredients that need updated prices.

An organized workbook reduces repeated work

KitaKitchen PH — Microsoft Excel Edition connects ingredient costs, recipes, suggested prices, sales, expenses, inventory, and profit reporting in one offline workbook. It is designed for Microsoft Excel 2019 or newer and includes an illustrated product-specific PDF user guide.

The workbook is a planning tool, not accounting, tax, legal, or financial advice. Its results depend on the information entered, so buyers should use current figures and review their own business requirements.

For food sellers who prefer working offline on a desktop or laptop, view KitaKitchen PH — Microsoft Excel Edition.