Solver como herramienta para la toma de decisiones financieras en las empresas atuneras, Manta.

Abstract

The present work analyzes the implementation of the solver, Microsoft Excel tool, for financial decision-making in tuna companies in the city of Manta. This particular sector is fundamental to the local economy, facing complex challenges that require advanced solutions to optimize resources, model financial scenarios and improve decision-making accuracy. The research used a quantitative approach through surveys applied to financial directors of 16 tuna companies, evaluating the acceptance and effectiveness of the solver in three dimensions; scenario modeling, resource optimization and speed in decision-making. The results showed a low acceptance of solver due to a lack of technical training and appreciation of complexity, with 56.3% of respondents disagreeing with its overall benefit. The correlation between the use of the solver and the improvement of financial decisions was moderate but not significant. The proposal included training workshops, implementation of pilot projects and technological improvements, seeking to overcome obstacles such as the lack of knowledge and resources. It was concluded that the solver, although it has a high potential to optimize financial processes, its effective application requires training, adequate infrastructure and strategies that demonstrate its real benefits in a competitive environment.