Morning Bean

Hot Drink Café

Author Kapish Mahajan
Date Sunday, February 6, 2022
To display sales information on items
Purpose from the Morning Bean menu
574746546.xlsx 02/06/2022 Prepare by: Kapish Mahajan

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 2017 2016 Net Change % Change
Speciality 4,464,800 3,780,427 684,373 18.10%
Smoothies 2,934,300 2,489,316 444,984 17.88%
Sandwiches 1,487,100 1,280,800 206,300 16.11%
Soups 994,600 1,050,253 (55,653) -5.30%
Total $ 9,880,800 $ 8,600,796 $ 1,280,004 14.88%

Units Sold per Month

Category Item Jan Feb Mar Apr
Vanilla Hazelnut Latte 7,400 8,000 8,200 8,800
White Chocolate Mocha 5,700 6,100 6,300 6,700
Caramel Macchiato 1,800 1,900 1,900 2,100
Hazelnut Mocha 3,100 3,300 3,400 3,600
Speciality

Classic Latte 5,700 6,100 6,300 6,700

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

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

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

7
574746546.xlsx 02/06/2022 Prepare by: Kapish Mahajan

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

7
574746546.xlsx 02/06/2022 Prepare by: Kapish Mahajan

May Jun
9,400 10,900
7,200 8,300
2,200 2,600
3,900 4,500
7,200 8,300
2,800 3,200
6,100 7,000
3,300 3,800
7,800 9,000
5,600 6,400
11,100 12,900
7,400 8,500
5,600 6,400
9,300 10,700
3,700 4,300
3,000 3,400
5,200 6,000
2,600 3,000
4,600 5,300
3,100 3,600
4,300 5,000
2,500 2,800

7
574746546.xlsx 02/06/2022 Prepare by: Kapish Mahajan

3,500 4,000
2,100 2,400
123,500 142,300

7
574746546.xlsx 02/06/2022 Prepare by: Kapish Mahajan

Top Sellers
Jul Aug Sep Oct Nov Dec TOTAL
11,000 10,600 9,800 8,300 7,800 10,900 111,100
8,400 8,100 7,500 6,400 6,000 8,300 85,000
2,600 2,500 2,300 2,000 1,800 2,600 26,300
4,500 4,300 4,000 3,400 3,200 4,500 45,700
8,400 8,100 7,500 6,400 6,000 8,300 85,000
3,200 3,100 2,900 2,500 2,300 3,200 32,800
7,100 6,800 6,300 5,400 5,000 7,000 71,700
3,900 3,700 3,500 2,900 2,700 3,800 39,000
9,100 8,700 8,100 6,900 6,400 9,000 91,700
6,500 6,200 5,800 4,900 4,600 6,400 65,500
12,900 12,400 11,500 9,800 9,200 12,800 130,800
8,600 8,300 7,700 6,500 6,100 8,500 87,100
6,500 6,200 5,800 4,900 4,600 6,400 65,500
10,800 10,400 9,600 8,200 7,600 10,700 109,100
4,300 4,100 3,800 3,300 3,100 4,300 43,500
3,500 3,300 3,100 2,600 2,400 3,400 34,900
6,000 5,800 5,400 4,600 4,300 6,000 61,100
3,000 2,900 2,700 2,300 2,100 3,000 30,500
5,400 5,200 4,800 4,100 3,800 5,300 54,400
3,700 3,500 3,300 2,800 2,600 3,600 37,000
5,000 4,800 4,500 3,800 3,600 5,000 50,900
2,900 2,800 2,600 2,200 2,000 2,800 29,100

7
574746546.xlsx 02/06/2022 Prepare by: Kapish Mahajan

4,000 3,900 3,600 3,100 2,800 4,000 40,700

2,400 2,300 2,200 1,900 1,700 2,400 24,700
143,700 138,000 128,300 109,200 101,700 142,200 1,453,100