Spreadsheet: 676679d1588933753-count-unique-value-from-a-date-range-with-multiple-criteria-audit-sheet
Sheet: Audit Sheet

Monthly Plan Summary - 2020
[NAME]
Updated -16th April 2020 |  | 2020-04-01 00:00:00 |  |  |  |  |  |  | May |  |  |  |  |  |  | June |  |  |  |  |  |  | July |  |  |  |  |  |  | August |  |  |  |  |  |  | September |  |  |  |  |  |  | October |  |  |  |  |  |  | Remarks
Factory | Plan MC | Buyer | No of style | Qty: | FOB | CM | Revenue (TK) | Open Capacity  (M/C) | Buyer | No of style | Qty: | FOB | CM | Revenue (TK) | Open Capacity  (M/C) | Buyer | No of style | Qty: | FOB | CM | Revenue (TK) | Open Capacity  (M/C) | Buyer | No of style | Qty: | FOB | CM | Revenue (TK) | Open Capacity  (M/C) | Buyer | No of style | Qty: | FOB | CM | Revenue (TK) | Open Capacity  (M/C) | Buyer | No of style | Qty: | FOB | CM | Revenue (TK) | Open Capacity  (M/C) | Buyer | No of style | Qty: | FOB | CM | Revenue (TK) | Open Capacity  (M/C)
ACCL-2 | 320 | George |  | 222102 | 562096.6799999998 | 141261.19 |  | No open capacity | George | 12 | 524457 | 1399809.79 | 342876.5383333333 |  | No open capacity | George | 13 | 323132 | 755497.0700000001 | 207609.472 |  | No open capacity | George | 8 | 249588 | 589448.1000000001 | 158927.3712 |  | open capacity 90 m/c | George | 1 | 10008 | 26521.2 | 8340 |  | Loading in progress | George | 2 | 40080 | 88777.19999999998 | 17535 |  | Loading in progress | George |  |  |  |  |  | Loading in progress | Runnig machine capacity at Marina has reduced to 240 since recruitment has stopped. CM values are not fully updated for May and onwards.
 |  | Dunnes |  |  |  |  |  |  | Dunnes |  |  |  |  |  |  | Dunnes | 2 | 14782 | 26894.5 | 11865.5 |  |  | Dunnes | 2 | 10250 | 36387.5 | 13427.5 |  |  | Dunnes |  |  |  |  |  |  | Dunnes |  |  |  |  |  |  | Dunnes
 |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada
 |  | Morrisons |  | 16952 | 53284.63999999999 | 10644 |  |  | Morrisons | 2 | 19076 | 81845.52 | 16425.25 |  |  | Morrisons | 3 | 10514 | 52797.48 | 12036.38 |  |  | Morrisons | 1 | 380 | 3078 | 429.4 |  |  | Morrisons | 2 | 11994 | 62153.78 | 18296.4 |  |  | Morrisons | 1 | 4326 | 27297.06 | 4326 |  |  | Morrisons
S.TTL |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 290 |  |  |  |  |  |  | 310 |  |  |  |  |  |  | 320
ALP | 220 | George | 11 | 45220 | 192450.4 | 47773.17 |  | No open capacity | George | 14 | 277880 | 662595.4 | 249345.35 |  | No open capacity | George | 18 | 473928 | 1095595.35 | 281529.6150000001 |  | No open capacity | George | 13 | 173690 | 366723.48 | 104193.67 |  | open capacity 40 m/c | George | 6 | 19756 | 48661.94 | 13734.86166666667 |  | Loading in progress | George | 1 | 30504 | 50789.16 | 167772 |  | Loading in progress | George |  |  |  |  |  | Loading in progress
 |  | Dunnes |  |  |  |  |  |  | Dunnes |  |  |  |  |  |  | Dunnes | 5 | 78817 | 93461.2 | 44585.09916666666 |  |  | Dunnes | 6 | 60824 | 140557.9 | 48823.18833333333 |  |  | Dunnes | 4 | 50443 | 92993.95 | 32913.7175 |  |  | Dunnes | 2 | 17494 | 13204.6 | 8597.6 |  |  | Dunnes
 |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada
 |  | Morrisons | 1 | 5110 | 12519.5 | 17374 |  |  | Morrisons | 1 | 7452 | 33407.4 | 21275.88 |  |  | Morrisons | 1 | 4202 | 16808 | 4202 |  |  | Morrisons | 1 | 6208 | 46560 | 45566.72 |  |  | Morrisons |  |  |  |  |  |  | Morrisons |  |  |  |  |  |  | Morrisons
 |  | GAP |  |  |  |  |  |  | GAP |  |  |  |  |  |  | GAP |  |  |  |  |  |  | GAP |  |  |  |  |  |  | GAP |  |  |  |  |  |  | GAP |  |  |  |  |  |  | GAP
