Introduction xv
Syllabus content
Covered in chapter
(1) Scatter diagrams and the correlation coefficient 3, 10
(2) Simple linear regression 10
F Forecasting – 15%
Learning outcomes
On completion of their studies students should be able to:
(i) Prepare a time series graph
(ii) Identify trends and patterns using an appropriate moving average
(iii) Identify the components of a time series model
(iv) Prepare a trend equation using either graphical means or regression analysis
(v) Calculate seasonal factors for both additive and multiplicative models and explain when each is appropriate
(vi) Calculate predicted values given a time series model
(vii) Identify the limitations of forecasting models
Syllabus content
Covered in chapter
(1) Time series analysis – graphical analysis 11
(2) Trends in time series – graphs, moving averages and linear regression 11
(3) Seasonal variations using both additive and multiplicative models 11
(4) Forecasting and its limitations 11
G Spreadsheets – 10%
Learning outcomes
On completion of their studies students should be able to:
(i) Explain the features and functions of spreadsheet software
(ii) Explain the use and limitations of spreadsheet software in business
(iii) Apply spreadsheet software to the normal work of a Chartered Management Accountant
Indicative Syllabus content
Covered in chapter
(1) Features and functions of commonly-used spreadsheet software: workbook,
worksheet, rows, columns, cells, data, text, formulae, formatting, printing, graphics
and macros. Note: Knowlegde of Microsoft Excel type spreadsheet
vocabulary/formulae syntax is required. Formula tested will be that which is
constructed by users rather than pre-programmed formulae
1, 12
(2) Advantages and disadvantages of spreadsheet software, when compared to manual
analysis and other types of software application packages
12
(3) Use of spreadsheet software in the day-to-day work of the Chartered Management
Accountant: budgeting, forecasting, reporting performance, variance analysis, what-if
analysis, discounted cashflow calculations
1, 3, 4b, 9, 10, 12