Cash, Inventory, and the Next Order

Physical-product growth asks the company to pay twice: once for the batch being sold and again for the batch that must be ordered before the first one finishes turning into cash. Gross margin can look respectable while the bank account reaches its low point.

The metrics chapter sketches hardware economics. This guide is a reorder worksheet, not accounting, customs, tax, or legal advice.

Start with landed and reversible cost

For each sellable unit, separate factory price, tooling allocation, freight, duty, inspection, packaging, payment fees, fulfillment, warranty allowance, and expected return cost. Do not hide cash timing inside one average. Mark which costs are paid at order, shipment, arrival, sale, and return.

Inventory accounting rules depend on facts and tax status. The IRS explains that businesses for which merchandise is an income-producing factor may need inventory accounting and a consistent identification and valuation method, subject to small-business exceptions (IRS Publication 538). That is a reason to align the management sheet with an accountant, not to turn this worksheet into a tax return.

Build the weekly cash calendar

Use rows for opening cash, customer collections, refunds, supplier deposit, supplier balance, freight/duty, fulfillment, payroll/overhead, and closing cash. Put purchase-order milestones on actual expected dates. Add a delay case for production and a slower-sales case. The lowest closing-cash week—not the average month—is the financing requirement.

Keep customer shipping promises conservative. FTC guidance says covered sellers need a reasonable basis for promised shipment timing and must provide delay options and prompt refunds when required; scope and exact obligations should be checked for the product and jurisdiction (FTC merchandise rule guide).

Worked hypothetical: the second batch

Worked hypothetical — not a benchmark. A company orders 1,000 units. Factory cost is $60 each, with a 40% deposit now and 60% before shipment. Freight, duty, and inspection total $14,000. Selling price is $150. Payment and fulfillment cost $13 per shipped order. The company expects 8% of orders to be returned; returned units are inspected and 70% can be resold. Each return requires a full $150 customer refund plus $22 of handling cash cost. Monthly overhead is $28,000.

Before sales, the first batch consumes $24,000 deposit + $36,000 balance + $14,000 logistics = $74,000. Selling all 1,000 produces $150,000 gross collections. Expected returns are 80 units, so the model reserves $12,000 for full-price refunds (80 × $150) and $1,760 for handling (80 × $22). Net customer cash after refunds is therefore $138,000, before the separate $13,000 payment/fulfillment cost, $1,760 handling cost, overhead, timing differences, or any loss on units that cannot be resold.

The supplier requires a $36,000 deposit for a larger second batch in week 7. By then 550 first-batch sales have been collected, producing $82,500 of gross customer cash. The 8% return assumption means reserving $6,600 for 44 full-price refunds and $968 for handling, leaving $75,900 of modeled net customer cash after refunds. Against that, the sheet carries $74,000 of batch cost, about $7,150 of payment/fulfillment cost, $968 of return handling, and roughly $42,000 of six-week overhead. Relative to zero opening cash, those modeled flows create a $48,218 deficit before the second deposit. Refunds may settle after week 7, so the bank balance could temporarily look higher; reserved refund cash is still not available for the reorder. The product may be profitable over the batch and still unable to place the next order.

Add a returns reserve and stock states

Track units as on-order, in-transit, available, committed, returned-awaiting-inspection, resellable, refurbished, and written off. A returned unit is not available inventory until inspected. Maintain a cash returns reserve based on actual cohort behavior; revise it by product, channel, and time since sale. Do not count store credit as equivalent to avoiding a refund where law or policy requires cash.

The next-order gate

Before approving a purchase order, record: sell-through by week; contribution after returns; weeks of usable stock; supplier lead-time range; deposit and balance dates; downside sales case; refund reserve; minimum operating-cash floor; and the week of the modeled cash trough. State which assumption would cancel, shrink, or split the order.

Limitations: the example ignores tax, chargebacks, foreign exchange, financing cost, defects, seasonal demand, and channel payment delays. It models expected net cash with a reserve, not the exact dates of individual refunds or later resale proceeds. Those omissions can dominate the answer. Replace every fictional input with quoted, contractual, or observed data before committing cash.