How to Calculate the Cost of Delivery of Your Product

20
8864
Excel Spreadsheets

Why calculate: freight is one of the items that most add cost to the final price of a product. In Brazil, with the territorial extension that we have, it is difficult to proceed with success in the enterprise, if this factor is forgotten. If you have a trade or small industry, you need to have the real notion of how to form the price of a product. Doing only the calculations of purchase price, profit margin, production and forgetting to put in the amount the final cost forecasts with the delivery of the product can cause imbalance in your accounts.

The result is that often the advertised price increases after the delivery calculation, depending on the location. To make your product more attractive and avoid confusion for your customers, it is important to know how to calculate the cost of delivery of your products.

How to calculate: there are many factors to take into account when choosing a delivery medium. First, on how many days will your company deliver in an ordinary month, as in the example below.

company data

The next decision is whether you will opt for an outsourced service or make deliveries with your own vehicle. Are we going to know the procedures for each of these cases?

1. Deliveries by third parties

Some forms of delivery have different geographical restrictions. For example, motoboy companies deliver in their region and Sedex to all Brazil. In this case, you need to create a spreadsheet for each geographic scope. The data to be collected are mainly:

  • Who would be the suppliers;
  • What type of cost is involved (if it is per delivery or per period);
  • Maximum delivery capacity;
  • Final value per month, for the need you have.

2. Own vehicle

If you are thinking of making the decision to own vehicles, add the driver's salary and benefits to the average monthly cost of the form of delivery. Do not forget to compute expenses like IPVA, insurance and fuel in your average monthly cost. Add tolls and ICMS if necessary. If you have to pay some help for the service, do the same process by adding the value of the remuneration to the price, dividing by the volume to be delivered. This is an extremely important factor in determining if it is not worth using the services of the Courier, or even hire companies specialized in freight, which already have expertise in the field, with management tools to reduce costs through the greater volume they carry .

3. How to analyze

Once you have made the specific calculations for each option, gather them in a spreadsheet, filling each field as in the example below.

delivery record

With this data, you can project costs in a variable way, considering daily, monthly or delivery figures.

variable delivery cost

With the monthly amount, make a projection for the coming years. It is a way of realizing if an option that at first seems more expensive can compensate in the medium or long term. In our example, deliveries with your own car would be worth it from the 11˚ month.

long term cost

A spreadsheet like this can help a lot to figure out the cost of delivering your product and evaluate the best option for your e-commerce, commerce or small industry. How about using the delivery cost worksheet from light? It may be a faster way to make this important decision!

Excel Spreadsheets

20 COMMENTS

  1. And there Rafael Blz. I have some new projects here in the company, your article helped me a lot. Thanks and Congratulations on the blog.

  2. Let's put it on the air again this week and get in touch with the link

  3. I also found this worksheet useful for anyone who has a motoboy company. We work here in the region of São Paulo and we have many exporadic deliveries ... .util, success!

  4. Hi Renato, it will depend on which worksheet you use to calculate the value of your products. In general, just add the value of freight in the costs of the product if this is what you want to do.

    It is worth saying that many businesses do not put the value of freight in the price of the product and charge it at the time of purchase, so the value of the product is no longer "expensive" in the view of the consumer and he knows what is the price of the product and what and freight.

  5. How do I calculate and embed the freight value in my products?
    I have a small industry and I want to offer CIF freight, I already have a carrier under negotiation, they serve all of Brazil.

LEAVE AN ANSWER

Please, write your comment
Please enter your name