Mathematics in Industry Reports (MIIR) 1 Foundry planning optimization: a decision support tool for a real-world case P. Munari 1 †, E. Beker 1 , G. M. Coelho 1 , K. M. Ferreira 1 , S. Rangel 3 , M. O. Santos 2 , R. S. Oliveira 4 , J. C. Cutipa-Luque 5 , J. L. Huarca-Quispe 5 , E. S. Zanutti 6 , J. A. Cuminato 2 †, and F. Louzada 2 . 1 Federal University of S˜ ao Carlos, S˜ao Carlos/SP, Brazil 2 University of S˜ ao Paulo, S˜ao Carlos/SP, Brazil 3 S˜ ao Paulo State University, S˜ao Jos´ e do Rio Preto/SP, Brazil 4 State University of Campinas, Campinas/SP 5 Universidad Nacional de San Agust´ ın de Arequipa, Arequipa, Per´ u 6 Lojas Riachuelo S.A, Brazil (Communicated to MIIR on 31 May 2023) Study Group: 9th Brazilian Study Group with Industry, 06-10 February 2023 , S˜ ao Carlos, Brazil Communicated by: Jos´ e Alberto Cuminato and Francisco Louzada Neto Industrial Partner: Tecumseh (https://www.tecumseh.com) Presenter: Gustavo Bianchi Mazzei - gustavo.mazzei@tecumseh.com Team Members: Pedro Munari, Federal University of S˜ao Carlos, S˜ ao Carlos/SP, Brazil; Eduardo Beker, Federal University of S˜ao Carlos, S˜ ao Carlos/SP, Brazil; Eduardo S. Zanutti, Lojas Riachuelo S.A, S˜ ao Carlos/SP, Brazil; Guilherme M. Coelho, Federal University of S˜ ao Carlos, S˜ ao Carlos/SP, Brazil; Juan C. Cutipa-Luque, Universidad Nacional de San Agustin de Arequipa, Peru; Jorge L. Huarca-Quispe, Universidad Nacional de San Agustin de Arequipa, Peru; Kamyla M. Ferreira, Federal University of S˜ao Carlos, S˜ ao Carlos/SP, Brazil; Maristela Oliveira dos Santos, University of S˜ ao Paulo, S˜ ao Carlos/SP, Brazil; Socorro Rangel, S˜ ao Paulo State University, S˜ao Jos´ e do Rio Preto/SP, Brazil; Ricardo S. Oliveira, Campinas State University, Campinas/SP, Brazil. Industrial Sector: Manufacturing Tools: mathematical optimization modeling, optimization solvers, combinatorial optimization Key Words: foundry, production planning, optimization, mathematical model, spreadsheet, decision support tool. MSC2020 Codes: 90B06, 90C27, 90C11, 90C59 † Corresponding Authors: munari@dep.ufscar.br and jacumina@icmc.usp.br https://doi.org/10.33774/miir-2023-kwwcv ORCID: https://orcid.org/0000-0001-5929-593X Content not peer-reviewed by MIIR. License: CC BY-NC-SA 4.0