INVENTORY BOSS — MEAL-PREP BATCH WORKSHEET
Guide: https://inventory-boss.net/blog/meal-prep-pricing-unsold-meals

Copy, edit or print. This is a manual worksheet, not an automatic calculator.
Use one currency. Start with a batch already prepared and packed; change
the cost assumptions if production or delivery changes with orders.

Batch/date: __________________  Currency: ______
Meals produced: ______  Expected paid meals: ______

BATCH COSTS
Ingredients: ______  Containers and labels: ______
Labor (include prep, packing and cleanup): ______
Allocated overhead (excluding labor already entered): ______
Delivery cost included in this batch: ______  Other costs: ______
Total entered batch cost: ______

CALCULATE
Production cost per meal = batch cost / meals produced: ______
Cost per paid meal = batch cost / expected paid meals: ______
Selling price, excluding tax collected for remittance: ______
Expected revenue = price x expected paid meals: ______
Amount left before fees = expected revenue - batch cost: ______
Margin before fees (%) = amount left / expected revenue x 100: ______

OPTIONAL TARGET PRICE WITH FEES
Chosen margin (%): ______  Processing rate (%): ______
Fixed charge per transaction: ______  Average meals per order: ______
Fixed fee per meal = fixed transaction charge / average meals per order: ____
Target price = (cost per paid meal + fixed fee per meal)
  / (1 - chosen margin / 100 - processing rate / 100): ______
The denominator and all meal counts used for division must be positive.
Round the final price UP to the next cent to meet the chosen target.

REVIEW AFTER SALES CLOSE
Meals sold at full price: ______  Discounted meals: ______
Actual total revenue (use actual prices): ______  Unsold meals: ______
Actual fees: ______  Other actual costs not already in the batch: ______
Result = actual revenue - batch cost - fees - other actual costs: ______
Raw/cooked yield or portion differences noticed: ___________________
What to change in the next batch or ordering deadline: _____________

Free calculator: https://inventory-boss.net/#cost-calculator