its off of an excel spread. and we have to find the cost per oz cost/oz cost per shot cost/shot result cont margin sellig price etc .. thats all weve been given

L M 4 Ounces per drink = 1 or 125 or 1,5 5 Bottles per case = 12 6 Drinks per case = 324.5 7 Bottle = 1 liter 8 Fluid Ounces per liter=338 9 750 ml = 25.4 oz 10 11 Price Categories = Well, Call, Premium Super Premium 12 13 Drinks per Case = (Fluid Ounces per liter x 12 liters per case Fluid Ounces per drink 14 Cost per Drink = (Bottle price/33 8 ounces per liter) Shot size 15 Drink Profit=Drink Selling Price - Cost per Drink 16 Total Gross Profit = (Drink Selling Price - Cost per Drink) x Total Drinks Sold 17 18 Pricing Wine by the Glass 19 Product Btl. Size Cost Bel Cost/oz Size/Por. CostPor CGS% 20 Big House Red 750 ml 6.99 20 21 Coppola Rosso 750 ml 8.99 30 22 Hess 3 Vineyards Red 750 ml 21.99 35 23 Sterling SVR 04 Red 750 ml 34.99 35 24 Blackstone Chardonnay 750 ml 10.99 25 25 Rex Hill Pinot Grigio Wiamette 750 ml 17 99 25 28 Kunde Sauvignon Blanc 750 ml 1499 25 27 Caymus Conundrum White 750 ml 21.99 30 28 Result Margin Cont Margin Price CGS% L M 4 Ounces per drink = 1 or 125 or 1,5 5 Bottles per case = 12 6 Drinks per case = 324.5 7 Bottle = 1 liter 8 Fluid Ounces per liter=338 9 750 ml = 25.4 oz 10 11 Price Categories = Well, Call, Premium Super Premium 12 13 Drinks per Case = (Fluid Ounces per liter x 12 liters per case Fluid Ounces per drink 14 Cost per Drink = (Bottle price/33 8 ounces per liter) Shot size 15 Drink Profit=Drink Selling Price - Cost per Drink 16 Total Gross Profit = (Drink Selling Price - Cost per Drink) x Total Drinks Sold 17 18 Pricing Wine by the Glass 19 Product Btl. Size Cost Bel Cost/oz Size/Por. CostPor CGS% 20 Big House Red 750 ml 6.99 20 21 Coppola Rosso 750 ml 8.99 30 22 Hess 3 Vineyards Red 750 ml 21.99 35 23 Sterling SVR 04 Red 750 ml 34.99 35 24 Blackstone Chardonnay 750 ml 10.99 25 25 Rex Hill Pinot Grigio Wiamette 750 ml 17 99 25 28 Kunde Sauvignon Blanc 750 ml 1499 25 27 Caymus Conundrum White 750 ml 21.99 30 28 Result Margin Cont Margin Price CGS%