Spreadsheet: 751521d1634150371-help-to-create-an-order-list-based-on-products-by-cheapest-supplier-price-comparison-test
Sheet: TA PACKAGING

Product | Supplier | Price | Quantity | Unit Price | Date | % change | Order Code | Notes |  | PRODUCT | SUPPLIER | PRICE | ORDER CODE | CHEAPEST PRICE | FROM
10" Greaseproof bag | ABPAC | 16.82 | 1000 |  |  |  | 1234 | Test |  | 10" Greaseproof bag |  |  |  |  |  |  |  |  |  | 12oz compostable d/w cup |  |  |  |  | BAKO
10" Greaseproof bag | BAKO | 16 | 1000 |  |  |  |  |  |  |  | BAKO |  |  |  |  |  |  |  |  | 12oz compostable lid |  |  |  |  | Bonds Packaging
10" Greaseproof bag | Catering 24 | 19.02 | 1000 |  |  |  |  |  |  |  | Bonds Packaging |  |  |  |  |  |  |  |  | 7" Greaseproof bag |  |  |  |  | Catering 24
12oz compostable d/w cup | Catering 24 | 45.54 | 500 |  |  |  |  |  |  |  | Catering 24 |  |  |  |  |  |  |  |  | 8oz compostable d/w cup |  |  |  |  | Enviropack
12oz compostable d/w cup | Next Day Coffee | 43.19 | 500 |  |  |  |  |  |  |  | Cups Direct |  |  |  |  |  |  |  |  | 8oz compostable lid |  |  |  |  | Enviropack 4+
12oz compostable d/w cup | [NAME] | 53.1 | 500 |  |  |  |  |  |  |  | Enviropack |  |  |  |  |  |  |  |  | Nesting Tray |  |  |  |  | Enviropack 5+
12oz compostable lid | Catering 24 | 53.99 | 1000 |  |  |  |  |  |  |  | Enviropack 4+ |  |  |  |  |  |  |  |  | No. 1 [NAME] |  |  |  |  | Next Day Coffee
12oz compostable lid | Next Day Coffee | 29.75 | 500 |  |  |  |  |  |  |  | Enviropack 5+ |  |  |  |  |  |  |  |  | No. 3 [NAME] |  |  |  |  | [NAME]
12oz compostable lid | [NAME] | 54.84 | 1000 |  |  |  |  |  |  |  | Next Day Coffee |  |  |  |  |  |  |  |  | Perforated Film Front [NAME] bag
7" Greaseproof bag | ABPAC | 10.28 | 1000 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | SOS Carrier Bag
7" Greaseproof bag | BAKO | 6.88 | 1000
7" Greaseproof bag | Catering 24 | 9.77 | 1000
8oz compostable d/w cup | Catering 24 | 38.34 | 500
8oz compostable d/w cup | Next Day Coffee | 38.39 | 500
8oz compostable d/w cup | [NAME] | 43.56 | 500 |  |  |  |  |  |  | PRICE HISTORY CHECK
8oz compostable lid | Catering 24 | 59.34 | 1000
8oz compostable lid | Next Day Coffee | 25.19 | 500 |  |  |  |  |  |  | PRODUCT | SUPPLIER | PRICE | DATE CHECK | DIFFERENCE | PRODUCT CODE | NOTES
8oz compostable lid | [NAME] | 45.35 | 1000
Nesting Tray | ABPAC | 32.74 | 500 |  |  |  |  | Too Expensive
Nesting Tray | Bonds Packaging | 21.12 | 220
No. 1 [NAME] | Catering 24 | 56.99 | 450
No. 1 [NAME] | Enviropack | 59.94 | 450
No. 1 [NAME] | Enviropack 4+ | 56.39 | 450
No. 3 [NAME] | Catering 24 | 42.24 | 180
No. 3 [NAME] | Enviropack | 44.34 | 180
No. 3 [NAME] | Enviropack 4+ | 41.99 | 180
Perforated Film Front [NAME] bag | Enviropack | 36.54 | 1000
Perforated Film Front [NAME] bag | Enviropack 5+ | 33.59 | 1000
Perforated Film Front [NAME] bag | Next Day Coffee | 39.59 | 1000 |  |  |  |  |  |  | ORDER LIST BASED BASED ON PRODUCTS BY CHEAPEST SUPPLIER
SOS Carrier Bag | Catering 24 | 21.59 | 250
SOS Carrier Bag | Enviropack | 21.59 | 250 |  |  |  |  |  |  | SUPPLIER | PRODUCTS | PRICE | ORDER CODE
SOS Carrier Bag | Enviropack 5+ | 19.79 | 250 |  |  |  |  |  |  | ABPAC
8oz compostable d/w  cup | Cups Direct | 41.94 | 500
12oz compostable d/w cup | Cups Direct | 51.54 | 500