Alchemy

4-Week Rolling COGS Report — Week 27 (6/28–7/4)

Summary

Food Detail

Beverage Detail

Paper Goods

By Vendor

💰 Price Variance

Food COGS (Wk 27)

32.7%

4-wk avg: 30.7% ▲ · tgt 29.0%

▲ worse ▼ better vs prior 4-wk

Beverage COGS (Wk 27)

25.8%

4-wk avg: 27.2% ▲ · tgt 21.5%

▲ worse ▼ better vs prior 4-wk

Total COGS

30.9%

4-wk dollar-weighted

Weekly Detail

Week	Dates	Gross Sales	Food %	Bev %	Total COGS $	COGS %
Wk 24	6/7–6/13	$97,262	28.8%	19.6%	$26,431	27.2%
Wk 25	6/14–6/20	$101,435	32.4%	33.0%	$34,210	33.7%
Wk 26	6/21–6/27	$109,815	29.6%	29.5%	$33,686	30.7%
Wk 27	6/28–7/4	$75,588	32.7%	25.8%	$24,277	32.1%
4-Week Avg		—	30.7% ▲	27.2% ▲	—	30.9%

COGS Trend & Gross Sales

Food Category Trends (4-Week vs Prior) ▲

Category	4-Wk	Prior 4-Wk	Change $
Sushi	$9,051	$11,815	-2,764
Fish/Seafood	$19,150	$16,711	+2,439
Meat/Poultry	$20,142	$21,793	-1,651
Dairy	$3,592	$3,898	-306
Bread/Bakery	$3,004	$2,788	+216
Dry Goods	$13,923	$13,772	+151
Produce	$9,451	$9,516	-65
Food Misc	$0	$0	+0

Week 27 Food Purchases — Vendor / Item

