Production Cost Optimization in Sugar Manufacturing Using Linear Programming: A Case Study of Savannah Sugar Company Limited, Numan, Nigeria
DOI:
https://doi.org/10.67868/t9gh3s70Schlagwörter:
Linear programming; Production planning; Sensitivity analysis;Abstract
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.
Literaturhinweise
Zusätzliche Dateien
Veröffentlicht
Ausgabe
Rubrik
Lizenz
Copyright (c) 2026 Nigerian Journal of Operations Research

Dieses Werk steht unter der Lizenz Creative Commons Namensnennung - Nicht-kommerziell - Keine Bearbeitungen 4.0 International.



