Spreadsheet: 825541d1681384815-price-list-find-and-highlight-cheapest-product-and-then-compare-suppliers-precedent-material-rates-test-for-practise-1-
Sheet: Master

Thistlebrook Ltd - Material Costs Tracker
Selector
Product Code | [NAME] | SubCat1 | Manufacturer | Supplier | Size | Material | QTY | Cost
CAMETANG25 | Metal | MF | Caseys | Supplier 1 | 1 | 25 x 25 Metal Angle GA2 (3.2)lm | lm | 5.1350376 |  | Highlight the cheapest price for each individual product in a colour
CAMETANG25 | Metal | MF | Caseys | Supplier 2 | 1 | 25 x 25 Metal Angle GA2 (3.2)lm | lm | 6.5733528
CCINSGPR25 | Insulation | Glass Mineral Wool | Craigcork | Supplier 2 | 25 | Acoustic Partition Roll | M2 | 25.6878048
CCINSGPR25 | Insulation | Glass Mineral Wool | Craigcork | Supplier 1 | 25 | Acoustic Partition Roll | M2 | 1.9808376
[NAME] | Insulation | Glass Mineral Wool | Craigcork | Supplier 1 | 50 | Acoustic Partition Roll | M2 | 1.5771
[NAME] | Insulation | Glass Mineral Wool | Craigcork | Supplier 2 | 50 | Acoustic Partition Roll | M2 | 1.2490632
CCINSGPR65 | Insulation | Glass Mineral Wool | Craigcork | Supplier 1 | 65 | Acoustic Partition Roll | M2 | 1.7915856
CCINSGPR65 | Insulation | Glass Mineral Wool | Craigcork | Supplier 2 | 65 | Acoustic Partition Roll | M2 | 1.5013992
CCINSGPR75 | Insulation | Glass Mineral Wool | Craigcork | Supplier 1 | 75 | Acoustic Partition Roll | M2 | 11.228952
CCINSGPR75 | Insulation | Glass Mineral Wool | Craigcork | Supplier 2 | 75 | Acoustic Partition Roll | M2 | 14.1434328
CCINSGPR100 | Insulation | Glass Mineral Wool | Craigcork | Supplier 1 | 100 | Acoustic Partition Roll | M2 | 10.282692
CCINSGPR100 | Insulation | Glass Mineral Wool | Craigcork | Supplier 2 | 100 | Acoustic Partition Roll | M2 | 6.283166400000001
CAFIXSCW35C | Fixings | Screws | Caseys | Supplier 1 | 35 | [NAME] | Box | 9.967272000000001
CAFIXSCW35C | Fixings | Screws | Caseys | Supplier 2 | 35 | [NAME] | Box | 6.5733528
[NAME] | Fixings | Screws | Caseys | Supplier 1 | 45 | [NAME] | Box | 16.71726
[NAME] | Fixings | Screws | Caseys | Supplier 2 | 45 | [NAME] | Box | 29.5359288
CATAPCOR30 | Jointing | Tapes | Caseys | Supplier 1 | 1 | Corner Tape (30m) | Roll | 5.034103200000001
CATAPCOR30 | Jointing | Tapes | Caseys | Supplier 2 | 1 | Corner Tape (30m) | Roll | 5.4
CAPLADWA25 | Plaster | Powders | Caseys | Supplier 1 | 1 | Drywall Adhesive (25kg) | Bag | 8.5
CAPLADWA26 | Plaster | Powders | Caseys | Supplier 2 | 1 | Drywall Adhesive (25kg) | Bag | 6.4598016
CABRDDUP12.5 | Board | Performance Boards | Caseys | Supplier 1 | 12.5 | Duplex | M2 | 10.2322248
CABRDDUP12.5 | Board | Performance Boards | Caseys | Supplier 2 | 12.5 | Duplex | M2 | 7.506996
CABRDDUP15.0 | Board | Performance Boards | Caseys | Supplier 1 | 15 | Duplex | M2 | 17.03268
CAPERDUP15.1 | Board | Performance Boards | Caseys | Supplier 2 | 15 | Duplex | M2 | 44.411136
CAFIRDUP12.5 | Board | Fire Boards | Caseys | Supplier 1 | 12.5 | Duplex Fire | M2 | 9.008395199999999
CAFIRDUP12.5 | Board | Fire Boards | Caseys | Supplier 2 | 12.5 | Duplex Fire | M2 | 10.11
CAFIRDUP15.0 | Board | Fire Boards | Caseys | Supplier 1 | 15 | Duplex Fire | M2 | 6.119147999999999
CAFIRDUP15.0 | Board | Fire Boards | Caseys | Supplier 2 | 15 | Duplex Fire | M2 | 6.4850352
 | Plaster | Powders | Caseys | Supplier 1 | 1 | [NAME] (25kg) | Bag | 7.784565600000001
 | Plaster | Powders | Caseys | Supplier 2 | 1 | [NAME] (25kg) | Bag | 0
 | Plaster | Powders | Caseys | Supplier 1 | 1 | [NAME] (25kg) | Bag | 5.992979999999999
 | Plaster | Powders | Caseys | Supplier 2 | 1 | [NAME] (25kg) | Bag | 8.2513872
 | Jointing | Tapes | Caseys | Supplier 1 | 1 | Thistle Pro Tape FT50 (90m) | Roll | 2.2836408
 | Jointing | Tapes | Caseys | Supplier 2 | 1 | Thistle Pro Tape FT50 (90m) | Roll | 5.324289599999999
 | Board | Standard Board | Caseys | Supplier 1 | 12.5 | Wallboard | M2 | 5.8794288
 | Board | Standard Board | Caseys | Supplier 2 | 12.5 | Wallboard | M2 | 1.450932
 | Board | Standard Board | Caseys | Supplier 1 | 15 | Wallboard | M2 | 1.1481288
 | Board | Standard Board | Caseys | Supplier 2 | 15 | Wallboard | M2 | 1.6654176