Roastery: ____________________ Count date: ____________________ All weights in pounds; costs in USD.
One row per lot. Landed cost includes allocated freight. Record green weight used, rather than finished roast weight. Keep a dated movement log for each lot.
| Purchase date | Supplier / coffee / origin | Lot code | Received lb | Landed $/lb | Green lb roasted | Other removals lb | Expected lb | Physical lb | Variance lb | Value $ |
|---|---|---|---|---|---|---|---|---|---|---|
| Example | Illustrative coffee | EX-01 | 100 | 5.00 | 10 | 0.5 | 89.5 | 89 | -0.5 | 447.50 |
Expected lb = received - green roasted - other removals. Variance = physical - expected. Value = expected lb × landed $/lb. Investigate count differences before adjusting stock.
Notes / movement log reference: ____________________________________________________________________________
Free worksheet from RoastBase. Connect purchases, inventory, and roast costs with a free 30-day trial. Regular price: $29/month, no per-pound fees.