Manage margins

How can you explain differences in profitability between activities without confusing economic performance with the effects of cost allocation?

1960 € per session, excl. VAT

In short

In one 7-hour day, excluding breaks, build a reliable understanding of profitability by activity. Use an authorised generative AI tool to prepare the data, make calculation conventions explicit, test allocations and identify areas for improvement. Every financial result is recalculated and submitted for human validation.

Why this training?

An activity may appear loss-making because it absorbs an excessive share of common costs. Conversely, a high margin may conceal unallocated costs, overlooked discounts or underestimated resource consumption. AI helps suggest checks, discuss allocation keys and draft management commentary. It replaces neither reproducible calculations nor a qualified professional’s judgement on the conventions adopted. Continuing case study: The fictitious organisation Talvion Agencement sells furniture, carries out installations and provides maintenance services. Over two fictitious quarters, its revenue increases but its profitability declines. Participants use sales, purchases, hours worked and common costs to distinguish operational effects from allocation effects. Application at work: At the next month-end close, reuse the model within an authorised scope, have the conventions validated by management accounting and monitor margin variances with their causes documented.

Objectives of this training

  • Reconcile cost accounting data with the accounting totals provided.
  • Calculate the contribution margin and the result after allocation.
  • Justify the allocation keys for common costs.
  • Break down margin changes between two periods.
  • Test the sensitivity of results and draft evidence-based recommendations.

Who is it for and what are the prerequisites?

Roles and tasks concerned

  • Management accountants and financial analysts
  • Activity managers and finance managers who monitor cost accounts

Prior skills

  • Distinguish between revenue, variable costs, fixed costs and profit or loss.
  • Use formulae and pivot tables in a spreadsheet.
  • Know how to formulate a structured request to a generative AI tool.

What you will work on

  1. Define approaches to assessing profitability

    Objective: Choose indicators that are comparable across activities. Contribution margin, direct fixed costs, common costs and result after allocation; percentages expressed relative to revenue.

  2. Ensure the reliability of the cost accounting dataset

    Objective: Ensure that assignments and amounts are correct. Duplicates, credit notes, missing data, periods and assignments; reconciliation with the totals provided.

  3. Build the financial analysis table

    Objective: Calculate successive margins. Separate variable and fixed costs, and direct and indirect costs; prevent double counting.

  4. Test the allocations

    Objective: Measure the influence of the conventions. Possible cost drivers: hours, floor areas or service visits; limitations of revenue-based allocation.

  5. Explain the changes

    Objective: Isolate the causes of quarterly variances. Price, volume, mix, unit cost and allocation effects; decomposition conventions without double counting.

  6. Prepare for human decision-making

    Objective: Present levers proportionate to the findings. Pricing, purchasing and organisational scenarios; limitations of full costing when deciding whether to discontinue an activity.

What you take away

  • Data dictionary and control log
  • Margin table by activity with traceable formulae
  • Allocation matrix and sensitivity tests
  • Management report with recommendations, limitations and indicators

Method and assessment

  • Short instructional inputs followed by immediate practice on the continuing case study.
  • Individual work followed by work in pairs, with peer review of the outputs.
  • Guided group discussion: what works, what needs correcting and what remains a human decision.
  • Preparation: Arrange a spreadsheet and access to an AI tool authorised by the organisation; use only fictitious or anonymised data. Identify the usual cost accounting conventions: scopes, period attribution, treatment of discounts and allocation keys.

Observable criteria: Cost accounting totals are reconciled with source data; every residual variance is explained. ; Formulae explicitly define the costs they include and the denominator used for percentages. ; Each allocation specifies its driver, its justification and a tested alternative. ; Every figure discussed is recalculated outside AI and linked to its source. ; Recommendations distinguish between findings, assumptions and required validations..

Frequently asked questions

Can AI calculate margins on its own?

Its proposals must be recalculated in the spreadsheet using auditable formulae.

Can you bring internal figures?

Only if anonymised, with prior authorisation and within the environment approved by the organisation.

Should a loss-making activity be discontinued?

Not automatically: examine avoidable costs, interdependencies and assumptions before making any decision.

Who validates the recommendations?

A qualified finance professional; no sensitive decision is automated.

Last updated: