A selling quote can remain unchanged while the cost of delivering it changes. The exposure depends on which purchases are already secured, when the customer accepts, and when the business can place its supplier order. A quote-validity date is therefore an operating assumption to connect with procurement, not a substitute for measuring the dollars still exposed. This worksheet evaluates the cost window without interpreting contract enforceability.
Worked decision model
Exposed cost increase = unsecured units × original input cost × input-price increase; contribution = quoted revenue − original order costs − exposed cost increase
Suppose a producer quotes 200 units at $75 each, creating $15,000 of potential revenue. Product inputs cost $38 per unit, other variable delivery costs are $7 per unit, and order setup costs $1,000. The quoted order contribution after setup is $5,000: $15,000 less $7,600 of inputs, $1,400 of other variable costs, and $1,000 setup. That is 33.3333% of quoted revenue under this defined cost boundary, before shared overhead.
The producer already has 80 units of input reserved at the quoted cost. The remaining 120 must be purchased after acceptance. If their input price rises 12% of the original $38, it becomes $42.56 and adds $4.56 for each exposed unit. Additional cost is $547.20, reducing order contribution to $4,452.80 and its share of revenue to approximately 29.6853%. Applying the 12% increase to all 200 units would overstate this particular exposure.
| Cost scenario | Extra input cost | Order contribution | Share of quoted revenue |
|---|---|---|---|
| Original cost | $0.00 | $5,000.00 | 33.3333% |
| 12% rise on 120 exposed units | $547.20 | $4,452.80 | 29.6853% |
| Maximum increase at 30% contribution | $500.00 | $4,500.00 | 30% |
If the minimum acceptable contribution is 30% of the $15,000 quote, the order can absorb at most $500 of additional cost. Spread over the 120 exposed units, that allows a $4.1667 increase per unit, approximately 10.9649% of the original $38 input price. The 12% scenario exceeds the budget by $47.20. That dollar gap is more useful for reviewing the offer than simply calling the supplier change a double-digit increase.
Map dates as well as amounts. A customer quote valid until Friday does not eliminate exposure if the supplier quote expires Wednesday or purchasing waits another week for approval. Inventory reservation also needs operational support: stock used for another order is no longer protected capacity for this quote. A customer deposit changes cash timing but does not itself lock a material price. Any supplier reservation payment belongs in the separate cash schedule.
Create a review trigger for the actual cost pool: an updated supplier quote, a missed purchase date, or reserved inventory falling below the assumed quantity. If the required selling price changes, calculate it from the new total cost and the intended margin rather than adding a supplier percentage to every price component. Check demand, customer terms, and delivery capacity separately. The worksheet makes exposure visible; it cannot promise that a price change will be accepted or that an assumed supplier cost will remain available.
Apply and verify the decision
-
Identify secured quantities
Match reserved stock or confirmed supplier commitments to this specific order. Treat quantities without a dependable reservation as exposed.
-
Align the calendars
Record customer acceptance, supplier validity, purchasing approval, and delivery dates together. Revisit the model when any date moves.
-
Set a dollar review point
Compare the updated cost estimate with the remaining contribution allowance and document who reviews the quote when that allowance is exceeded.
Method reference: OpenStax: Relevant Information for Decision-Making. Accessed October 22, 2026. The reference supports the accounting concept; all scenario prices, rates, probabilities, and worked calculations are independently constructed hypothetical examples.
Related calculators & guides
- Supplier Rebate Thresholds: Count the Extra Stock
- All-Units vs. Incremental Purchase Discounts
- Purchase Price Variance: Separate Price from Volume
- Material Usage Variance for Actual Good Output
- Labor Rate vs. Efficiency Variance
- Standard vs. Actual Product Cost
- Order Setup Cost in Product Quotes
- Bottleneck Product Mix with Demand Limits
- Special Order Incremental Profit
- Should You Discontinue a Product?
- Sell Now or Process Further: Incremental Value
- Rework vs. Scrap: Expected Recovery
- Warranty Allowance per Unit Sold
- Consignment vs. Wholesale Economics
- Distributor vs. Sales Agent Economics
- Wholesale Case-Pack Pricing and Partial Cases
- Customer Cost to Serve: Beyond Product Margin
- Outsourcing Overflow Production
- Supplier Replacement and Transition Cost
- Materials Price and Usage Variance Calculator
- Special Order Incremental Profit Calculator
- Sell or Process Further Calculator
- Warranty Cost Planning Calculator
- Materials Variance Reference: Price and Usage
- Incremental Order Decision Reference
- Worked Example: Accepting an Order with Displaced Work
- Production and Supplier Decisions Workbook
- Pricing and Product Cost Playbook
Report an error
Thank you! Your feedback helps us make this page better.
Could not send. Please try again.