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

{"sheet":"Bottle Beer Cost % Sample","index":0,"n_rows":19,"n_cols":10,"rows_kept":19,"merged":[[0,3,0,6],[1,3,1,4],[1,5,1,6],[2,3,3,4],[2,5,3,6],[12,3,12,4],[14,0,14,2],[15,0,15,2],[15,3,15,4],[16,0,16,2],[16,3,16,4],[17,0,17,2],[17,3,17,4],[18,0,18,2],[18,3,18,4]]}
["PURCHASES",null,null,"SALES"]
["Brand Category","Cases Purchased \nper Week","Average Cost per Case \n(24 Bottles)","Happy Hour Bottle Beer Sales as a Percentage of \nTotal Bottled Beer Sales",null,"Last Year's Bottle Beer Sales"]
["Domestic Bottles:",8,{"v":17,"d":"$17.00"},{"v":0.2,"d":"20%"},null,{"v":58750,"d":"$58,750.00"}]
["Imported Bottles:",3,{"v":29,"d":"$29.00"}]
[]
["CONTAINERS"]
["Bottle or Can \nPrices","Domestic Happy Hour Price per Bottle","Import Happy Hour Price per Bottle","Domestic \nRegular Price per Bottle","Import\nRegular Price per Bottle"]
[null,{"v":3,"d":"$3.00"},{"v":4,"d":"$4.00"},{"v":5,"d":"$5.00"},{"v":6,"d":"$6.00"}]
[null,null," "," "]
["CALCULATIONS"]
["Container Sizes","Domestic Price","Import Price","Weighted Average Price",{"$nulls":4},"Weighted Average Cost per Bottle","Potential Sales\nper Week"]
[{"$f":"A8","v":0},{"$f":"SUM(B8*D3)+(D8*(1-D3))","v":{"v":4.6,"d":"$4.60"}},{"$f":"SUM(C8*D3)+(E8*(1-D3))","v":{"v":5.6000000000000005,"d":"$5.60"}},{"$f":"SUM(B12*H12)+(C12*(1-H12))","v":{"v":4.872727272727273,"d":"$4.87"}},null,null,"Domestic %",{"$f":"SUM(B3/(B3+B4))","v":{"v":0.7272727272727273,"d":"73%"}},{"$f":"((C3/24*B3)+(C4/24*B4))/(B3+B4)","v":{"v":0.8446969696969698,"d":"$0.84"}},{"$f":"((B3*24)*B12)+((B4*24)*C12)","v":{"v":1286.4,"d":"$1,286.40"}}]
[{"$nulls":3},"Potential Bottled Beer\nCost Percentage:",null,{"$f":"I12/D12","v":{"v":0.17335199004975127,"d":"17.3%"}}]
[]
["BOTTLED BEER LOSS ANALYSIS"]
["Bottled Beer Sales Potential Per Week:",null,null,{"$f":"J12","v":{"v":1286.4,"d":"$1,286.40"}}]
["Bottled Beer Sales Potential Per Month:",null,null,{"$f":"D16*4.3","v":{"v":5531.52,"d":"$5,531.52"}}]
["Bottled Beer Sales Potential Per Year:",null,null,{"$f":"D16*52","v":{"v":66892.8,"d":"$66,892.80"}}]
["Bottled Beer Sales LOST Per Year:",null,null,{"$f":"F3-D18","v":{"v":-8142.800000000003,"d":"-$8,142.80"}}]

{"sheet":"Bottle Beer Cost % Worksheet","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"merged":[[0,3,0,6],[1,3,1,4],[1,5,1,6],[2,3,3,4],[2,5,3,6],[12,3,12,4],[14,0,14,2],[15,0,15,2],[15,3,15,4],[16,0,16,2],[16,3,16,4],[17,0,17,2],[17,3,17,4],[18,0,18,2],[18,3,18,4]]}
["PURCHASES",null,null,"SALES"]
["Brand Category","Cases Purchased \nper Week","Average Cost per Case \n(24 Bottles)","Happy Hour Bottle Beer Sales as a Percentage of \nTotal Bottled Beer Sales",null,"Last Year's Bottle Beer Sales"]
["Domestic Bottles:"]
["Imported Bottles:"]
[]
["CONTAINERS"]
["Bottle or Can \nPrices","Domestic Happy Hour Price per Bottle","Import Happy Hour Price per Bottle","Domestic \nRegular Price per Bottle","Import\nRegular Price per Bottle"]
[]
[null,null," "," "]
["CALCULATIONS"]
["Container Sizes","Domestic Price","Import Price","Weighted Average Price",{"$nulls":4},"Weighted Average Cost per Bottle","Potential Sales\nper Week"]
[{"$f":"A8","v":0},{"$f":"SUM(B8*D3)+(D8*(1-D3))","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(C8*D3)+(E8*(1-D3))","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(B12*H12)+(C12*(1-H12))","v":{"$error":"#DIV/0!"}},null,null,"Domestic %",{"$f":"SUM(B3/(B3+B4))","v":{"$error":"#DIV/0!"}},{"$f":"((C3/24*B3)+(C4/24*B4))/(B3+B4)","v":{"$error":"#DIV/0!"}},{"$f":"((B3*24)*B12)+((B4*24)*C12)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Potential Bottled Beer\nCost Percentage:",null,{"$f":"I12/D12","v":{"$error":"#DIV/0!"}}]
[]
["BOTTLED BEER LOSS ANALYSIS"]
["Bottled Beer Sales Potential Per Week:",null,null,{"$f":"J12","v":{"v":0,"d":"$0.00"}}]
["Bottled Beer Sales Potential Per Month:",null,null,{"$f":"D16*4.3","v":{"v":0,"d":"$0.00"}}]
["Bottled Beer Sales Potential Per Year:",null,null,{"$f":"D16*52","v":{"v":0,"d":"$0.00"}}]
["Bottled Beer Sales LOST Per Year:",null,null,{"$f":"F3-D18","v":{"v":0,"d":"$0.00"}}]