Spreadsheet: 820809d1678292223-weighted-avg-collection-days-on-fifo-basis-sample-data
Sheet: Sheet1

Date | Customer | [NAME] | Payment Allocated | Outstanding
2022-04-01 00:00:00 | [NAME] | 8920
2022-04-01 00:00:00 | JKSK | 24192
2022-04-01 00:00:00 | Kamal Chand & Brothers - Dinesh Hirawat | 93090.99999999999
2022-04-01 00:00:00 | [NAME] | 4800
2022-04-01 00:00:00 | [NAME] | 3240
2022-04-01 00:00:00 | [NAME] | 4356
2022-04-01 00:00:00 | Cash | 4998
2022-04-01 00:00:00 | Saha Plastic Salar | 35020
2022-04-01 00:00:00 | Bhavani | 2232
2022-04-01 00:00:00 | [NAME] | 2376
2022-04-01 00:00:00 | Umesh Bhai | 7776
2022-04-01 00:00:00 | Santosh | 1512
2022-04-01 00:00:00 | [NAME] | 46824
2022-04-01 00:00:00 | [NAME] | 6720
2022-04-02 00:00:00 | Munshi Plastic | 8064
2022-04-02 00:00:00 | Dada Bhai Plastic Umarpur | 17500
2022-04-02 00:00:00 | [NAME] | 6696
2022-04-02 00:00:00 | [NAME] | 6804
2022-04-02 00:00:00 | Cash | 3510
2022-04-02 00:00:00 | Raja International | 3744
2022-04-02 00:00:00 | Santosh | 1656
2022-04-02 00:00:00 | Saha Plastic Salar | 33858
2022-04-02 00:00:00 | [NAME] | 17000
2022-04-02 00:00:00 | [NAME] | 36700
2022-04-02 00:00:00 | [NAME] | 6048
2022-04-02 00:00:00 | Kamal Chand & Brothers - Dinesh Hirawat | 7130
2022-04-02 00:00:00 | [NAME] | 10450
2022-04-04 00:00:00 | [NAME] | 32250
2022-04-04 00:00:00 | [NAME] | 8370
2022-04-04 00:00:00 | Munshi Plastic | 20304
2022-04-04 00:00:00 | Biswajit Mondal Barasat | 8950
2022-04-04 00:00:00 | [NAME] | 24700
2022-04-04 00:00:00 | [NAME] (Basanti) | 8500
2022-04-04 00:00:00 | [NAME] | 7500
2022-04-04 00:00:00 | Cash | 3444
2022-04-04 00:00:00 | [NAME] | 2304
2022-04-04 00:00:00 | [NAME] | 5400
2022-04-04 00:00:00 | [NAME] | 11016
2022-04-04 00:00:00 | [NAME] | 2826
2022-04-04 00:00:00 | New Raja Store | 3780
2022-04-04 00:00:00 | [NAME] | 6048
2022-04-04 00:00:00 | [NAME] | 6435
2022-04-04 00:00:00 | Kamal Chand & Brothers - Dinesh Hirawat | 19494
2022-04-04 00:00:00 | AK Dhanbad | 10850
2022-04-04 00:00:00 | [NAME] | 9072
2022-04-04 00:00:00 | [NAME] | 7900
2022-04-04 00:00:00 | [NAME] | 54786
2022-04-04 00:00:00 | [NAME] | 25200
2022-04-05 00:00:00 | Afzal Plastic Umarpur | 34020
2022-04-06 00:00:00 | Mantu Da | 15984
2022-04-04 00:00:00 | [NAME] | 9730
2022-04-05 00:00:00 | Umesh Bhai | 10530
2022-04-05 00:00:00 | [NAME] | 1890
2022-04-05 00:00:00 | Munshi Plastic | 12600
2022-04-05 00:00:00 | [NAME] | 14680
2022-04-05 00:00:00 | [NAME] | 4320
2022-04-05 00:00:00 | Cash | 4955
2022-04-05 00:00:00 | BK Enterprises | 4536
2022-04-05 00:00:00 | Santosh | 3204
2022-04-05 00:00:00 | Bhavani | 936
2022-04-05 00:00:00 | [NAME] | 3912
2022-04-05 00:00:00 | [NAME] | 2100
2022-04-05 00:00:00 | [NAME] | 4284
2022-04-05 00:00:00 | BB Raigarh | 26688
2022-04-05 00:00:00 | [NAME] | 16580
2022-04-06 00:00:00 | [NAME] | 2916
2022-04-06 00:00:00 | [NAME] | 14040
2022-04-06 00:00:00 | Cash | 2970
2022-04-06 00:00:00 | [NAME] | 6480
2022-04-06 00:00:00 | Bullet Store | 3384
2022-04-06 00:00:00 | Santosh | 6480
2022-04-06 00:00:00 | [NAME] | 5184
2022-04-06 00:00:00 | JKSK | 12096
2022-04-06 00:00:00 | [NAME] | 33264
2022-04-06 00:00:00 | [NAME] | 2480
2022-04-06 00:00:00 | [NAME] | 1872
2022-04-07 00:00:00 | [NAME] | 3240
2022-04-07 00:00:00 | [NAME] | 4800
2022-04-07 00:00:00 | [NAME] | 3960
2022-04-07 00:00:00 | [NAME] (MKS) | 14692
2022-04-07 00:00:00 | [NAME] | 9732
2022-04-07 00:00:00 | Cash | 4842
2022-04-07 00:00:00 | PK [NAME] | 8720
2022-04-07 00:00:00 | Bhavani | 1452
2022-04-07 00:00:00 | [NAME] | 1674
2022-04-07 00:00:00 | Raja International | 6480
2022-04-07 00:00:00 | Bullet Store | 18000
2022-04-07 00:00:00 | Kamal Chand & Brothers - Dinesh Hirawat | 46384.99999999999
2022-04-07 00:00:00 | [NAME] | 14600
2022-04-08 00:00:00 | [NAME] | 8370
2022-04-08 00:00:00 | [NAME] | 9720
2022-04-08 00:00:00 | [NAME] | 4122
2022-04-08 00:00:00 | [NAME] | 6048
2022-04-08 00:00:00 | Cash | 1026
2022-04-08 00:00:00 | [NAME] | 74352
2022-04-08 00:00:00 | NK Supplier | 3740
2022-04-08 00:00:00 | BK Enterprises | 6264
2022-04-08 00:00:00 | [NAME] | 2808
2022-04-08 00:00:00 | Munshi Plastic | 8064