Practical guide
Understanding inventory and unit economics — sensitivity table
Everyday editorial team · GEOINNOVATION CO., LTD · Published · Updated
What this calculation is for
An inventory plan connects expected sales with supplier lead time and safety stock. It can reveal the cash tied up in an order without pretending that future demand is known.
How the method works
Weekly sales times lead-plus-safety weeks gives a reorder threshold. The ordering comparison uses current stock, supplier minimum quantity and unit cost, while unit contribution provides a separate sales-cost reference. The displayed model uses: Reorder point = weekly sales × (lead time + safety weeks); estimate cash required for the order quantity.
A worked example
For an illustrative inventory and unit economics scenario, use Current inventory units: 600 units; Average units sold per week: 90 units/week; Supplier lead time: 4 weeks; Safety-stock weeks: 2 weeks; Wholesale cost per unit: 18 $; Selling price per unit: 45 $; Supplier minimum order quantity: 100 units. The modeled suggested reorder quantity is 100 units. These are example assumptions, not current prices, official benefit amounts or personalized advice.
Assumptions and real-world differences
The suggested order should not be interpreted as a mandatory immediate purchase: review stock coverage and the supplier minimum. Demand seasonality, spoilage, lead-time variability and financing are not forecast. Demand, supplier terms, spoilage, carrying costs and sales seasonality are not forecast.
Reading the supplier lead time sensitivity table
The tool evaluates the same model across a range of supplier lead time values while holding other assumptions constant. Choose a realistic low value, high value and number of points. Each row reports the same headline measure; the table is a set of conditional calculations, not a probability distribution or a forecast. Input-step rounding can make nearby rows equal.
Reproduce this tool’s example
These fixed example inputs are independent of edits you make above. Enter them in this tool to reproduce the result, then replace them with your own assumptions.
- Minimum supplier lead time
- 2 weeks
- Maximum supplier lead time
- 6 weeks
- Number of comparison points
- 5 points
- Current inventory units
- 600 units
- Average units sold per week
- 90 units/week
- Safety-stock weeks
- 2 weeks
- Wholesale cost per unit
- 18 $
- Selling price per unit
- 45 $
- Supplier minimum order quantity
- 100 units
Sensitivity analysis: 5 comparison points
Supplier lead time ranges from 2 weeks to 6 weeks.
- Supplier lead time: 2 weeks: 100 units
- Supplier lead time: 3 weeks: 100 units
- Supplier lead time: 4 weeks: 100 units
Frequently asked questions
- Does an order quantity prove I need to buy today?
- No. Compare current stock with the reorder threshold and actual lead time before placing an order.
- Which inputs should I check before using this inventory and unit economics estimate?
- Check current inventory units, average units sold per week, supplier lead time, safety-stock weeks, wholesale cost per unit, selling price per unit, supplier minimum order quantity. Match each field’s unit and time period, then compare the detailed rows rather than treating the headline alone as the complete answer.
- Does the most favorable row show the most likely outcome?
- No. The table assigns no likelihood to any row. It shows how the result responds to the chosen assumption, and you remain responsible for selecting a plausible range.