Track B: Management Accounting & FP&A
What you will be able to do
- Analyse costs and break-even
- Build sales, production and cash budgets
- Explain variances
- Prepare a monthly management pack
17 lessons and projects. Short, practical steps in a spreadsheet, with real Excel for the features a browser cannot run.
Outline
Module 1: Costing
- Cost behaviour: fixed, variable, semi-variable
- Break-even and margin of safety
- Contribution by product
- Absorption vs marginal costing profit
- Activity-based costing
Module 2: Budgeting
- Sales budget
- Production and materials budget
- Cash budget
- Flexed budget
Module 3: Variance analysis
- Budget vs actual
- Sales price and volume variances
- Materials and labour variances
- Variance bridge chartReal Excel
Module 4: Forecasting and reporting
- 12-month rolling forecast
- Driver-based forecast
- Management pack with commentary
Capstone: annual budget and monthly management pack
Completing it earns a certificate of completion. It is not an accreditation or a professional qualification.
Start free