S.TTL |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 200 |  |  |  |  |  |  | 245 |  |  |  |  |  |  | 265
MARINA | 220 | George | 5 | 66597 | 252776.13 | 40237.26666666667 |  | No open capacity | George | 9 | 255854 | 591353.1999999998 | 257106.1131333332 |  | No open capacity | George | 10 | 262866 | 601925.6999999998 | 135864.6633333333 |  | No open capacity | George | 4 | 50236 | 133980.4 | 31521.28 |  | open capacity 85m/c | George | 2 | 29016 | 51793.56 | 13347.36 |  | Loading in progress | George | 1 | 110040 | 166710.6 | 60522 |  | Loading in progress | George |  |  |  |  |  | Loading in progress
 |  | Dunnes |  |  |  |  |  |  | Dunnes | 1 | 24000 | 52800.00000000001 | 18480 |  |  | Dunnes | 1 | 16992 | 37400 | 13083.84 |  |  | Dunnes | 2 | 28520 | 77178.4 | 35780.83166666667 |  |  | Dunnes | 2 | 14713 | 40452.89999999999 | 19402.75 |  |  | Dunnes | 1 | 2000 | 4200 | 1600 |  |  | Dunnes
 |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada
 |  | Morrisons | 6 | 15234 | 57150.5 | 31665.6 |  |  | Morrisons | 5 | 59118 | 158762.37 | 37898.85333333333 |  |  | Morrisons | 5 | 35016 | 106310.76 | 28595.4 |  |  | Morrisons | 3 | 18250 | 50333.34 | 13170.18 |  |  | Morrisons | 2 | 25698 | 93427.35999999999 | 30686.87 |  |  | Morrisons | 1 | 18152 | 67162.4 | 12101.33333333333 |  |  | Morrisons
 |  | GAP |  |  |  |  |  |  | GAP |  |  |  |  |  |  | GAP |  |  |  |  |  |  | GAP |  |  |  |  |  |  | GAP |  |  |  |  |  |  | GAP |  |  |  |  |  |  | GAP
S.TTL |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 175 |  |  |  |  |  |  | 240 |  |  |  |  |  |  | 245
NKK | 120 | George | 3 | 11810 | 31654.5 | 9586.821666666667 |  | No open capacity | George | 3 | 169804 | 318703.2 | 62132.35333333333 |  | No open capacity | George | 3 | 247332 | 536730.9000000001 | 117877.95 |  | No open capacity | George | 3 | 107870 | 234799.8 | 51344.93666666667 |  | open capacity  35 m/c | George |  |  |  |  |  | Loading in progress | George |  |  |  |  |  | Loading in progress | George |  |  |  |  |  | Loading in progress
 |  | Canada |  |  |  |  |  |  | Dunnes | 1 | 15015 | 5755.750000000001 | 5405.4 |  |  | Dunnes |  |  |  |  |  |  | Dunes | 1 | 10004 | 32500 | 17507 |  |  | Dunes | 1 | 6000 | 19500 | 10500 |  |  | Dunnes |  |  |  |  |  |  | Canada
 |  | Morrisons |  |  |  |  |  |  | Morrisons |  |  |  |  |  |  | Morrisons | 1 | 9996 | 30687.72 | 4998 |  |  | Morrisons |  |  |  |  |  |  | Morrisons |  |  |  |  |  |  | Morrisons |  |  |  |  |  |  | Morrisons
S.TTL |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 115 |  |  |  |  |  |  | 90 |  |  |  |  |  |  | 120
SAFFA | 180 | George | 10 | 47936 | 306394.55 | 49736.00833333334 |  | No open capacity | George | 11 | 160267 | 400574.28 | 103721.33 |  | No open capacity | George | 16 | 359069 | 943650.7200000002 | 223052.2575 |  | No open capacity | George | 9 | 218564 | 500090.9600000001 | 139536.6933333333 |  | NO open capacity | George | 6 | 101334 | 353746.04 | 97368.84666666666 |  | Loading in progress | George | 2 | 27968 | 123982.4 | 33124 |  | Loading in progress | George |  |  |  |  |  | Loading in progress
 |  | Dunnes |  |  |  |  |  |  | Dunnes | 1 | 20000 | 48300 | 9150 |  |  | Dunnes | 3 | 28513 | 60056.4 | 36734.24000000001 |  |  | Dunnes | 2 | 19033 | 46072.60000000001 | 18901.125 |  |  | Dunnes | 3 | 37297 | 101543.8 | 47411.45833333333 |  |  | Dunnes | 2 | 9010 | 23733 | 9305 |  |  | Dunnes
 |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada
 |  | Morrisons | 5 | 29282 | 86104.78 | 17491.73333333333 |  |  | Morrisons | 12 | 88528 | 237257.8 | 57304.02666666666 |  |  | Morrisons | 8 | 51302 | 178299.72 | 39443.13 |  |  | Morrisons | 3 | 17636 | 57825.3 | 15132.33333333333 |  |  | Morrisons | 2 | 17010 | 84186 | 23760 |  |  | Morrisons | 2 | 12450 | 64185 | 15825 |  |  | Morrisons
