Bar Inventory Cost Analysis
Bar Inventory Cost Analysis
 0      0        0      0.00%    0.00%
 0      0        0
 0      0        0      0.00%    0.00%
 0      0        0      0.00%    0.00%
 0      0        0      0.00%    0.00%
 0      0        0      0.00%    0.00%
 0      0        0      0.00%    0.00%
0   0   0   0.00%   0.00%
0   0   0   0.00%   0.00%
0   0   0   0.00%   0.00%
0   0   0   0.00%   0.00%
0   0   0   0.00%   0.00%
0   0   0   0.00%   0.00%
0   0   0   0.00%   0.00%
0   0   0   0.00%   0.00%
0   0   0   0.00%   0.00%
0 0 0 0.00% 0.00%
0   0   0   0.00%   0.00%
0   0   0   0.00%   0.00%
0   0   0   0.00%   0.00%
0   0   0   0.00%   0.00%
0   0   0   0.00%   0.00%
0   0   0   0.00%   0.00%
0   0   0   0.00%   0.00%
0   0   0   0.00%   0.00%
0   0   0   0.00%   0.00%
                                     Unit
              Item                            Cost Price   30 ml      Usage   Usage Cost
                                   (ML/GM)
   Lemon Grass - infused Gin            750    142.4475      5.6979
      Bombay Sapphire                   750      137.86
        Lemon Grass                     250      4.5875
     Total Batch Cost
                                              Cost
                                   Cost Price Price
                                   per Pack / per          Total
            Item                   BTL        Gm/ ML Usage Cost
Turmeric & Lemon - infused Vodka             0.17541      60    10.5246
           Triple sec                         0.2925      15    4.3875
          Lemon Juice                        0.009253     15     0.1388
          Sugar Syrup                        0.002268     15    0.03402
              Ice                             0.0045      100     0.45
  Lemon (Garnish) - Dehydrated                0.0694       1    0.0694
                                    Cost
                         Cost Price Price
                         per Pack / per          Total
        Item             BTL        Gm/ ML Usage Cost
   Zonin prosecco Brut             0.09104     150   13.656
       Disaronno                    0.1716     30    5.148
    Strawberry Puree               0.04412     15    0.6618
                                        Cost
                             Cost Price Price
                             per Pack / per          Total
          Item               BTL        Gm/ ML Usage Cost
 Lemon Grass - infused Gin             0.18993      60    11.3958
          Aperol                       0.132657     30    3.97971
       Lemon Juice                     0.009253     15     0.1388
        Sugar Syrup                    0.002268     30    0.06804
            Ice                         0.0045      100     0.45
   Strawberry ( Garnish )                0.42        1     0.42
                                    Cost
                         Cost Price Price
                         per Pack / per          Total
         Item            BTL        Gm/ ML Usage Cost
   Stolichnaya premium             0.172907     60    10.3744
     Pineapple juice               0.00368      30    0.1104
     Cranberry juice               0.00455      30    0.1365
       Grenadine                    0.0441      15    0.6615
      Lemon Juice                  0.009253     15    0.1388
      Orgeat Syrup                  0.063       15     0.945
      Blue Curaçao                  0.2925      30     8.775
           Ice                      0.0045      100    0.45
                                         Cost
                              Cost Price Price
                              per Pack / per          Total
          Item                BTL        Gm/ ML Usage Cost
     Jose Cuervo silver                 0.180187     60    10.8112
        Lemon Juice                     0.009253     15    0.1388
        Grenadine                        0.0441      10     0.441
        Sugar Syrup                     0.002268     10    0.02268
      Grapefruit juice                  0.00568      120    0.6816
        Soda water                      0.005061     90    0.45545
            Ice                          0.0045      100    0.45
   Orange Peel (Garnish)                 0.864        1     0.864
 Green Apple Peel (Garnish)              1.8282       1    1.8282
  Red Apple Peel (Garnish)                 0                  0
                                                Cost
                                     Cost Price Price
                                     per Pack / per          Total
             Item                    BTL        Gm/ ML Usage Cost
   Captain Morgan Dark Rum                      0.156       60     9.36
            Campari                            0.12149      30    3.6447
         Pineapple juice                       0.00368      120    0.4416
          Lemon Juice                          0.009253     15     0.1388
           Sugar Syrup                         0.002268     15    0.03402
               Ice                              0.0045      100    0.45
