Menu Item report

The Menu Item tab shows what one dish costs to make and how much of its price is margin. Every ingredient has its own row, so you can see which ingredient drives the cost.

Choose the dish in the Choose a menu item… picker. The address changes to /reports?type=menu-item&menuItemId=…. Archived menu items are in the picker too.

This report is the theoretical cost: the recipe times today's prices. It does not use sales. For what food really cost over a period, use the Food Cost report.

The top row

For a dish made from a recipe, the top row shows Selling Price, Food Cost, Food Cost %, Gross Margin and Portions per Batch.

cost per sale = batch cost ÷ portions per batch × portions per sale
food cost %   = cost per sale ÷ selling price

Food Cost % is green at 30% or less, yellow up to 35%, and red above 35%. It shows "—" when the selling price is zero. This report uses these fixed bands, not the target you set on the dish. The Menu page compares each dish with its food cost target.

Ingredient Cost Breakdown

Each row shows the ingredient, the recipe amount, and the amount in the product's own unit when the units differ. The right side shows the line cost and its share of the batch. Rows are sorted by cost, highest first.

Each row also says where its price came from:

• Receipt avg is the weighted average of this year's receipts for the product.
• Product default is the case cost on the product. Rinvy uses it when the product has no receipts this year.
• Computed from recipe is a house-made product, priced from its own recipe.
• No cost data means Rinvy has no price for the ingredient. An ingredient you do not stock, such as water, always shows this and costs $0.

The Batch Summary card under the list adds up the batch: total cost, yield, cost per portion, selling price, gross margin and food cost %.

When the cost is incomplete

A cost is incomplete when Rinvy cannot work out the cost of one or more ingredients. That happens in three cases: the recipe unit does not convert to the product's unit, the product no longer exists, or a house-made ingredient has no recipe (or its recipe uses itself in a loop). Rinvy leaves those ingredients out of the sum instead of guessing. The dish then looks cheaper than it is.

An ingredient with No cost data is not incomplete. Rinvy knows what it is, but nothing has a price for it yet, so it costs $0. The Food Cost % does not turn red for it. Receive the product or set its case cost to give it a price.

When a dish is incomplete, Food Cost % shows red whatever the number is. Find the row that explains the gap. It has a warning line under it:

• Unit conversion failed (cup → lb) — cost excluded means the recipe states the ingredient in a unit that the product cannot convert to. Add a unit conversion on the product. See units, case size and costs.
• Recipe output product — no recipe data found to compute cost means a house-made ingredient has no recipe that Rinvy can price.
• This recipe's own cost is incomplete is on a sub-recipe row. The gap is inside the sub-recipe. Open the menu item for that sub-recipe to find the ingredient that was left out.

An estimated cost is a different state. A cost is estimated when no ingredient in the recipe, including its sub-recipes, is priced from a receipt. The ingredients use the case cost on the product, or $0 when there is no case cost. A dish can be estimated and incomplete at the same time, and a combo component row can show both labels.

Combos

A combo has no recipe. Its report lists each component with its quantity and its cost per sale. A component row says Estimated (no receipt data) or Incomplete (ingredients excluded) when that applies. The Combo Summary card compares the combo price with If Sold Separately, the total of the components' own prices. The difference is the Bundle Discount.