Estimate inventory with gross-profit and retail evidence

A fire destroys one location's count sheets. Cedar Trail still has beginning inventory, purchases, and sales. An estimate can frame the loss investigation; it cannot reconstruct evidence it never observed.

Gross-profit method

With $20,000 beginning inventory and $80,000 net purchases, goods available at cost are $100,000. A supplied historical gross margin of 30 percent of $120,000 net sales gives $36,000 estimated gross profit and $84,000 estimated cost of goods sold. Estimated ending inventory is $16,000.

The cost reconciliation is explicit: $84,000 estimated COGS + $16,000 estimated ending = $100,000 goods available.

Challenge the rate and the sales base. Product mix, markdowns, returns, inflation, theft, damage, unusual sales, and the fire itself may break the historical relationship. State whether the estimate is for interim reporting, insurance support, reasonableness review, or another bounded purpose.

Average-cost retail method

The separate store pool has $90,000 goods available at cost and $150,000 at retail. The cost-to-retail ratio is 60 percent. Net sales of $110,000 leave $40,000 at retail, producing a $24,000 cost estimate.

That simple illustration deliberately omits the fuller retail ledger. A markup raises the recorded retail amount, a markdown lowers it, and a later cancellation reverses some of the earlier change. Employee discounts, customer returns, transfers between pools, and shrinkage, goods missing from the records or count, also change the bridge. You are not expected to calculate those extensions here. Their treatment depends on the declared retail-method variant, so do not mix this average-cost ratio with a conventional lower-of- cost treatment.

This pool also closes: $110,000 sales + $40,000 ending at retail = $150,000 goods available at retail, and $40,000 × 60% = $24,000 at cost. The retail tie verifies the supplied movement relationship; it does not prove that shrinkage, markdowns, or returns are complete.

Keep estimates accountable

For each estimate retain purpose, population, method variant, opening balance, movement controls, rate derivation, exclusions, sensitivity, comparison with physical or subsequent evidence, preparer, reviewer, and replacement plan. A formula can be correct while its relationship is stale.

For sensitivity only, reduce net sales by $10,000 while holding every other supplied input unchanged. The gross-profit method then estimates $33,000 gross profit, $77,000 cost of goods sold, and $23,000 ending inventory. The retail method leaves $50,000 ending at retail and estimates $30,000 at cost. Those check figures do not establish which customers returned which goods, whether the returned units reentered the owned pool, or whether they are saleable.

Follow the focused learning path

Start with the Cedar estimation example. Then complete Northstar practice with independent sales, margin, and retail-pool facts. Return to the broad Cedar Trail example for the full close.