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

Thermal Analysis of Composite Hollow Cylinders Using COMSOL Software

The composite hollow cylinders are used in design of steam pipes and electrical cable wires where insulating material is added to them so as to avoid the heat transfer to surroundings and stream turbine where the stream...

Integration of Lean Manufacturing And Six Sigma Using Statistical Methods

This research integration of lean manufacturing and six-sigma was carried out in the Nigerian Breweries Enugu Plant where management strategies were not so developed. The main objective of this work was focused on the mi...

Effect of Crusher Dust-Geogrid Composite on Interface Shear Strength

Modern geotechnical practice often uses technique of reinforced soil – a composite of soil and reinforcement mostly geogrids. In civil engineering application geogrid is widely use to reinforce embankment, retaining wall...

Buckling analysis of single-layered FG nanoplates on elastic substrate with uneven porosities and various boundary conditions

In this investigation the buckling behavior of single-layered functionally graded nanoplates with uneven porosities exposed to hygrothermal loads is modeled for the first time. Using the Eringen’s nonlocal elasticity the...

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...

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