Spreadsheet: 694235d1599470009-consolodating-date-power-query-product-report-analysis
Sheet: Food

 |  |  |  |  |  |  |  | August
PLU | Menu | COS | Gross Price | Net Price | COS % | Net Profit |  | Amount | Price | Disc | Sales | %  Category | % Total | Profit | +/- Last Month
 | Breakfast |  |  | avg |  |  |  |  |  | ??? |  | 1
XF1 | American Breakfast | 47.9801 | 199 |  |  |  |  | 50 | 175.4 | 40
XF2 | American Breakfast Toastie | 37.297 | 170
XF3 | Ham & Cheese Toastie | 32.74676 | 160
XF4 | Ham Cheese Panini | 39.02154 | 180
XF5 | Pancakes | 24.15 | 150
XF6 | Yogurt & berries | 30.8 | 129
XF45 | [NAME] (hidden)
 | Favorites |  |  | avg |  |  |  | Amount | Price |  | Sales
XF7 | Chicken & Bacon | 22.43155 | 160
XF8 | Ham Cheese Mayo | 29.93251 | 160
XF9 | [NAME] | 21.94486 | 160
XF10 | Vegan Hummus & Beedroot | 21.02382 | 160
XF16 | Copenhagen Hotdog | 29.21633 | 150
XF17 | Chili Cheese Dog | 29.26012 | 150
 | Premium |  |  | avg |  |  |  | Amount | Price |  | Sales
XF11 | Roast Beef & Avocado | 57.56795 | 250
XF12 | [NAME] | 44.1869 | 250
XF13 | Vegan [NAME] | 36.9701 | 200
XF14 | Submarine Supreme | 50.61301 | 250
XF15 | Chili Cheese Steak | 63.5855 | 280
 | Burgers |  |  | avg |  |  |  | Amount | Price |  | Sales
[NAME] | American Moby | 63.53515 | 240
[NAME] | Lucky 13 Burger | 61.87121 | 240
[NAME] | The Black Pearl | 52.5603 | 240
XF21 | Vegan Mexican Burger | 69.82533 | 240
 | Sides |  |  | avg |  |  |  | Amount | Price |  | Sales
XF34 | Premium Cheese Fries | 30.73397 | 150
[NAME] | [NAME] | 63.18 | 220
[NAME] | [NAME] | 95.2 | 300
XF37 | [NAME] | 14.32378 | 99
XF38 | Falafel Balls | 11.83537 | 99
XF39 | French Fries (+2 sauces) | 14.256 | 99
XF39b | French Fries only | 7 | 60
XF40 | Fries n Crispy | 27.49 | 150
[NAME] | Onion Rings | 18.4384 | 129
XF42 | [NAME] | 9.99 | 80
 | Wraps |  |  | avg |  |  |  | Amount | Price |  | Sales
XF22 | Caesar Wrap | 27.7679 | 170
XF23 | [NAME] | 50.26368 | 210
XF24 | [NAME] | 22.26668 | 150
XF25 | Falafel Wrap | 20.31224 | 150
XF26 | chicken Mexi Wrap | 28.15 | 170
XF27 | beef [NAME] | 55.31 | 230
 | Salads |  |  | avg |  |  |  | Amount | Price |  | Sales
XF28 | Caesar Salad | 45.6 | 170
 | Add chicken | 5.6 | 49
XF29 | Falafel Salad | 35.96912 | 170
XF30 | Smoked Salmon Salad | 55.6184 | 240
XF31 | Tomato Salad | 25.02181 | 170
XF32 | [NAME] | 32.76268 | 170
XF33 | [NAME] | 59.56 | 230
 | Desserts |  |  | avg |  |  |  | Amount | Price |  | Sales
