OTIMIZAÇÃO LINEAR APLICADA Á PRODUÇÃO DE SALTENHAS.

Abstract

This technical report aims to optimize the production and resource management of a microenterprise specialized in handcrafted saltenhas, located in Campo Grande, Mato Grosso do Sul, Brazil. To this end, concepts from Operations Research were applied. Through the use of the Simplex Method and the Solver tool in Microsoft Excel, a Linear Programming model was developed with the objective of maximizing total sales revenue and minimizing waste, considering constraints related to production capacity, input availability, and demand forecasting. A numerical application was carried out using real data from gastronomic fairs held in the city of Campo Grande, Mato Grosso do Sul, allowing for the development of a model that reflects the operational reality of the microenterprise. Based on this information, sales projections for the month of May were elaborated, resulting in an optimized production strategy. The results demonstrate the effectiveness of mathematical modeling as a decision-support tool for small businesses, contributing to increased profitability, waste reduction, and improved resource allocation.