Scribd
Upload
2 views12 pages

Flavor Cost and Profit Analysis

The document provides detailed financial data on various flavors sold by a café, including costs, prices, sales, expenses, income, and total profit for each flavor. It also includes monthly sales data for different beverage categories over the year, highlighting top-selling items. Overall, it serves as a comprehensive overview of product performance and profitability for the café.

Uploaded by

257720101209
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
2 views12 pages

Flavor Cost and Profit Analysis

The document provides detailed financial data on various flavors sold by a café, including costs, prices, sales, expenses, income, and total profit for each flavor. It also includes monthly sales data for different beverage categories over the year, highlighting top-selling items. Overall, it serves as a comprehensive overview of product performance and profitability for the café.

Uploaded by

257720101209
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Flavor Costs (per quart)

Flavors Cost Price Sales Expense Income Total Profit


Fruit Heaven Splurge 2.14 5.68 662 1416.68 3760.16 2343.48
Nutty Heaven Splurge 2.36 5.2 592 1397.12 3078.4 1681.28
Whole Vanilla Bean Chunk 2.59 5.83 264 683.76 1539.12 855.36
Poprock Pancake Syrup 1.78 4.99 264 469.92 1317.36 847.44
Caramel Pavement 1.76 4.93 260 457.6 1281.8 824.2
Cinnamon Donut 1.54 4.32 264 406.56 1140.48 733.92
Mocha Coffee 2.56 5.84 204 522.24 1191.36 669.12
Black Bean Choco 1.46 4.09 233 340.18 952.97 612.79
Pistachio and Pecans 1.28 3.59 260 332.8 933.4 600.6
Blueberry Choco 2.32 6.5 143 331.76 929.5 597.74
Red Hot Chili Choco 1.25 3.5 260 325 910 585
Choco Heaven Splurge 2.28 5.34 178 405.84 950.52 544.68
Yellow Snow Cream 0.35 1.16 662 231.7 767.92 536.22
Jawbreaker Mint 2.05 5.74 140 287 803.6 516.6
Pecan and Peanut Truffle 1.98 5.55 143 283.14 793.65 510.51
Cheesecake Caramel 3.25 6.37 154 500.5 980.98 480.48
Animal Crackers 1.77 4.96 143 253.11 709.28 456.17
Wafflecone Rasberry 1.08 3.03 233 251.64 705.99 454.35
Mint Choco Cherry 1.35 3.78 178 240.3 672.84 432.54
Yogurt Covered Cashew 1.79 4.48 154 275.66 689.92 414.26
Green Tea Wheatgrass 0.28 1.93 189 52.92 364.77 311.85
Campbell's Soup Souffle 1.11 3.11 140 155.4 435.4 280
Sour Tart Sherbet 1.5 3.05 174 261 530.7 269.7

Flavor Sales Over 250


Chart Title
4000 Fruit Heaven Splurge
Nutty Heaven Splurge
Whole Vanilla Bean Chunk
3500 Poprock Pancake Syrup
Caramel Pavement
Cinnamon Donut
Mocha Coffee
3000
Black Bean Choco
Pistachio and Pecans
Blueberry Choco
2500
Red Hot Chili Choco
Choco Heaven Splurge
Income

Yellow Snow Cream


2000
Jawbreaker Mint
Pecan and Peanut Truffle
Cheesecake Caramel
1500
Animal Crackers
Wafflecone Rasberry
Mint Choco Cherry
1000
Yogurt Covered Cashew
Green Tea Wheatgrass
Campbell's Soup Souffle
500
Sour Tart Sherbet

0
Income
Animal Crackers
Wafflecone Rasberry
Mint Choco Cherry
1000
Yogurt Covered Cashew
Green Tea Wheatgrass
Campbell's Soup Souffle
500
Sour Tart Sherbet