Pineapple ( Garnish ) - Dehydrated              0.124        1     0.124
                                        Cost
                             Cost Price Price
                             per Pack / per          Total
          Item               BTL        Gm/ ML Usage Cost
  Coffee - infused Bourbon             0.268899     60    16.1339
          Khalua                       0.212667     30     6.38
       Vanilla Syrup                   0.065714     25    1.64286
            Ice                         0.0045      100     0.45
                                          Cost
                               Cost Price Price
                               per Pack / per          Total
          Item                 BTL        Gm/ ML Usage Cost
 Ginger Root - infused Vodka             0.175407     60    10.5244
       Mango Nectar                      0.00455      120    0.546
      Strawberry Syrup                    0.0441      10     0.441
             Ice                          0.0045      100     0.45
      Mango (Garnish)                     #N/A         1
                                        Cost
                             Cost Price Price
                             per Pack / per          Total
          Item               BTL        Gm/ ML Usage Cost
  Orange - infused Whiskey             0.198864     60     11.9318
        Maple Syrup                    0.065714     30     1.97143
         Angostura                      0.3549      2.00   0.7098
       Orange Bitters                   0.5733       2     1.1466
            Ice                         0.0045      100     0.45
      Orange (Garnish)                  0.144        1      0.144
                                        Cost
                             Cost Price Price
                             per Pack / per          Total
          Item               BTL        Gm/ ML Usage Cost
  Johnnie Walker Red Label             0.19656      60    11.7936
       Pomegranate                     0.00167      60    0.1002
        Lemon Juice                    0.009253     15    0.1388
         Disaronno                      0.1716      30    5.148
            Ice                         0.0045      100    0.45
        Sugar Syrup                    0.002268     15    0.03402
                                    Cost
                         Cost Price Price
                         per Pack / per          Total
         Item            BTL        Gm/ ML Usage Cost
   Stolichnaya premium             0.172907     60    10.3744
     Cranberry juice               0.00455      60     0.273
     Roohafza Syrup                0.012188     10    0.12188
      Lemon Juice                  0.009253     15     0.1388
        Triple sec                  0.2925      15     4.3875
           Ice                      0.0045      100    0.45
    Orange (Garnish)                0.144        1     0.144
                                   Cost
                        Cost Price Price
                        per Pack / per          Total
        Item            BTL        Gm/ ML Usage Cost
       JIM Beam                   0.22932      60    13.7592
      Maple Syrup                 0.065714     30    1.97143
       Tea Loose                   0.021        5     0.105
       Fresh Milk                 0.00605      15    0.09075
          Ice                      0.0045      100     0.45
   Rosemary (Garnish)             0.18201       1    0.18201
                                       Cost
                            Cost Price Price
                            per Pack / per          Total
          Item              BTL        Gm/ ML Usage Cost
   Zonin prosecco Brut                0.09104     150    13.656
     Strawberry Puree                 0.04412     30     1.3236
   Strawberry ( Garnish )              0.42       1.00    0.42
                                     Cost
                            Cost Price Price
                            per Pack / per          Total
          Item              BTL        Gm/ ML Usage Cost
   Stolichnaya premium                0.172907      60    10.3744
       Tomato juice                   0.00455      120     0.546
       Lemon Juice                    0.009253      15     0.1388
         Tabasco                         0.15      2.5     0.375
            Salt                      0.00263       3     0.00789
          Pepper                       0.0769       2      0.1538
            Ice                        0.0045      100      0.45
   Worcestershire Sauce                 0.074      2.5     0.185
   Celery Stick (Garnish)              #N/A                #N/A
   Worcestershire Sauce
                            Cocktail Recipe w/ Cost
                                  Cost
                         Cost Price Price
                         per Pack / per          Total
         Item            BTL        Gm/ ML Usage Cost
   Stolichnaya premium             0.172907     60
         Archers                    0.1677      30
     Cranberry juice               0.00455      60
      Orange Juice                 0.00368      60
           Ice                      0.0045
    Orange (Garnish)                0.144
                                   Cost
                          Cost Price Price
                          per Pack / per          Total
         Item             BTL        Gm/ ML Usage Cost
   Bacardi Carta Blanca             0.180187      60
         Malibu                     0.191067      30
     Coconut Cream                  0.01125       30
     Pineapple juice                0.00368      120
       Sugar Syrup                  0.002268      15
           Ice                       0.0045
   Pineapple (Garnish)                #N/A
                                   Cost
                          Cost Price Price
                          per Pack / per          Total
         Item             BTL        Gm/ ML Usage Cost
   Bacardi Carta Blanca             0.180187      60
       Lime Wedge                    #N/A
          Mint                       0.0083
       Lemon Juice                  0.009253      15
       Sugar Syrup                  0.002268      15
       Soda water                   0.005061     330
           Ice                       0.0045
   Mint Leaves (Garnish               #N/A
   Lime Wheel (Garnish)              #N/A
                                Cost
                       Cost Price Price
                       per Pack / per          Total
        Item           BTL        Gm/ ML Usage Cost
       JIM Beam                  0.22932       60
       Angostura                  0.3549
      Lemon Juice                0.009253      30
      Sugar Syrup                0.002268      30
          Ice                     0.0045
    Orange (Garnish)               0.144
                                      Cost
                             Cost Price Price
                             per Pack / per          Total
          Item               BTL        Gm/ ML Usage Cost
  Johnnie Walker Red Label             0.19656       60
        Mint Leaves                     #N/A
        Lemon Juice                    0.009253      15
        Sugar Syrup                    0.002268      15
            Ice                         0.0045
   Mint Leaves (Garnish)                 #N/A
                               Cost
                      Cost Price Price
                      per Pack / per          Total
        Item          BTL        Gm/ ML Usage Cost
      Hennessy VS               0.399757      60
        Honey                   0.01138       15
      Mixed Spice                0.0331
        Celery                    #N/A
    Dehydrated Lime               #N/A
Total Product Cost
                             Cocktail Recipe w/ Cost
                                   Cost
                          Cost Price Price
                          per Pack / per          Total
         Item             BTL        Gm/ ML Usage Cost
      Hennessy VS                   0.399757     30
   Bacardi Carta Blanca             0.180187     30
        Triple sec                   0.2925      15
       Lemon Juice                  0.009253     30
           Ice                       0.0045      100
       Sugar Syrup                  0.002268     15
Total Product Cost
                          Cocktail Recipe w/ Cost
                                Cost
                       Cost Price Price
                       per Pack / per          Total
        Item           BTL        Gm/ ML Usage Cost
    Bombay Sapphire              0.183813      60
     Martini Rosso               0.09828       30
        Campari                  0.12149       30
    Orange (Garnish)              0.144
                                 Cost
                        Cost Price Price
                        per Pack / per          Total
        Item            BTL        Gm/ ML Usage Cost
        Gordons                   0.183827      60
    Martini extra dry             0.09419       30
           Ice                     0.0045
         Olives                     #N/A
Total Product Cost
                            Cocktail Recipe w/ Cost
                                  Cost
                         Cost Price Price
                         per Pack / per          Total
         Item            BTL        Gm/ ML Usage Cost
    Jose Cuervo silver             0.180187      60
        Triple sec                  0.2925       15
      Orange Juice                 0.00368      120
       Grenadine                    0.0441       10
           Ice                      0.0045
    Orange (Garnish)                0.144
                                  Cost
                         Cost Price Price
                         per Pack / per          Total
         Item            BTL        Gm/ ML Usage Cost
    Jose Cuervo silver             0.180187      60
        Triple sec                  0.2925       30
      Lemon Juice                  0.009253      15
       Sugar Syrup                 0.002268      15
           Ice                      0.0045
           salt                    0.00263
Total Product Cost
                              Cocktail Recipe w/ Cost
                                    Cost
                           Cost Price Price
                           per Pack / per          Total
         Item              BTL        Gm/ ML Usage Cost
      Guava Nectar                   0.00455      150
       Lemon Juice                   0.009253     15
         Tabasco                       0.15
            Ice                       0.0045
      Chili (Garnish)                  #N/A
   Chilli powder garnish
Total Product Cost
                              Cocktail Recipe w/ Cost
                                    Cost
                           Cost Price Price
                           per Pack / per          Total
         Item              BTL        Gm/ ML Usage Cost
    Aam Panna Mixture                 #DIV/0!     90
          Sprite                     0.006867    300
   Lime Wedge (Garnish)                #N/A
   Mint Sprigs (Garnish)               #N/A
            Ice                       0.0045
                              Cost
                     Cost Price Price
                     per Pack / per          Total
       Item          BTL        Gm/ ML Usage Cost
      Fresh Milk               0.00605     150
     Sugar Syrup               0.002268     15
    Thandai Powder              0.0525     10.00
       Saffron                  15.75      0.001
         Ice                    0.0045
                                 Cost
                        Cost Price Price
                        per Pack / per          Total
        Item            BTL        Gm/ ML Usage Cost
    Cucumber Syrup                 0.0441      20
     Lavender Syrup                0.063       20
      Lemon Juice                 0.009253     15
         Sprite                   0.006867     300
          Ice                      0.0045
   Cucumber (Garnish)               #N/A
   Rosemary (Garnish)             0.18201
                                    Cost
                           Cost Price Price
                           per Pack / per          Total
         Item              BTL        Gm/ ML Usage Cost
     Shikanji Powder          13     0.177778    2.5
       Lemon Juice                   0.009253    15
          Sprite                     0.006867    300
   Lime Wedge (Garnish)                #N/A
   Mint Leaves (Garnish)               #N/A
            Ice                       0.0045
                                    Cost
                           Cost Price Price
                           per Pack / per          Total
         Item              BTL        Gm/ ML Usage Cost
       Mojito Syrup                   0.0441     30
       Lemon Juice                   0.009253    15
          Sprite                     0.006867    300
            Ice                       0.0045
  Lemon Wedge (Garnish)                #N/A
   Mint Leaves (Garnish)               #N/A
                                    Cost
                           Cost Price Price
                           per Pack / per          Total
         Item              BTL        Gm/ ML Usage Cost
       Lemon Juice                   0.009253     30
       Sugar Syrup                   0.002268     15
           Mint                       0.0083
          Sprite                     0.006867     300
            Ice                       0.0045
  Lemon Wedge (Garnish)                #N/A
   Mint Leaves (Garnish)               #N/A
                                     Cost
                            Cost Price Price
                            per Pack / per          Total
          Item              BTL        Gm/ ML Usage Cost
        Ginger Ale                    0.008242     330
        Grenadine                      0.0441      15
       Lemon Juice                    0.009253     15
            Ice                        0.0045
            Salt                      0.00263
          Pepper                       0.0769
            Ice                        0.0045
   Celery Stick (Garnish)               #N/A
                                     Cost
                            Cost Price Price
                            per Pack / per          Total
          Item              BTL        Gm/ ML Usage Cost
       Tomato juice                   0.00455      150
       Lemon Juice                    0.009253     15
   Worcestershire Sauce                0.074
         Tabasco                        0.15
            Salt                      0.00263
          Pepper                       0.0769
            Ice                        0.0045
   Celery Stick (Garnish)               #N/A
                              Cost
                     Cost Price Price
                     per Pack / per          Total
       Item          BTL        Gm/ ML Usage Cost
      Yoghurt            7      0.0075     333.33
     Mango Pulp                0.029412     150
       saffron                  15.75      0.001
                              Cost
                     Cost Price Price
                     per Pack / per          Total
       Item          BTL        Gm/ ML Usage Cost
      Yoghurt            7      0.0075    333.33
       Mint                     0.0083      4
                              Cost
                     Cost Price Price
                     per Pack / per          Total
       Item          BTL        Gm/ ML Usage Cost
      Yoghurt            7      0.0075    333.33
        Salt                   0.00263     1.5
       Mint                     0.0083      1
                              Cost
                     Cost Price Price
                     per Pack / per          Total
       Item          BTL        Gm/ ML Usage Cost
      Yoghurt            7      0.0075     333.33
     Sugar Syrup               0.002268     15
       saffron                  15.75      0.001