XF43 | [NAME] | 17.80842 | 120
[NAME] | Pancake Dessert | 31.21 | 175
PLU | [NAME] | COS | Gross Price | Net Price | COS % | Gross Profit |  | Amount | Price |  | Sales
XTOP1 | Avocado 1/4 | 5.25 | 50 | 46.72897196261682 | 0.11235 | 41.47897196261682
XTOP2 | [NAME]g | 2.878 | 30 | 28.03738317757009 | 0.1026486666666667 | 25.15938317757009
XTOP3 | [NAME] 40g | 3 | 20 | 18.69158878504673 | 0.1605 | 15.69158878504673
XTOP4 | Chopped Parsley | 2.75 | 10 | 9.345794392523365 | 0.29425 | 6.595794392523365
[NAME] | Diced Onion 20g | 1.82 | 10 | 9.345794392523365 | 0.19474 | 7.525794392523364
[NAME] | Falafel Balls 2 pcs | 3.1925 | 40 | 37.38317757009346 | 0.085399375 | 34.19067757009346
XTOP7 | Fried Onion 15g | 3.15 | 15 | 14.01869158878505 | 0.2247 | 10.86869158878505
[NAME] | 1/4 Fried Wrap 2 pcs | 2.725 | 20 | 18.69158878504673 | 0.1457875 | 15.96658878504673
XTOP9 | [NAME] | 2.725 | 15 | 14.01869158878505 | 0.1943833333333334 | 11.29369158878505
XTOP10 | Grisini 1 pc | 3.12 | 10 | 9.345794392523365 | 0.33384 | 6.225794392523365
[NAME] | Guagamole 80g | 11.73645 | 85 | 79.43925233644859 | 0.1477411941176471 | 67.70280233644858
XTOP12 | Marinated Onion 15g | 1.3725 | 15 | 14.01869158878505 | 0.097905 | 12.64619158878505
XTOP13 | Onion Rings 2 pcs | 5.6 | 40 | 37.38317757009346 | 0.1498 | 31.78317757009346
XTOP14 | Peanuts 15g | 0.388 | 20 | 18.69158878504673 | 0.020758 | 18.30358878504673
XTOP15 | Pickled Cucumber 10 pcs | 0.5688 | 15 | 14.01869158878505 | 0.0405744 | 13.44989158878505
XTOP16 | Plucked Parsley | 1.925 | 10 | 9.345794392523365 | 0.205975 | 7.420794392523365
XTOP17 | Plucked Coriander | 1.65 | 10 | 9.345794392523365 | 0.17655 | 7.695794392523364
XTOP18 | Radish 10 Slices | 0.75 | 10 | 9.345794392523365 | 0.08025 | 8.595794392523365
XTOP19 | Raw Sliced Onion 15g | 1.365 | 10 | 9.345794392523365 | 0.146055 | 7.980794392523364
XTOP20 | Red Bell Pepper 40g | 8.4 | 25 | 23.36448598130841 | 0.3595200000000001 | 14.96448598130841
XTOP21 | Semi dry Tomatoes 20g | 7.467 | 55 | 51.4018691588785 | 0.1452670909090909 | 43.93486915887851
XTOP22 | Sliced Jalapeno 30g | 2.0528 | 15 | 14.01869158878505 | 0.1464330666666667 | 11.96589158878505
XTOP23 | Sunflower Sprouts 10g | 2.9332 | 20 | 18.69158878504673 | 0.1569262 | 15.75838878504673
XTOP24 | [NAME] pcs | 1.848 | 15 | 14.01869158878505 | 0.131824 | 12.17069158878505
XTOP25 | Vegan [NAME] 80g | 6.492 | 70 | 65.42056074766354 | 0.09923485714285715 | 58.92856074766355
XTOP26 | [NAME] 1pcs | 5.132 | 15 | 14.01869158878505 | 0.3660826666666667 | 8.886691588785046
XTOP27 | Cucumber 30g | 0.84 | 10 | 9.345794392523365 | 0.08988 | 8.505794392523365
XTOP28 | 2 Pancakes Syrup 1 Lurpak | 7.97 | 70 | 65.42056074766354 | 0.1218271428571429 | 57.45056074766354
XTOP29 | Vegan [NAME]g | 43.735 | 120 | 112.1495327102804 | 0.3899704166666667 | 68.41453271028037
PLU | [NAME]Cheese | COS | Gross Price | Net Price | COS % | Gross Profit |  | Amount | Price |  | Sales
XMFD1 | Bacon Crumble 30g | 10.2941 | 40 | 37.38317757009346 | 0.275367175 | 27.08907757009346
XMFD3 | Beef Patty 100g | 34.11 | 120 | 112.1495327102804 | 0.3041475 | 78.03953271028037
[NAME] | Cheddar Shredded 30g | 3.712 | 55 | 51.4018691588785 | 0.07221527272727273 | 47.6898691588785
XMFD5 | [NAME] 85g | 5.4765 | 70 | 65.42056074766354 | 0.08371221428571429 | 59.94406074766354
XMFD6 | [NAME] pcs | 17.955 | 70 | 65.42056074766354 | 0.274455 | 47.46556074766355
XMFD2 | [NAME] pcs | 10.2941 | 40 | 37.38317757009346 | 0.275367175 | 27.08907757009346
[NAME] | [NAME] pcs | 9.5 | 65 | 60.74766355140186 | 0.1563846153846154 | 51.24766355140186
XMFD7 | Emmentaller 1 slice | 8.3046 | 45 | 42.05607476635514 | 0.1974649333333334 | 33.75147476635514
XMFD8 | Fried Egg 1 pc | 3.6825 | 30 | 28.03738317757009 | 0.1313425 | 24.35488317757009
XMFD9 | Hotdog 1 pc | 17.75 | 60 | 56.07476635514018 | 0.3165416666666667 | 38.32476635514018
XMFD10 | [NAME]g | 34.8975 | 65 | 60.74766355140186 | 0.5744665384615385 | 25.85016355140186
XMFD11 | Roast [NAME]g | 34.271 | 140 | 130.8411214953271 | 0.2619283571428572 | 96.57012149532709
[NAME] | Sliced Ham 2 pcs | 15.88134 | 70 | 65.42056074766354 | 0.2427576257142857 | 49.53922074766354
[NAME] | Smoked Salmon 50g | 29.75 | 130 | 121.4953271028037 | 0.2448653846153846 | 91.74532710280373
PLU | Sauces & Dressing | COS | Gross Price | Net Price | COS % | Gross Profit |  | Amount | Price |  | Sales
[NAME] | Caesar Sauce 40g | 4.9688 | 35
XSD2 | Cheese Sauce 40g | 4.18 | 50
XSD3 | Chili [NAME]g | 4.18 | 35
XSD4 | Choron Mayo 40g | 4.551 | 35
XSD5 | [NAME] 40g | 3.694 | 35
XSD6 | [NAME] 40g | 3.7105 | 35
[NAME] | Ketchup 40g | 3.9565 | 35
XSD8 | Mayo 40g | 2.485 | 35
XSD9 | Remoulade 40g | 3.026 | 35
XSD10 | Lemon Sour Cream 40g | 3.2512 | 35
XSD11 | [NAME] 40g | 4.428 | 35
PLU | Salad | COS | Gross Price | Net Price | COS % | Gross Profit |  | Amount | Price |  | Sales
 | Myo Oak SW | 4.9 | 20
 | Myo Mix Salad SW | 4.4205 | 20
 | Myo Iceberg SW | 2.905 | 20
 | Myo romain SW | 2.905 | 20
 | [NAME] | 9.13 | 55
 | [NAME] | 13.893 | 65
 | [NAME] | 15.4 | 65
 | Myo Romain Salad | 9.13 | 65
