Product costing tools
Unit Price Calculator
The Unit Price Calculator maintains shared ingredient and packaging prices that can be reused across recipes. It calculates recipe costs, unit prices, taxes, packaging, and pricing multipliers while automatically recalculating affected recipes when a source price changes.
The Challenge
Home bakers selling their products often had ingredient and packaging prices repeated across many recipes. When a source price changed, every affected recipe had to be found and recalculated manually.
The Approach
I conceived, designed, and built a central repository for ingredient and packaging prices. Recipes reference those shared records, allowing the application to calculate unit costs using ingredients, packaging, taxes, and pricing multipliers. When a source price changes, affected recipes are recalculated automatically.
Highlights
- Original product conceived and built by me
- Central ingredient and product-price repository
- Shared packaging-price repository
- Automatic recipe-cost calculation
- Automatic unit-price calculation
- Automatic recalculation after price changes
- On-the-fly unit conversion
- Support for taxes and pricing multipliers
- Designed for home baking businesses
