Hi Experts,
I’m currently analyzing the system logic for how estimated costs are calculated and allocated to items in a Transfer Order (TO) scenario. I have a few questions regarding the Cost Category and Apportionment Method behavior, particularly around the use of Volumetric apportionment.
CASE:
I’m working with a voyage (VOY000045) that includes two Transfer Orders and four TO lines, as detailed below:
Sum of Weight = Gross weight x Quantity
Sum of Volume = (Depth x Width x Height) x Quantity
Sum of Volumetric = Sum of Volume / Divisor (with Divisor = 5000)
| Transfer order |
000979 |
000980 |
|
| Item |
PH-LC-0001-STD |
PH-LC-0002-STD |
PH-LC-0002-MVA |
PH-LC-0004-MVA |
|
| Item model group |
STD |
STD |
MVA |
MVA |
|
| Gross weight |
10.00 |
2.2 |
0.10 |
9.5 |
|
| Depth |
5.00 |
3 |
10.00 |
1 |
|
| Width |
10.00 |
2 |
10.00 |
2 |
|
| Height |
2.00 |
2 |
3.00 |
2 |
|
| Cost amount per unit |
10.00 |
8 |
15.52 |
13.5 |
|
| Transfer quantity |
500.00 |
900.00 |
700.00 |
900.00 |
3,000.00 |
| Sum of Weight |
5,000.00 |
1,980.00 |
70.00 |
8,550.00 |
15,600.00 |
| Sum of Volume |
50,000.00 |
10,800.00 |
210,000.00 |
3,600.00 |
274,400.00 |
| Sum of Volumetric |
10.00 |
2.16 |
42.00 |
0.72 |
54.88 |
| Sum of transfer value |
5,000.00 |
7,200.00 |
10,865.72 |
12,150.00 |
35,215.72 |
This is the Cost category - Cost apportionment method combination available (correct me if I've missed something)
| |
|
|
Cost apportionment method |
Link to other cost type |
Cost broken by quantity (auto cost) |
| |
|
|
Percent |
Quantity |
Amount |
Volume |
Weight |
Measurement |
Volumetric |
| |
|
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
| Cost category |
Fixed |
a |
|
a2 |
a3 |
a4 |
a5 |
a6 |
a7 |
|
|
| Pcs. |
b |
|
b2 |
b3 |
b4 |
b5 |
b6 |
b7 |
|
|
| Percent |
c |
c1 |
c2 |
c3 |
c4 |
c5 |
c6 |
c7 |
y |
|
| Rate |
d |
|
d2 |
d3 |
d4 |
d5 |
d6 |
d7 |
|
z |
| Volumetric |
e |
|
e2 |
e3 |
e4 |
e5 |
e6 |
e7 |
|
|
1/ <Volumetric> cost apportionment method (7)
Basically, the cost amount will apport based on the sum of volumetric of each TO line.
For example, I have fixed $1000 of freight, and I want to allocate based on Volumetric (combination a7).
To manually calculate, the formular = Cost amount / Total sum of volumetric x Sum of volumetric of each TO line.
-- For example, item PH-LC-0001-STD: 1000 / 54.88 x 10 = 182.22
It's the same for the method:
- Quantity (devided by Total sum of quantity)
- Amount (devided by Total sum of amount)
- Volume (devided by Total sum of Volume)
- Weight (devided by Total sum of Weight)
- Measurement (I will not mention here)
2/ <Pcs.> Cost category (b)
With the Pcs. category, "cost value" = $1 is for each peace of item. So, in the case, the total cost amount will be: $1 x 3000 = $3000
I choose to allocate the cost based on quantity, the formular = Cost amount / Total sum of quantity x Sum of quantity of each TO line.
3/ <Volumetric> cost category (e)
I expected that when using Cost Category = Volumetric (e) and Apportionment Method = Volumetric, the system would:
- Apply cost based on volumetric units (Volume / 5000)
- If Cost Value = $1, then Total Cost = $1 × 54.88 = $54.88
I try to define the formular: Total cost amount / Total volumetric x Sum of volumetric of the line
- Cost value: $1
- Total weight: 15600 (Cost category Volumetric)
==> Total cost amount = Cost value x Total weight = 15600
- Total volumetric: 54.88 (Cost apportionment method)
-- Item PH-LC-0001-STD: 15600 / 54.88 x 10 = 2842.57
The question is: Why does the Volumetric cost category use Weight (15,600) as the basis for cost value calculation, rather than Volumetric (54.88), even when the apportionment method is set to Volumetric?
This creates an inconsistency between what we expect (“$1 per volumetric unit”) and how the system computes the total cost (“$1 per kg of weight”).
350
Share
Report
All responses (
Answers (
