Spreadsheet: 477402d1472274938-how-to-count-the-datas-from-multiple-range-procurement-initiatives_pmo-tracker_260816
Sheet: Receipt Details of July

CFB [NAME] Details
Item No | Item Name | QTY | UNIT OF MEASUREMENT | New rate | Landed Cost | Old rate | Diff | Saving Value | Recd week
P12634 | Outer 500 gm Jar 500 | 206 | NO | 22.57 | 4788.9 | 22.68 |  |  | 3rd week of July
P12636 | Outer PVC/Premium Sa | 347 | NO | 22.61 | 8007.3 | 23.29 |  |  | 3rd week of July
P12640 | Outer100 ml Bottle 4 | 319 | NO | 23.85 | 7776.45 | 28.66 |  |  | 3rd week of July
P12694 | [NAME] | 540 | NO | 34.74 | 19145.7 | 38 |  |  | 3rd week of July
P12694 | [NAME] | 254 | NO | 35.75 | 9262.11 | 38 |  |  | 3rd week of July
P12694 | [NAME] | 77 | NO | 35.75 | 2807.81 | 38 |  |  | 3rd week of July
P12694 | [NAME] | 526 | NO | 35.75 | 19180.59 | 38 |  |  | 3rd week of July
P12695 | [NAME] | 1650 | NO | 4.46 | 7506.18 | 4.8 |  |  | 3rd week of July
P12695 | [NAME] | 5326 | NO | 4.75 | 26057.46 | 4.8 |  |  | 3rd week of July
P12695 | [NAME] | 774 | NO | 4.46 | 3521.08 | 4.8 |  |  | 3rd week of July
P12695 | [NAME] | 4500 | NO | 4.46 | 20471.4 | 4.8 |  |  | 3rd week of July
P12695 | [NAME] | 1250 | NO | 4.46 | 5686.5 | 4.8 |  |  | 3rd week of July
P12695 | [NAME] | 1000 | NO | 4.75 | 4892.5 | 4.8 |  |  | 3rd week of July
P12801 | CFB [NAME] | 557 | NO | 17 | 9753.07 | 18.65 |  |  | 3rd week of July
P12801 | CFB [NAME] | 476 | NO | 17 | 8253.84 | 18.65 |  |  | 3rd week of July
P12801 | CFB [NAME] | 1100 | NO | 17 | 19261 | 18.65 |  |  | 3rd week of July
P13542 | Outer for Lip Balm 4 | 200 | NO | 19.39 | 3955.56 | 21.15 |  |  | 3rd week of July
P14179 | [NAME] active Li | 400 | NO | 18.01 | 7353.6 | 21.17 |  |  | 3rd week of July
P15152 | Outer Antitan Facila | 1067 | NO | 14.73 | 16031.25 | 15.17 |  |  | 3rd week of July
P15265 | [NAME] | 360 | NO | 2.65 | 973.08 | 6.5 |  |  | 3rd week of July
P15413 | Outer100 ml Bottle 2 | 1000 | NO | 16.28 | 16615 | 17.8 |  |  | 3rd week of July
P15525 | Inner- 296 x 143x 33 | 2034 | NO | 6.89 | 14428.59 | 7.3 |  |  | 3rd week of July
P15526 | Outer- 307 x 305 x 3 | 710 | NO | 22.77 | 16653.83 | 24.95 |  |  | 3rd week of July
P15526 | Outer- 307 x 305 x 3 | 200 | NO | 22.77 | 4691.22 | 24.95 |  |  | 3rd week of July
P15553 | Outer BFC 100ml + GP | 440 | NO | 20.04 | 8994.92 | 22.1 |  |  | 3rd week of July
P15553 | Outer BFC 100ml + GP | 900 | NO | 20.04 | 18580.05 | 22.1 |  |  | 3rd week of July
P15904 | Outer - Antan bdy Lt | 983 | NO | 30.82 | 30901.98 | 33.15 |  |  | 3rd week of July
P15904 | Outer - Antan bdy Lt | 1000 | NO | 30.82 | 31436.4 | 33.15 |  |  | 3rd week of July
P15904 | Outer - Antan bdy Lt | 500 | NO | 30.82 | 15718.2 | 33.15 |  |  | 3rd week of July
P15904 | Outer - Antan bdy Lt | 550 | NO | 30.82 | 17290.02 | 33.15 |  |  | 3rd week of July
P15904 | Outer - Antan bdy Lt | 780 | NO | 30.82 | 24520.39 | 33.15 |  |  | 3rd week of July
P15904 | Outer - Antan bdy Lt | 600 | NO | 30.82 | 18861.84 | 33.15 |  |  | 3rd week of July
 |  |  |  |  |  |  | Total
Item No | Item Name | QTY | UNIT OF MEASUREMENT | Purchase Price | Landed Cost | Old Rate | Diff | Saving value | Recd Week
P13673 | Bleach Jar with [NAME] | 30000 | NO | 1.79 | 54774 | 2.1 |  |  | 2nd
P13673 | Bleach Jar with [NAME] | 60000 | NO | 1.79 | 109548 | 2.1 |  |  | 2nd
P13673 | Bleach Jar with [NAME] | 30000 | NO | 1.79 | 54774 | 2.1 |  |  | 2nd
P13673 | Bleach Jar with [NAME] | 51000 | NO | 1.79 | 93115.8 | 2.1 |  |  | 3rd
P13673 | Bleach Jar with [NAME] | 30000 | NO | 1.79 | 54774 | 2.1 |  |  | 3rd
P13673 | Bleach Jar with [NAME] | 30000 | NO | 1.79 | 54774 | 2.1 |  |  | 3rd
P13673 | Bleach Jar with [NAME] | 30000 | NO | 1.79 | 54774 | 2.1 |  |  | 3rd
P13673 | Bleach Jar with [NAME] | 30000 | NO | 1.79 | 54774 | 2.1 |  |  | 3rd
P13673 | Bleach Jar with [NAME] | 37500 | NO | 1.79 | 68467.5 | 2.1 |  |  | 3rd
P13673 | Bleach Jar with [NAME] | 51000 | NO | 1.79 | 93115.8 | 2.1 |  |  | 3rd
P13673 | Bleach Jar with [NAME] | 30000 | NO | 1.79 | 54774 | 2.1 |  |  | 3rd
P13673 | Bleach Jar with [NAME] | 60000 | NO | 1.79 | 109548 | 2.1 |  |  | 3rd
P13673 | Bleach Jar with [NAME] | 30000 | NO | 1.79 | 54774 | 2.1 |  |  | 3rd
P13673 | Bleach Jar with [NAME] | 45000 | NO | 1.79 | 82161 | 2.1 |  |  | 3rd
P13673 | Bleach Jar with [NAME] | 30000 | NO | 1.79 | 54774 | 2.1 |  |  | 3rd