Vendor / Item	GL	Pack	Qty	Amount
►US Foods				$4,871.22
FRENCH FRIES	4035	CA 6/4.5 LB	20	$879.40
CHICKEN - BREAST	4065	CA 4/5 LB	7	$560.77
PORK - RIBS	4065	LB WEIGHT	96.62	$422.23
CHICKEN - WINGS	4065	CA 4/10 LB	8	$417.68
BEEF - PATTY	4065	CA 32/8 OZ	4	$323.84
BACON	4065	CA 1/15 LB	3	$224.88
SWEET POTATO FRIES	4035	CA 5/3 LB	5	$223.00
BEEF - PATTY	4065	CA 56/4 OZ	3	$194.88
BEEF - TENDERLOIN	4065	LB WEIGHT	9.8	$185.71
DEMI GLACE - VEAL	4035	CA 1/16 LB	1	$132.21
MAYO - HEAVY	4035	CA 4/1 GAL	3	$124.02
AVOCADO - PULP	4035	CA 8/2 LB	2	$122.26
CHICKEN - TENDERS	4065	LB WEIGHT	20	$77.80
BACON - CHOPPED	4065	CA 2/5 LB	1	$75.88
CRAB - LUMP - SUSHI	4095	CA 6/1 LB	1	$69.87
KETCHUP - POUCH	4035	CA 6/114 OZ	2	$68.08
BEEF/PORK - GROUND BLEND	4065	CA 5/2 LB	1	$67.93
SAUSAGE - ANDOUILLE	4065	LB WEIGHT	10.82	$64.16
UDON NOODLE	4035	CA 8/2.5 LB	1	$59.99
OIL - BLENDED	4035	CA 4/1 GAL	1	$55.66
BREAD - NAAN	4020	CA 6/8/4.4 OZ	1	$48.97
MILK - CONDENSED - SWEETENED	4030	CA 24/14 OZ	1	$48.87
SAUCE - NASHVILLE HOT	4035	CA 4/.5 GAL	1	$47.30
TORTILLA - FLOUR - 8"-12"	4020	CA 12/12 EA	1	$44.48
BREAD - GLUTEN FREE - BURGER BUN	4020	CA 24/3.3 OZ	1	$43.78
WAFFLES - FROZEN	4035	CA 26/3.17 OZ	1	$39.51
TOMATOES - PEELED - CANNED	4035	CA 6/#10 CN	1	$37.32
VINEGAR - CIDER	4035	CA 4/1 GAL	1	$36.71
WALNUT - PIECES	4035	CA 1/5 LB	1	$31.55
FLOUR - CORN	4035	CA 1/50 LB	1	$30.87
WORCESTERSHIRE SAUCE	4035	EA 1/1 GAL	1	$30.36
PASTA - DRY	4035	CA 2/10 LB	1	$28.76
RANCH DRESSING MIX	4035	CA 18/3.2 OZ	1	$27.67
PEPPER - CHIPOTLE - CANNED	4035	CA 12/7 OZ	1	$24.82
►Ipswich Shellfish Co				$3,206.44
OYSTERS	4040	CA 1/100 CT	11	$1,005.00
LOBSTER - CLAW/KNUCKLE - FROZEN	4040	LB WEIGHT	16	$608.00
SALMON	4040	LB WEIGHT	57.47	$603.44
COD	4040	LB WEIGHT	15	$228.75
SHRIMP - 8/12	4040	LB WEIGHT	20	$217.00
CALAMARI	4040	LB WEIGHT	25	$196.25
OYSTERS - SHUCKED	4040	1 GAL	1	$110.00
CLAMS - COUNTNECKS	4040	CA 1/100 CT	2	$94.00
CRAB - LUMP	4040	LB WEIGHT	25	$79.50
SHRIMP - 21/25	4040	LB WEIGHT	10	$64.50
►New England Mutual Trading				$2,847.35
BEEF - RIBEYE - CAP	4065	LB WEIGHT	21.15	$613.35
TUNA - GROUND	4095	CA 22 lb	2	$276.00
SHRIMP - TEMPURA	4095	CA 100/EA	4	$240.00
SEAWEED SALAD	4095	EA 1/4.4 lb	8	$152.00
RICE - BLUE	4095	40 LB	4	$144.00
EDAMAME	4080	CA 24/14.1 OZ	3	$129.00
KANIKAMA STICK - IMITATION CRAB	4095	CA 20/500 g	1	$120.00
NORI - FULL CUT	4095	CA 10/50 EA	1	$118.00
NORI - HALF CUT	4095	CA 10/100 CT	1	$118.00
SOY WRAPPER	4095	PAK 20 EA	10	$110.00
TOBIKO - ALL	4095	EA 1.1 LB	3	$96.00
VINEGAR - SUSHI	4095	CA 4 GAL	2	$92.00
GARI - PICKLED GINGER	4095	CA 18 LB	2	$90.00
EEL SAUCE	4095	CA 6/64 FL OZ	1	$88.00
TEMPURA - SWEET POTATO	4095	CA 10/1.1 LB	1	$88.00
TONKATSU SAUCE	4095	CA 6/1.8L	1	$68.00
TAMARI - GLUTEN FREE SOY	4095	CA 6/1.8L	1	$66.00
SRIRACHA	4095	CA 12/28 fl oz	1	$48.00
SWEET CHILI SAUCE	4095	CA 12/32 OZ	1	$40.00
UDON NOODLE	4035	CA 8/5X8oz	1	$38.00
MIOLA POWDER - POTATO STARCH	4095	EA 10/2.2LB	1	$35.00
SOY SAUCE - PACKETS - GLUTEN FREE	4095	CA 500/EA	1	$34.00
SOY SAUCE - PACKETS	4095	CA 500/EA	1	$25.00
DASHI - POWDER	4095	2.2 LB	1	$10.00
SHICHIMI TOGARASHI	4095	PAK 10.6oz	1	$9.00
►Baldor Boston				$2,535.87
AVOCADO	4080	48 CT	4	$272.43
CAULIFLOWER	4080	12 CT	4	$151.60
LETTUCE - ROMAINE	4080	24 CT	2	$147.28
PORK - RACK	4065	LB WEIGHT	13.58	$143.40
BROCCOLINI	4080	18 CT	3	$111.20
PISTACHIO - SHELLED - RAW	4035	5 LB	1	$82.80
LETTUCE - GREEN LEAF	4080	10 LB	2	$79.31
CUCUMBERS	4080	12 CT	6	$75.88
TOMATO - CHERRY	4080	CA 12/1 PT	3	$73.95
PUREE - STRAWBERRY	4035	EA 6/30 OZ	4	$73.00
PEPPER - SHISHITO	4080	1/2 BSH	2	$71.80
PANKO - GLUTEN FREE	4035	10 LB	2	$70.78
PUREE - MANGO	4035	EA 6/30 OZ	4	$68.52
TOMATO - 5x6	4080	25 LB	2	$61.54
WATERMELON	4080	1 PC	5	$53.00
MICRO GREENS	4080	8 OZ	2	$51.60
CHERRIES - DRIED	4035	5 LB	1	$50.13
PUREE - BLOOD ORANGE	4035	EA 6/30 OZ	2	$49.76
LETTUCE - HYDRO BOSTON	4080	CA 12 EA	2	$48.00
WATERMELON - MINI	4080	6 CT	1	$45.50
PEPPER - RED	4080	11 LB	2	$38.24
LETTUCE - FRISEE	4080	12 CT	1	$36.75
LETTUCE - ROMAINE - HEARTS	4080	CA 20 LB	1	$36.75
SHALLOTS - PEELED	4080	5 LB	2	$36.06
LETTUCE - FRISEE	4080	CA 12 EA	1	$34.63
BROCCOLI	4080	CA 4/3 LB	1	$33.71
MUSHROOM - OYSTER	4080	3 LB	1	$33.50
LETTUCE - ROMAINE - BABY	4080	24 CT	1	$31.57
SEABEANS - SALTY FINGERS	4080	1 LB	2	$31.00
CELERY	4080	12 CT	1	$30.54
CHIVES	4080	1 LB	2	$30.48
OIL - TRUFFLE - WHITE	4035	1 LT	1	$29.28
POTATO - SWEET - WHITE	4080	CA 20 LB	1	$29.00
MANGOES	4080	6-9CT	2	$27.02
SCALLIONS	4080	48 CT	1	$23.86
POTATO - YUKON - GOLD	4080	50 LB	1	$23.68
APPLES - ALL	4080	20 CT	1	$23.12
ONION - RED	4080	25 LB	1	$22.43
PEPPER - POBLANO	4080	CA 10 LB	1	$20.24
PEPPER - YELLOW	4080	CA 11 LB	1	$20.20
PUREE - PRICKLY PEAR	4035	EA 6/30 OZ	1	$19.67
GARLIC - PEELED	4080	5 LB	1	$18.08
BASIL	4080	1 LB	2	$17.84
TOMATILLOS	4080	10 LB	1	$15.73
SPINACH - BABY	4080	4 LB	1	$14.88
SPINACH - BABY	4080	CA 2/2 LB	1	$14.78
WATERCRESS	4080	1.5 LB	1	$14.02
OYSTER SAUCE	4035	CA 5 LB	1	$11.99
TASSO HAM	4065	LB WEIGHT	1.29	$10.75
BANANAS	4080	CA 10 LB	1	$10.02
GREEN PEPPERCORNS	4035	3.5 OZ	2	$8.58
CILANTRO	4080	4 OZ	1	$3.41
PARSLEY	4080	3 CT	1	$2.58
►Halibut Jack Seafood				$1,434.86
TUNA	4040	LB WEIGHT	55.9	$1,003.40
HALIBUT	4040	LB WEIGHT	18.8	$431.46
►Paul W. Marks Co.				$1,001.91
FRY SHORTENING	4035	CA 35 LB	7	$261.45
BUTTER - ALL	4030	CA 36/1 LB	2	$175.12
CHEESE - FETA	4030	CA 2/8 LB	3	$142.37
PICKLES - DILL - CHIPS	4035	5 GAL	3	$94.53
CHEESE - CREAM	4030	CA 10/3 LB	1	$60.42
CHEESE - GRANA PADANO	4030	LB WEIGHT	9.1	$59.06
CHEESE - CHEDDAR	4030	CA 4/2.5 LB	1	$56.01
CHEESE - AMERICAN - SLICED	4030	CA 4/5 LB	1	$51.11
CREAM - HEAVY	4030	CA 12/32 OZ	1	$39.72
BUTTERMILK	4030	CA 12/1 QT	2	$33.16
CHEESE - RICOTTA	4030	3 LB	1	$14.56
SOUR CREAM	4030	EA 6/5 LB	2	$14.40
►Boston Bread Service				$573.68
BREAD - BURGER BUN - ALL	4020	DOZ	18	$196.02
BREAD - FOCACCIA	4020	EACH	12	$174.00
BREAD - BURGER BUN - ALL	4020	PAK 8 EA	24	$119.76
BREAD - SOURDOUGH - LOAF	4020	LOAF (EA)	10	$83.90
►Southern Glazer's Beverage Company				$68.00
KITCHEN WINE - WHITE	4035	CA 4/5 L	1	$68.00
►Martignetti Companies				$35.94
PUREE - PASSION FRUIT	4035	CA 6/16.9 FL OZ	1	$35.94

