Optimization of net revenue in fruit wholesale distribution through a linear programming model

This report addresses the problem of daily net revenue maximization in a fruit wholesale company. For this purpose, a linear programming model has been formulated whose objective function is the maximization of the net daily revenue of the company, which considers certain restrictions required by the business owner, such as an average size of the jabs of the fruits sold, storage capacity, prices of the different suppliers, among others. The calculation of the optimal solution of the model was carried out using computer programs such as LINGO, in addition to a comparison with the SOLVER function of Microsoft Excel. Subsequently, a sensitivity analysis of the model created is performed to evaluate the impact of variations in the restrictions within the objective function. Finally, the maximum daily net income that the company can achieve under the established conditions is determined, in addition to decision-making, together with a sales plan, supported by the results of the proposed model. The results of this study provide a strategic tool for maximizing revenue in operationally constrained business environments, demonstrating the potential of linear programming to optimize decision-making in wholesale companies.