Micro Report Specification and Calculations Workbook

This spreadsheet template is a structured costing and reporting workbook designed to calculate and present the full costs of training/education programmes at a detailed level. It captures core programme assumptions (e.g., trainee numbers, completion rates, study hours/weeks, cohorts, development time, currencies and inflation parameters), then translates them into consolidated outputs such as total programme costs and income, unit costs per trainee starter/graduate, and component-level cost analysis.
A key feature of the template is that it allows costing to be done by programme and by course type, enabling planners to compare how different delivery modes (e.g., text-based, project-based, residential, ICT, and other course types) affect the overall cost structure. It breaks costs into consistent components, such as learning resources, trainee support, assessment & quality assurance, and programme resources/overheads—and provides summary views that support budgeting, scenario testing, and standardized reporting.

Table of contents
Programme Summary: high-level detailed costing report summary (programme totals, unit costs, component analysis)
1. Course Type Summary – consolidated summary by course type (component cost breakdown comparisons)
2. Course Type Master – course type input/master table (course counts, courses per trainee, trainee numbers, notes)
3. Programme Details – detailed costing report by component at programme level
4. Text – costing by course type: Text courses (component calculations and outputs)
5. Project – costing by course type: Project courses
6. Residential – costing by course type: Residential courses
7. ICT – costing by course type: ICT courses
8. Other1 – costing by course type: Other course type (1)
9. Other2 – costing by course type: Other course type (2)