Zanella, FernandoVaz, Clara B.2024-02-152024-02-152023Zanella, Fernando; Vaz, Clara B. (2023). Sustainable short-term production planning optimization. SN Computer Science. ISSN 2662-995X. 4:6, p. 1-122662-995Xhttp://hdl.handle.net/10198/29487This study proposes a framework for short-term production planning of a Portuguese company operating as a tier 2 supplier in the automotive sector. The framework is intended to support the decision-making process regarding a single progressive hydraulic press, which is used to manufacture cold-stamped parts for exhaust systems. The framework consists of two sequential levels: (1) a Mixed-Integer Linear Programming (MILP) model to determine the optimal production quantities per week while minimizing the total cost; (2) a dynamic production sequencing rule for scheduling operations on the hydraulic press. The two levels are combined and implemented in Excel, where the MILP model is solved using the Solver add-in, and the second level uses the optimal production quantities as inputs to determine the production sequence using a dynamic priority rule. To validate the framework, a proposed optimal plan was compared to a real plan executed by the company, and it was found that the framework could save up to 22.1% of the total cost observed in reality while still satisfying demand. To address uncertainties, the framework requires a rolling weekly planning horizon.engMixed-integer linear programmingShort-term production planningResponsible productionjournal article10.1007/s42979-023-02261-72661-8907