Spreadsheet: 185149d1349524640-2-references-to-match-and-return-an-exact-value-db-cust-n-quote
Sheet: ExWork DB

Quotation DB |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
Customer Name |  | COTEL PRECISION | COTEL PRECISION | Cotel Shanghai | Cotel ShenZhen | Sin Hai Huap | Cotel
Reference |  | SE7552525 | SE7552526 | SE7552527 | SE7552528 | SE7552529 | SE7552530 | SE7552531 | SE7552532 | SE7552533 | SE7552534 | SE7552535 | SE7552536 | SE7552537 | SE7552538 | SE7552539 | SE7552540 | SE7552541
1 | Ocean Freight
2 | THC | As per receipt | As per receipt |  |  | As per receipt
3 | EDI/ IID | As per receipt | As per receipt |  |  | As per receipt
4 | BL/DO | As per receipt | As per receipt |  |  | As per receipt
5 | Seal | As per receipt | As per receipt |  |  | As per receipt
6 | Agency Fee | As per receipt | As per receipt |  |  | As per receipt
7 | CRM | As per receipt | As per receipt |  |  | As per receipt
8 | Telex Release | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt
9 | Other Charges - From Carrier | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt
10 | Forwarding Fee - FCL | 220 | 180 |  |  | Quoted by [NAME]
11 | Forwarding Fee - LCL | 200 | 180 |  |  | Quoted by [NAME]
12 | Part of Shipment | 30 | 30 |  |  | Quoted by [NAME]
13 | Transhipment | 30 | 30 |  |  | Quoted by [NAME]
14 | [NAME] | 30 | 30 |  |  | Quoted by [NAME]
15 | Examination | RM100- [NAME] | 30 |  |  | Quoted by [NAME]
16 | [NAME] | 30 | 30 |  |  | Quoted by [NAME]
17 | Duty Drawback | 50 | 30 |  |  | Quoted by [NAME]
18 | Westport Drayage - 20 | 90 | 90 |  |  | 90
19 | Westport Drayage - 40 | 150 | 130 |  |  | 150
20 | Westport Un/Stuffing -20 | 195 | 265 |  |  | TBA
21 | Westport Un/Stuffing -40 | 295 | 380 |  |  | 700
22 | Positioning (W2W) 20' | 135 | 205 |  |  | 150
23 | Positioning (W2N) 20' | 205 | 205 |  |  | 210
24 | Positioning (W2W) 40' | 135 | 205 |  |  | 150
25 | Positioning (W2N) 40' | 205 | 205 |  |  | 210
26 | Heavy Lifting | 150 | 105 |  |  | -
27 | [NAME] | 300 | 300 |  |  | -
28 | Northport De/Stuffing -20 | 350 | 350 |  |  | -
29 | [NAME] | 580 | 580 |  |  | 750
30 | Positioning (N2N) 20' | 205 | 210 |  |  | -
31 | Positioning (N2W) 20' | 250 | 250 |  |  | -
32 | Positioning (N2N) 40' | 205 | 210 |  |  | 220
33 | Positioning (N2W) 40' | 250 | 250 |  |  | 250
34 | Heavy Lifting | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt
35 | [NAME] | 300 | 300 |  |  | 700
36 | 1 Tonner | 220 | 20
37 | 3 Tonners | 250 | 20
38 | 5/8 Tonners | 340 | 20
39 | 10 Tonners | 400 | 20
40 | 20 Tonners | 450 | 20
41 | Labour - Lorry Hired | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt | As per receipt
42 | Overtime (Min 2hrs) | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
43 | Overtime on Sunday | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
44 | Haulage | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff
45 | Side Loader | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff | AMH Tariff
46 | Depot Gate Charges | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25
47 | Marine Insurance | NIL | 0.0035