Royal Pricing & Profit Calculator · Excel workbook

Price with the whole picture.

Know Your Numbers. Price With Confidence. Grow Your Profit.

Bring ingredient and material costs, labor, overhead and selling fees into one pricing decision so owners can determine what to charge for a product or service. Built to replace guesswork with organized financial information owners can use. The approach draws on practical small-business experience and developing spreadsheet and analytics skills.

Caterers, bakers and food-preparation businesses

One-time price$49USD · one-time · not a subscription

Excel workbook and companion PDF after verified payment · no account required · Google Sheets is not available.

Follow the worked example Try a one-product estimateRead the payment-fee guideRead the food-business repricing guideLearn how to calculate food cost per servingRead the custom-baking pricing guide

Illustrative pricing walkthrough

Vanilla cake boxes

8 per batch
Illustrative costs for one batch
Ingredients$18.40
Labor$12.00
Packaging$3.60
Overhead$4.00
Batch cost$38.00
Unit cost · one box$4.75
Suggested price at a 40% target margin$7.92
Comparison selling price$8.50
Total cost including estimated fee$4.75
Estimated profit / box
$3.75
Realized margin
44.1%
Markup
78.9%
Illustrative only · 0% price-based fee · $0.00 fixed fee. Margin = profit ÷ selling price; workbook markup = profit ÷ unit cost. Entered transaction fees reduce profit but are not part of the workbook’s markup denominator.

Royal Pricing & Profit Calculator

Eight tabs to build a clearer price.

  1. 01

    Start Here

    Instructions and a sample scenario.

  2. 02

    Business Settings

    Currency, tax assumptions and fees.

  3. 03

    Cost Library

    Ingredients, materials and unit costs.

  4. 04

    Product Builder

    Quantity, labor and overhead allocation.

  5. 05

    Pricing Calculator

    Markup, margin and target selling price.

  6. 06

    Scenario Comparison

    Compare prices and costs.

  7. 07

    Profit Summary

    Revenue, costs and estimated contribution.

  8. 08

    Definitions

    Plain-language explanations of financial terms.

Free one-product estimate

Try your numbers before you set a price.

Use this planning aid to compare prices from the costs and fee assumptions you enter. It is separate from the workbook, does not provide workbook access, and cannot guarantee a profit result. Your draft stays in this browser only; it does not create an account or customer record.

This device only

Saved estimates

Name estimates to keep separate versions of your inputs. Saving here does not include or unlock the workbook.

No named estimates saved yet.

Saved estimates and the current draft stay in this browser. Neither is sent to a server or tied to an account.

Choose a shared cost basis

Enter ingredients and direct materials, including packaging, for one sellable item. Ingredient and batch cost guide

Enter the labor amount for one sellable item. Labor cost guide

Enter the allocated overhead amount for one sellable item. Overhead allocation guide

A percentage charged against the selling price. This estimator has no separate fixed-fee input. Payment fee types guide

Your desired profit share of the selling price after entered costs and percentage fees. Margin and markup comparison guide

Target profit divided by base cost. The 80% starting value is an illustrative workbook example, not a recommendation. Margin and markup comparison guide

Sample starting values allocate the vanilla cake-box example to $2.75 ingredients and materials (including packaging), $1.50 labor, and $0.50 overhead per item. The target margin starts at 40%, the illustrative workbook markup is 80%, and the fee is 0%; the markup is not a recommendation. Replace every value with your own.

Margin and markup prices · planning estimates

Suggested selling price at target margin$7.92
Estimated payment fee
$0.00
Estimated profit per item
$3.17
Estimated margin
40.0%
Estimated markup
66.7%

Base cost $4.75 + estimated payment fee $0.00 = total per-item cost $4.75.

Suggested selling price at target markup$8.55

Compare two selling prices

What changes at each price?

Each scenario starts with shared costs. Add a separate base cost when its costs differ.

Use the number of sellable items in this order. This is separate from batch yield.

