How to use and verify calculations — Menu & Grocery Planning Tool
Menu & Grocery Planning Tool
First save recipes and their ingredients in the production sheet. In the planner, choose a period start and a daily, weekly or monthly view. An optional end date adjusts the interval; entries outside it remain saved but do not enter the displayed summary. Add each preparation with its date and the number of servings to produce. The planner divides this number by the saved recipe yield to obtain a scaling factor. Two recipes using 250 g and 500 g of the same ingredient require 750 g before utilization adjustments. The list groups by the selected ingredient record, not name similarity. Whole packages are calculated after consolidating demand. Compare the purchasing cost with your budget and inspect preparation cost separately. Duplicating a period copies its schedule to a following interval of equal duration while retaining the original.
Data before results
Start by identifying the product, recipe and production period. Record the measured quantity, its unit and the price actually supplied by the vendor. A one kilogram package contains one thousand grams, but the price of the entire package is not the price of a single gram. Choose one currency for the project and keep every amount in that currency. Selecting a currency changes presentation without looking up exchange rates. Unknown essential costs should remain blank. Entering zero for an unknown amount produces a different conclusion from recording that the information is unavailable. Check every field before saving and keep a record of the original purchasing information.
Purchasing, use and utilization
The net quantity used is the ingredient entering the preparation after trimming. Utilization is a fraction between zero and one: eighty percent is entered as 0.80. The gross purchasing quantity is the net quantity divided by utilization. This adjustment represents explicitly supplied operational loss and does not automatically apply nutrient losses or composition changes. When there is no measured loss, the user can enter utilization of one. There is no universal loss rate for every food. Measurements made in your operation should use the same procedure and weighing reference so that comparisons remain meaningful over time. Keep purchase measurements separate from the final cooked weight.
Checking measurement units
Mass, volume and item counts are different dimensions. The engine converts milligrams, grams, kilograms, ounces and pounds within mass, and milliliters and liters within volume. Crossing mass and volume requires a density entered in grams per milliliter. That density must correspond to the ingredient and measurement conditions. A cup does not have a universal mass. An item count does not automatically supply the weight of each item either. In the production sheet, keep the package quantity consistent with the purchasing unit. In comparisons, serving quantities use the displayed base unit: grams, milliliters or individual units. Do not compare different dimensions as though they were equivalent.
Formulas and calculation audit
Open View calculation to inspect the expression, substituted values, origin and version of the applied formula. Ingredient cost is the package price multiplied by the required gross quantity and divided by package size. For example, a one thousand gram package priced at twenty currency units, with gross use of two hundred and fifty grams, costs five currency units. Operations use exact fractions internally; decimal places and rounding are presentation choices. Adding amounts that were rounded manually can create small differences compared with a total calculated before rounding. The audit shows the intermediate steps needed to investigate those differences and confirm the original input values.
Margin, markup and contribution
Margin and markup have different bases. For a cost of seven, a thirty percent margin requires a selling price of ten. A thirty percent markup on the same cost produces a price of nine and ten hundredths. The tools keep these results separate. Contribution subtracts variable costs and entered fees from the discounted selling price. It shows how much remains to cover fixed expenses and other commitments. It is not net profit. Taxes and fees are not inferred from a country or tax regime. Break-even requires positive contribution and entered period fixed costs, using the same time reference as the corresponding sales volume.
| Formula | Entered values and units | Results |
|---|---|---|
| Cost per serving | 60 / 12 | 5 |
| Price with target margin | 7 / (1 − 0.30) | 10 |
| Price with markup | 7 × (1 + 0.30) | 9.10 |
Storage, backup and recovery
Recipes, ingredients, formulas and schedules share a local project in this browser. Save a JSON backup before clearing the browser, changing devices or making substantial edits. History keeps up to twenty manually saved versions; automatic saving preserves the current work but does not replace an external copy. Imports are checked for file size, schema version, structure and references between recipes and ingredients. An incompatible file must not replace the current project. Local storage depends on device permissions and available space. It is not encrypted protection. People with access to the browser profile may access saved data. Store exported commercial documents in an appropriate private location.
Exports and operational decisions
Reports contain entered data, results, units, generation date and calculation audit. Use CSV for a simple table and XLSX to organize information in a spreadsheet. PDF and printing make it easier for another person in the operation to check the numbers. PNG records the results view, including the calendar when available. Inspect downloaded files and retain the JSON backup for continued editing. Reports contain no advertising. Before purchasing, confirm availability, commercial package sizes, current prices and vendor conditions. A mathematical simulation reflects the entered parameters; it is not a stock reservation or a guaranteed quotation. Compare reports using matching periods and consistent units.
Limits and custom formulas
The advanced editor lets you duplicate a standard formula, select operational variables and test a custom expression. Its syntax accepts numbers, parentheses and arithmetic without executing code. Testing verifies structure and dimensional compatibility, but it does not establish technical suitability for a specific purpose. The standard version stays identified and preserved. Optional composition data is supplied by the user with an explicit source, reference quantity and unit. Missing values appear as unavailable information. These calculations do not prescribe diets, assess patients, certify foods as safe for allergies or create official food labels. Use these fields only to inspect arithmetic proportions of information that is actually known.
Frequently asked questions
Is registration required?
No. All five tools work free in the browser without registration.
How can I verify the result?
Open View calculation and inspect inputs, units, expression, version and steps. Export the audit for review.
Do calculations produce official labels?
No. These are commercial and operational tools without clinical assessment or regulatory certification.
Integrated tools
Quima Food Business Tools — Food operations
Recipe Cost & Production Sheet
Food Yield & Conversion Calculator