The ministry of finance of Ojaja Republic prepared the aggregate Medium-Term Expenditure-Framework (MTEF) budget for consideration by the National Assembly as contained in the country’s Constitution. The following are the MTEF actual budget estimates and the approved budget estimates by various sectors have been thoroughly screened by the Budget Committees of the Senate and House of Representatives: Ojaja Federal Republic Summary of total budgeted expenditure by sector for 2020 Sector code Sector name Actual estimates 2020 Approved estimates 2020 N’m N’m 01 Administrative sector: Personnel cost 40,000 34,000 Overhead cost 25,000 21,250 Consolidated revenue charges 18,600 15,810 Capital expenditure 62,400 53,040 Sub-total 146,000 124,100 02 Economic sector: Personnel cost 22,500 20,250 Overhead cost 12,600 11,340 Consolidated revenue charges 28,600 25,740 Capital expenditure 41,300 37,170 Sub total 105,000 94,500 03 Law and justice sector: Personnel cost 15,800 15,800 Overhead cost 20,200 20,200 Consolidated revenue charges 17,500 17,500 Capital expenditure 38,500 38,500 Sub total 92,000 92,000 92 04 Regional sector: Personnel cost 40,800 38,760 Overhead cost 22,200 21,090 Consolidated revenue charges 16,700 15,865 Capital expenditure 32,300 30,685 Sub total 112,000 106,400 Summary of total expenditure by sectors: Personnel cost 119,100 108,810 Overhead cost 80,000 73,880 Consolidated revenue charges 81,400 74,915 Capital expenditure 174,500 159,395 Total 455,000 417,000 Additional information (i) Administrative sector - all costs at incremental basis of 15%, except for capital expenditure which will increase by 10%. (ii) Economic sector - all costs at incremental basis of 25%, except for overhead cost which will decrease by 5%. (iii) Law and justice sector - all costs at declining basis of 5%, except for personnel cost which will increase by 10%. (iv) Regional sector - all cost at incremental basis of 10%, except for consolidated revenue charges which will decrease by 15%. Required:
Prepare proposed budget estimates, for 2021, 2022 and 2023 based on the approved estimates for year 2020.
Explain the following in relation to National Chart of Accounts (NCOA) structure for budgeting: i. Functional segment (2 Marks) ii. Programme segment (2 Marks) iii. Geographical segment (2 Marks)
Enumerate FOUR steps require for budgeting with the National Chart of Accounts. (4 Marks) 93
Revise this question
The medium-term expenditure framework › The format and the incremental projectionThe National Chart of Accounts and financial reporting formats › The structure: six segmentsPurposes of the budget and budgeting methods in Nigeria › Steps for budgeting with the chartSuggested answer
Ojaja Federal Republic Preparation of proposed budgeted estimates for 2021 to 2023 Sector code Sector name 2020 2020 2021 2022 2023 Actual estimates Approved estimates Proposed estimates Proposed estimates Proposed estimates N’000 N’000 N’000 N’000 N’000 01 Administrative sector Personnel cost 40,000.00 34,000.00 39,100.00 44,965.00 51,709.75 Overhead cost 25,000.00 21,250.00 24,437.50 28,103.13 32,318.60 Consolidated revenue charges 18,600.00 15,810.00 18,181.50 20,908.73 24,045.04 Capital expenditure 62,400.00 53,040.00 58,344.00 64,178.40 70,596.24 Sub-total 146,000.00 124,100.00 140,063.00 158,155.26 178,669.63 02 Economic sector Personnel cost 22,500.00 20,250.00 25,312.50 31,640.63 39,550.78 Overhead cost 12,600.00 11,340.00 10,773.00 10,234.35 9,722.63 Consolidated revenue charges 28,600.00 25,740.00 32,175.00 40,218.75 50,273.44 Capital expenditure 41,300.00 37,170.00 46,462.50 58,078.13 72,597.66 97 Sub total 105,000.00 94,500.00 114,723.00 140,171.85 172,144.51 03 Law and justice sector Personnel cost 15,800.00 15,800.00 17,380.00 19,118.00 21,029.80 Overhead cost 20,200.00 20,200.00 19,190.00 18,230.50 17,318.98 Consolidated revenue charges 17,500.00 17,500.00 16,625.00 15,793.75 15,004.63 Capital expenditure 38,500.00 38,500.00 36,575.00 34,746.25 33,008.94 Sub total 92,000.00 92,000.00 89,770.00 87,888.00 86,362.34 04 Sub total Personnel cost 40,800.00 38,760.00 42,636.00 46,899.60 51,589.56 Overhead cost 22,200.00 21,090.00 23,199.00 25,518.90 28,070.79 Consolidated revenue charges 16,700.00 15,865.00 13,485.25 11,462.46 9,743.09 Capital expenditure 32,300.00 30,685.00 33,753.50 37,128.85 40,841.74 Sub total 112,000.00 106,400.00 113,073.75 121,009.81 130,245.18 Summary of total expenditure by sectors Personnel cost 119,100.00 108,810.00 124,428.50 142,623.23 163,879.89 Overhead cost 80,000.00 73,880.00 77,599.50 82,086.88 87,431.00 Consolidated revenue charges 81,400.00 74,915.00 80,466.75 88,383.69 99,066.20 Capital expenditure 174,500.00 159,395.00 175,135.00 194,131.63 217,044.57 Total 455,000.00 417,000.00 457,629.75 507,225.42 567,421.66
(b) Explanation of National Chart of Accounts (NCOA) in relation to budget structure i. Functional segment: The functional classification or classification by functions of government is a detailed classification of the functions or a socio-economic objective, that government unit aims to achieve through various outlays. It therefore, organises government activities according to their broad objectives or purposes. 98
ii. Programme segment: The programme classification identifies various set of activities to meet specific policy objectives of the government e.g. Pre- primary education, poverty alleviation and food security.
iii. Geographical segment: The geographical classification is used to identify the geographical location of an entity (MDAs)or a project so that an analysis of government budget along various zones, states and local government areas in the country can be done.
(c) Steps required for budgeting with the National Chart of Accounts
i. Identify the government institutions (cost and revenue centres) from the hierarchy of administrative list and codes provided in the chart of accounts. ii. Identify the economic items that would be executed during the fiscal year. iii. Identify the functions intended to be performed by government institutions (revenue and cost centres). iv. Identify the programmes intended to be carried out by the government institutions. v. Determine the sources of financing the budgeted amount for each budget line. vi. Identify the planned location for the economic transactions or government institutions.
Examiner’s report The question tests candidates’ knowledge on the preparation of budget estimates using Medium-Term Expenditure Framework (MTEF) as well as IPSAS 24 in part (a) of the question, while parts (b) and (c) test candidates’ knowledge on the explanation of functional, programme and geographical segments in relation to structure of National Chart of Account (NCOA) for budgeting purposes. All the candidates attempted the question and their performance was average. The commonest pitfalls were the inability of the candidates to explain the functional, programme and geographical segments in relation to structure National Chart of Account (NCOA) for budgeting purposes. Also candidates were unable to incorporate the additional information given in the notes to the question in the preparation of budget estimates using Medium-Term Expenditure Framework (MTEF). Candidates are advised to pay more attention to the relevant provisions of budget estimates using Medium-Term Expenditure Framework (MTEF) and also to make use of Pathfinder and Study Text for better performance in the Institute’s future examinations. 99
Marking guide Marks Marks a Preparation of proposed budget estimates Title ½ Calculation of total: Administrative sector budget estimates 3¾ Economic sector budget estimates 3¾ Law and justice sector budget estimates 3¾ Regional sector budget estimates 3¾ Summary of expenditure budget estimates by sectors 4½ 20
b. Explanation of National Chart of Accounts (NCOA) in relation to budget structure Explanation of the segments identified 6 c Steps required for budgeting with the National Chart of Accounts 4 Total 30