Beverage Subcategories ▲

Beer

24.8%

$6,547 / $26,382

Liquor

19.4%

$14,141 / $72,871

Wine

39.0%

$8,497 / $21,779

NA Beverage

73.0%

$5,997 / $8,219

Week 27 Beverage Purchases — Vendor / Item

Vendor / Item	GL	Pack	Qty	Amount
►Southern Glazer's Beverage Company				$1,511.35
JACK DANIELS -WHISKEY	4005	CA 12/1 LTR	1	$383.88
CAPOSALDO - PROSECCO	4010	CA 12/750ml	3	$297.00
GREY GOOSE - VODKA	4005	CA 6/1L	1	$221.94
CASAMIGOS - TEQUILA - REPOSADO	4005	CA 6/1 LTR	1	$202.94
CASAMIGOS - TEQUILA - BLANCO	4005	CA 6/1 L	1	$182.94
RAEBURN - CHARDONNAY	4010	CA 12/750 ML	1	$120.00
BURGUNDY - BOX - BAR	4010	CA 4/5 L	1	$68.00
STOLI - VODKA - RAZ	4005	BTL 1/L	1	$34.65
►Martignetti Companies				$1,486.25
KETEL ONE - VODKA	4005	CA 12/1 LTR	1	$366.65
TANQUERAY - GIN	4005	CA 12/1 LTR	1	$355.85
ABSOLUT - VODKA - PEAR	4005	CA 12/1 LTR	1	$251.93
CHATEAU DE SANCERRE - SAUVIGNON BLANC	4010	CA 12/750 ML	2	$240.00
HIGH NOON - HARD SELTZER - VARIETY PACK	4000	CA 24/355 ML	3	$141.00
MALIBU - RUM	4005	BTL 1/L	2	$51.88
COINTREAU	4005	BTL 1/L	1	$45.95
SAPPORO - LAGER - PREMIUM - PACKAGE	4000	CA 24/12 fl oz	1	$32.99
►M. S. Walker				$1,438.26
TITO'S - VODKA	4005	CA 12/1 LTR	2	$503.76
TOHU - SAUVIGNON BLANC	4010	CA 12/750ml	2	$216.00
CARMEL ROAD - PINOT NOIR - MONTEREY	4010	CA 12/750ml	2	$204.00
SCARPETTA - PINOT GRIGIO	4010	CA 12/750ml	1	$120.00
GRAINGERS DELUXE - VODKA	4005	CA 12/1 LTR	1	$119.88
CORDIAL - TRIPLE SEC	4005	CA 12/1 LTR	1	$91.99
BENVOLIO - PINOT GRIGIO	4010	CA 12/750ml	1	$84.00
JUAN GIL - SHANIA - RED	4010	CA 3/3L	1	$60.00
CHOCOLAT - CORDIAL - TRIPLE CHOCOLATE LIQUEUR	4005	BTL 1/750ml	2	$38.63
►Seaboard Products				$630.00
CORDIAL - TRIPLE SEC	4005	BTL 1/750ml	2	$236.00
ALLAGASH - KEG	4000	KEG 15.5g	1	$200.00
ANZA - TEQUILA - BLANCO	4005	CA 12/1 LTR	1	$105.00
MICHELOB ULTRA - PACKAGE	4000	CA 24/12 fl oz	2	$62.00
WATER - STILL	4070	CA 24/12 fl oz	1	$27.00
►Baldor Boston				$492.15
SUGAR - DEMERARA - BAR	4070	CA 50 LB	1	$79.58
LEMONS - BAR	4070	165 CT	1	$58.58
ORANGES - BAR	4070	56 CT	1	$50.14
PUREE - LYCHEE - BAR	4070	30 OZ	2	$49.98
PUREE - BLOOD ORANGE - BAR	4070	EA 6/30 OZ	2	$49.78
PUREE - POMEGRANATE - BAR	4070	EA 6/30 OZ	2	$43.36
LIMES - BAR	4070	CA 175 CT	1	$39.77
PUREE - PEAR - BAR	4070	EA 6/30 OZ	2	$39.72
PUREE - STRAWBERRY - BAR	4070	EA 30 OZ	2	$36.50
MILK - COCONUT - BAR	4070	CA 6/48 fl oz	1	$33.49
MINT - BAR	4070	LB WEIGHT	1	$11.25
►US Foods				$387.47
SYRUP - DR PEPPER - BIB	4070	CA 1/5 GAL	1	$130.10
SYRUP - GINGER ALE - BIB	4070	CA 1/3 GAL	1	$75.31
SYRUP - LEMON LIME - BIB	4070	CA 1/3 GAL	1	$71.94
SYRUP - LEMONADE - BIB	4070	CA 1/3 GAL	1	$71.94
JUICE - CRANBERRY	4070	CA 12/32 OZ	1	$38.18
►Paul W. Marks Co.				$254.64
JUICE - LIME - BAR	4070	CA 12/1 LTR	2	$105.84
JUICE - LEMON - BAR	4070	CA 12/1 LTR	1	$58.92
JUICE - ORANGE	4070	CA 6/.5 GAL	1	$42.89
JUICE - GRAPEFRUIT	4070	CA 6/32 fl oz	1	$30.37
MILK	4070	EA 9/.5 GAL	6	$16.62
►Merrimack Valley Distributing Co.				$209.55
SUN CRUISER - VODKA ICED TEA	4000	CA 24/12 fl oz	2	$90.00
CORONA - PACKAGE	4000	CA 24/12 fl oz	1	$34.30
CORONA - PREMIER - PACKAGE	4000	CA 24/12 fl oz	1	$30.75
COORS LIGHT - PACKAGE	4000	CA 24/12 fl oz	1	$27.25
MILLER LITE - PACKAGE	4000	CA 24/12 fl oz	1	$27.25

