Optimization of Distribution Network of Nigerian Bottling Company PLC Using LINGO

Journal Title: IOSR Journal of Mechanical and Civil Engineering (IOSR-JMCE) - Year 2018, Vol 15, Issue 4

Abstract

This research on Optimization of Distribution Network using LINGO was carried out in the Nigerian Bottling Company (NBC) which has many distribution centres all over the country. Three plants and twenty two warehouses within the South-South and South-East region of Nigeria were selected for this study. Model for the distribution problem of the company were developed using linear programming approach. The data collected was analyzed using LINGO programming. The analytical result obtained was thirty billion, nine hundred and three million, nine hundred and fifteen thousand, twenty nine naira, eleven kobo (N30, 903,915,029.11). The actual distribution cost obtained from the company’s annual report is almost equal to this value. The optimization result obtained was (N6, 798,861,306.36) which is the annual distribution cost for the period of six years. When compared with the analytical method N24, 105,053,722.75 (about N4,017508953 per annual) was saved and all the demand was met and all warehouses supplied with demands within their proximity. This showed that about 22% reduction in distribution cost was achieved by optimizing all the distribution cost elements. In addition, the existing situation of the company was improved and a new network system for the company designed. The study recommended the application of this research outcome to other similar companies that intend emulating the benefits in the designed distribution network.

Authors and Affiliations

Engr. Dr. B. E. Okafor, Engr. Dr. I. Nnanna

Keywords

Related Articles

Effects of the Quality of Facilities on Residential Building and Environmental Sustainability in the LSDPC Low-Cost Housing EstateIba, Lagos State.

The impact of good quality facilities in sustainable housing development cannot be overemphasised. Hence, there is need for proper provision and effective maintenance by qualified professionals. The main purpose of this...

Fixed Offshore Platform Rehabilitation with Friction Damper

This work presents a study for a fixed offshore platform to show the value of applying friction damper in increasing the lateral resistance under wind, waves and currents. It is considered an extendable work for previous...

Improve the Calorific Value of Municipal Solid Waste By Adding Additive Material For Incineration Process

Rapid increase in urbanization and per capita income has lead to high rate of Municipal Solid Waste(MSW) generation (0.34kg/capita/day in 2016) and it is expected to have even higher rate of 0.70 kg/capita/day. In many d...

Analysis Of Water Status Quality And Flood And Innundation Causes In Rawa Matang Hanau Irrigation Area Balangan District

Matang Hanau is an irrigated swamp area located in Lampihong District, Balangan Regency this will be developed into a swamp irrigation area. The area is inhabited by transmigration community with oil palm gardening as th...

Effect of Outrigger Structural System on Highrise Structures, Subjected to Lateral Loads

There are several factors which have made it compulsory for our nation and the world to go for highrise structures and the skyscrapers. One of such factors is rapidly increment in population in urban areas. But it is a b...

Download PDF file
  • EP ID EP438461
  • DOI 10.9790/1684-1504042841.
  • Views 53
  • Downloads 0

How To Cite

Engr. Dr. B. E. Okafor, Engr. Dr. I. Nnanna (2018). Optimization of Distribution Network of Nigerian Bottling Company PLC Using LINGO. IOSR Journal of Mechanical and Civil Engineering (IOSR-JMCE), 15(4), 28-41. https://europub.co.uk/articles/-A-438461