PLU | MYO | COS | Gross Price | Net Price | COS % | Gross Profit |  | Amount | Price |  | Sales
MO1 | Make You Own Sw | 6.49 | 45 |  |  |  | price incl. regular/onesize sandwich with salad of choice
MO2 | Make Your Own Salad | 13.893 | 50 |  |  |  | price incl. regular/onesize salad with salad of choice
PLU | [NAME] | COS | Gross Price | Net Price | COS % | Gross Profit |  | Amount | Price |  | Sales
XDEST1 | Vanilla Ice Cream Scoop | 6.38 | 20
XDEST2 | [NAME]g | 1.63 | 30
XDEST3 | Coconut Granola 50g | 5 | 20
XDEST4 | Sliced Banana | 5.14 | 15
XDEST5 | Chocolate Sauce 30g | 5.32 | 20
XDEST6 | Caramel Sauce 30g | 3.17 | 15
PLU | Bread | COS | Gross Price | Net Price | COS % | Gross Profit |  | Amount | Price |  | Sales
BK7 | Regular Panini | 4.5 | 30
BK11 | 2 Slice Ryebread Sw | 5.4 | 30
BK8 | Regular Wrap | 4.5 | 25
BK2 | Regular Burgerbun | 4.5 | 25
BK4 | Regular Ciabatta | 3 | 30
BK10 | 2 Slice Country Loaf Sw | 3.6 | 25
BK5 | Focaccia half | 4 | 35
BK6 | 1 Hotdog Bread | 5.5 | 25
PLU | Pastries & Muffins | COS | Gross Price | Net Price | COS % | Gross Profit |  | Amount | Price |  | Sales
PM1 | Croissant | 7 | 60
PM2 | [NAME] | 8 | 70
PM5 | Muffin | 9 | 60
PLU | Bakery Multipacks | COS | Gross Price | Net Price | COS % | Gross Profit |  | Amount | Price |  | Sales
 | Regular Panini | 4.5 | 30
 | 2 Slice Ryebread Sw | 5.4 | 30
 | Regular Wrap | 4.5 | 25
 | Regular Burgerbun | 4.5 | 25
 | Regular Ciabatta | 3 | 30
 | 2 Slice Country Loaf Sw | 3.6 | 25
 | Regular Focaccia | 4 | 35
 | 1 Hotdog Bread | 5.5 | 25
 | Croissant | 7 | 60
 | [NAME] | 8 | 70
 | Muffin | 9 | 60