Skip to content
Financial Reporting | Part 16 of 20

Integrated Planning: Connect Sales, Capacity, Profit and Cash

Build a driver-based plan with linked income statement, balance sheet and cash flow rather than independent forecasts.

A revenue forecast, cost budget and cash plan can each look plausible while contradicting one another. Sales assumes rapid growth, operations lacks capacity and treasury discovers the funding gap after commitments are made.

Integrated planning translates one set of operating assumptions into connected financial statements.

Start with the business drivers

Define the segments, products, volumes, prices and discounts that explain revenue.

Then connect the demand to the capacity, materials, staffing and service needed to deliver it.

Use detail where it changes a decision. Excessive planning granularity can consume time without improving the forecast.

Assign owners to assumptions and distinguish customer evidence from management ambition.

Build the operating economics

Separate costs that vary with activity from fixed and step costs.

A simple percentage of revenue can be a useful starting point, while each material relationship needs examination.

Capacity may increase in discrete steps. Productivity may improve only after investment and learning. Wage and material assumptions can differ from selling-price changes.

A hypothetical manufacturer expecting higher volume should not assume unchanged headcount and no capital expenditure without evidence of available capacity.

Add the balance-sheet requirements

  • Receivables follow billing and collection.
  • Inventory follows flow and stock policy.
  • Payables follow purchasing and payment terms.

Use appropriate drivers and account for seasonality.

Build asset schedules for investment, depreciation, disposal and relevant measurement changes. Forecast provisions and other material balances consistently with the operating assumptions.

The balance sheet should emerge from the plan rather than be an afterthought.

Specify debt maturities, funding availability, interest assumptions and minimum cash requirements.

Tax and owner distributions need their own logic and appropriate input. They should not be copied mechanically from a historical percentage.

If borrowing depends on cash need and interest depends on borrowing, handle the interaction transparently.

A financing plug can reveal the amount needed. It does not prove that a lender will provide it.

Reconcile all three statements

Profit connects to equity through the relevant movements. The cash-flow statement explains changes in cash. Asset and liability schedules connect opening and closing balances.

Check that the accounting equation holds and that closing cash matches the cash-flow bridge.

A balanced model can still contain unrealistic assumptions. Mechanical checks establish consistency, while commercial and operating challenge establishes credibility.

Separate these review tasks.

Use the plan to make choices

Test demand, timing, margin and working-capital variations. Identify when capacity, cash or covenant constraints become binding.

Distinguish a forecast of the likely outcome from a target and an authorized budget. Mixing these roles encourages optimistic reporting and weakens early warning.

Review actuals against drivers and update the outlook as evidence changes.

Preserve the explanation for material revisions so the organization learns about forecasting quality.

Integrated planning is a shared management model of how the business intends to operate and fund itself. Its strongest output is a clearer set of decisions about customers, capacity, investment and financing before the organization makes incompatible commitments.

Newsletter

One Lean idea.
Every week.