Spreadsheet: 193493d1352847802-formula-to-determine-cost-of-items-sold-on-a-particular-date-costing
Sheet: Data

PLU | Group | Full Description | No. Sold | Unit Price £ | Sales £ | Date | Cost Per Unit | Cost of Items Sold £ | Profit £ | Profit Margin | [NAME]
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 3 | 1.5 | 4.5 | 2012-04-01 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 7 | 1.5 | 10.5 | 2012-04-06 00:00:00
000000000000000002 | Beers | [NAME] | 3 | 1.5 | 4.5 | 2012-04-06 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 4 | 1.5 | 6 | 2012-04-13 00:00:00
000000000000000002 | Beers | [NAME] | 5 | 1.5 | 7.5 | 2012-04-13 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 2 | 1.5 | 3 | 2012-04-14 00:00:00
000000000000000002 | Beers | [NAME] | 4 | 1.5 | 6 | 2012-04-14 00:00:00
000000000000000003 | Beers | Boddingtons 440ml | 2 | 1.5 | 3 | 2012-04-14 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 5 | 1.5 | 7.5 | 2012-04-20 00:00:00
000000000000000002 | Beers | [NAME] | 5 | 1.5 | 7.5 | 2012-04-20 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 23 | 1.5 | 34.5 | 2012-04-21 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 15 | 1.5 | 22.5 | 2012-04-27 00:00:00
000000000000000002 | Beers | [NAME] | 7 | 1.5 | 10.5 | 2012-04-27 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 8 | 1.5 | 12 | 2012-04-28 00:00:00
000000000000000003 | Beers | Boddingtons 440ml | 9 | 1.5 | 13.5 | 2012-04-28 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 4 | 1.5 | 6 | 2012-05-04 00:00:00
000000000000000002 | Beers | [NAME] | 4 | 1.5 | 6 | 2012-05-04 00:00:00
000000000000000003 | Beers | Boddingtons 440ml | 3 | 1.5 | 4.5 | 2012-05-05 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 3 | 1.5 | 4.5 | 2012-05-11 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 2 | 1.5 | 3 | 2012-05-18 00:00:00
000000000000000002 | Beers | [NAME] | 4 | 1.5 | 6 | 2012-05-18 00:00:00
000000000000000003 | Beers | Boddingtons 440ml | 3 | 1.5 | 4.5 | 2012-05-20 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 8 | 1.5 | 12 | 2012-05-25 00:00:00
000000000000000002 | Beers | [NAME] | 8 | 1.5 | 12 | 2012-05-25 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 6 | 1.5 | 9 | 2012-05-27 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 1 | 1.5 | 1.5 | 2012-06-01 00:00:00
000000000000000002 | Beers | [NAME] | 4 | 1.5 | 6 | 2012-06-01 00:00:00
000000000000000003 | Beers | Boddingtons 440ml | 1 | 1.5 | 1.5 | 2012-06-03 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 12 | 1.5 | 18 | 2012-06-08 00:00:00
000000000000000002 | Beers | [NAME] | 4 | 1.5 | 6 | 2012-06-08 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 2 | 1.5 | 3 | 2012-06-10 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 1 | 1.5 | 1.5 | 2012-06-15 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 4 | 1.5 | 6 | 2012-06-22 00:00:00
000000000000000002 | Beers | [NAME] | 2 | 1.5 | 3 | 2012-06-23 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 4 | 1.5 | 6 | 2012-06-30 00:00:00
000000000000000002 | Beers | [NAME] | 1 | 1.5 | 1.5 | 2012-06-30 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 5 | 1.5 | 7.5 | 2012-07-06 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 19 | 1.5 | 28.5 | 2012-07-07 00:00:00
000000000000000002 | Beers | [NAME] | 9 | 1.5 | 13.5 | 2012-07-07 00:00:00
000000000000000003 | Beers | Boddingtons 440ml | 2 | 1.5 | 3 | 2012-07-07 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 1 | 1.5 | 1.5 | 2012-07-13 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 2 | 1.5 | 3 | 2012-07-20 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 2 | 1.5 | 3 | 2012-07-21 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 13 | 1.5 | 19.5 | 2012-07-27 00:00:00
000000000000000002 | Beers | [NAME] | 6 | 1.5 | 9 | 2012-07-27 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 4 | 1.5 | 6 | 2012-08-03 00:00:00
000000000000000002 | Beers | [NAME] | 3 | 1.5 | 4.5 | 2012-08-03 00:00:00
000000000000000003 | Beers | Boddingtons 440ml | 1 | 1.5 | 1.5 | 2012-08-03 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 3 | 1.5 | 4.5 | 2012-08-10 00:00:00
000000000000000002 | Beers | [NAME] | 3 | 1.5 | 4.5 | 2012-08-10 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 3 | 1.5 | 4.5 | 2012-08-17 00:00:00
000000000000000002 | Beers | [NAME] | 5 | 1.5 | 7.5 | 2012-08-17 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 4 | 1.5 | 6 | 2012-08-24 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 9 | 1.5 | 13.5 | 2012-08-31 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 2 | 1.5 | 3 | 2012-09-01 00:00:00
000000000000000002 | Beers | [NAME] | 2 | 1.5 | 3 | 2012-09-01 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 9 | 1.5 | 13.5 | 2012-09-07 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 11 | 1.5 | 16.5 | 2012-09-14 00:00:00
000000000000000002 | Beers | [NAME] | 5 | 1.5 | 7.5 | 2012-09-14 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 4 | 1.5 | 6 | 2012-09-21 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 1 | 1.5 | 1.5 | 2012-09-23 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 6 | 1.5 | 9 | 2012-09-28 00:00:00
000000000000000001 | Beers | [NAME] Extra Smooth 440ml | 3 | 1.5 | 4.5 | 2012-09-29 00:00:00
000000000000000002 | Beers | [NAME] | 19 | 1.5 | 28.5 | 2012-09-29 00:00:00