At each review.
Suggested for your taskOriginal Studio 3 / A connected everyday workflow
Maker Pricing & Order Profit Workbook
Cost the product. Quote the order. Keep the actual profit honest.
Connect supplier packs, product recipes and manual selling assumptions to a quote, then compare entered historical order actuals by month.
- Format
- Excel · .xlsx
- Inside
- 9 worksheets
- Included
- Clean file + example + guide
$4.90USD · one-time priceVAT included where applicable. Other applicable taxes are shown at checkout.Explore the sheets Try a calculation
Check the capacity and fitWho it is for, supplied record limits and software requirements
The everyday problem
Does this price cover the product, your time and the selling fees?
A material pack price is not a product cost. A quoted margin is not the profit of an order already sold. This workbook connects usable pack quantities and a recipe to a current quote, while historical orders retain the actual amounts you entered.
Optional guideNeed help getting started?Choose where to begin. All listed files are included.
Add the complete product to your cart whenever you’re ready. Use this guide only if you’d like help choosing what to open first; your choices do not change the product or its price.
Guide step 1 of 4
What would you like to do?
Pick a useful task, or build your own selection.
Which sheets would you explore first?
Choose your starting points. The workbook keeps all its connected sheets and formulas; this does not remove or rebuild worksheets.
Nothing selected yet.
Before starting and reviewing.
Suggested for your taskBefore agreeing an order price.
Suggested for your taskWhen comparing actual results.
Suggested for your taskWhen defining or changing a product.
Suggested for your taskWhen a supplier pack changes.
Suggested for your taskWhen a product recipe changes.
Suggested for your taskAfter an order has an actual result.
Suggested for your taskFor your first session.
Suggested for your taskWhich file would you open first?
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Your starting plan.
Your first file or method
Both XLSX files, all 9 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the complete setup guideThe complete product. Your starting choices do not change its contents or price.
Your choices help you understand the complete product. They do not alter its contents or price.
Both XLSX files, all 9 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the tasks, contents and file choices
Useful starting tasks
Follow one pouch from a recipe into a quote and an actual order.. Use the included START_HERE.pdf guide to follow one complete task in a disposable example copy.
Choose my own starting points. Explore the contents and select only the parts you would use first.
Contents to explore
- Dashboard: At each review.
- Settings: Before starting and reviewing.
- Quote: Before agreeing an order price.
- Monthly: When comparing actual results.
- Products: When defining or changing a product.
- Materials: When a supplier pack changes.
- Recipe: When a product recipe changes.
- Orders: After an order has an actual result.
- Start: For your first session.
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Explore the worked example: Fictional records show how the sheets work together. Save a disposable copy before trying a change. maker-pricing-example.xlsx
Start my own working copy: Open the clean workbook after reading the guide. Keep the original and save a copy for your own records. maker-pricing-clean.xlsx
Follow the complete first taskUse the included guide and a disposable example copy.
Your first useful session / Start with the example
Follow one pouch from a recipe into a quote and an actual order.
Follow this one complete task before entering your own records. Keep the blank original and save a working copy.
Connect the costs
In the fictional example, M-FAB and M-ZIP feed product P-001 through Recipe. Products shows base unit cost 10.00.
Review the quoted price
Quote uses ten units, a 10% discount, 5% selling fee, 1.00 flat fee and 30% target contribution margin. The asking price is 17.27 before discount.
Keep actuals separate
Orders records net revenue 155.00, actual costs 109.00 and profit 46.00. Changing a material price changes the current quote, not these historical totals.
EVERY WORKSHEET / ACTUAL EXAMPLE FILE
See what you enter.
Understand what updates.
Inspect all 9 sheets. These are images of the delivered example, with fictional records. Open an image to read its full detail.
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Dashboard
At each review.
- You enter
- No routine entry
- Calculated or supplied reference
- Actual revenue, costs, profit and warning counts
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Settings
Before starting and reviewing.
- You enter
- Review date, currency and reporting year
- Calculated or supplied reference
- Settings validation
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Quote
Unit costs, selling fees and target contribution in one quote.
- You enter
- Product, units, discount, selling fees and target margin
- Calculated or supplied reference
- Required price, contribution, margin and markup
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Monthly
Current material prices do not rewrite completed order actuals.
- You enter
- No routine entry
- Calculated or supplied reference
- Actual order totals by month through the review date
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Products
A recipe and your time become a base unit cost.
- You enter
- ID, product, minutes, hourly cost, packaging, overhead and active state
- Calculated or supplied reference
- Recipe material cost, labour cost and base unit cost
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Materials
When a supplier pack changes.
- You enter
- Stable ID, pack price, usable quantity and unit
- Calculated or supplied reference
- Unit material cost and warnings
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Recipe
When a product recipe changes.
- You enter
- Stable line ID, product ID, material ID and quantity per unit
- Calculated or supplied reference
- Linked unit cost and recipe cost
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Orders
After an order has an actual result.
- You enter
- Date, product ID, units and actual sales, refunds, cost and fee totals
- Calculated or supplied reference
- Net revenue, total actual cost and contribution
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Start
For your first session.
- You enter
- No routine entry
- Calculated or supplied reference
- Definitions, capacities and instructions
Follow the supplied fictional exampleRead the inputs and the result together
From the supplied fictional example
One pouch. Ten units. A price with a reason.
The quote targets a 30% contribution margin after the entered fees. The actual order separately records sales 160, refunds 5 and costs 109. Current material price changes do not rewrite the actual order.
- Base cost / units
- 10.00 / 10
- Discount / selling fee
- 10% / 5% + 1.00 flat
- Required before discount
- 17.27 / unit
- Quoted contribution
- 46.63
- Entered actual order profit
- 46.00
TRY THE WORKFLOW / FREE
Change a cost. Review the price.
A complete small browser tool to try the planning method. It is separate from the linked records in the downloadable workbook.
From setup to a regular review
How you use it.
Open the 3-step setup and review routineInputs, calculations and the decision each step supports
- 01
Build the unit cost
You enterRegister materials by usable pack quantity, then link them to the product recipe.
CalculatedMaterial quantities, labour minutes, packaging and overhead become base cost.
Your next stepConfirm units and resolve missing or duplicate IDs.
- 02
Quote the order
You enterChoose a product, units, discount, variable and flat selling fees, and target contribution margin.
CalculatedThe quote solves the required after-discount price and before-discount asking price.
Your next stepCheck the assumptions against your actual channel before agreeing a price.
- 03
Record the actual result
You enterEnter historical order sales, refunds, costs and fees once in Orders.
CalculatedMonthly results use actual entered totals through your chosen review date.
Your next stepCompare the result with your quote without rewriting history when current costs change.
9 sheets. Inspect each one.Inputs, outputs and when to use every worksheet
DashboardOpen sheet details
Editable inputs
- No routine entry
Calculated or reference
- Actual revenue, costs, profit and warning counts
At each review.
Inspect the actual Dashboard sheetSettingsOpen sheet details
Editable inputs
- Review date, currency and reporting year
Calculated or reference
- Settings validation
Before starting and reviewing.
Inspect the actual Settings sheetQuoteOpen sheet details
Editable inputs
- Product, units, discount, selling fees and target margin
Calculated or reference
- Required price, contribution, margin and markup
Before agreeing an order price.
Inspect the actual Quote sheetMonthlyOpen sheet details
Editable inputs
- No routine entry
Calculated or reference
- Actual order totals by month through the review date
When comparing actual results.
Inspect the actual Monthly sheetProductsOpen sheet details
Editable inputs
- ID, product, minutes, hourly cost, packaging, overhead and active state
Calculated or reference
- Recipe material cost, labour cost and base unit cost
When defining or changing a product.
Inspect the actual Products sheetMaterialsOpen sheet details
Editable inputs
- Stable ID, pack price, usable quantity and unit
Calculated or reference
- Unit material cost and warnings
When a supplier pack changes.
Inspect the actual Materials sheetRecipeOpen sheet details
Editable inputs
- Stable line ID, product ID, material ID and quantity per unit
Calculated or reference
- Linked unit cost and recipe cost
When a product recipe changes.
Inspect the actual Recipe sheetOrdersOpen sheet details
Editable inputs
- Date, product ID, units and actual sales, refunds, cost and fee totals
Calculated or reference
- Net revenue, total actual cost and contribution
After an order has an actual result.
Inspect the actual Orders sheetStartOpen sheet details
Editable inputs
- No routine entry
Calculated or reference
- Definitions, capacities and instructions
For your first session.
Inspect the actual Start sheetCompare with a manual starting pointWhat the connected workbook adds
| What is included | The free browser workflow | Maker Pricing & Order Profit Workbook 1.0 |
|---|---|---|
| Scope | One quote or a seven-day manual session plan. | Linked stable-ID records across nine worksheets. |
| History | A local draft with manual JSON backup. | Separate input registers and calculated review views. |
| Instructions | Inline scope and assumptions. | Fictional example, clean workbook and illustrated guides. |
Files, capacities and practical limitsRead these before choosing your working copy
The download
Files with a purpose.
maker-pricing-clean.xlsx
Clean connected workbook with marked inputs, formulas, checks and built-in navigation.
maker-pricing-example.xlsx
Separate fictional worked records covering a complete routine.
START_HERE.pdf
Your single guide to setup, the first useful task, file recovery, practical limits and license.
English. Software separate. One currency for monetary records.
Before you choose
Fit and practical limits.
- A maker pricing small batches of handmade goods using one currency and manual records.
- A home studio comparing a quoted price with the actual contribution from completed orders.
Understand the boundaries.
- 100 materials, 100 products, 500 recipe lines and 200 order records. One currency; no conversion.
- Amounts are net of tax. Selling fees, labour assumptions and historical actuals are entered by you; no marketplace fee lookup or tax calculation.
- A current quote uses current material and product costs. Orders retain entered historical costs; they do not update when a material price changes.
- Contribution is after the entered selling fees. Margin and markup use different denominators; neither is a tax or accounting profit measure.
- No stock depletion, purchasing, ecommerce connection, receipt capture or bookkeeping automation.
- Native Excel verification remains pending. Resolve input warnings before reading the calculated views.
Native Excel verification remains pending. Google Sheets and Numbers support has not been established.
Maker Pricing & Order Profit Workbook / Version 1.0
Your own working copy.
Clean workbook, separate example and one START_HERE.pdf guide covering setup, practical limits and the internal-use license.
$4.90USD · One-time purchaseVAT included where applicable. Other applicable taxes are shown at checkout.
Desktop spreadsheet software required; it is not included. Native Excel compatibility is still awaiting verification.
Private preview. Purchases are unavailable while the files and delivery are verified.
Questions about this workbook
The details that affect your choice.
Does the file connect to an external service?
No. Records and review dates are entered manually. The supplied workbook has no macros, external connections or account.
What happens at the row limit?
The documented capacities are fixed. Extending them requires extending formulas and validations; automatic expansion is not advertised.
How should I start?
Follow the illustrated first task in the fictional example, then save a working copy of the clean file. Blue cells are inputs; grey cells contain formulas.