Uma modelagem matemática e otimização em VBA para reduzir custos em uma transportadora

Abstract

This work addresses the use of Visual Basic to optimize and eventually reduce fuel costs in a carrier. Optimization here will be a way to minimize expenses and maximize profits. The main expenses in a transport company are tires, IPVA, employee salary, maintenance, and fuel. Spending on fuel accounts for almost 30% of expenses incurred by the transport company, so any savings made on top of this expense generates a large profit in the end. The Visual Basic tool is part of the Excel developer tab, which makes it possible to create forms, macros, etc. In this work, a data entry form was created so that it performs a mathematical modeling based on the data registered by the drivers during the trip, thus generating the result in the return to the company. Using data provided by a driver, it was possible to verify a significant decrease in the amount spent on fuel by the company on a trip. Through this form and the mathematical modeling presented, it can be stated that the fuel expense can be minimized and, consequently, increase the net profits of a transport company.