{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Liquor Cost Potential Sample","Liquor Cost Potential Worksheet"],"not_rendered":{"defined_names":2,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Liquor Cost Potential Sample","index":0,"n_rows":28,"n_cols":10,"rows_kept":28,"merged":[[0,4,0,5],[1,4,1,5],[2,4,2,5],[4,4,4,5],[5,4,5,5],[7,5,7,6],[8,5,8,6],[9,5,9,6],[21,2,21,3],[23,0,23,2],[24,0,24,2],[24,3,24,4],[25,0,25,2],[25,3,25,4],[26,0,26,2],[26,3,26,4],[27,0,27,2],[27,3,27,4]]}
["PURCHASES",{"$nulls":3},"SALES"]
["Price Category","Bottles Purchased per Week","Average Cost per Bottle",null,"Happy Hour Liquor Sales as a Percentage of Total \nLiquor Sales"]
["Well",18,{"v":7,"d":"$7.00"},null,{"v":0.2,"d":"20%"}]
["Call",7,{"v":12,"d":"$12.00"}]
["Premium",4,{"v":22,"d":"$22.00"},null,"Last Year's \nActual Liquor Sales"]
["Top Shelf",2,{"v":30,"d":"$30.00"},null,{"v":104500,"d":"$104,500.00"}]
[]
["PRICING",{"$nulls":4},"POURING"]
["Price Category","Happy Hour Price","Regular Price","Sales Mix",null,"Shot Size",null,null,"Drinks per Bottle"]
[{"$f":"A3","v":"Well"},{"v":2,"d":"$2.00"},{"v":3,"d":"$3.00"},{"$f":"B3/(B3+B4+B5+B6)","v":{"v":0.5806451612903226,"d":"0.58"}},null,1.25,null,null,{"$f":"IF(F10=0.75,45,IF(F10=0.875,38,IF(F10=1,33,IF(F10=1.125,30,IF(F10=1.25,27,IF(F10=1.5,22))))))","v":27}]
[{"$f":"A4","v":"Call"},{"v":3,"d":"$3.00"},{"v":4,"d":"$4.00"},{"$f":"B4/(B3+B4+B5+B6)","v":{"v":0.22580645161290322,"d":"0.23"}}]
[{"$f":"A5","v":"Premium"},{"v":4,"d":"$4.00"},{"v":5,"d":"$5.00"},{"$f":"B5/(B3+B4+B5+B6)","v":{"v":0.12903225806451613,"d":"0.13"}}]
[{"$f":"A6","v":"Top Shelf"},{"v":5,"d":"$5.00"},{"v":6,"d":"$6.00"},{"$f":"B6/(B3+B4+B5+B6)","v":{"v":0.06451612903225806,"d":"0.06"}}]
["CALCULATIONS"]
[]
["Price Category","Cost per  Bottle","Cost per Ounce","Cost per Drink","Average Price","Liquor Cost Percentage","Weighted Average Factor",null,"Potential Revenue per Liter Bottle","Potential Weekly Revenue"]
[{"$f":"A10","v":"Well"},{"$f":"C3","v":{"v":7,"d":"$7.00"}},{"$f":"B17/33","v":{"v":0.21212121212121213,"d":"$0.21"}},{"$f":"C17*F10","v":{"v":0.26515151515151514,"d":"$0.27"}},{"$f":"(B10*E3)+(C10*(1-E3))","v":{"v":2.8000000000000003,"d":"$2.80"}},{"$f":"D17/E17","v":0.09469696969696968},{"$f":"F17*D10","v":{"v":0.05498533724340175,"d":"5.50%"}},null,{"$f":"E17*I10","v":{"v":75.60000000000001,"d":"$75.60"}},{"$f":"B3*I17","v":{"v":1360.8000000000002,"d":"$1,360.80"}}]
[{"$f":"A11","v":"Call"},{"$f":"C4","v":{"v":12,"d":"$12.00"}},{"$f":"B18/33","v":{"v":0.36363636363636365,"d":"$0.36"}},{"$f":"C18*F10","v":{"v":0.4545454545454546,"d":"$0.45"}},{"$f":"(B11*E3)+(C11*(1-E3))","v":{"v":3.8000000000000003,"d":"$3.80"}},{"$f":"D18/E18","v":0.11961722488038277},{"$f":"F18*D11","v":{"v":0.027010341102021915,"d":"2.70%"}},null,{"$f":"E18*I10","v":{"v":102.60000000000001,"d":"$102.60"}},{"$f":"B4*I18","v":{"v":718.2,"d":"$718.20"}}]
[{"$f":"A12","v":"Premium"},{"$f":"C5","v":{"v":22,"d":"$22.00"}},{"$f":"B19/33","v":{"v":0.6666666666666666,"d":"$0.67"}},{"$f":"C19*F10","v":{"v":0.8333333333333333,"d":"$0.83"}},{"$f":"(B12*E3)+(C12*(1-E3))","v":{"v":4.8,"d":"$4.80"}},{"$f":"D19/E19","v":0.1736111111111111},{"$f":"F19*D12","v":{"v":0.022401433691756272,"d":"2.24%"}},null,{"$f":"E19*I10","v":{"v":129.6,"d":"$129.60"}},{"$f":"B5*I19","v":{"v":518.4,"d":"$518.40"}}]
[{"$f":"A13","v":"Top Shelf"},{"$f":"C6","v":{"v":30,"d":"$30.00"}},{"$f":"B20/33","v":{"v":0.9090909090909091,"d":"$0.91"}},{"$f":"C20*F10","v":{"v":1.1363636363636362,"d":"$1.14"}},{"$f":"(B13*E3)+(C13*(1-E3))","v":{"v":5.800000000000001,"d":"$5.80"}},{"$f":"D20/E20","v":0.1959247648902821},{"$f":"F20*D13","v":{"v":0.012640307412276263,"d":"1.26%"}},null,{"$f":"E20*I10","v":{"v":156.60000000000002,"d":"$156.60"}},{"$f":"B6*I20","v":{"v":313.20000000000005,"d":"$313.20"}}]
[{"$nulls":9},{"$f":"SUM(J17:J20)","v":{"v":2910.6000000000004,"d":"$2,910.60"}}]
[null,null,"Potential Liquor \nCost Percentage:",null,{"$f":"SUM(G17:G20)","v":{"v":0.1170374194494562,"d":"11.7%"}}]
[]
["LIQUOR LOSS ANALYSIS"]
["Liquor Sales Potential Per Week:",null,null,{"$f":"$J$21","v":{"v":2910.6000000000004,"d":"$2,910.60"}}]
["Liquor Sales Potential Per Month:",null,null,{"$f":"D25*4.3","v":{"v":12515.580000000002,"d":"$12,515.58"}}]
["Liquor Sales Potential Per Year:",null,null,{"$f":"D25*52","v":{"v":151351.2,"d":"$151,351.20"}}]
["Liquor Sales LOST Per Year:",null,null,{"$f":"E6-D27","v":{"v":-46851.20000000001,"d":"-$46,851.20"}}]

