Question 1

What's included in this manufacturing business plan template?

Accepted Answer

The template includes 5 worksheets: an Executive Summary with product type, production capacity, unit economics, and funding need; a Startup Costs & Funding sheet breaking down facility, equipment, tooling, and working capital; a 12-month Revenue Forecast built from unit production and sales pipeline with a ramp-up schedule; a 3-Year Projected P&L showing revenue by units sold, COGS per unit, gross profit, operating expenses, and EBITDA; and a Dashboard with capacity utilization %, cost per unit, break-even volume, cash conversion cycle, and profitability trajectory. All formulas are pre-built.

Question 2

How do I calculate cost of goods sold (COGS) per unit?

Accepted Answer

COGS per unit includes: direct materials (raw materials that go into each unit), direct labor (wages of workers directly making the product), and allocated manufacturing overhead (rent, utilities, equipment depreciation, quality control, materials handling—spread across all units produced). For example, if you make 1,000 units per month at $35 direct material + $10 direct labor + $5 allocated overhead = $50 COGS per unit. The template has a detailed COGS calculation that breaks these out. As you scale production and approach full capacity, COGS per unit typically decreases because you're spreading fixed overhead across more units.

Question 3

What's capacity utilization and why does it matter?

Accepted Answer

Capacity utilization is the percentage of your maximum production capacity that you're actually using. If your equipment can produce 5,000 units per month but you're only selling 2,000, you're at 40% utilization. This matters because your fixed costs (facility rent, depreciation, salaried labor) don't change when you reduce utilization, so your cost per unit increases. A manufacturer at 40% utilization might have $60 cost per unit; at 80% utilization, the same unit might cost $48 because the fixed overhead is spread across more units. The Dashboard shows utilization so you can see whether you need additional sales capacity, need to cut fixed costs, or need additional sales effort.

Question 4

What should I include in startup costs for a manufacturing business?

Accepted Answer

Include: facility lease or purchase and buildout (production floor, warehouse, quality control area); production equipment and machinery (with quotes from suppliers); tooling and molds if required for your product; materials handling and storage equipment; quality control equipment; utility infrastructure (power, water, ventilation); initial raw materials inventory; initial finished goods inventory; and working capital for accounts receivable during ramp-up. Most manufacturers need $500,000–$5,000,000+ in startup capital depending on production volume and equipment requirements.

Question 5

How much working capital do I need for manufacturing?

Accepted Answer

Working capital depends on your cash conversion cycle: (Days of inventory + Days of accounts receivable) minus (Days of accounts payable). If you hold 45 days of inventory, customers pay in 45 days, and you pay suppliers in 30 days, your cash cycle is 45 + 45 - 30 = 60 days. With $50 COGS per unit and 1,000 units per month in revenue, you need roughly $100,000 in working capital (60 days ÷ 30 days × $50 × 1,000 units). Build a cash conversion cycle analysis to calculate your exact working capital need and update it as your business scales.

Question 6

What's a healthy gross margin for a manufacturer?

Accepted Answer

Gross margin (revenue minus COGS per unit) should typically be 40–60% for most manufacturers. This needs to be high enough to cover operating expenses (sales, marketing, distribution, administration) and leave room for EBITDA. For example, if your selling price is $100 per unit and COGS is $50 (50% gross margin), you have $50 per unit for operating expenses and profit. If operating expenses average $30 per unit, you have $20 per unit or 20% EBITDA margin. If COGS is $60 (40% gross margin), you're tight. The template shows gross margin so you can see whether your pricing and manufacturing efficiency are on target.

Question 7

What's break-even volume and how do I calculate it?

Accepted Answer

Break-even volume is the number of units you must sell per month to cover all your fixed costs (facility rent, salaried labor, depreciation) and variable costs (materials, hourly labor). Break-even = (Fixed costs per month) ÷ (Contribution margin per unit), where contribution margin = (Selling price per unit) - (Variable COGS per unit). If your fixed costs are $20,000 per month, selling price is $100, and variable cost is $50, then break-even = $20,000 ÷ $50 = 400 units per month. If you can realistically sell more than 400 units per month, your business model is viable. The Dashboard calculates your break-even volume automatically.

Question 8

How long should I model the ramp-up period for manufacturing?

Accepted Answer

Model a 6–12 month ramp-up where production starts at 40–50% of capacity in month one and reaches 75–85% by month 12 depending on your sales pipeline and production constraints. Some manufacturers are limited by sales (can't sell more units), others by production (can't make units fast enough). In the Revenue Forecast, model both separately and identify which is the constraint. If you're sales-limited, focus on customer acquisition; if you're production-limited, focus on production efficiency or capacity expansion. Most year-one ramp-ups reach 60–70% of mature production by month 12.

Question 9

Should I model equipment purchase vs. lease in my business plan?

Accepted Answer

Yes, include both scenarios in the Startup Costs sheet. Equipment lease is typically 2–4% of equipment purchase price per month, with the advantage that you conserve working capital and avoid balance sheet debt. Equipment purchase requires upfront capital but gives you ownership and lower long-term cost. For most manufacturing startups, leasing or used equipment is the better choice to conserve working capital during ramp-up. The Startup Costs sheet has a toggle so you can model the cash flow impact of lease vs. purchase and decide which makes sense for your situation.

Question 10

Does this work in Google Sheets?

Accepted Answer

Yes. The template is built in Excel (.xlsx) but is fully compatible with Google Sheets. Upload the file to Google Drive, open it with Google Sheets, and all formulas, formatting, and charts will work without modification. You can share it with your lender, accountant, or business partners directly from Google Drive.

Manufacturing Business Plan Template

What's Inside This Manufacturing Business Plan Template

Executive Summary

Startup Costs & Funding

Revenue Forecast

Projected P&L

Dashboard

Manufacturing Business Plan Template Features

How to Use This Manufacturing Business Plan Spreadsheet

Why Manufacturers Need a Solid Business Plan

Manufacturing Industry at a Glance

Revenue Drivers

Key Cost Categories

Typical Margins

Seasonality

Key Performance Indicators

Manufacturing Business Plan Template FAQ

More Manufacturing Templates

More Business Plan Templates