FP Academy · INSIGHTS

Build a simple price and volume budget in Excel

Separate activity, prices and costs in a budget you can update by changing its assumptions.

Mohammad Amar · Founder & Owner · 08.10.2026

Start with assumptions

Break revenue into units sold and price per unit. This lets you explain whether changes arise from activity, price or both. You can use billable hours, participants or assignments if you define the units consistently.

A fictional monthly budget

A business expects to sell 200 services at DKK 500 each. Variable cost is DKK 150 per service and fixed monthly operating costs are DKK 50,000. Figures exclude VAT.

Revenue is 200 × 500 = DKK 100,000. Variable costs are 200 × 150 = DKK 30,000. Contribution is DKK 70,000, leaving budgeted operating profit of DKK 20,000 before interest and tax.

Set up the model

Put labels in column A and inputs in column B.

Use =B2*B3 in B7 for revenue and =B2*B4 in B8 for variable costs. In B9, =B7-B8 gives contribution. In B10, =B9-B5 gives operating profit. Each formula refers back to the assumptions so changing an input updates the result.

Test lower activity

At 160 services, revenue falls to DKK 80,000 and variable costs to DKK 24,000. Fixed costs remain DKK 50,000, leaving profit of DKK 6,000. Volume falls 20%, while profit falls from DKK 20,000 to DKK 6,000 because fixed costs stay in place.

Make the budget easy to check

Document the source of assumptions and the month covered. Separate inputs from formulas, use consistent units and identify costs that change only at capacity thresholds. FP Academy’s budgeting and forecasting course uses models participants can explain and update themselves.