Question 1

Who is the Royal Pricing & Profit Calculator for?

Accepted Answer

It is designed for caterers, bakers, and food-preparation businesses that want to bring ingredient or material costs, labor, overhead, and selling fees into a pricing decision. The workbook helps organize those inputs and compare a possible price; it does not promise a particular profit outcome.

Question 2

How should I work through the workbook?

Accepted Answer

Use the tabs in order: Start Here, Business Settings, Cost Library, Product Builder, Pricing Calculator, Scenario Comparison, Profit Summary, and Definitions. Blue cells are editable inputs; pale-green cells are protected formulas or calculated results. Dropdowns, range checks, and error warnings guide entries where provided. Replace the illustrative sample inputs with your own before relying on a price.

Question 3

What can I enter in the Cost Library?

Accepted Answer

The categories are Ingredients, Packaging, and Other materials. For each line, enter a category, item name, quantity per batch, unit, and unit cost; the workbook calculates the line total as quantity multiplied by unit cost. The unit list is each, batch share, oz, lb, g, kg, ml, L, hour, and portion.

Question 4

What do Business Settings and Product Builder cover?

Accepted Answer

Product Builder adds the number of sellable units in a batch, labor per batch, and allocated overhead per batch. Business Settings offers USD, CAD, AUD, GBP, and EUR currency labels; changing the label does not convert entered values. Its sales-tax planning rate is excluded from profit and price formulas. You can also enter a price-based fee rate and a fixed fee per sale, and the suggested price accounts for those fee assumptions.

Question 5

How are markup and margin different?

Accepted Answer

Markup is profit divided by cost. Margin is profit divided by selling price. They use different denominators, so the percentages are not interchangeable. The suggested price solves for the target margin after the entered price-based and fixed fees are included.

Question 6

What does the vanilla cake box example show?

Accepted Answer

This is an illustrative sample, not a business result: 8 boxes per batch use $18.40 of ingredients, $12.00 of labor, $3.60 of packaging, and $4.00 of overhead. That is $38.00 per batch, or $4.75 per box. With a 40% target margin and both fee assumptions at zero, the suggested price is $7.92. At the $8.50 comparison price, estimated contribution is $3.75 per box, margin is 44.1%, and markup is 78.9%. Estimates exclude taxes, owner draws, financing, and costs not entered in the workbook.

Question 7

How much does the workbook cost, and how do I get it?

Accepted Answer

The Excel workbook is a $49 USD one-time purchase. Complete the hosted checkout; the server verifies payment for this exact product before it releases the workbook and its companion quick-start PDF on the confirmation page. You do not need an app account. A Google Sheets copy or template has not been created or owner-tested, and there is no shareable template link.

Question 8

Should I use the sample figures to set my own price?

Accepted Answer

No. The vanilla cake box figures are illustrative inputs to show how the workbook is organized. Replace them with your own quantities, costs, labor, overhead, and fee assumptions, then review the warnings and calculations. Any estimate still excludes taxes, owner draws, financing, and costs you have not entered.

Royal Pricing & Profit Calculator FAQ

Need more detail?