The cost model is still useful after the award. A packaging revision, a slower production ramp, or a freight change can alter the economics of a program that looked sound when it was quoted.
A usable model helps the team answer two questions: what changed, and what decision do we need to make?
The structure below is my analytical recommendation. It is not a Walmart or Sam’s Club costing template, a required disclosure format, or a statement about the retailer’s internal margin approval process.
Keep the agreed basis visible
Record the item, approved specification, pack configuration, production assumptions, commercial terms, and basis date. Distinguish an executed agreement from a quote, forecast, or internal planning scenario.
Use one consistent unit for the calculation and reconcile the rollup to cases or other selling units. A sellable club pack, an individual component, and a shipping case are different units; name them explicitly.
Separate costs without counting them twice
A useful internal build might distinguish materials, conversion, allocated overhead, packaging, and the freight or handling costs your company bears under the agreed terms.
The categories depend on your accounting approach and what is already included in supplier quotations. If a co-manufacturer’s unit price includes labor, packaging, and scrap, adding those costs again will overstate the total.
Treat yield and scrap carefully. Define the calculation and the base to which a loss factor applies. A yield adjustment is not automatically an additional scrap charge.
| Input | What to document |
|---|---|
| Quantity or rate | Unit of measure and calculation basis |
| Source | Quote, contract, production history, or assumption |
| Date | When the evidence was current |
| Scope | What is included and excluded |
| Sensitivity | What could change the input |
| Owner | Who can confirm or update it |
Keep price and margin definitions distinct
The supplier’s selling price is not the retailer’s shelf price. Supplier gross margin, markup on cost, and the retailer’s item margin are different calculations.
For an internal illustration, suppose the supplier sells one unit for $2.00 and assigns $1.60 of cost of goods sold to that unit. Gross profit is $0.40 and gross margin is 20% of sales. Markup on the $1.60 cost is 25%.
If comparable cost rises to $1.70 while the selling price stays unchanged, gross profit becomes $0.30 and gross margin becomes 15%. This is illustrative arithmetic, not a target margin or forecast. Use finance-approved definitions and the appropriate net sales and cost treatment for your actual reporting.
Model the decisions you might actually face
Choose scenarios based on evidence rather than a universal low/base/high percentage.
A lower-volume case should reflect credible changes in run length, changeovers, labor, minimum order quantities, and inventory exposure. A pack-change case should show the incremental materials, throughput, handling, and transport effects. A commodity scenario should state the reference, date, and relationship to your purchase cost.
Forecast volume should remain labeled as a forecast. Do not treat it as guaranteed utilization or a purchase commitment.
Show the change before sharing the detail
A concise comparison can make the discussion easier:
| Driver | Previous basis | Proposed basis | Effect per defined unit |
|---|---|---|---|
| Pack structure | Current approved version | Proposed revision | Calculated delta |
| Production | Current evidenced assumptions | Revised run assumptions | Calculated delta |
| Freight | Current contractual basis | Proposed route or terms | Calculated delta |
Reconcile the deltas to the new total. Explain uncertainty as a range where appropriate rather than hiding it in a single precise figure.
Carry an accepted cost change into the operating records
A commercial decision needs an implementation owner. I recommend retaining the approval, confirmed effective date, item and location scope, unit basis and the records that still need to change. Keep the requested date separately if it differs from the confirmed date. When approval depends on new orders, keep each PO's original issue date separate from any revision date. A later revision alone does not establish that it is a new order covered by that approval.
For a fictional example, a supplier has a confirmed cost of $2.10 per sellable unit for a defined future period. An existing order still shows $2.00. The internal model can show both values and their scope while the account team establishes which basis applies to that order. The model does not authorize finance to use a different invoice amount or operations to amend the order.
Use Retail Reason's old-cost purchase-order guide to compare the actual approval, item record and relevant PO version. Return the supported result to the cost model with its source and date. A submitted update should not silently become the confirmed selling price in every scenario.
If the apparent difference comes from cases versus sellable units, work through Retail Reason's PO and case-pack comparison before interpreting it as a price change. Keep the physical configuration and arithmetic basis visible to both finance and operations.
Agree on what leaves the company
An internal cost model may contain sensitive commercial information. Share the detail required by the agreement or the specific discussion, with your company’s approval. A should-cost exercise does not create a blanket obligation to expose every internal cost or margin.
Use the agreed commercial process to propose changes; an updated spreadsheet does not itself change the price or terms. Keep accepted revisions connected to the specification, orders, and implementation date.
If reconciling the model uncovers an operating question about orders, payments, or deductions, look for the relevant guide in Retail Reason’s maintained retail answers. Keep the company’s cost assumptions and approval decisions in its own commercial record.
If the model’s main problem is repeated manual work or unclear assumptions, Startup Success Lab can help. Retail Reason Intelligence provides operating guidance alongside the work.