Marketing - Case Study PPT ONLY

profilelolita077
hot_and_cold_coffee_costing.v2.xls
Home>Business & Finance homework help>Marketing homework help>Marketing - Case Study PPT ONLY

Hot Drinks

642.86
Items cost price -P case 150 4 25.14 287.5 1096.67 157.5 56.53 35 861 400 671.43 338 87.14
Items cost price -P piece 0.15 0.19 0.58
Ingredient Espresso Milk Cream Lid Cup Sugar Syrup Caramel Sleeve Stirir Anti spl Napkin Mocha Cost/Cup Selling Price Marg Marg%
Cappuccino
TALL Recipe 10.00 225.00
Cost 1.50 0.90 0.29 0.64 0.14 0.58 0.04 0.13 0.11 4.34 12.00 7.66 176%
GRANDE Recipe 16.00 300.00
Cost 2.40 1.20 0.29 1.10 0.21 0.58 0.04 0.13 0.11 6.06 14.00 7.94 131%
Latte
TALL Recipe 10.00 315.00
Cost 1.50 1.26 0.29 0.64 0.14 0.58 0.04 0.13 0.11 4.70 13.00 13.00 177%
GRANDE Recipe 16.00 350.00
Cost 2.40 1.40 0.29 1.10 0.21 0.58 0.04 0.13 0.11 6.26 15.00 15.00 139%
Caramel Macchiato
TALL Recipe 10.00 230.00 15.00 10.00
Cost 1.50 0.92 0.29 0.64 0.14 0.85 0.39 0.58 0.04 0.13 0.11 5.59 15.00 9.41 168%
GRANDE Recipe 16.00 320.00 22.50 10.00
Cost 2.40 1.28 0.29 1.10 0.21 1.27 0.39 0.58 0.04 0.13 0.11 7.80 17.00 9.20 118%
Americano Americano
TALL Recipe 16.00
Cost 3.00 0.29 0.64 0.58 0.04 0.13 0.11 4.80 11.00 6.20 129%
GRANDE Recipe 26.00
Cost 3.90 0.29 1.10 0.58 0.04 0.13 0.11 6.15 13.00 6.85 111%
Mocha
TALL Recipe 10.00 265.00 30.00
Cost 1.50 1.06 0.52 0.29 0.64 0.58 0.04 0.13 0.11 1.08 5.96 15.00 9.04 152%
GRANDE Recipe 16.00 320.00 30.00
Cost 2.40 1.28 0.52 0.29 1.10 0.58 0.04 0.13 0.11 1.44 7.90 17.00 9.10 115%
Espresso SINGLE
Recipe 10.00
Cost 1.50 0.49 1.99 8.00 6.01 303%
Double Espresso
Recipe 16.00
Cost 2.40 0.49 2.89 10.00 7.11 247%
8.00
Espresso Macchiato
1 Shot Recipe 10.00
Cost 1.50 0.49 1.99 8.00 6.01 303%
2 Shots Recipe 16.00
Cost 2.40 0.49 2.89 10.00 7.11 247%
Espresso Con Panna
1 Shot Recipe 10.00 7.50
Cost 1.50 0.93 0.49 2.92 8.00 5.08 174%
2 Shots Recipe 16.00 7.50
Cost 2.40 0.93 0.49 3.82 10.00 6.18 162%
houssam.shono: each cup takes 5 grams caramel
houssam.shono: TALL SIZE
houssam.shono: GRANDE SIZE

Iced Drinks

205 589
Items cost price -P Case 150 3.23 25.14 213 628 56.53 35 500 338 87.14
Items cost price -P Piece 0.15 0.193 0.05
Espresso Milk Cream Lid Cup Sugar Syrup Caramel Straw Stirir Anti spl Napkin Mocha Cost/Cup Selling Price Margin SR Margin %
Latte
TALL Recipe 10 315.00
Cost 1.5 1.02 0.21 0.59 0.05 0.11 3.47 13 9.53 274%
GRANDE Recipe 16 350.00
Cost 3 1.13 0.21 0.63 0.05 0.11 5.13 15 9.87 192%
Caramel Macchiato
TALL Recipe 10 230.00 15.00 10.00
Cost 1.5 0.74 0.21 0.59 0.85 0.39 0.05 0.11 4.43 15 10.57 238%
GRANDE Recipe 16 320.00 22.50 10.00
Cost 3 1.03 0.21 0.63 1.27 0.39 0.05 0.11 6.70 17 10.30 154%
Americano
TALL Recipe 16
Cost 3 0.21 0.59 0.05 0.11 3.96 11 7.04 178%
GRANDE Recipe 26
Cost 4.5 0.21 0.63 0.05 0.11 5.50 13 7.50 136%
Mocha
TALL Recipe 10 265.00 30
Cost 1.5 0.86 0.52 0.21 0.59 0.05 0.11 1.08 4.92 15 10.08 205%
GRANDE Recipe 16 320.00 30
Cost 3 1.03 0.52 0.21 0.63 0.05 0.11 1.44 7.00 17 10.00 143%
Double Shot Iced Shaken Espresso
Recipe 16 15.00 12.5
Cost 2.4 0.04 0.2 0.05 0.11 2.80 15 12.20 436%
houssam.shono: tall size
houssam.shono: TALL SIZE
houssam.shono: GRANDE SIZE
houssam.shono: 15 ml
houssam.shono: 12.5 ml
houssam.shono:

Retail Store Price List

Prices in SAR
Single Double Triple Machine Needed
Starbucks espresso Espresso 8 10 12 CTM
Espresso con panna 8 10 12 CTM
espresso macchiato 8 10 12 CTMS
12 OZ 16 OZ 20 OZ
Starbucks chocolate Signature hot chocolate 14 16 N/A IN SBSS CTMS
White hot chocolate 14 16 N/A IN SBSS CTMS
Espresso Traditions Caffè latte 13 15 N/A IN SBSS CTM
Flat white 8Oz 13 CTM
Cappuccino 13 15 N/A IN SBSS CTM
Caffè Americano 11 13 N/A IN SBSS CTM
caramel macchiato 15 17 N/A IN SBSS CTM
Caffè mocha 15 17 N/A IN SBSS CTMS
white chocolate mocha 15 17 N/A IN SBSS CTMS
caramel mocha 17 19 N/A IN SBSS CTMS
double mocha macchiato 17 19 N/A IN SBSS CTMS
Starbucks on ice Iced coffee 11 13 N/A IN SBSS CTM
Iced Caffè latte 13 15 N/A IN SBSS CTM
Iced Caffè Americano 11 13 N/A IN SBSS CTM
Iced caramel macchiato 15 17 N/A IN SBSS CTM
Iced Caffè mocha 15 17 N/A IN SBSS CTM
Iced white chocolate mocha 15 17 N/A IN SBSS CTM
Iced signature chocolate 14 16 N/A IN SBSS CTM
Iced Double Mocha Machiato 17 19
Double shot iced shaken espresso 15 CTM
Add on Add Espresso shot 4
add flavor 4
add cream 4
add chocolate 4