0% found this document useful (0 votes)
57 views4 pages

Menu Sales Case 7 Data File

The document provides sales information for Morning Bean Hot Drink Café. It shows the units sold and gross sales for 2017 and 2016 for different menu categories including speciality drinks, smoothies, sandwiches, and soups. Speciality drinks were the top selling category in both units and dollars. Overall, the café saw a 16.66% increase in total units sold and a 18.8% increase in total gross sales from 2016 to 2017.

Uploaded by

Maulana Malik
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
0% found this document useful (0 votes)
57 views4 pages

Menu Sales Case 7 Data File

The document provides sales information for Morning Bean Hot Drink Café. It shows the units sold and gross sales for 2017 and 2016 for different menu categories including speciality drinks, smoothies, sandwiches, and soups. Speciality drinks were the top selling category in both units and dollars. Overall, the café saw a 16.66% increase in total units sold and a 18.8% increase in total gross sales from 2016 to 2017.

Uploaded by

Maulana Malik
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

Morning Bean

Hot Drink Café


Author
Date Wednesday, February 7, 2018

To display sales information on items


Purpose from the Morning Bean menu
Website Location
[Link] 12/08/2023

Morning Bean
Hot Drink Café

Units Sold
Menu Category 2017 2016 Net Change % Change
Speciality 653,800 548,000 105,800 19.31%
Smoothies 436,000 364,000 72,000 19.78%
Sandwiches 217,900 180,600 37,300 20.65%
Soups 145,400 153,000 (7,600) -4.97%
Total 1,453,100 1,245,600 207,500 16.66%

Gross Sales
Menu Category Column1 2017 2016 Net Change
Speciality $ 4,464,800 $ 3,780,427 $ 684,373
Smoothies 2,934,300 2,489,316 444,984
Sandwiches 1,487,100 1,280,800 206,300
Soups 994,600 1,050,253 (55,653)
Total $ 9,880,800 $ 8,600,796 $ 1,280,004

2 of 4
[Link] 12/08/2023

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

Classic Latte 5,700 6,100 6,300 6,700 7,200 8,300


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

Mixed Berry Smoothie 5,800 6,300 6,500 6,900 7,400 8,500


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

Turkey Chili 1,900 2,100 2,200 2,300 2,500 2,800


Brocolli Cheddar 2,700 2,900 3,000 3,200 3,500 4,000
Wild Rice & Mutton 1,700 1,800 1,800 2,000 2,100 2,400
TOTAL 97,300 104,600 107,500 114,800 123,500 142,300

3 of 4
[Link] 12/08/2023

Morning Bean
Hot Drink Café
Units Sold per Month Top Sellers
Category Item Jul Aug Sep Oct Nov Dec TOTAL
Vanilla Hazelnut Latte 11,000 10,600 9,800 8,300 7,800 10,900 111,100
White Chocolate Mocha 8,400 8,100 7,500 6,400 6,000 8,300 85,000
Caramel Macchiato 2,600 2,500 2,300 2,000 1,800 2,600 26,300
Hazelnut Mocha 4,500 4,300 4,000 3,400 3,200 4,500 45,700
Speciality

Classic Latte 8,400 8,100 7,500 6,400 6,000 8,300 85,000


Classic Mocha 3,200 3,100 2,900 2,500 2,300 3,200 32,800
Tea Latte 7,100 6,800 6,300 5,400 5,000 7,000 71,700
Cappuccino 3,900 3,700 3,500 2,900 2,700 3,800 39,000
Vanilla Hazelnut Blender 9,100 8,700 8,100 6,900 6,400 9,000 91,700
Caramel Blender 6,500 6,200 5,800 4,900 4,600 6,400 65,500
Strawberry Banana Smoothie 12,900 12,400 11,500 9,800 9,200 12,800 130,800
Sandwiches Smoothies

Mixed Berry Smoothie 8,600 8,300 7,700 6,500 6,100 8,500 87,100
Blackberry Lemonade 6,500 6,200 5,800 4,900 4,600 6,400 65,500
Strawberry Lemonade 10,800 10,400 9,600 8,200 7,600 10,700 109,100
Classic Lemonade 4,300 4,100 3,800 3,300 3,100 4,300 43,500
Applewood Bacon & Cheddar 3,500 3,300 3,100 2,600 2,400 3,400 34,900
Turkey-Sausage & Cheddar 6,000 5,800 5,400 4,600 4,300 6,000 61,100
Ham & Swiss 3,000 2,900 2,700 2,300 2,100 3,000 30,500
Sante Fe 5,400 5,200 4,800 4,100 3,800 5,300 54,400
Florentine 3,700 3,500 3,300 2,800 2,600 3,600 37,000
Chicken Noodle 5,000 4,800 4,500 3,800 3,600 5,000 50,900
Soups

Turkey Chili 2,900 2,800 2,600 2,200 2,000 2,800 29,100


Brocolli Cheddar 4,000 3,900 3,600 3,100 2,800 4,000 40,700
Wild Rice & Mutton 2,400 2,300 2,200 1,900 1,700 2,400 24,700
TOTAL 143,700 138,000 128,300 109,200 101,700 142,200 1,453,100

4 of 4

You might also like