Application of Linear Programming Model for Additional Production using Excess Raw Material

Authors

  • Kulika Dadas ภาควิชาวิศวกรรมอุตสาหการ คณะวิศวกรรมศาสตร์ จุฬาลงกรณ์มหาวิทยาลัย
  • Paveena Chaovalitwongse Department of Industrial Engineering, Faculty of Engineering, Integrated Management System and Smart Technology Research Group Chulalongkorn University

Keywords:

Linear Programming model, Resource allocation, Decision Making, Excess Inventory

Abstract

This paper proposes a linear programming model in order to support decision making of additional production using excess raw material. The solution of additional production determines how much to produce and how much to order. The objective of this process is to reduce excess raw material value to be disposed each month and to increase revenue for business. This study is conducted as follows. Firstly, data related to excess raw material as well as current ordering additional production are reviewed. Secondly, a linear programming model is formulated to determine the solution that minimize the total cost of this additional production and according to production constraints where the excess raw material value is reduced. Finally, the proposed LP model is implemented in Python programming and tested with previous data to show if it could determine solution of additional production which reduces the excess raw material value.

           Test results showed that the excess raw material value can be reduced by 25.05 % or 236 thousand of dollars per month when the solution from proposed LP model is used to allocate excess raw material for additional production. In addition, the revenue can also be increased in average by 179 thousand of dollars per month. Thus, the total benefit from LP model solution contributes to 415 thousand of dollars each month.

References

ดิเรก วรรณเศียร, “แบบจำลอง,” วารสารวิชาการมหาวิทยาลัยอีสเทิร์นเอเชีย, ปีที่ 1, ฉบับที่ 1, หน้า 83–89, 2549.

พิศาล สีนวล, “การใช้โปรแกรมทางคณิตศาสตร์สำหรับแก้ปัญหาจัดสรรทรัพยากรเพื่อลดเวลาในการวางแผนการผลิต,”สารนิพนธ์ วศ.บ., คณะวิศวกรรมศาสตร์ มหาวิทยาลัยธรรมศาสตร์, 2559.

ภัทราภรณ์ สัจจนดำรงค์, “การพัฒนาแผนการผลิตหลักสำหรับอุตสาหกรรมแบบผลิตตามสั่ง,” วิทยานิพนธ์ วศ.บ., จุฬาลงกรณ์มหาวิทยาลัย, กรุงเทพฯ, 2550.

G. L. Kerrigan and J. P. Norback, “Linear Programming in the Allocation of Milk Resources for Cheese Making,” Journal of Dairy Science, vol. 69, no. 5, pp. 1432-1440, 1986.

P. Doganis and H. Sarimveis, “Optimal scheduling in a yogurt production line based on mixed integer linear programming,” Journal of Food Engineering, vol. 80, no. 2, pp. 445-453, 2007.

Downloads

Published

2022-04-30

Issue

Section

Research Articles