Finance

“How do we plan for best and worst case?”

Plan for the best and worst case.

Best- and worst-case analysis can be scoped using declared assumptions for sales, prices and costs.

Talk to us

The problem

  • Budgeting is detached from daily operations.
  • Worst-case scenarios take weeks to model in Excel.

Who this is for

  • CFO
  • CEO
  • Operations Director

Questions you can answer

  • What is our forecast accuracy MAPE?
  • What is our forecast bias?
  • What is our budget pacing variance?

Answers

What is our forecast accuracy MAPE?

built per customer
Sources needed
  • Finance plan
  • ERP actuals
Calculation
Mean absolute percentage error
What you see
Forecast accuracy dashboard

What is our budget pacing variance?

built per customer
Sources needed
  • Finance plan
  • Accounting actuals
Calculation
(actual YTD − plan YTD) ÷ plan YTD × 100
What you see
Budget pacing dashboard

How do we model best and worst case margins?

built per customer
Sources needed
  • Finance plan
Calculation
Margin under declared changes to sales volume, prices and costs
What you see
Best, expected and worst case side by side, from your plan figures

How do we declare plan figures?

built per customer
Sources needed
  • Spreadsheets
  • Finance software
Calculation
Declared inputs mapping
What you see
Scenario inputs table

How Dataloader solves it

  1. Connect actuals We pipe in your ERP and accounting systems.
  2. Declare plan figures Plan figures are declared inputs.
  3. Track variance We surface deviations between budget and actuals.

Scenario Planning

What you see

Budget vs actuals and forecasts.

Illustrative
  • vs Budget
  • vs Worst Case
Budget vs actuals and forecasts. Illustrative example. Figures are not customer data.
MetricActualPlanVarianceForecast Bias
Revenue
Costs
Margin
Illustrative | Accounting updated 06:15 Illustrative example. Figures are not customer data.

KPI definitions

Forecast accuracy MAPE

Formula
Average of absolute percentage errors
Inputs
  • Finance plan
  • ERP actuals
Missing data
Requires finance plan and ERP actuals.

Forecast bias

Formula
Sum of forecast errors ÷ Sum of actuals
Inputs
  • Finance plan
  • ERP actuals
Missing data
Requires finance plan and ERP actuals.

Budget pacing variance

Formula
(actual YTD − plan YTD) ÷ plan YTD × 100
Inputs
  • Accounting actuals
  • Finance plan
Missing data
Requires accounting actuals and finance plan.

Revenue vs plan

Formula
Actual revenue ÷ Planned revenue
Inputs
  • Accounting revenue
  • Finance plan
Missing data
Requires accounting revenue and finance plan.

Business case

Forecast accuracy improvement

  • Current error margin
  • Cost of overstock/understock
  • Calculation: Savings = Reduced waste + captured sales.

Customer result

Customer result

Orders from three webshops routed automatically to five stores and two supplier warehouses. Orders are no longer typed over by hand.

Measured in the Dataloader sync logs

Industries where this matters

Frequently asked questions

Where do plan figures come from?

Plan figures are declared inputs.

Plan for the best and worst case.