{"sheet":"Liquor Cost Potential Worksheet","index":1,"n_rows":28,"n_cols":10,"rows_kept":28,"merged":[[0,4,0,5],[1,4,1,5],[2,4,2,5],[4,4,4,5],[5,4,5,5],[7,5,7,6],[8,5,8,6],[9,5,9,6],[21,2,21,3],[23,0,23,2],[24,0,24,2],[24,3,24,4],[25,0,25,2],[25,3,25,4],[26,0,26,2],[26,3,26,4],[27,0,27,2],[27,3,27,4]]}
["PURCHASES",{"$nulls":3},"SALES"]
["Price Category","Bottles Purchased per Week","Average Cost per Bottle",null,"Happy Hour Liquor Sales as a Percentage of Total \nLiquor Sales"]
[]
[]
[{"$nulls":4},"Last Year's \nActual Liquor Sales"]
[]
[]
["PRICING",{"$nulls":4},"POURING"]
["Price Category","Happy Hour Price","Regular Price","Sales Mix",null,"Shot Size",null,null,"Drinks per Bottle"]
[{"$f":"A3","v":0},null,null,{"$f":"B3/(B3+B4+B5+B6)","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"IF(F10=0.75,45,IF(F10=0.875,38,IF(F10=1,33,IF(F10=1.125,30,IF(F10=1.25,27,IF(F10=1.5,22))))))","v":false}]
[{"$f":"A4","v":0},null,null,{"$f":"B4/(B3+B4+B5+B6)","v":{"$error":"#DIV/0!"}}]
[{"$f":"A5","v":0},null,null,{"$f":"B5/(B3+B4+B5+B6)","v":{"$error":"#DIV/0!"}}]
[{"$f":"A6","v":0},null,null,{"$f":"B6/(B3+B4+B5+B6)","v":{"$error":"#DIV/0!"}}]
["CALCULATIONS"]
[]
["Price Category","Cost per  Bottle","Cost per Ounce","Cost per Drink","Average Price","Liquor Cost Percentage","Weighted Average Factor",null,"Potential Revenue per Liter Bottle","Potential Weekly Revenue"]
[{"$f":"A10","v":0},{"$f":"C3","v":{"v":0,"d":"$0.00"}},{"$f":"B17/33","v":{"v":0,"d":"$0.00"}},{"$f":"C17*F10","v":{"v":0,"d":"$0.00"}},{"$f":"(B10*E3)+(C10*(1-E3))","v":{"v":0,"d":"$0.00"}},{"$f":"D17/E17","v":{"$error":"#DIV/0!"}},{"$f":"F17*D10","v":{"$error":"#DIV/0!"}},null,{"$f":"E17*I10","v":{"v":0,"d":"$0.00"}},{"$f":"B3*I17","v":{"v":0,"d":"$0.00"}}]
[{"$f":"A11","v":0},{"$f":"C4","v":{"v":0,"d":"$0.00"}},{"$f":"B18/33","v":{"v":0,"d":"$0.00"}},{"$f":"C18*F10","v":{"v":0,"d":"$0.00"}},{"$f":"(B11*E3)+(C11*(1-E3))","v":{"v":0,"d":"$0.00"}},{"$f":"D18/E18","v":{"$error":"#DIV/0!"}},{"$f":"F18*D11","v":{"$error":"#DIV/0!"}},null,{"$f":"E18*I10","v":{"v":0,"d":"$0.00"}},{"$f":"B4*I18","v":{"v":0,"d":"$0.00"}}]
[{"$f":"A12","v":0},{"$f":"C5","v":{"v":0,"d":"$0.00"}},{"$f":"B19/33","v":{"v":0,"d":"$0.00"}},{"$f":"C19*F10","v":{"v":0,"d":"$0.00"}},{"$f":"(B12*E3)+(C12*(1-E3))","v":{"v":0,"d":"$0.00"}},{"$f":"D19/E19","v":{"$error":"#DIV/0!"}},{"$f":"F19*D12","v":{"$error":"#DIV/0!"}},null,{"$f":"E19*I10","v":{"v":0,"d":"$0.00"}},{"$f":"B5*I19","v":{"v":0,"d":"$0.00"}}]
[{"$f":"A13","v":0},{"$f":"C6","v":{"v":0,"d":"$0.00"}},{"$f":"B20/33","v":{"v":0,"d":"$0.00"}},{"$f":"C20*F10","v":{"v":0,"d":"$0.00"}},{"$f":"(B13*E3)+(C13*(1-E3))","v":{"v":0,"d":"$0.00"}},{"$f":"D20/E20","v":{"$error":"#DIV/0!"}},{"$f":"F20*D13","v":{"$error":"#DIV/0!"}},null,{"$f":"E20*I10","v":{"v":0,"d":"$0.00"}},{"$f":"B6*I20","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":9},{"$f":"SUM(J17:J20)","v":{"v":0,"d":"$0.00"}}]
[null,null,"Potential Liquor \nCost Percentage:",null,{"$f":"SUM(G17:G20)","v":{"$error":"#DIV/0!"}}]
[]
["LIQUOR LOSS ANALYSIS"]
["Liquor Sales Potential Per Week:",null,null,{"$f":"$J$21","v":{"v":0,"d":"$0.00"}}]
["Liquor Sales Potential Per Month:",null,null,{"$f":"D25*4.3","v":{"v":0,"d":"$0.00"}}]
["Liquor Sales Potential Per Year:",null,null,{"$f":"D25*52","v":{"v":0,"d":"$0.00"}}]
["Liquor Sales LOST Per Year:",null,null,{"$f":"E6-D27","v":{"v":0,"d":"$0.00"}}]