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

Autori

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

DOI:

https://doi.org/10.67868/t9gh3s70

Parole chiave:

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.

Biografie autore

  • 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

Riferimenti bibliografici

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

File supplementari

Pubblicato

2026-11-19

Come citare

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

Articoli simili

1-10 di 25

Puoi anche Iniziare una ricerca avanzata di similarità per questo articolo.