| Description |
1. Create a Sales contract for 640 x 60 kg bags ( Basis contract with ddiffrential ( basis )= 30 usc/lb , Future month - July 18
that is 38.4 MT.
2. REceive a purchase contract for 38.4 MT.
3. Open Logistics outbound shipment do a outbound shipment .
Select the same contract and select the inventory lot and post it for 640 60 KG bag
4. Do the price fix for the sales contract partially . that means out of 2 lot one lot fixing for 127 usc/lb
5. Set the future settlement price for the selected future month ( July 18) - 123 usc/lb
Hence the calculation of price should be weighted average
(127( fixed price for one lot ) + 123( settlement price for the month ) ) / 2( total number of lots ) + 30( basis value of that same contract from sequence)
127+123)/2 + 30= 155 c/lb is the price that is 3306.93 usd/MT
now the total price should be 3306.93*38.4=126986.1 USD.
But in system it is showing different number
!pastedImage_d97314_0.png!
|