Monthly Mill Production Report Template: Tracking Logs In, Lumber Out, and Cost per Board Foot
Most mills know their monthly board foot tally to within a hundred feet. Far fewer know what each of those board feet cost to produce. The difference between those two numbers is where margin hides, and where it leaks. A monthly production report that ties logs in to lumber out and drags the month's operating costs across the same period turns a pile of scale tickets and invoices into one page you can actually act on.
What follows is a template structure you can reuse every month, plus the calculations and habits that keep it honest.
Every mill report should answer three questions, in this order: Did we cut what we planned? Did we get the yield we expected out of the logs we bought? And what did each board foot cost, net of what we sold as byproduct?
If your current template can't answer those in under a minute, it's a data dump, not a report. Cut it down until it can.
The input side begins with scale tickets, and it goes wrong in predictable ways. Loads scaled in one month and paid in the next get counted twice or not at all. Species get lumped together when the mill actually runs them separately. Timber cut from company land gets valued one way in January and another way in June.
Two rules fix most of this. First, count logs when they're consumed, not when they're delivered — that keeps the log inventory ledger and the production tally on the same footing. Second, put the log rule at the top of the template: Doyle, Scribner, or International 1/4-inch. A mill that quietly changes rules mid-year will show a recovery swing that has nothing to do with the sawmill.
Report logs in MBF, lumber in board feet, and convert carefully. Mixing thousands and singles is the most common arithmetic error in mill accounting.
A single production total is nearly useless on its own. Break the output into grade and thickness, because a mill can hit its volume target and still lose money if the grade mix tilts toward low-value boards.
Decide up front whether your tally is green or dry, and state it on the report. Kiln drying shrinks lumber, so a green tally will always run ahead of a dry tally of the same lumber. Pick one basis for cost per board foot and stay with it month to month.
Then calculate yield as a percentage: lumber out divided by log volume in, on the same basis. Yield is the number that tells you whether the log supply, the saw filing, or the breakdown decisions changed.
Sort costs into two columns, fixed and variable, before you add anything up. That split tells you what a slow month genuinely costs to carry and what simply scales with production. A workable set of buckets:
Keep the same buckets every month. A report whose categories shift around can't be compared to anything.
(Total operating cost − byproduct credits) ÷ board feet produced = cost per board foot.
Cost per board foot is only meaningful when the numerator and denominator come from the same month, the same logs, and the same basis of measure.
Show both a gross figure and a net figure. Gross tells you what the mill spent to make a foot of lumber; net tells you what it actually carried after the chip truck left. Both are useful, and showing only one invites arguments.
Say a mill produces 210,000 board feet in a month. Logs, labor, energy, repairs, depreciation, and overhead come to $94,500. Byproduct sales bring in $8,400. Net cost is $86,100, so cost per board foot is $0.41.
Now run the same math by grade, or by shift, if your tally allows it. A mill-wide average hides the fact that a low-grade run can cost noticeably more per foot than a clean 4/4 run. You don't need precision to two decimals — you need to see which products are carrying the mill and which are dragging it.
Set a threshold for the variance column — a percentage or a dollar amount — and only require explanations above it. Without a threshold, the notes turn into a wall of text and nobody reads them.
Pick dates and hold them. Daily tally sheets in by the next morning. Scale tickets reconciled by the second business day. Cost figures pulled from the ledger by the fifth. Report out by the seventh. The rhythm matters more than the polish; a report that arrives three weeks late has already missed its chance to change anything.
Keep the finished product to one page plus a short written note: three things that moved, why they moved, and one action for next month. That note is what turns a spreadsheet into management. Writing it forces you to decide what actually happened, which is the part a template can never do for you.
One last caution: this is management accounting, built for decisions. If the same figures feed tax filings, lender covenants, or an ownership dispute, have your accountant review the format before you rely on it.
The mills that catch a bad month while it's still small are the ones that built the habit when things were good.
Photo: Jean-Paul Wettstein / Pexels
Previous Post
Lumber Inventory Valuation Methods for Sawmills: FIFO, Average Cost, and Specific Identification Compared
Next Post
Mill Payroll Checklist: Shift Differentials, Overtime, and Piece-Rate Pay for Sawmill Crews
