will be entered after the goods reach.
Once this date is entered, it will add to the stock in hand. Till then it is "goods in transit"
Clearing & Forwarding Agent's Details
:
Container Send to location / office (will come from location master)
Office:
(will be a drop down from location/ office master - office name)
Destination Port
(will come from location/ office master)
Address, phone, fax, email, ... These details will automatically come once the office is selected.
Pricing Details
Currency
(will come when location is selected)
Total FOB of container:
$
Will come from below table
convert to
Naira
$ FOB x original exchange rate
Freight Charges: :
$
convert to
Naira
$ freight x original exchange rate
Clearing Charges
Naira
(Mitesh will enter)
Total Exp. (FOB + Freight+ clearing)
Niara
(FOB + Freight+ clearing)
Miscelaneous
(loss in transit, other exp ...)
% of
Mitesh will enter
=
Niara
Landing cost total
Naira
Total Exp + Misc
Total landing expense
Naira
Freight + clearing + misc
FORMULA FOR CALCULATING
"ADDED EXCHANGE RATE"
landing exp = x % of FOB (Niara)
8,55,000 = (x/100) * 62,50,000
therefore
8,55,000 = x * 62,500
therefore
x = 8,55,000 / 62,500
therefore
x = 13.68 (round it up to nearest quater on the higher side - .25/ .50/ .75/.00)
therefore
x = 13.75
means
For 100 it is 13.75
For 125 (original exchange rate)
it is how much ?
= (13.75 * 125)
/ 100
=17.1875
(round it to nearest half - .50 / .00 on the higher side)
= 17.50
Added exchange rate
Naira
Exchange rate of Dollar to Naira :
original exchange rate
(Mitesh will enter)
+
Added exchange rate
=
Final Exchange rate
This will be the rate on which the product pricing calculation will be done
Products send in that container
with details (from product master) :
add (on add it will come on right side)
will come from product master
and will allow multiple selection
>> add
<< Remove
Remove
Select the ones to remove
Submit -- on submit it will show on below table
PRODUCT NAME
Packing (this is number of units per carton)
Cartons
Total Qty despatched
FOB($) per unit
Total FOB($) (qty despatched * FOB($) per unit)
per unit cost in Naira
Extra Cost in Naira
total Cost in Naira
Qty arrived at port . By defaukt it will take the same as qty despatched
Qty Loss in transit
(Qty despatched - Qty arrived at port)
This qty will be subtracted from stock in hand and will be shown as loss in transit
Total loss Naira (qty loss in transit * per unit cost in Naira) This will also feature in the profit & loss of goods
Spoons
pcs
will come fromfrom product master
(5*200)1000
1000 x 10 =
10,000
FOB($) per unit * exchange rate
=1420.50
00.00
(per unit cost in naira x qty despatched)
=14,25,000.50
+ extra cost
editable
Eg: 980
(not more than 100)
1000-980
=
20
20 * 1240.50
=
Cups
2,000
20
40,000
20*142.50
= 2850
2850 * 2000
= 57,00,000
200
-
Total
50,000
71,25,000.50
24810
There is a possibility that certain products are directly purchased from the local people of the location. But they will have to add them in the shipping master as the calculation is done as per the shipping master. The product name will come from the product master. But the pricing will not be as per formula. We will give then a field to add the price per unit in "local currency- Naira"
will come from product master
and will allow multiple selection
>> add
<< Remove
Remove
Select the ones to remove
Submit -- on submit it will show on below table
PRODUCT NAME
Total Qty purchased locally
per unit cost in Naira
Extra Cost in Naira
total Cost in Naira
Spoons
1000
will manually enter as no formulas is followed for local purchase
100
00.00
per unit cost in naira x qty purchased)
=1000 x 100
=1,00,000
+ extra cost
Cups
2,000
100
0.00
2000 * 100
= 2,00,000
Total
This can also be added in the above table, with all other fields remaining blank. This table will add in the stock, only it will not follow the pricing formula as trhe goods are purchased at the final location.