Brewery planning: connect tank release dates to the sales forecast

A brewery's sales forecast needs to connect each batch with the vessel space, quality release, transfer and packaging work required before the beer is available for sale. A monthly total of planned brew volume can look achievable while individual orders fall due before their batches can leave the tanks.

The Brewers Association's production-scheduling guidance links long-term plans with weekly brewing, cellaring, cleaning, quality and packaging tasks. It also emphasizes adapting the schedule when conditions change. For finance, the practical implication is to use the production team's current release forecast rather than treating the original brew calendar as a fixed delivery promise.

Keep required process and quality decisions with qualified staff. Financial targets do not establish a shorter fermentation or release period. The schedule should show the time the approved process needs, the uncertainty around it and the consequences for customer commitments if the batch is not ready when first expected.

List each tank's relevant capacity and permitted uses, then show the interval during which it is unavailable to another batch. Include filling, the approved process, transfer and the preparation required before reuse. Use actual vessel availability rather than assuming a tank becomes free at midnight on a forecast packaging date.

Treat transfer dependencies explicitly. A batch cannot move into a destination vessel that is still occupied or unavailable, and an available packaging line does not help if the beer cannot reach it. Likewise, a suitable empty tank may not resolve a shortage of packaging materials or a booked external canning slot.

Carry batches across month boundaries. Opening work in process occupies capacity before the new month's first brew, and batches started late in the month may not become finished goods until later. Omitting either side can make the same tank appear to support overlapping production in successive monthly plans.

Assume a hypothetical brewery has four identical eligible tanks available at the start of a thirty-day month. Its approved planning assumptions require eighteen occupied days for each batch of Product A and 26 for each batch of Product B, including the modeled turnaround. These are invented durations for the scheduling example, not brewing recommendations.

Sales requests three A batches and two B batches by month end. The total required occupancy is three times eighteen plus two times 26, or 106 tank-days. Four tanks across thirty days provide 120 tank-days in aggregate, which appears sufficient. However, the batches occupy continuous intervals and all five cannot start at once.

If two A batches and two B batches begin on day one, the A tanks become available on day nineteen. A third A batch beginning then does not finish its eighteen-day occupied interval within the month. It becomes available for the next stage on day 37 under these counting assumptions. Spare aggregate tank-days near month end do not turn into an earlier uninterrupted interval.

Suppose each A batch yields an illustrative eighteen hectoliters of accepted packaged product and each B batch yields seventeen. Assuming the next stages can complete the first four batches before month end, available new output is 36 hectoliters of A and 34 of B, totaling seventy. The original five-batch request totaled 88, leaving eighteen hectoliters of A for a later period.

At a hypothetical retained selling amount of $200 per hectoliter, that timing difference moves $3,600 of planned sales value out of the immediate availability forecast. It is not automatically a permanently lost sale; determine whether the customer accepts later delivery, takes another product or cancels under the applicable arrangement. Collections then follow the actual billing and payment terms.

Keep materials already purchased and work already performed visible in the cash plan. A delayed release can postpone receipts while ingredient, labor and packaging payments continue. The accountant should apply the relevant inventory and revenue policies, but the operating forecast must first provide an accurate status for the batch and its expected next event.

Options may include an earlier start in the preceding period, an agreed change in customer delivery, a different product mix, compatible confirmed external capacity or additional equipment. Each requires its own commercial and operational check. Do not assume another vessel is interchangeable simply because its nominal volume matches.

Evaluate costs that actually change, including additional handling, outside production, freight and any remaining internal work. Compare the revised delivery outcome with the contribution and customer commitment it protects. A tank purchase is a larger decision that requires a sustained demand case, installation feasibility and the other resources needed to use it.

A packaging bottleneck may remain after tank capacity improves. Check the entire release path again after the proposed change. Buying another vessel can increase work in process without increasing saleable output if the downstream process is still unable to complete the volume on time.

Assign an owner to update actual starts, transfers, release decisions and packaging completion. Retain the prior forecast and reason for a material change so sales and finance can distinguish a process delay, demand change, equipment problem or missing input. The current calendar should be the common source for customer availability promises.

At the end of the period, compare planned and actual ready-for-sale dates by batch. Keep confirmed orders distinct from an unconstrained sales forecast. Use the observed timing range to improve future commitments without lowering required standards. A reliable tank calendar is valuable because it reveals when stock will exist, which order it can serve and when the related cash can reasonably arrive.