How is the Landed cost calculated at ,if i work it out manually

Hello all ,i am trying to arrive at the same Actual landed cost as per the Landed Cost Report… on line 1.R4001.10 instead i arrive at R5079.60 please see below screenshot
image
image

Line 2 below is the same but when i calculate it on excel i am arriving at a different fi
image
gure
image

can anyone advise as to how Epicor Calculates its formula to arrive at the Actual Unit cost

I don’t know the inner workings of the financial side… what money is suppose to go where…

Your excel calculation is:
“Actual Unit Cost” = (ZAR Total Cost + Total Duty Amount + Total Indirect Cost) / Qty

But it appears that Epicor’s calculation is:
“Actual Unit Cost” = (ZAR Total Cost + Total Indirect Cost) / Qty

Epicor is not including the Duty cost in their actual unit cost.

Is this correct… can it be changed… :man_shrugging:

Since both lines have the same (USD) unit cost, the result should be very similar. I believe the slight difference (4,001.09 vs 4,001.1) is just a factor of scale/rounding.

(16,933.92 + 7,072.63) / 6 = 4,001.092

(846,696.24 + 353,634.35) / 300 = 4,001.102

1 Like