ResagratiaResagratiaResagratia
+234 806 299 1199
contact@resagratia.com

Insights Dashboards – Nigeria’s 2020 Proposed Budget

  • Home
  • Business
  • Insights Dashboards – Nigeria’s 2020 Proposed Budget

Some weeks ago we revealed the Open Analytics Initiative which aims to provide useful data and analytics solutions for free to everyone to use, reuse, and redistribute with the intent to promote information dissemination, knowledge sharing, and skills acquisition.

We believe doing this supports our vision of data democratisation, continuous human capital development and creating a positive impact in Nigeria. By engendering collaboration to solve local, complex challenges, we aim to develop and maintain a repository of the finest research and robust solutions in the areas of data visualisation, analytics, and business intelligence.

Insights Dashboards

There are over 270 individual chargeable items in Nigeria’s 2020 budget, the largest of which is salaries, gulping up over N2.4 trillion ($6.8bn). This is followed by interest payment on internal public debt, non-regular allowances, interest payment on external public debt and pensions.

A host of contributors, many of whom are professionals, have designed interactive information dashboards which serve as a way to better understand the budget details and to convey a wealth of information on Nigeria which was previously unknown.

With the Open Analytics Data Platform, we have unlocked a new dimension in how we analyse and present budget details, and most importantly, we have access to well-structured data on Nigeria’s MDAs (ministries, departments, and agencies).

Visual 1: Proposed Budget Distribution for Federal Government Owned Educational Institutions

Report Author: John Analoh | Resagratia

Explore the interactive dashboard below.

Key takeaways:

Ministry of Education is earmarked to receive ₦653 billion as its total budgetary allocation in 2020. Of this Amount, ₦568 billion or 87% is to be spent on personnel costs i.e Salaries, Allowances, and Social Benefits. ₦51 billion (8%) is to be spent on various capital projects while ₦34 billion has been proposed to cover the overhead costs.

For Universities, a total of ₦285 billion is allocated and the University of Nigeria, Nnsuka comes out top for total allocation at ₦18 billion followed closely by Ahmadu Bello University, Zaria at ₦17 billion. In both cases, personnel costs consume the bulk of the allocation leaving little for Capital Projects and Overhead costs.    For Capital Projects, a total of ₦7 billion is proposed to be spent with the University of Maiduguri receiving ₦1.3billion followed by the University of Abuja at ₦1.2 billion. 

Polytechnics get a total allocation of ₦79 billion and the Federal Polytechnic Kaduna comes out with the highest proposed allocation at ₦8 billion (10%) while Yaba College of Technology is to get the highest amount earmarked for Capital Projects. The bulk of budgetary allocation for Polytechnics is to be gulped by Personnel costs. 

Colleges of Education would get a total allocation of ₦53 billion spread across all 21 Federal Government-owned colleges of education in the country. Capital project spend is about ₦1 billion which constitutes just 2% of the total allocation. Personnel costs constitute 94% of the proposed budget spend.

The budget proposal also covers the 114 Federal Government-owned Secondary institutions situated in the 36 states of the federation including the Federal Capital Territory.  A total of allocation ₦52 billion has been proposed with ₦10 billion (19%) going into funding Capital Projects while ₦21 billion (40%) is to cover personnel costs.
Side note: Federal owned Universities of Agriculture are classified under the Ministry of Agriculture and not under the Ministry of Education.


Visual 2: Ministry of Defence et al

Report Author: Tosin Openiyi | LinkedIn

Explore the interactive dashboard below.

Key takeaways:

MOD Summary: The Ministry of Defence intends to spend approximately 11% of her total allocation on 268 capital projects, 202 are new projects and 66 are currently ongoing. A total sum of approx. 6 billion naira will be spent on the purchase of arms and ammunitions.

MOD Other Insights: This visual revealed that the Federal Government of Nigeria encourages local trainings (3.76 billion naira) over international training (1.63 billion naira) for the Ministry of Defence and they will also be spending approx. 786 million naira on ICT (purchase of computers, computer software acquisition and internet access charges).

On fuel consumption, the least budget goes to Cooking Gas/Fuel Cost (229 Million Naira) and both Motor Vehicle Fuel Cost and Plant/Generator Fuel Cost have the highest budget (approx. 6.1 billion naira).

