Spreadsheet: 883693d1732340404-help-needed-creating-a-comprehensive-spreadsheet-for-managing-a-bar-hotel-accommodation-help-needed
Sheet: Control sheet

Description | Code | Quantity | Wholesale price/unit | Total wholesale price | Retail price/unit | Total retail | Profit/unit | Total profit
Chrome vodka [NAME] | 1 | 10 | 216 |  | 300 |  |  |  |  |  | Drinks with Measured servings:
Chrome vodka 750ml | 2 | 3 | 560 |  | 850
Chrome lmn [NAME] | 3 | 10 | 216 |  | 300 |  |  |  |  |  |  | Price
Chrome lmn 750ml | 4 |  |  |  |  |  |  |  |  |  | County 125ml | 150
Chrome gin [NAME] | 5 | 10 | 216 |  | 300 |  |  |  |  |  | Chrome gin 125ml | 150
Chrome gin 750ml | 6 | 3 | 560 |  | 850 |  |  |  |  |  | Chrome vodka 125ml | 150
County 250ml | 7 | 15 | 245 |  | 300 |  |  |  |  |  | Best patiala 125ml | 100
County 750ml | 8 | 1 | 680 |  | 850 |  |  |  |  |  | Dallas | 100
[NAME] | 9
Gilbeys gin 350ml | 10 | 10 | 576 |  | 750
Gilbeys gin 750ml | 11 | 2 | 1240 |  | 1500 |  |  |  |  |  | Tots:
Richot brandy 250ml | 12 | 2 | 416 |  | 550
[NAME] | 13 | 3 | 576 |  | 800
Richot brandy 750ml | 14 | 1 | 1240 |  | 1500
Best whiskey [NAME] | 15 | 3 | 330 |  | 450 |  |  |  |  |  | Meals
Best whiskey 750ml | 16 |  |  |  |  |  |  |  |  |  | Chips & 1/4 chicken
Best gin [NAME] | 17 | 3 | 270 |  | 400 |  |  |  |  |  | Chips & 1/2 chicken
Best gin 750ml | 18 | 1 | 750 |  | 1000 |  |  |  |  |  | Chips & full chicken
Best patiala [NAME] | 19 | 20 | 130 |  | 200 |  |  |  |  |  | Beef served with ugali
Captain [NAME] | 20 | 3 | 336 |  | 500
Captain [NAME] 350ml | 21 |  |  |  |  |  |  |  |  |  | Rooms
Captain [NAME] 750ml | 22
Hunters 250ml | 23 | 3 | 325 |  | 450
Hunters choice 350ml | 24 | 2 | 460 |  | 650
Hunters choice 750ml | 25 | 1 | 960 |  | 1300
Guarana 330ml | 26 | 6 | 175.125 |  | 250
Sminorf ice black 330ml | 27 | 6 | 175.125 |  | 250
Sminorf ice pineapple 330ml | 28 | 6 | 175.125 |  | 250
Bond 7 whisky 250ml | 29 | 2 | 416 |  | 550
Bond 7 whisky 350ml | 30 | 2 | 576 |  | 800
Bond 7 whisky 750ml | 31 | 1 | 1240 |  | 1500
Sminorf red 250ml | 32 | 2 | 416 |  | 550
Sminorf red 350ml | 33 | 2 | 576 |  | 850
Sminorf red 750ml | 34 | 2 | 1240 |  | 1500
White cap larger | 35 | 8 | 195.52 |  | 250
Tusker lite | 36 | 8 | 186.68 |  | 250
[NAME] | 37 | 10 | 169 |  | 250
Guiness | 38 | 8 | 204.36 |  | 250
Kenya Cane 250ml | 39 | 4 | 267.78 |  | 350
Kenya Cane 350ml | 40
Kenya cane 750ml | 41
[NAME] 69 375ml | 42 | 2 | 760 |  | 1100
[NAME] 69 750ml | 43
Snapp 330ml | 44 | 6 | 175.125 |  | 250
Predator | 45 | 12 | 54.17 |  | 70
Lemonade | 46 | 12 | 41.67 |  | 60
Water 500ml | 47 | 24 | 20.83 |  | 40
Wafari water 1lt | 48 | 12 | 41.67 |  | 70
Dunhill | 49 | 2 | 445 |  | 500
Sportsman | 50 | 2 | 355 |  | 400
[NAME] king | 51 | 2 | 215 |  | 300
4th street | 52
Four cousins | 53
Lime | 54
Redbull | 55
Black & white | 56
White cap | 57
Guiness | 58
Tusker lite | 59
KC 250ml | 60
KC 350ml | 61
KC 750ml | 62
[NAME] | 63
Kibao 250ml | 64
Kibao 350ml | 65
Kibao 750ml | 66
Tripple Ace 250ml | 67
Tripple Ace 350ml | 68
Tripple Ace 750ml | 69
Lime | 70
Dallas | 71
[NAME] meakins 250ml | 72
[NAME] meakins 750ml | 73
Soda | 74
[NAME] | 75
Tusker cider | 76
Tusker Larger | 77
Delmonte | 78
V&A 250ml | 79
V&A 750ml | 80
[NAME] | 81