A dealer margin worksheet is a decision record, not a promise of profit. It helps a distributor or showroom team make the commercial assumptions visible before comparing models, markets, or order routes. The worksheet should connect a specific model reference and configuration to the buyer’s own expected purchase, freight, handling, sales, service, and local-cost assumptions.
Start with a defined sales scenario
Build one worksheet for one selected model, intended market, sales route, and order context. A barrel sauna for a showroom, an indoor cabin for a local retail buyer, and a commercial project package can have very different handling, installation, lead-generation, and after-sales assumptions. Combining them into one average number hides the decisions that matter.
Use ranges or scenarios where a cost is uncertain. Freight, duty, tax treatment, exchange rates, local delivery, storage, sales commissions, installation support, and warranty handling are market- and order-specific. They should be verified by the responsible buyer, broker, carrier, accountant, and local professional rather than copied from a generic online calculator.
Use a complete cost map
| Worksheet area | Buyer input | Review note |
|---|---|---|
| Product scope | Selected model reference, configuration, selected options, and quantity. | Keep the calculation tied to an identifiable product and order scope. |
| Purchase and shipping | Quoted product amount, transport route, packing assumptions, brokerage, duties, taxes, currency treatment, and local delivery. | Record source, date, currency, and what each figure includes or excludes. |
| Local operating cost | Warehouse handling, showroom preparation, marketing, sales time, installation support, and financing where relevant. | Use the buyer’s own local data rather than a supplier-side estimate. |
| Service allowance | Training, spare-parts readiness, customer support, returns process, and warranty-policy assumptions. | Separate expected service work from a blanket percentage if possible. |
| Target sales scenario | Expected sales price range, channel, timing assumption, and any discount policy. | Keep assumptions visible; a target is not an achieved sale. |
Separate gross margin from actual business return
A simple gross-margin view can help compare the expected sale value with the direct product and shipment scope. It does not measure the full return on a showroom, dealer launch, or project program. Actual business results may also depend on inventory carrying time, customer acquisition, finance costs, installation labor, local service, claims, taxes, and the buyer’s own overhead.
Keep the labels precise. Use “assumption,” “quote,” “estimate,” “range,” and “actual” rather than presenting a spreadsheet output as a guarantee. When an order changes model, destination, currency, quantity, or packing direction, update the relevant inputs instead of reusing an old result.
Review the assumptions before using the result
| Review question | Why it changes the decision | Evidence to retain |
|---|---|---|
| Does the model reference match the proposed sale? | Different size, wood, heater, glass, packaging, and option choices can change scope. | Model link, drawing revision, and chosen option record. |
| Are all logistics inputs current? | Routing, fuel, port, carrier, brokerage, and local delivery conditions may change. | Current quotes and stated validity dates. |
| Are local costs owned by the right team? | Warehouse, installation, sales, and support estimates are not factory costs. | Internal budget owner and local-source notes. |
| What changes under a cautious scenario? | A lower sales value, slower turnover, or higher landed cost may affect the decision. | Base, cautious, and upside assumptions kept side by side. |
| What still needs confirmation? | The worksheet must not replace a specific order, drawing, tax, or site review. | Open-items list with owner and date. |
Use the worksheet to ask better questions
A useful worksheet identifies the precise question behind a commercial decision: whether a selected model fits a showroom plan, whether a quantity supports a distribution launch, whether a project budget includes local obligations, or which costs require a different route. It should make uncertainty visible early enough for the buyer to revise the scope before committing.
Keep commercial claims proportionate
No worksheet can promise a sales price, margin, turnover rate, or return. It does not replace local tax, legal, accounting, financial, installation, or market advice. The buyer should confirm these matters with appropriately qualified local parties and update the file when the selected model, destination, or commercial scope changes.
Use model references consistently
For a selected product reference, see the sauna product library. For wood, glass, roof, lighting, and accessory directions, see materials and accessory options. Final commercial terms and local responsibilities remain specific to the buyer’s order and destination.
Working file preview: model-level commercial worksheet
Keep each commercial worksheet tied to one selected model or configuration, destination, sales route and period. Enter the source and date beside every figure. A blank field is better than an invented estimate. The worksheet is a management record for comparing scenarios; it is not a price list, tax calculation, funding recommendation, or promise of profit.
| Worksheet block | Input to record | Source/status |
|---|---|---|
| Selected sale scope | Model/reference, chosen configuration, quantity, intended channel, destination, currency and target sales period. | Current product/order file and buyer-owned sales scenario. |
| Direct purchase scope | Quoted product amount, included/excluded options, packing assumptions and quote validity. | Supplier quotation date and revision. |
| Landed-cost inputs | Transport, insurance where applicable, brokerage, duty/tax treatment, currency assumptions, local delivery and handling. | Carrier/broker/accounting source, date and inclusion note. |
| Local cost inputs | Storage, showroom preparation, sales time, marketing, financing, installation support and service preparation. | Buyer-owned budget source; mark estimate, quote or actual. |
| Revenue scenario | Expected sale value/range, discounts, payment timing, channel fees and the reason for each assumption. | Buyer market record; an expectation is not a completed sale. |
| Actuals and variance | Actual invoiced value, incurred cost, date, variance from the scenario and reason for the difference. | Accounting/operational record owned by the buyer. |
Keep the calculation labels precise
Write the formula in the file and label its scope. For example, a direct contribution view may compare expected sale proceeds with the defined direct purchase and delivery scope. A broader business-return view may also include local selling, storage, finance, service, overhead and the timing of cash received. Neither figure is useful if the selected model, quantity, currency, dates and cost inclusions differ between scenarios.
| Metric label | State what it includes | State what remains outside it |
|---|---|---|
| Quoted product amount | The named product/configuration and inclusions stated on the current quote. | Freight, local taxes, broker fees, local delivery, finance and buyer operating costs unless expressly included. |
| Landed-cost estimate | Defined product, shipment and local arrival inputs recorded for the specific route. | Later market, finance, sales, installation, service or claim costs unless separately entered. |
| Gross-margin scenario | The buyer’s stated sales value less the explicitly chosen direct cost lines. | Overhead, cash timing, returns, claims, slow turnover and other omitted risks. |
| Program return review | Actual sales/cost records for the buyer’s own defined program and period. | A prediction or guarantee for another market, model or future period. |
Run three assumptions side by side
Use the same cost map for a base case, a cautious case and an upside case. Change only the assumptions that are genuinely uncertain, such as sale value, currency, delivery cost, channel discount, storage time or local service allowance. Record why each version exists. Comparing explicit scenarios is more useful than claiming one output is “the ROI.”
- Base case: current known inputs and a clearly dated expected sales scenario.
- Cautious case: lower expected sale value, higher defined cost, longer cash cycle or other buyer-identified downside inputs.
- Upside case: only assumptions the buyer can explain with actual evidence or a documented plan.
- Actual case: replace estimates with the buyer’s recorded invoices, costs and dates after the program runs.
- Change log: note model, quantity, route, currency, packaging, destination or configuration changes that make a former calculation no longer comparable.
Check cash timing separately from margin
A positive margin scenario does not automatically show when cash is paid or received. Record payment milestones, deposits, freight or brokerage timing, warehouse/storage exposure, customer payment terms, and expected inventory holding period in a separate cash-timing view. The U.S. Small Business Administration also distinguishes bookkeeping, costs, and cash-flow management in its business finance guidance; buyers should use appropriately qualified local accounting and financial advice for their own market and tax position.
Commercial boundary
CSauna can clarify an identified product scope, available materials/components, packing information and order-specific quotation inputs. It does not provide tax, legal, accounting, investment, credit, market, freight, installation or financial advice, and no worksheet can guarantee sales price, margin, turnover, cash flow, or return. Final commercial decisions belong to the buyer and its appropriately qualified local advisers using the current order, destination, contracts and actual records.