Paper Goods (GL 6120)

Week	Amount
Wk 24	$1,431.17
Wk 25	$1,136.76
Wk 26	$1,250.23
Wk 27	$1,291.96
4-Wk Total	$5,110.12

Top 30 Vendors — Week 27

#	Vendor	Week 27 Spend
1	US Foods	$5,313.89
2	TriMark United East	$3,802.23
3	Ipswich Shellfish Co	$3,206.44
4	Baldor Boston	$3,028.02
5	New England Mutual Trading	$2,919.60
6	Southern Glazer's Beverage Company	$1,563.55
7	Martignetti Companies	$1,508.16
8	Halibut Jack Seafood	$1,434.86
9	M. S. Walker	$1,423.87
10	Paul W. Marks Co.	$1,268.55
11	Boston Bread Service	$581.44
12	Seaboard Products	$532.40
13	Merrimack Valley Distributing Co.	$184.35

Price Increases

Price Decreases

Items Compared

↑ Price Increases (Wk 26 → Wk 27)

Item	Vendor	Prior $/unit	Cur $/unit	Change
AVOCADO	Baldor Boston	$54.48	$68.21	+$13.73
LETTUCE - ROMAINE	Baldor Boston	$60.19	$73.64	+$13.45
CHEESE - FETA	Paul W. Marks Co.	$36.22	$47.46	+$11.24
LEMONS - BAR	Baldor Boston	$49.13	$58.58	+$9.45
PEPPER - RED	Baldor Boston	$9.99	$19.12	+$9.13
CAULIFLOWER	Baldor Boston	$34.62	$37.90	+$3.28
CUCUMBERS	Baldor Boston	$10.10	$12.32	+$2.21
MANGOES	Baldor Boston	$11.35	$13.51	+$2.16
LETTUCE - FRISEE	Baldor Boston	$33.95	$35.69	+$1.74
ONION - RED	Baldor Boston	$21.20	$22.43	+$1.23

↓ Price Decreases (Wk 26 → Wk 27)

Item	Vendor	Prior $/unit	Cur $/unit	Change
RAEBURN - CHARDONNAY	Southern Glazer's Beverage Company	$135.00	$120.00	$15.00
TAMARI - GLUTEN FREE SOY	New England Mutual Trading	$78.00	$66.00	$12.00
WATERMELON	Baldor Boston	$19.62	$10.60	$9.03
LETTUCE - ROMAINE - HEARTS	Baldor Boston	$45.36	$36.75	$8.61
CILANTRO	Baldor Boston	$8.49	$3.41	$5.08
MICRO GREENS	Baldor Boston	$29.93	$25.80	$4.12
PEPPER - SHISHITO	Baldor Boston	$39.53	$35.90	$3.62
BREAD - BURGER BUN - ALL	Boston Bread Service	$8.53	$7.94	$0.59

Generated July 07, 2026 • Serenitee Restaurant Group