Implantação de planilha de custos de transporte graneleiro

Abstract

It is proposed to present a transport cost sheet for the purposes of implementing a cost methodology of mechanic + cart form costs for the monthly total costs, as well as the Bootstrap numerical simulation demonstration, the averages of Costs and to use the least squares polynomial regression to follow the evolution of the average cost to determine the economic life of the asset when this is its minimum. The method for obtaining the spreadsheet was prepared for a historical series of cost elements and their values. Based on them, we used the numerical simulation method Bootstrap to determine a cost medium and by the numerical simulation of Monte Carlo and statistical method of polynomial regression by the criterion of least squares to verify if a mean cost curve reaching its minimum. The result for a successful implementation of the full cost spreadsheet and an introduction of numerical simulation and polynomial regression calculation methodology. The conclusion is that the company can safely expand its field of non-road transportation activities in the state of Mato Grosso.