Negative freight costs - example 5
The total freight costs for Load A are USD -25. The total freight costs of load A are increased by USD 100.
| Object level | Object | Original freight costs | Increased freight costs | Increased by |
|---|---|---|---|---|
| 1 | Load A | -25 | 75 | 100 |
| 2 | Shipment 1 | 25 | 58.33 | 33.33 |
| 2 | Shipment 2 | -50 | 16.67 | 66.67 |
| 3 | Shipment 1, line 10 | 25 | 58.33 | 33.33 |
| 3 | Shipment 1, line 20 | 0 | 0 | 0 |
| 3 | Shipment 2, line 10 | -25 | 8.34 | 33.34 |
| 3 | Shipment 2, line 20 | - 25 | 8.33 | 33.33 |
The USD 100 increase of Load A is proportionally distributed among both shipments.
The original freight cost amount for Shipment 1 is USD 25.
To determine the part of the total increase to be allocated to Shipment 1, the original freight costs of Shipment 1 are divided by the added original freight costs of both shipments and multiplied with the total increase for the load:
25 / (25 + 50) * 100 = 33.33
For Shipment 2, the outcome is 50 / (25 +50) * 100 = 66.67
To determine the part of the total increase to be allocated to line 10 of Shipment 1, the original freight costs of line 10 are divided by the total original freight costs of Shipment 1 and multiplied with the total increase for Shipment 1:
25 / (25 + 0) * 33.33 = 33.33
For line 20 of Shipment 1, the outcome is 0: 0 / (25 + 0) * 33.33 = 0.
For shipment line 10 of Shipment 2, the increase is:
25 / (25 + 25) * 66.67 = 33.34
For line 20, the increase is USD 33.33. For the last shipment line of a shipment, the calculation is not performed, but instead the calculated amounts for the other shipment lines is added up and subtracted from the total freight cost increase for the shipment:
66.67 - 33.34 = 33.33