Lumber is bought and counted in board feet: thickness in inches, times width in inches, times length in feet, divided by 12. A board 1 inch thick, 8 inches wide and 10 feet long is 6.67 board feet. A woodworking inventory spreadsheet keeps one row for each species and thickness, in board feet, with what you paid a foot. A second sheet records each load as a lot, with its moisture when it arrived, so you know what's ready to cut. Sheet goods, finishes, glue, abrasives, hardware and finished pieces get their own rows. Below is a sheet filled in for a made-up woodshop, the sum for how much rough lumber a job really takes, and the file.
The short version
- Board feet = thickness (in) × width (in) × length (ft) ÷ 12.
- One row for each species and thickness.
- Each load is a lot, with its moisture on arrival and the date.
- Rough lumber yields less than its footage. Find your own share.
- Finishes and glue have shelf lives. Date them.
- TaroStack takes lumber and hardware off stock with each batch and notes which load it came from. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Walnut, 4/4, rough | bd ft | 142 | 100 | $11.50 | $1,633.00 | OK |
| White oak, 4/4, rough | bd ft | 210 | 150 | $7.80 | $1,638.00 | OK |
| Hard maple, 8/4, rough | bd ft | 64 | 80 | $8.40 | $537.60 | REORDER |
| Cherry, 4/4, rough | bd ft | 96 | 60 | $8.90 | $854.40 | OK |
| Baltic birch plywood, 3/4 in, 5x5 | sheet | 9 | 6 | $78.00 | $702.00 | OK |
| Cutting board, walnut, 12x18 | each | 14 | 10 | $44.60 | $624.40 | OK |
Eleven rows in all, $6,741.60 of stock, with hard maple and serving trays to reorder.
Board feet, worked
| Board | Sum | Board feet |
|---|---|---|
| 4/4 walnut, 8 in × 10 ft | 1 × 8 × 10 ÷ 12 | 6.67 |
| 8/4 maple, 6 in × 8 ft | 2 × 6 × 8 ÷ 12 | 8.00 |
| 4/4 oak, 5.5 in × 12 ft | 1 × 5.5 × 12 ÷ 12 | 5.50 |
"4/4" is quarters of an inch: 4/4 is one inch rough, 8/4 is two. Rough lumber is measured before it's surfaced, so the footage you buy is always more than the footage you end up with.
Tally a load when it arrives. Measure each board, write the footage on its end in marker, and add them up against the invoice. From then on, taking a board off the rack means subtracting the number on its end.
What a job really takes
| Eight walnut cutting boards | |
|---|---|
| Finished size each, 12 × 18 × 1.5 in | 2.25 bd ft |
| Finished wood in eight boards | 18 bd ft |
| Rough walnut used | 30 bd ft |
| Yield | 60% |
Forty percent of the walnut became shavings, sawdust, end trim and the sapwood that was cut away. That's normal for rough stock, and worse for walnut than for most because of the pale sapwood. It's also where the money is: at $11.50 a foot, each board has $43 of walnut in it, not the $26 its finished size suggests.
So the 142 board feet on the rack isn't 63 cutting boards. At this shop's yield it's about 37. Quote from the yield, not from the finished dimensions, and keep a figure for each species: clear maple wastes less than walnut.
Loads are lots
| Received or made | Item | Lot | Quantity | Note |
|---|---|---|---|---|
| Oct 5 | Walnut, 4/4 | WN-1005 | 180 bd ft | Kiln dried; 7% on arrival |
| Oct 5 | White oak, 4/4 | WO-1005 | 250 bd ft | Kiln dried; 8% |
| Nov 9 | Hard maple, 8/4 | HM-1109 | 64 bd ft | 10%: sticker and wait two weeks |
| Nov 12 | Cutting board, walnut | CB-1112 | 8 | Walnut WN-1005; 30 bd ft used |
Two reasons to keep loads apart. Moisture: the maple came in at 10%, wetter than this shop likes to cut, so it's on the sheet and not yet available. Counting it as ready would promise a job the wood can't keep. Matching: boards from one load, often one tree, match in color and grain. A table top glued up from two loads of walnut can show a line. Note the load on each batch of finished pieces, the way lot codes are used in how to create lot numbers.
Finishes and glue
A can of hardwax oil skins over once it's opened, and wood glue thickens with age and frost. Both are on the Lots sheet with a use-by, and this shop writes the opening date on every lid. A finish that fails on a delivered piece costs far more than the can.
Selling the finished pieces online and at shows is in Etsy inventory spreadsheet and craft fair inventory sheet. Adding time and overhead to the wood is in batch cost calculator.
Get the spreadsheet
Download the woodworking inventory spreadsheet. Four sheets: inventory with value and REORDER, lots for loads and batches, a count sheet, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The rack changes every time someone pulls a board, and nobody walks to a laptop with sawdust on their hands. A month in, the walnut row is whatever it was after the last delivery, and the only way to trust it is to tally the whole rack again.
How TaroStack does it
TaroStack takes the wood off when the pieces go on.
Each product is a recipe. A cutting board takes 3.75 board feet of rough walnut, glue, oil and a label, with a scrap allowance. Record eight boards and 30 board feet come off the rack on the sheet.
The load is noted. The lot of lumber used goes onto the batch record automatically.
A load can wait. Put lumber on hold while it acclimates. It's counted, and it's kept out of what's available until you release it.
Recipe truth. From your own batches, TaroStack shows whether a product really uses the lumber its recipe says. That's your yield, kept current.
What things really cost. Each batch is costed from the loads it used, so a price rise at the dealer shows up in the next board's cost.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Subtract the wood a job used | By hand, later | Recorded with the batch |
| Wood that's still acclimating | A note | On hold |
| Yield by product | Measure and guess | Recipe truth |
| Cost of a board at today's prices | Retype the price | From the loads used |
Stock, lots, recipes and batches are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
