Production Cost Optimization in Sugar Manufacturing Using Linear Programming: A Case Study of Savannah Sugar Company Limited, Numan, Nigeria
Nigerian Journal of Operations Research · 19.11.2026 · 3 (4) · 32-45
DOI: 10.67868/t9gh3s70 ↗Kurz gefasst
Fachartikel in der Zeitschrift Nigerian Journal of Operations Research, online erschienen am 19.11.2026. Verfasst von Garba Yahaya und 2 weiteren Autor:innen. Der Volltext ist frei zugänglich (Open Access, CC BY-NC-ND 4.0).
Abstract (Originalsprache)
Sugar manufacturers in Nigeria work under fluctuating cane supply, limited capacity, costly overtime, high electricity cost and limited storage, yet monthly production is often planned by experience alone, which can lead to unnecessary overtime, unnecessary stock and higher cost. This study develops a linear programming (LP) model to minimize the production cost of Savannah Sugar Company Limited (Dangote Sugar Refinery), Numan, Nigeria, over six months from January to June 2025. The model has 18 decision variables and 66 constraints on demand balance, production capacity, raw material, labour, machine hours, electric power and storage, and electricity is charged to each ton produced. Data came from company records and interviews with 13 key informants, with labour, machine-hour, electric power and storage parameters assumed where records were unavailable, and the model was solved with the Simplex LP engine of Microsoft Excel Solver, followed by sensitivity analysis. The minimum total cost is ₦4,678,873,844.50. The optimal plan produces 16,174.6 tons in regular time and 1,595.4 tons on overtime, uses overtime only from April to June, and leaves no stock at the end of June. Regular capacity and raw material are the binding constraints: one more ton of regular capacity saves ₦25,000 to ₦53,142.50, and one more ton of raw material saves ₦2,185.75 to ₦7,185.75 in April to June. A break-even holding period of about 2.1 months explains the timing of overtime. Tests on the assumed parameters show that the plan is unchanged for adverse changes of at least 10% in machine time and storage but is sensitive to the regular-time labour and electric power limits, where a change above 1.9% brings overtime forward and raises cost by about 1% to 4%. The study concludes that LP with Excel Solver is a practical planning tool for a Nigerian sugar plant, provided that the assumed parameters are replaced by measured plant values.
Zitieren
APA
Yahaya, G., Yami, A. M., & Raphael, A. O. (2026). Production Cost Optimization in Sugar Manufacturing Using Linear Programming: A Case Study of Savannah Sugar Company Limited, Numan, Nigeria. Nigerian Journal of Operations Research, 3(4), 32-45. https://doi.org/10.67868/t9gh3s70
Vancouver
Yahaya G, Yami AM, Raphael AO. Production Cost Optimization in Sugar Manufacturing Using Linear Programming: A Case Study of Savannah Sugar Company Limited, Numan, Nigeria. Nigerian Journal of Operations Research. 2026;3(4):32-45. doi:10.67868/t9gh3s70
BibTeX
@article{Yahaya2026,
author = {Yahaya, Garba and Yami, Ayuba Modu and Raphael, Afolabi Oludele},
title = {Production Cost Optimization in Sugar Manufacturing Using Linear Programming: A Case Study of Savannah Sugar Company Limited, Numan, Nigeria},
journal = {Nigerian Journal of Operations Research},
year = {2026},
volume = {3},
number = {4},
pages = {32--45},
doi = {10.67868/t9gh3s70}
}
EUVIMED