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

Reduction in Scratches & Edge Wrinkles Defects in CRM

The Rolling is mostly used metal forming process due to its greater production and great control of finished products. . In the present competitive situation in this world we need to improve our areas in order to stay in...

A Comparative Evaluation of the Effects of Categorical Factors on the Safety of Multilane Interstate Highways

This article reports the results of comparative analysis of the significance of categorical factors with two to five levels influencing safety on interstate highways. The study used the Highway Safety Information System...

Performance on The Arterial Road In North Luwu Regency

Arterial roads in North Luwu Regency are Sultan Hasanuddin road, serving local traffic within cities, intercity within the province and inter province. This research aims to analyze the performance of road segments and f...

New Airbag Protection Cover Development of Cell Phone Against Free Fall Using Advanced Finite Element Analysis Approach

Researchers widely used physical testing method toinvestigate the damage of cellular phone during free fall. It is always very costly, time consuming and complex. Finite element analysis is an advanced simulation tools w...

Strength of CFST at Elevated Temperature

This paper deals the strength behavior of concrete filled steel tubes at elevated temperature. The main purpose of such a research is to figure out the significance of various structural parameters on the strength of CFS...

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