0
Income
Chart Title
Fruit Heaven Splurge
Nutty Heaven Splurge
Whole Vanilla Bean Chunk
Poprock Pancake Syrup
Caramel Pavement
Cinnamon Donut
Mocha Coffee
Black Bean Choco
Pistachio and Pecans
Blueberry Choco
Red Hot Chili Choco
Choco Heaven Splurge
Yellow Snow Cream
Jawbreaker Mint
Pecan and Peanut Truffle
Cheesecake Caramel
Animal Crackers
Wafflecone Rasberry
Mint Choco Cherry
Yogurt Covered Cashew
Green Tea Wheatgrass
Campbell's Soup Souffle
Sour Tart Sherbet

ncome
Animal Crackers
Wafflecone Rasberry
Mint Choco Cherry
Yogurt Covered Cashew
Green Tea Wheatgrass
Campbell's Soup Souffle
Sour Tart Sherbet

ncome
[Link] 01/22/2026

Morning Bean
Hot Drink Café

tinhocfighter
[Link] 01/22/2026

Morning Bean
Hot Drink Café
Units Sold per Month
Category Item Jan Feb Mar
Vanilla Hazelnut Latte 7,400 8,000 8,200
White Chocolate Mocha 5,700 6,100 6,300
Caramel Macchiato 1,800 1,900 1,900
Hazelnut Mocha 3,100 3,300 3,400
Speciality

Classic Latte 5,700 6,100 6,300


Classic Mocha 2,200 2,400 2,400
Tea Latte 4,800 5,200 5,300
Cappuccino 2,600 2,800 2,900
Vanilla Hazelnut Blender 6,100 6,600 6,800
Caramel Blender 4,400 4,700 4,800
Strawberry Banana Smoothie 8,800 9,400 9,700
Sandwiches Smoothies

Mixed Berry Smoothie 5,800 6,300 6,500


Blackberry Lemonade 4,400 4,700 4,800
Strawberry Lemonade 7,300 7,800 8,100
Classic Lemonade 2,900 3,100 3,200
Applewood Bacon & Cheddar 2,300 2,500 2,600
Turkey-Sausage & Cheddar 4,100 4,400 4,500
Ham & Swiss 2,000 2,200 2,300
Sante Fe 3,700 3,900 4,000
Florentine 2,500 2,700 2,700
Chicken Noodle 3,400 3,700 3,800
Soups

Turkey Chili 1,900 2,100 2,200


Brocolli Cheddar 2,700 2,900 3,000
Wild Rice & Mutton 1,700 1,800 1,800
TOTAL 97,300 104,600 107,500

tinhocfighter
[Link] 01/22/2026

Morning Bean
Hot Drink Café
Units Sold per Month
Category Item Apr May Jun
Vanilla Hazelnut Latte 8,800 9,400 10,900
White Chocolate Mocha 6,700 7,200 8,300
Caramel Macchiato 2,100 2,200 2,600
Hazelnut Mocha 3,600 3,900 4,500
Speciality

Classic Latte 6,700 7,200 8,300


Classic Mocha 2,600 2,800 3,200
Tea Latte 5,700 6,100 7,000
Cappuccino 3,100 3,300 3,800
Vanilla Hazelnut Blender 7,200 7,800 9,000
Caramel Blender 5,200 5,600 6,400
Strawberry Banana Smoothie 10,300 11,100 12,900
Sandwiches Smoothies

Mixed Berry Smoothie 6,900 7,400 8,500


Blackberry Lemonade 5,200 5,600 6,400
Strawberry Lemonade 8,600 9,300 10,700
Classic Lemonade 3,400 3,700 4,300
Applewood Bacon & Cheddar 2,800 3,000 3,400
Turkey-Sausage & Cheddar 4,800 5,200 6,000
Ham & Swiss 2,400 2,600 3,000
Sante Fe 4,300 4,600 5,300
Florentine 2,900 3,100 3,600
Chicken Noodle 4,000 4,300 5,000
Soups

Turkey Chili 2,300 2,500 2,800


Brocolli Cheddar 3,200 3,500 4,000
Wild Rice & Mutton 2,000 2,100 2,400
TOTAL 114,800 123,500 142,300

tinhocfighter
[Link] 01/22/2026

Morning Bean
Hot Drink Café
Units Sold per Month
Category Item Jul Aug Sep
Vanilla Hazelnut Latte 11,000 10,600 9,800
White Chocolate Mocha 8,400 8,100 7,500
Caramel Macchiato 2,600 2,500 2,300
Hazelnut Mocha 4,500 4,300 4,000
Speciality

