Production Cost Optimization in Sugar Manufacturing Using Linear Programming: A Case Study of Savannah Sugar Company Limited, Numan, Nigeria

Authors

  • Yahaya Garba Author
  • Ayuba Modu Yami Modibbo Adama University Yola Author
  • Afolabi Oludele Raphael Author

DOI:

https://doi.org/10.67868/t9gh3s70

Keywords:

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.

Author Biographies

  • Ayuba Modu Yami, Modibbo Adama University Yola

    Department of Operations Research, Modibbo Adama University, Yola, Adamawa State, Nigeria

  • Afolabi Oludele Raphael

    Department of Operations Research, Modibbo Adama University, Yola, Adamawa State, Nigeria

References

Optimal production plan, demand and closing stock, January to June

Additional Files

Published

19-11-2026

How to Cite

Production Cost Optimization in Sugar Manufacturing Using Linear Programming: A Case Study of Savannah Sugar Company Limited, Numan, Nigeria. (2026). Nigerian Journal of Operations Research, 3(4), 32-45. https://doi.org/10.67868/t9gh3s70

Similar Articles

1-10 of 25

You may also start an advanced similarity search for this article.