Production capacity planning: formula and worked examples
How do you calculate production capacity and use it to plan orders?
Plain guides to production capacity planning, bills of materials, cost per unit and reorder points, written for people who make things by hand and want the numbers to behave.
In-depth hubs with formulas, worked examples and a free calculator for each topic.
How do you calculate production capacity and use it to plan orders?
How do you plan production for a small business?
How do I turn inventory into a production number?
How do I decide whether to accept an order?
About 20 drops per mL, so one drop is about 0.05 mL. Chart, bottle sizes and a free calculator with grams.
Open the calculator01FundamentalsProduction capacity planning is working out the maximum number of finished units you can actually make with the materials, time and equipment you have right now. For a small maker it comes down to one honest number per product: how many can I make today before something runs out?
Read the guide02RecipesA bill of materials is the full list of every input needed to make one unit of a product, with an exact quantity and unit for each line. Build it once per product and every other calculation, capacity, cost and reorder, falls out of it automatically.
Read the guide03MoneyCost per unit is the sum of every BOM line multiplied by what you actually paid for that material, per unit of measure. Margin is your selling price minus that cost, expressed as a percentage of the price.
Read the guide04BuyingA reorder point is the stock level at which you place a new order, calculated from how fast you use a material and how long your supplier takes to deliver, plus a safety buffer.
Read the guide05OrdersCompare the order against your remaining capacity after everything you already committed to. If the shortfall is zero you can say yes, and if it is not, you know exactly what to buy and by when.
Read the guide06ToolsSpreadsheets are excellent for a single snapshot and poor at staying true over time. Each new product multiplies the formulas, and every manual stock edit is a chance to drift away from reality.
Read the guide07FormulasFive calculations run a small batch business: a per-unit bill of materials with measured waste, batch capacity and its bottleneck material, order shortfall after committed stock, a reorder point from supplier lead time, and a selling price set from target margin. Together they tell you what one unit costs, how many you can make, what to buy and what to charge.
Read the guide08ShortagesMultiply each material's amount per unit by the number of units you plan to make, add your waste allowance, then subtract the stock that is actually available. Any positive result is a shortage you must buy before the run. Zero or less means that material is covered.
Read the guide09SpreadsheetsUse three linked Excel Tables: Raw Materials, BOM and Finished Goods. Give each material a unique identifier, keep stock and recipe quantities in the same unit, and calculate production capacity from the material that runs out first. Track completed goods separately from what you could make.
Read the guideMakeable runs every one of these calculations for you the moment you enter a material or accept an order. Start free, no card needed.