Lumber is counted in board feet, and a lumber inventory spreadsheet has a row for each species, thickness and grade: walnut 4/4 isn't interchangeable with walnut 8/4, and select isn't FAS. Each row has the board feet on the rack, what a board foot cost, and a reorder level. That much is ordinary. What makes lumber different is that a board on the rack isn't always a board you can use. Wood that came in last week may still be too wet to mill, so each delivery is recorded with its moisture reading and the date it will be ready. And a project needs more wood than its parts add up to. Below is a sheet for a made-up furniture shop, the board foot sum, and the file.
The short version
- One row for each species, thickness and grade.
- Board feet = thickness (in) × width (in) × length (ft) ÷ 12.
- Record each delivery with its moisture reading and a ready date.
- Buy 20% to 30% more than the parts need. This shop uses 25%.
- Slabs and sheet goods are counted by the piece.
- TaroStack takes board feet off the rack when you record what you built. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Walnut, 4/4, FAS | bd ft | 186 | 150 | $11.50 | $2,139.00 | OK |
| Hard maple, 4/4, FAS | bd ft | 240 | 200 | $6.80 | $1,632.00 | OK |
| White oak, 4/4, FAS | bd ft | 95 | 150 | $8.40 | $798.00 | REORDER |
| White oak, 8/4, FAS | bd ft | 60 | 40 | $10.20 | $612.00 | OK |
| Cherry, 4/4, select | bd ft | 130 | 100 | $7.90 | $1,027.00 | OK |
| Ash, 4/4, select | bd ft | 40 | 60 | $5.20 | $208.00 | REORDER |
Ten rows in all, $9,437 on the racks, with two to reorder: 4/4 white oak and ash. A small shop has more money in its lumber rack than in most of its machines.
Board feet
A board foot is a piece 1 inch thick, 12 inches wide and 12 inches long.
| The sum | Thickness in inches × width in inches × length in feet ÷ 12 |
| A 4/4 board, 8 inches wide, 10 feet long | 1 × 8 × 10 ÷ 12 = 6.7 board feet |
| An 8/4 board, 6 inches wide, 8 feet long | 2 × 6 × 8 ÷ 12 = 8 board feet |
Thickness is given in quarters of an inch as it came off the saw: 4/4 is one inch rough, 8/4 is two. Tally each board when a delivery arrives, with a tape and a lumber crayon, and write the board feet on the end. Counting the rack later is then adding up numbers, not measuring boards.
What's ready to mill
| Delivered | Item | Board feet | Moisture | Ready to mill | Note |
|---|---|---|---|---|---|
| Nov 12 | White oak, 4/4 | 60 | 11% | Nov 26 | Acclimating |
| Sep 30 | Walnut, 4/4 | 250 | 8% | Oct 14 | Ready |
| Oct 20 | Walnut slabs, 3 | 12% | Feb 1 | Air dried: still drying | |
| Aug 5 | Hard maple, 4/4 | 400 | 7% | Aug 19 | Ready |
This tab answers what the rack count can't. A table needs 62 board feet of white oak, and the rack holds 95 board feet of 4/4 white oak. Sixty of them came on November 12 at 11% moisture and are sitting in the shop to settle until the 26th. Only 35 board feet can be milled today. Wood milled too wet moves after it's built, and the customer finds out in February.
Keep a moisture meter by the door, read a few boards from each delivery, and write the reading and a ready date on the sheet. The rule here, two weeks in the shop, is this shop's own.
Buying for a project
A table's cut list adds up to 62 board feet. That isn't what to pull from the rack.
| Parts, from the cut list | 62 bd ft |
| Allowance for knots, checks, sapwood and offcuts, 25% | 15.5 bd ft |
| To set aside | 78 bd ft |
The allowance is what turns rough boards into clear parts. It's higher for long, wide parts and for lower grades. Track it: weigh or tally what goes in the offcut bin for a few projects, and you'll know your own number.
So the table needs 78 board feet of white oak, the rack has 35 ready and 60 more on the 26th. The job can start on the 26th, and the reorder flag on that row is right.
Offcuts are stock too, if they're big enough. Shorts over two feet go on a shelf by species. Cutting boards and small goods are made from them: see is woodworking profitable.
Slabs are sold and used one at a time. Give each a number, its size, and its own drying date.
Supplies, hardware and finished pieces are covered in woodworking inventory spreadsheet, and pricing the work in how to price woodworking projects.
Get the spreadsheet
Download the lumber inventory spreadsheet. Four sheets: inventory with value and REORDER, deliveries with their ready dates, a count sheet that works out each difference and what it's worth, 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
Three jobs are on the floor. Each has had boards pulled for it, some milled, some waiting. The rack sheet still shows what was there before any of them started, because nobody subtracts a board when they carry it to the jointer. A customer calls about a walnut desk, and the honest answer to "do you have the wood?" is a walk to the rack with a tape.
How TaroStack does it
TaroStack takes the wood off the rack when you record the work.
Lumber is stock by species and thickness, in board feet, with what each delivery cost you.
Each delivery is a lot. Its moisture reading and ready date go in its notes, and a lot that isn't ready can sit on hold.
Each product is a recipe, with scrap: 62 board feet of parts and the allowance on top. Record the build and the lumber comes off stock at what it cost.
"What could I make right now" says whether the rack covers a job, and which species stops you.
A price-creep report by supplier shows hardwood moving before the next quote goes out.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Oak that's ready to mill | Read the delivery tab | Stock not on hold |
| Wood for the desk | Walk to the rack | What could I make right now |
| What a table's lumber cost | Last year's price | From what you paid |
| Board feet after three jobs | Not subtracted | Taken off with each build |
Stock, lots and recipes 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.
