Forecast Cost of Goods Sold
Connect delivery costs with sales volumes, unit economics and the gross profit behind the plan.
Sales volume, COGS and gross profit · FY2026–FY2027
Preview · Illustrative values · EUR thousands / Units as labeledRevenue and COGS
| Line item | FY2026 | FY2027 |
|---|---|---|
| Sales volume · units | 100,000 | 110,000 |
| Price · EUR / unit | 120 | 125 |
| Cost · EUR / unit | 72 | 72 |
| Revenue | 12,000.0 | 13,750.0 |
| Cost of goods sold | (7,200.0) | (7,920.0) |
| Gross profit | 4,800.0 | 5,830.0 |
| Gross margin | 40.0% | 42.4% |
Free · No signup
Define the direct-cost boundary first
A COGS model forecasts the costs of delivering the goods or services sold. Decide which materials, delivery labor and other costs belong in that boundary. Keep the classification consistent with revenue and with historical observations. Moving a cost from COGS to overhead changes gross margin without changing the underlying business economics.
This forecast is part of the financial operating model. Separate business lines when they have different delivery economics. The COGS implementation reference explains supported cost methods and eligible revenue-volume links; it does not choose the accounting classification for your business.
Use a revenue percentage for stable economics
COGS at 60% of EUR 10 million revenue gives EUR 6 million of cost and EUR 4 million of gross profit. A ratio is useful when the relationship is stable and further detail would not improve the forecast. Revisit it when purchasing terms, delivery mix or capacity utilization changes.
The Gross Margin Calculator calculates a margin, cost limit or revenue target from supplied figures for one period. Use it to inspect a particular relationship, then use the COGS forecast to explain how that relationship evolves. A target gross margin does not by itself establish an achievable procurement cost.
Use one volume source for sales and cost
For a quantity-based line, forecast unit cost × delivery volume and connect that volume to the revenue forecast. Separate selling price from unit cost. In the preview, sales increase from 100,000 units at EUR 120 to 110,000 at EUR 125; cost stays at EUR 72 per unit.
That shared volume gives EUR 7.2 million and EUR 7.92 million of COGS. The price change improves gross margin while greater volume raises absolute cost. BalanceCheat supports linked cost volume when the revenue line uses Price × volume. An unrelated revenue method should not be treated as an eligible quantity merely to make the linkage fit.
Forecast mix and semi-variable costs explicitly
A blended cost percentage can hide changes between products or business lines. Keep distinct lines when premium products, service delivery or supplier terms differ. A greater share of a lower-margin stream can reduce the overall margin even when each line’s economics remain unchanged.
Distinguish variable consumption from committed or step costs. A delivery contract can include a minimum amount plus activity-dependent charges; a new production shift can create a capacity step. Represent components using supported amounts, growth or quantity relationships and explain the threshold. Do not imply a universal automatic cost-threshold method for every product line.
Read gross profit alongside the wider P&L
Gross profit is revenue less COGS; gross margin expresses that result relative to revenue. Check both measures. Higher sales at a lower margin may still increase gross profit, while a better margin on shrinking sales can reduce it. Trace the change to volume, price, unit cost or mix before interpreting the headline.
The gross-profit and subtotal reference explains how source rows feed calculated totals. Continue into the income statement model to include overhead, depreciation and the remaining earnings forecast. Gross profit is not net income and does not establish cash generation.
Review the cost forecast over time
Align input timing with sales and explain unit-cost changes using purchasing, wage or delivery assumptions. Keep historical cost definitions comparable with the forecast. Check whether personnel costs already supply a delivery expense before adding it to another COGS line; duplication can distort both margins and operating profit.
Preserve assumptions behind the forecast rather than forcing gross profit to a desired amount. Test the effect of a weaker selling price or higher unit cost through the same model, and review the source relationships after changing a method. The cost-source reference describes the product’s links and adjustment signs.
Frequently asked questions
How is a COGS model different from a gross-margin calculator?
The COGS model forecasts delivery costs across future periods from activity and cost assumptions. The calculator computes a selected-period margin or target from supplied figures.
When should COGS use a revenue ratio?
When cost economics are sufficiently stable and a ratio makes the forecast understandable. Use separate quantities or lines when prices, mix or delivery costs change materially.
Can any revenue line provide a linked sales volume?
No. The product’s linked-volume method requires an eligible Price × volume revenue line. The Handbook explains supported methods and references.
Does a higher gross margin always mean more profit?
No. Revenue scale, overhead, depreciation, financing and taxes also affect the eventual result. Compare absolute gross profit with margins and the full P&L.