Enter a positive target to the nearest cent. The starting $100.00 is a sample.

Order totals multiply each entered per-item price, base cost, and rounded payment fee by quantity. This estimate uses the costs entered and excludes fixed costs that are not modeled here.

Scenario 1 · planning estimate

Positive USD amount, to the nearest cent.

Shared mode uses the per-item or batch cost above. Custom mode replaces it with this scenario’s ingredient/material, labor and overhead cost for one item.

Shared base cost: $4.75

Selling price$10.00
Effective base cost
$4.75
Estimated payment fee
$0.00
Total per-item cost
$4.75
Estimated profit
$5.25
Estimated margin
52.5%
Estimated markup
110.5%

Estimated order totals · 1 item

Estimated order sales
$10.00
Estimated base costs
$4.75
Estimated payment fees
$0.00
Estimated total costs
$4.75
Estimated order profit
$5.25
Minimum whole orders for $100.00 profit
20 orders

Scenario 2 · planning estimate

Positive USD amount, to the nearest cent.

Shared mode uses the per-item or batch cost above. Custom mode replaces it with this scenario’s ingredient/material, labor and overhead cost for one item.

Shared base cost: $4.75

Selling price$12.00
Effective base cost
$4.75
Estimated payment fee
$0.00
Total per-item cost
$4.75
Estimated profit
$7.25
Estimated margin
60.4%
Estimated markup
152.6%

Estimated order totals · 1 item

Estimated order sales
$12.00
Estimated base costs
$4.75
Estimated payment fees
$0.00
Estimated total costs
$4.75
Estimated order profit
$7.25
Minimum whole orders for $100.00 profit
14 orders

A custom base cost replaces the shared per-item basis for that scenario. The payment-fee rate remains shared. The starting prices, $10.00 and $12.00, are sample values; change them to compare your own.

Margin = estimated profit ÷ selling price.

Markup = estimated profit ÷ base cost. Payment fees reduce profit but stay separate from the cost denominator used by the workbook.

Order totals multiply the selected per-item base cost and payment fee by order quantity. Batch yield divides the total batch cost into a per-unit base cost; order quantity is the number of sellable units in the order. This estimate uses the costs entered and excludes fixed costs that are not modeled here. Confirm your recipe yield, labor, overhead, taxes, channel fees, and local pricing before making a business decision.

Royal Profit Lab

Free one-product planning estimate

A standalone planning estimate based on the assumptions entered below. It is separate from the paid workbook, does not grant workbook access, and cannot guarantee profit.

All monetary values are in USD.

Active cost basis
Ingredient/material + labor + overhead per item
Total batch cost (USD)
No value entered
Sellable batch yield
No value entered
Derived cost per sellable unit (USD)
Unavailable
Ingredient cost per item (USD)
$2.75 USD
Labor cost per item (USD)
$1.50 USD
Overhead cost per item (USD)
$0.50 USD
Payment-fee rate (%)
0.0%
Target profit margin (%)
40.0%
Target markup (%)
80.0%
Order quantity (sellable items)
1 item
Target profit amount (USD)
$100.00 USD
Scenario 1 selling price (USD)
$10.00 USD
Shared base cost (USD)
$4.75
Scenario 2 selling price (USD)
$12.00 USD
Shared base cost (USD)
$4.75
Suggested selling price at target margin (USD)
$7.92
Base cost (USD)
$4.75
Estimated payment fee (USD)
$0.00
Total per-item cost (USD)
$4.75
Estimated profit per item (USD)
$3.17
Estimated margin (%)
40.0%
Estimated markup (%)
66.7%
Target markup
80.0%
Suggested selling price at target markup (USD)
$8.55
Markup-based estimated payment fee (USD)
$0.00
Markup-based estimated profit (USD)
$3.80

Scenario 1

Base cost (shared, USD)
$4.75
Selling price (USD)
$10.00
Estimated payment fee (USD)
$0.00
Total per-item cost (USD)
$4.75
Estimated profit (USD)
$5.25
Estimated margin (%)
52.5%
Estimated markup (%)
110.5%

