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

Recycled refractory brick and Kaolin in Green concrete production

The paper presents results of three studies on concrete mixes containing calcined clay to produce green concrete. The first type (Type I) was Metakaolin (600° K Calcination), second type (Type II) was calcined kaolin in...

Relative Performance of Red Mud over Red Soils as Construction Material

Natural soils are prominent material for construction activities. Red soils are widely distributed in north coastal districts of Andhra Pradesh, which are strong in dry conditions and compressed under saturated condition...

Design and Fabrication of A Single Acting Hydraulic Crane

In this present work, the designed and fabrication of a single acting hydraulic crane was carried out. The hydraulic crane is made up of the following main components; the hydraulic actuator or actuating cylinder, the ma...

Emission and Performance testing of single cylinder CI engine with using ricebran biodiesel

The rate of petroleum reserve is declining while energy demand keeps increasing. The current expansion of the Indian economy has escalated petroleum demand, prices have surged, hurting the economies of poor and developin...

Experimental Study of Effect the Load Applied and Length of Adiabatic Section on the Performance of the Wicked Horizontal Heat Pipe.

An experimental study is carried out to evaluate the thermal performance of wicked horizontal heat pipe (WHHP).R134-a is used as working fluid with mass 123 gram. The WHHP was made of three parts condenser, evaporator an...

Download PDF file
  • EP ID EP438461
  • DOI 10.9790/1684-1504042841.
  • Views 51
  • 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