Test the price, capacity and costs behind your brewery / microbrewery. Explore the online worksheet previews alongside calculations from the current illustrative business case.
6 online worksheet illustrations, described below
Opening budget, scenario assumptions and dashboard views
Five-year forecast and separate operating break-even sensitivity
Editable Excel product with assumptions and formulas
The online preview illustrates 6 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01Product lines, units and pricesUses the verified E21 manufacturing engine for a 10-barrel production microbrewery with taproom: each physical product line has an independent launch date, sold-unit volume and selling price, followed by seasonality and separately supported additional revenue.Explore layout ↓
02Materials and direct production costSeparates malt, hops, yeast, adjuncts, water treatment, cans, labels, cartons, kegs, excise, freight, losses and channel-linked costs from paid payroll and fixed overhead so each saleable barrel equivalent has a visible contribution.Explore layout ↓
03Production capacity and qualityBridges independently entered sales to brew turns, fermentation and conditioning tank-days, cold storage, packaging rate, cleaning, yield, labor and channel sell-through, with setup, run, finishing, inspection, maintenance and downtime visible rather than assuming every scheduled hour produces saleable output.Explore layout ↓
04Staffing and operating expensesSchedules paid owner work, production and administrative roles, start dates, employer costs, occupancy, utilities, maintenance, software, sales and recurring overhead.Explore layout ↓
05Startup uses, funding and scenariosSchedules site work, brewhouse, cellar, refrigeration, packaging, taproom, laboratory and reserve, working capital and financing, then compares low, base and high unit, price, contribution and fixed-cost paths.Explore layout ↓
06Statements and dashboardConnects product-line revenue, direct production cost, payroll, operating expense, capital and funding schedules to five-year statements, cash flow, balance sheet, KPIs and a management dashboard.Explore layout ↓
Explore the online worksheet illustrations
Open each online sheet presentation to read its specification and illustration. These web views are not screenshots or downloadable Excel files.
Brewery / MicrobreweryPlanned XLSX
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$1,050,000
$1,620,000
$2,184,000
Ingredients, packaging, excise and sales-linked costs
$472,500
$696,600
$917,280
Production, taproom, sales and management payroll
$520,000
$560,000
$590,000
Occupancy, utilities, maintenance, insurance and overhead
$400,000
$445,000
$490,000
EBITDA
−$342,500
−$81,600
$186,720
EBITDA margin
-32.6%
-5.0%
8.5%
Planned presentation, not a completed file. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01Product lines, units and pricesWorksheet specification
Product lines, units and prices
Planned purpose: Uses the verified E21 manufacturing engine for a 10-barrel production microbrewery with taproom: each physical product line has an independent launch date, sold-unit volume and selling price, followed by seasonality and separately supported additional revenue.
Inputs
Product-line names
Launch dates
Units sold by line
Selling price by line
Monthly seasonality
Separately supported additional revenue
Outputs
Revenue by product line
Monthly and annual revenue
Product mix and growth
Limits and completion needs
The product lines must remain operationally distinct: taproom pours converted to barrel equivalents, packaged beer by format, wholesale kegs and any separately supported merchandise or event income.
Do not count the same liquid again when it moves from production into taproom, packaged or wholesale sales.
02Materials and direct production costWorksheet specification
Materials and direct production cost
Planned purpose: Separates malt, hops, yeast, adjuncts, water treatment, cans, labels, cartons, kegs, excise, freight, losses and channel-linked costs from paid payroll and fixed overhead so each saleable barrel equivalent has a visible contribution.
Produced volume becomes revenue only when saleable product is released, allocated to a channel, sold and recognized under the selected accounting treatment.
03Production capacity and qualityWorksheet specification
Production capacity and quality
Planned purpose: Bridges independently entered sales to brew turns, fermentation and conditioning tank-days, cold storage, packaging rate, cleaning, yield, labor and channel sell-through, with setup, run, finishing, inspection, maintenance and downtime visible rather than assuming every scheduled hour produces saleable output.
Inputs
Machine and finishing capacity
Setup and run time
Yield and scrap
Inspection and rework
Maintenance and downtime
Outputs
Available production time
Used capacity
Bottlenecks, yield and rework
Limits and completion needs
Revenue inputs do not prove that equipment, labor or quality systems can deliver the volume.
04Staffing and operating expensesWorksheet specification
Staffing and operating expenses
Planned purpose: Schedules paid owner work, production and administrative roles, start dates, employer costs, occupancy, utilities, maintenance, software, sales and recurring overhead.
Inputs
Roles and headcount
Pay rates and employer burden
Shift and coverage plan
Operating expenses
Maintenance and replacement policy
Outputs
Monthly payroll
Operating expense
Coverage gaps and cash need
Limits and completion needs
National occupation data do not set local offers or a complete employer burden.
Estimating, setup, production, inspection, finishing, shipping, sales and administration must be assigned.
05Startup uses, funding and scenariosWorksheet specification
Startup uses, funding and scenarios
Planned purpose: Schedules site work, brewhouse, cellar, refrigeration, packaging, taproom, laboratory and reserve, working capital and financing, then compares low, base and high unit, price, contribution and fixed-cost paths.
Inputs
Opening uses
Vendor and installation timing
Reserve policy
Debt and equity
Scenario multipliers
Outputs
Sources and uses
Cash runway
Funding gap
Break-even and sensitivity
Limits and completion needs
The StartFigures allocation is not a property, equipment, contractor, insurer or lender quote.
Debt service, tax, deposits, installation timing and replacement capital require a dated cash schedule.
06Statements and dashboardWorksheet specification
Statements and dashboard
Planned purpose: Connects product-line revenue, direct production cost, payroll, operating expense, capital and funding schedules to five-year statements, cash flow, balance sheet, KPIs and a management dashboard.
Inputs
Selected scenario
Working-capital timing
Financing
Tax assumptions
Opening balances
Outputs
P&L
Cash flow
Balance sheet
Dashboard and ratios
Limits and completion needs
Outputs inherit every unit, price, yield, capacity, cost, funding and collection assumption.
A forecast does not certify demand, quality, permits, safety, capacity or profitability.
Ways to prepare your files
Template
Current product · Shopify checkout
Edit the financial model with your own assumptions.
Define the revenue drivers, operating modules, outputs and review criteria before agreeing the work.
Project quote · Schedule agreed with you
Assumptions you can change
These are the current inputs behind the business case and the intended starting points for the editable workbook. Range endpoints represent modeled scopes or sensitivities, not measured national averages.
Blended realized revenue per saleable barrel equivalent
$1,050.00
$650.00 – $1,500.00
Revenue per sold unit
Saleable barrel equivalents per operating day
8
5 – 11
Daily throughput in the stated operating scope
Operating days per week
5
4 – 6
Trading schedule
Fixed operating costs / month
$90,000
Held constant
Operating break-even threshold
Contribution margin
58.0%
Held constant
Share of sales available for fixed costs
Starting share of mature volume
30.0%
Base ramp input
Opening month revenue
Mature volume added / month
5.0%
Base ramp input
Monthly ramp increment, capped at mature volume
Ramp horizon
15 months
Base ramp input
Period checked for operating break-even
The opening budget and annual expense inputs also need local quotes and staffing estimates. This page shows fixed examples; the free calculator lets you change price, volume and trading days.
Volume-only sensitivity · revenue at mature volume · monthly USD
Scenario
Daily units
Monthly revenue
Break-even revenue
First operating break-even
Lower volume
5
$113,663
$155,172
Not reached
Base volume
8
$181,860
$155,172
Month 13
Higher volume
11
$250,058
$155,172
Month 8
Only saleable barrel equivalents per operating day changes. Blended realized revenue per saleable barrel equivalent: $1,050.00; 5 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 15-month ramp. This sensitivity is separate from the annual forecast and does not measure cash payback.
Sample outputs from the current case
These results are calculated from the website’s illustrative assumptions. They demonstrate intended workbook topics, not a tested Excel file.
01 / Annual forecast
Revenue across five years
$1.1m
Year 1
$1.6m
Year 2
$2.2m
Year 3
$2.4m
Year 4
$2.7m
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Leasehold, utilities, drainage, ventilation and fire work$350,000
10-barrel brewhouse, cellar tanks and controls$420,000
Glycol, refrigeration, kegging and modest packaging$220,000
Taproom bar, furniture, POS and service equipment$120,000
Laboratory, safety, wastewater and material handling$65,000
Licensing, design, professional fees and pre-opening$45,000
Opening ingredients, kegs, cans and packaging$100,000
Working capital and contingency reserve$230,000
One-time budget: $1,550,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $2,184,000.
Ingredients, packaging, excise and sales-linked costs$917,280
Production, taproom, sales and management payroll$590,000
Occupancy, utilities, maintenance, insurance and overhead$490,000
EBITDA$186,720
EBITDA margin: 8.5%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
7
Break-even revenue / month
$155,172
Base revenue / month at maturity
$181,860
First operating break-even
Month 13
Units mean saleable barrel equivalents per operating day. The ramp covers 15 months; operating break-even does not measure recovery of opening capital.
The annual forecast and fixed-cost sensitivity are separate planning views. The website does not yet supply a complete funding, debt, tax and working-capital schedule for a cumulative cash-flow or payback chart. Read the full input basis and limitations.
Annual forecast and calculator comparison
The annual forecast and calculator use separate scenarios. Their revenue ramp or cost allocations differ, as shown below. The calculator's break-even month does not reconcile the annual forecast.
Original base inputs · USD per year
Check
Annual forecast
Calculator inputs
Year 1 revenue
$1,050,000
$1,254,834
Year 1 operating result
−$342,500
−$352,196
Year 3 / mature annual operating result
$186,720
$185,746
Calculator figures use the original first 12 months and mature monthly result × 12; sliders do not change this comparison. Neither column measures cash flow or payback. Input basis.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your brewery / microbrewery together. Update the narrative when you change the forecast.
The Business Plan uses Word and the Financial Model uses Excel. The online illustrations use this website's scenario data and may differ from the purchased files.
File format
XLSX
Editor
Microsoft Excel
Editing
Input cells, forecast assumptions and formulas; workbook behavior still needs verification.
Other software
Compatibility with alternative editors has not been verified.
Delivery and terms
Review the product description, delivery details, license and final total in Shopify before paying.
Use the purchase button to buy the Brewery / Microbrewery Financial Model for $109 through Shopify. This is a one-time price in USD before any applicable taxes.
What do the online previews show?
The online preview explains Product lines, units and prices, Materials and direct production cost, Production capacity and quality, Staffing and operating expenses, Startup uses, funding and scenarios, Statements and dashboard using this website's illustrative case. It is separate from the downloadable Excel model.
Are these previews pages from a finished file?
The web previews are rendered from the website's case record. They illustrate planning concepts and calculations; they are not screenshots or a page-by-page inventory of the downloadable product.
What would I need to change for my business?
Review blended realized revenue per saleable barrel equivalent, saleable barrel equivalents per operating day, the operating schedule, opening budget and costs. These web previews do not edit a workbook. Test the website's price and volume assumptions in the business idea page's calculator.
Is the written business plan included?
The Financial Model is sold separately. The $168 Bundle adds the $59 Business Plan and $109 Financial Model for the same business to one cart, one of each.
Do the figures establish what my business will earn?
No. The figures describe an illustrative U.S. operating case, not measured industry averages or a prediction for your location. EBITDA is not owner cash, and operating break-even does not recover the opening investment. Check local costs, capacity and demand before using the assumptions.