Estimated order totals · 1 item

Estimated order sales (USD)
$10.00
Estimated base costs (USD)
$4.75
Estimated payment fees (USD)
$0.00
Estimated total costs (USD)
$4.75
Estimated order profit (USD)
$5.25
Whole orders needed to reach target profit
20 orders

Scenario 2

Base cost (shared, USD)
$4.75
Selling price (USD)
$12.00
Estimated payment fee (USD)
$0.00
Total per-item cost (USD)
$4.75
Estimated profit (USD)
$7.25
Estimated margin (%)
60.4%
Estimated markup (%)
152.6%

Estimated order totals · 1 item

Estimated order sales (USD)
$12.00
Estimated base costs (USD)
$4.75
Estimated payment fees (USD)
$0.00
Estimated total costs (USD)
$4.75
Estimated order profit (USD)
$7.25
Whole orders needed to reach target profit
14 orders

Sample starting values allocate the vanilla cake-box example to $2.75 ingredients and materials (including packaging), $1.50 labor, and $0.50 overhead per item. The target margin starts at 40% and the fee at 0%; replace every value with your own.

The starting scenario prices, $10.00 and $12.00, are sample values; change them to compare your own.

Each scenario uses its selected shared or custom base cost and the shared payment-fee rate. Margin = estimated profit ÷ selling price. Markup = estimated profit ÷ base cost. Payment fees reduce profit but stay separate from the cost denominator. Batch cost per unit is rounded to cents before it is used in the estimate.

The markup price uses base cost × (1 + target markup) ÷ (1 − percentage fee rate). The 80% starting markup is an illustrative workbook example, not a recommended target.

Order totals multiply the selected per-item base cost and payment fee by order quantity. Batch yield divides the total batch cost into a per-unit base cost; order quantity is the number of sellable units in the order. Confirm your recipe yield, labor, overhead, taxes, fixed charges, channel fees, and local pricing before making a business decision.

This estimate uses the costs entered and excludes fixed costs that are not modeled here.

From cost to price

Every cost has a place in the decision.

The calculator brings the costs behind a product or service together, then helps an owner compare a target price with a possible selling price.

01

Build the full cost

Ingredients and packaging, labor, overhead allocation and selling fees.

02

Set a target margin

See a suggested selling price that accounts for unit cost and fee assumptions.

03

Compare the result

Keep margin and markup separate: profit ÷ selling price versus profit ÷ unit cost. Entered transaction fees reduce estimated profit but are not part of the workbook’s markup denominator.

Format status

Buy the Excel workbook. Google Sheets is not available.

The Excel workbook is a $49 USD one-time purchase. After the server verifies payment for this exact product, the confirmation page provides both the workbook and its companion quick-start PDF. No app account is required. The Google Sheets copy/template has not been created or owner-tested and has no shareable link.

One-time purchase · $49 USD

Excel workbook

Purchase for $49 USD once. The workbook and its companion quick-start PDF are available after payment is verified. No app account is required.

Not available yet

Google Sheets copy/template

The copy has not been created or owner-tested, and there is no shareable template link yet.

Availability updates

Get Google Sheets availability updates

Leave your email for an update if this format becomes available.

No account needed. This request does not provide access to a template.

Excel download access is released only after the server verifies the $49 USD one-time payment; the companion quick-start PDF is provided beside it on the confirmation page. No app account is required. The Google Sheets copy has not been created or owner-tested and has no shareable template link.

Product questions

Ask about the calculator.

Ask about the Excel workbook, Google Sheets availability, or how the pricing and profit estimates work. The workbook is a $49 USD one-time purchase with download access after verified payment; its companion quick-start PDF is available beside it after payment is verified. Google Sheets has not been created or owner-tested and has no shareable link.

No account is needed. Sending a question does not provide product access or confirm format compatibility.