Calculation of liters to be sold at a gas station to optimize profits using the simplex method for a correct decision- making

Measurements of monthly sales were made from January to June 2021 at a gas station in order to obtain historical information and based on it determine, applying the simplex method for decision making, the correct number of liters of gasoline of the Magna (green) and Premium (red) type and Diesel necessary to obtain a maximum profit based on a budget that the company has. The monthly observations and the calculation were made using the EXCEL software with pre-recorded formulas to apply the simplex method and were developed during the period from July 05 to 09, 2021. This research work takes advantage of the benefits of the simplex method to find and optimize the best cost-benefit relationship and find the maximum possible profit in the sale of gasoline at a given station. The fluctuation in the changes of the gasolines costs in the last three years was considered to carry out the calculations of this investigation.