S.TTL |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 130 |  |  |  |  |  |  | 180 |  |  |  |  |  |  | 200
ARKAY 2 | 150 | George |  |  |  |  |  | No open capacity | George |  |  |  |  |  | No open capacity | George |  |  |  |  |  | No open capacity | George |  |  |  |  |  | No open capacity 55 m/c | George |  |  |  |  |  | Loading in progress | George |  |  |  |  |  | Loading in progress | George |  |  |  |  |  | Loading in progress
 |  | Dunnes |  |  |  |  |  |  | Dunnes | 2 | 24033 | 55272.60000000001 | 19429.825 |  |  | Dunnes | 2 | 22545 | 51415.2 | 18052.4475 |  |  | Dunnes | 2 | 19258 | 37666.8 | 15486.64166666667 |  |  | Dunnes | 3 | 42036 | 72840.40000000001 | 30412.88333333333 |  |  | Dunnes | 2 | 14750 | 30975 | 11861.45833333334 |  |  | Dunnes
 |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada
 |  | Morrisons | 10 | 105012 | 248605.04 | 62120.41333333334 |  |  | Morrisons | 7 | 63668 | 165487.6 | 39022.46666666667 |  |  | Morrisons | 15 | 146484 | 462950.08 | 112328.0266666667 |  |  | Morrisons | 9 | 80721 | 264637.76 | 53457.895 |  |  | Morrisons | 2 | 17570 | 69794.4 | 25597.25 |  |  | Morrisons | 2 | 20896 | 70650.72 | 17360.33333333333 |  |  | Morrisons
S.TTL |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 |  |  |  |  |  |  | 115 |  |  |  |  |  |  | 150
G.TTL
SUMMARY
Factory | Planned Machine | Buyer | Nos. of Style | Planned Qty: | FOB | Planned CM | Revenue (TK) | Open Capacity (M/C) | Buyer | Nos. of Style | Planned Qty: | FOB | Planned CM | Revenue (TK) | Open Capacity (M/C) | Buyer | Nos. of Style | Planned Qty: | FOB | Planned CM | Revenue (TK) | Open Capacity (M/C) | Buyer | Nos. of Style | Planned Qty: | FOB | Planned CM | Revenue (TK) | Open Capacity (M/C) | Buyer | Nos. of Style | Planned Qty: | FOB | Planned CM | Revenue (TK) | Open Capacity (M/C) | Buyer | Nos. of Style | Planned Qty: | FOB | Planned CM | Revenue (TK) | Open Capacity (M/C) | Buyer | Nos. of Style | Planned Qty: | FOB | Planned CM | Revenue (TK) | Open Capacity (M/C)
ACCL,ALP, MARINA,NKK,SAFA, ARKY 2 |  | George |  |  |  |  |  |  | George |  |  |  |  |  |  | George |  |  |  |  |  |  | George |  |  |  |  |  |  | George |  |  |  |  |  |  | George |  |  |  |  |  |  | George
 |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada |  |  |  |  |  |  | Canada
 |  | Morrisons |  |  |  |  |  |  | Morrisons |  |  |  |  |  |  | Morrisons |  |  |  |  |  |  | Morrisons |  |  |  |  |  |  | Morrisons |  |  |  |  |  |  | Morrisons |  |  |  |  |  |  | Morrisons
 |  | Dunnes |  |  |  |  |  |  | Dunnes |  |  |  |  |  |  | Dunnes |  |  |  |  |  |  | Dunnes |  |  |  |  |  |  | Dunnes |  |  |  |  |  |  | Dunnes |  |  |  |  |  |  | Dunnes
G.TTL
 |  | Particulars | [NAME] | Order Qty % | FOB $ | FOB % | CM $ | CM % | Particulars | [NAME] | Order Qty % | FOB $ | FOB % | CM $ | CM % | Particulars | [NAME] | Order Qty % | FOB $ | FOB % | CM $ | CM % | Particulars | [NAME] | Order Qty % | FOB $ | FOB % | CM $ | CM % | Particulars | [NAME] | Order Qty % | FOB $ | FOB % | CM $ | CM % | Particulars | [NAME] | Order Qty % | FOB $ | FOB % | CM $ | CM % | Particulars | [NAME] | Order Qty % | FOB $ | FOB % | CM $ | CM %
 |  | Total |  | 1 |  | 1 |  | 1 | Total |  | 1 |  | 1 |  | 1 | Total |  | 1 |  | 1 |  | 1 | Total |  | 1 |  | 1 |  | 1 | Total |  | 1 |  | 1 |  | 1 | Total |  | 1 |  | 1 |  | 1 | Total |  | 1 |  | 1 |  | 1
 |  | Own Dept. |  |  |  |  |  |  | Own Dept. |  |  |  |  |  |  | Own Dept. |  |  |  |  |  |  | Own Dept. |  |  |  |  |  |  | Own Dept. |  |  |  |  |  |  | Own Dept. |  |  |  |  |  |  | Own Dept.
 |  | Other Dept. |  |  |  |  |  |  | Other Dept. |  |  |  |  |  |  | Other Dept. |  |  |  |  |  |  | Other Dept. |  |  |  |  |  |  | Other Dept. |  |  |  |  |  |  | Other Dept. |  |  |  |  |  |  | Other Dept.
 |  | Note : Conversion Rate for $1 = BDT 82