Security Issues: This visual shed light on how serious the Federal Government intends to address security issues in the country and it is interesting to know that in the 21st century/digital age, 1 billion naira will be spent on printing of security documents only. In total, more money will be given to the Ministry of Defense (approx. 20.2 billion naira) and for the purchase of security equipment, the National Security Adviser has the highest capital expenditure (approx. 8.7 billion naira). The total capital expenditure of the proposed budget is approx. 9.45 trillion naira and the expense of 52 billion naira on security-related issues make up less than 1%.

It’s also important to mention that a total of 100 billion naira has been budgeted for operation Lafiya Dole and other operations of the armed forces.


Visual 3: Ministry of Science & Technology, Ministry of Health and Budget Distribution across Federal Government Hospitals

Report Author: Obinna Iheanachor | LinkedIn

Explore the interactive dashboard below.

Key takeaways:

With an allocation of ₦427.30 billion, the Federal Ministry of Health is ranked in the top 10 MDAs by allocation. However, this amount is just 4.5% of the total budget for MDAs (₦9.45 trillion).

Breaking this down to health cost per citizen, this means that the Government is allocating an estimated ₦2000 for the healthcare of each citizen in 2020.

Below are some noteworthy insights:

  1. Federal Hospitals claim ₦10.57 billion of ₦46.48 billion allocated for capital projects.
  2. There are 35 Federal Hospitals in Nigeria spread across just 21 states. However, we have at least one Federal Hospital/Medical Centre/Clinic in every state of the Federation.
  3. ₦339.1 million is allocated for Construction/Provision of Hospitals/Health Centres.
  4. The top two capital projects being carried out by the Ministry of Health is the Polio Eradication Initiative (PEI) with an allocation of ₦4.8 billion and Expanded Midwives Service Scheme with an allocation of ₦2 billion.
  5. With the prevalence of polio (in parts of Northern Nigeria predominantly) and the high rate of maternal deaths (according to the World Health Organization, Nigeria is the country where almost 20% of all global maternal deaths happen), this might explain the increased importance given to these capital projects.

Visual 4: Federal Ministry of Humanitarian Affairs and Disaster Management

Report Author: Abdulazeez Kuranga | LinkedIn

Explore the interactive dashboard below.

Key takeaways:

Of the total N444.3 billion allocated to the ministry of humanitarian affairs and disaster management, the National Social Investment Office got the largest share as 90% of the total ministry’s allocation was budgeted to it. While the remaining four sub-MDAs will share the remaining 10%.

All allocations to the North East Development Commission (NEDC) will go into capital expenditure and this amounts to N37.83 billion while 87.5% of the total allocation to the National Social Investment Office will go into recurrent expenditure.

The Ministry of Humanitarian Affairs and Disaster Management will be spending more on the development of national unified social register (N437 million) than it will spend on resettlement of IDPs in North East and Bakassi returnees (N165 million) as well as the rehabilitation programme for drug addiction (N150 million) combined.

Further analysis of the projects to be done by the ministry shows that apart from the top two projects to be done in 2020, the ministry prioritizes projects to itself than it does to cater to humanitarian affairs and disaster management in the country. For example, the ministry is spending more on the remodeling of the zonal office of NEMA in the South-South region than it will spend on resettling IDPs and Bakassi returnees.

Visual 5: Federal Ministry of Environment: Capital Projects and Waste Management

Report Author: Edith Oni | LinkedIn

Explore the interactive dashboard below.

Key takeaways:

The Ministry of Environment has a total allocation running into ₦ 28 billion with an allowance of ₦ 9.6 billion for capital projects while ₦ 18 billion is poised to be spent on recurrent items like salaries.

Of the ₦ 9.6 billion for capital expenditure, only ₦ 189 million is reserved for waste management projects. There are a total of 216 projects to be executed under the Ministry of Environment.

In the area of waste management, 12 projects have been proposed, 5 of which are currently ongoing and 7 are new projects. 3 of the 5 ongoing projects are community-based waste management projects.

Waste Management Projects

Resa Academy

Resa Academy is set to launch March 7, 2020. This will be 6 weeks of intensive fundamentals training in Microsoft Power BI, Excel and Python with a core focus on building real-life analytics solutions for various business use cases and for the Open Analytics Platform.

Access the discounts we have for students, women and if you pay via Paystack today!

To view our brochure and learning model, REGISTER HERE.


What next?

You can also connect to the data and tell your own stories about Nigeria. This article will get you started – Open Analytics Data – Nigeria’s Proposed 2020 budget.

Related article > How to build a location intelligent Power BI dashboard

Other tutorials > Breaking down and analysing Nigeria’s 2020 budget proposal

To find out more about our upcoming Academy and workshopsjoin the tribe, subscribe to our latest insights and watch this space!