Excel calculation formula of automobile transportation freight

Freight of the whole batch of goods (yuan) = ton hour fee (yuan /t)× invoiced weight (t)+ freight of the whole batch of goods (yuan/(t km)) × invoiced weight (t)× invoiced mileage (km)+ other freight charges (yuan).

Customs supervision vehicle is a kind of closed vehicle specially used to transport goods under customs supervision, which is usually called white van. Used to transport goods under customs supervision from one customs supervision area to another. For example, when goods are transported from abroad to ports, they need to be cleared at the customs at the destination, so this kind of "customs supervision" car is needed. This kind of car needs to apply to the customs, and it can only carry goods under customs supervision after it is registered and filed with the customs. After the goods are loaded, the customs officers will lock the truck door (numbered). After arriving at the destination, the local customs will check whether the lock is correct and then unlock it. Generally speaking, it is used to transport goods that need customs supervision, and generally used to transport goods in transit. Vehicles under customs supervision need to be filed at the customs. Each car is equipped with a customs supervision transport manual, commonly known as "big account book", which records the details of the supervised goods in detail. As for the cost, it is usually a little more expensive than ordinary container trucks, but it is unnecessary to transport supervised goods or ordinary goods.