Canned Goods — Product Movements
Per-product stock movements for the period.
| Code | Barcode | Description | Size | Opening Stock | Purchases | IBT | IDT | Sales (at cost) | Adjustments | Waste | Shrinkage | Closing Stock |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| P100000 | 600100000000 | White Bread 700g | 700g | 1,175 | 2,807 | 11 | 6 | (3,024) | (24) | (12) | (19) | 920 |
| P100037 | 600100000031 | Brown Bread 700g | 700g | 3,185 | 7,608 | 31 | 15 | (8,195) | (65) | (32) | (53) | 2,494 |
| P100074 | 600100000062 | UHT Milk 1L | 1L | 6,175 | 14,748 | 60 | 30 | (15,887) | (126) | (63) | (102) | 4,835 |
| P100111 | 600100000093 | Fresh Milk 2L | 2L | 10,144 | 24,228 | 98 | 49 | (26,099) | (207) | (103) | (167) | 7,943 |
| P100148 | 600100000124 | Butter 500g | 500g | 15,093 | 36,047 | 147 | 73 | (38,831) | (308) | (154) | (249) | 11,818 |
| P100185 | 600100000155 | Cheddar Cheese 800g | 800g | 21,021 | 50,206 | 204 | 102 | (54,084) | (429) | (214) | (347) | 16,460 |
| P100222 | 600100000186 | Eggs Large 18s | 18s | 27,929 | 66,705 | 271 | 136 | (71,857) | (569) | (285) | (461) | 21,869 |
| P100259 | 600100000217 | Bananas /kg | /kg | 35,817 | 85,543 | 348 | 174 | (92,151) | (730) | (365) | (591) | 28,045 |
| P100296 | 600100000248 | Tomatoes /kg | /kg | 44,684 | 106,721 | 434 | 217 | (114,964) | (911) | (456) | (738) | 34,988 |
| P100333 | 600100000279 | Onions 2kg | 2kg | 54,531 | 130,239 | 529 | 265 | (140,298) | (1,112) | (556) | (900) | 42,698 |
| P100370 | 600100000310 | Apples Pink Lady 1.5kg | 1.5kg | 65,357 | 156,096 | 635 | 317 | (168,153) | (1,333) | (666) | (1,079) | 51,175 |
| P100407 | 600100000341 | Potatoes 7kg | 7kg | 10,283 | 24,559 | 100 | 50 | (26,456) | (210) | (105) | (170) | 8,052 |
| Total | 295,396 | 705,509 | 2,868 | 1,434 | (760,000) | (6,023) | (3,011) | (4,875) | 231,298 | |||