Average Unit Cost Difference
This is ending cost of one item from 01jan24 to 31dec24.
We have a requirement to find how the ending cost 380.81442 generated.
We aware the cost updated due to Purchase orders and LCM adjustments.
PO | Transaction Date | Item Price USD | Item Price AED | Added Qunatity | Estimated landed cost | Actual Cost | Shipment number | Invoice value | AIR Freight charges | Courier Freight charges | Customs BME | DO charges-Delivery Order | MOH Import Clearance Permit | MOH Import First Permit | Other Charges (If Any) | Storage_Charges | Truck renting for shipments | LCM Value | LCM Unit cost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16700822 | 10-Jan-24 | 100.00 | 367.00 | 5.00 | 1,954.51 | 390.90 | 2284 | 1,836.50 | - | - | 104.56 | 5.03 | 20.65 | 0.61 | 0.93 | 1.42 | 1.29 | 1970.98 | 394.19666 |
16700832 | 10-Jan-24 | 100.00 | 367.00 | 4.00 | 1,563.61 | 390.90 | 2284 | 1469.2 | - | - | 83.65 | 4.02 | 16.52 | 0.49 | 0.74 | 1.14 | 1.03 | 1576.79 | 394.19666 |
16700869 | 25-Apr-24 | 95.00 | 348.94 | 5.00 | 1,856.14 | 371.23 | 2335 | 1744.68 | - | - | 93.08 | 2.04 | 18.53 | 1.14 | 1.72 | 1.02 | - | 1862.19 | 372.43861 |
16700960 | 21-Nov-24 | 100.00 | 367.00 | 1.00 | 390.37 | 390.37 | 2454 | 367.3 | - |