Classic Latte 8,400 8,100 7,500


Classic Mocha 3,200 3,100 2,900
Tea Latte 7,100 6,800 6,300
Cappuccino 3,900 3,700 3,500
Vanilla Hazelnut Blender 9,100 8,700 8,100
Caramel Blender 6,500 6,200 5,800
Strawberry Banana Smoothie 12,900 12,400 11,500
Sandwiches Smoothies

Mixed Berry Smoothie 8,600 8,300 7,700


Blackberry Lemonade 6,500 6,200 5,800
Strawberry Lemonade 10,800 10,400 9,600
Classic Lemonade 4,300 4,100 3,800
Applewood Bacon & Cheddar 3,500 3,300 3,100
Turkey-Sausage & Cheddar 6,000 5,800 5,400
Ham & Swiss 3,000 2,900 2,700
Sante Fe 5,400 5,200 4,800
Florentine 3,700 3,500 3,300
Chicken Noodle 5,000 4,800 4,500
Soups

Turkey Chili 2,900 2,800 2,600


Brocolli Cheddar 4,000 3,900 3,600
Wild Rice & Mutton 2,400 2,300 2,200
TOTAL 143,700 138,000 128,300

tinhocfighter
[Link] 01/22/2026

Morning Bean
Hot Drink Café
Units Sold per Month
Category Item Oct Nov Dec
Vanilla Hazelnut Latte 8,300 7,800 10,900
White Chocolate Mocha 6,400 6,000 8,300
Caramel Macchiato 2,000 1,800 2,600
Hazelnut Mocha 3,400 3,200 4,500
Speciality

Classic Latte 6,400 6,000 8,300


Classic Mocha 2,500 2,300 3,200
Tea Latte 5,400 5,000 7,000
Cappuccino 2,900 2,700 3,800
Vanilla Hazelnut Blender 6,900 6,400 9,000
Caramel Blender 4,900 4,600 6,400
Strawberry Banana Smoothie 9,800 9,200 12,800
Sandwiches Smoothies

Mixed Berry Smoothie 6,500 6,100 8,500


Blackberry Lemonade 4,900 4,600 6,400
Strawberry Lemonade 8,200 7,600 10,700
Classic Lemonade 3,300 3,100 4,300
Applewood Bacon & Cheddar 2,600 2,400 3,400
Turkey-Sausage & Cheddar 4,600 4,300 6,000
Ham & Swiss 2,300 2,100 3,000
Sante Fe 4,100 3,800 5,300
Florentine 2,800 2,600 3,600
Chicken Noodle 3,800 3,600 5,000
Soups

Turkey Chili 2,200 2,000 2,800


Brocolli Cheddar 3,100 2,800 4,000
Wild Rice & Mutton 1,900 1,700 2,400
TOTAL 109,200 101,700 142,200

tinhocfighter
[Link] 01/22/2026

Morning Bean
Hot Drink Café
Units Sold per Month Top Sellers
Category Item TOTAL
Vanilla Hazelnut Latte 111,100
White Chocolate Mocha 85,000
Caramel Macchiato 26,300
Hazelnut Mocha 45,700
Speciality

Classic Latte 85,000


Classic Mocha 32,800
Tea Latte 71,700
Cappuccino 39,000
Vanilla Hazelnut Blender 91,700
Caramel Blender 65,500
Strawberry Banana Smoothie 130,800
Sandwiches Smoothies

Mixed Berry Smoothie 87,100


Blackberry Lemonade 65,500
Strawberry Lemonade 109,100
Classic Lemonade 43,500
Applewood Bacon & Cheddar 34,900
Turkey-Sausage & Cheddar 61,100
Ham & Swiss 30,500
Sante Fe 54,400
Florentine 37,000
Chicken Noodle 50,900
Soups

Turkey Chili 29,100


Brocolli Cheddar 40,700
Wild Rice & Mutton 24,700
TOTAL 1,453,100

tinhocfighter

You might also like