15 Walnut

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)

30.1%

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

▲ worse ▼ better vs prior 4-wk

Beverage COGS (Wk 27)

31.1%

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

▲ worse ▼ better vs prior 4-wk

Total COGS

32.1%

4-wk dollar-weighted

Weekly Detail

Week	Dates	Gross Sales	Food %	Bev %	Total COGS $	COGS %
Wk 24	6/7–6/13	$45,118	33.5%	13.5%	$13,694	30.4%
Wk 25	6/14–6/20	$41,735	31.2%	28.5%	$12,997	31.1%
Wk 26	6/21–6/27	$45,986	34.3%	32.2%	$15,963	34.7%
Wk 27	6/28–7/4	$40,870	30.1%	31.1%	$13,056	31.9%
4-Week Avg		—	32.4% ▲	26.4% ▲	—	32.1%

COGS Trend & Gross Sales

Food Category Trends (4-Week vs Prior) ▲

Category	4-Wk	Prior 4-Wk	Change $
Meat/Poultry	$9,982	$11,165	-1,183
Sushi	$3,858	$2,907	+951
Fish/Seafood	$6,951	$7,399	-448
Produce	$7,107	$7,518	-410
Dry Goods	$9,468	$9,398	+70
Bread/Bakery	$1,519	$1,450	+69
Dairy	$2,703	$2,643	+60
Food Misc	$0	$0	+0

Week 27 Food Purchases — Vendor / Item

Vendor / Item	GL	Pack	Qty	Amount
►US Foods				$4,216.06
FRENCH FRIES	4035	CA 6/5 LB	9	$425.79
CHICKEN - BREAST	4065	CA 4/5 LB	4	$292.68
BACON	4065	CA 1/15 LB	3	$223.17
BEEF - PATTY	4065	CA 20/8 OZ	4	$211.92
DUMPLINGS - ALL	4035	CA 120/1 OZ	3	$150.15
MILK - EVAPORATED	4035	CA 6/#10 CN	2	$140.34
BEEF - PASTRAMI	4065	LB WEIGHT	19.64	$133.36
CALAMARI	4040	CA 2/10/8 OZ	2	$124.42
CHICKEN - WINGS	4065	CA 4/10 LB	2	$104.42
CHICKEN - DICED	4065	LB WEIGHT	40	$103.60
AVOCADO	4080	CA 1/48 EA	2	$100.20
CHICKEN - WHOLE	4065	LB WEIGHT	45.5	$90.09
POTATO - YUKON - GOLD	4080	CA 1/50 LB	2	$85.16
BUTTER - ALL	4030	CA 36/1 LB	1	$77.89
BRUSSELL SPROUTS	4080	CA 2/5 LB	3	$75.30
WALNUT - PIECES	4035	CA 3/2 LB	1	$69.65
CRANBERRIES - DRIED	4035	CA 1/10 LB	2	$68.62
SHRIMP - 16/20	4040	CA 5/2 LB	1	$68.48
CHEESE - CHEDDAR	4030	CA 4/2.5 LB	1	$62.07
CHEESE - GOAT	4030	CA 2/2 LB	2	$61.08
WALNUT - PIECES	4035	CA 1/5 LB	1	$59.05
CASHEWS	4035	CA 1/5 LB	1	$52.23
CUCUMBERS	4080	CA 1/12 EA	4	$50.80
MANGOES	4080	CA 1/8-14 EA	3	$50.67
BREAD - NAAN	4020	CA 6/8/4.4 OZ	1	$48.97
PASTA - DRY	4035	CA 4/5 LB	1	$48.69
STRING BEANS	4080	CA 2/5 LB	2	$46.94
MAYO - HEAVY	4035	CA 4/1 GAL	1	$46.17
CHEESE - CHEDDAR - SHREDDED	4030	CA 4/5 LB	1	$44.08
CREAM - HEAVY	4030	CA 12/1 QT	1	$42.21
EDAMAME - SHELLED	4035	CA 6/2.5 LB	1	$41.91
CAULIFLOWER	4080	CA 1/12 EA	1	$40.22
CHEESE - MUNSTER - SLICED	4030	CA 4/2.5 LB	1	$39.98
CHEESE - SWISS	4030	CA 4/2.5 LB	1	$38.77
BROCCOLINI	4080	CA 1/18 EA	1	$36.95
CREAM - WHIPPED	4030	CA 12/15 OZ	1	$36.31
PEPPER - ROASTED RED - CANNED	4035	CA 12/28 OZ	1	$35.18
MANGO - CHUNK	4080	CA 2/5 LB	1	$34.44
TOMATO - 5x6	4080	CA 1/25 LB	1	$32.23
TORTILLA - CHIP - RAW - ALL	4035	CA 1/30 LB	1	$32.19
KALE - BABY	4080	CA 1/3 LB	2	$31.64
ORANGE	4080	CA 1/12 EA	2	$30.90
PORK - GROUND	4065	CA 4/2.5 LB	1	$30.88
FLOUR - CORN	4035	CA 1/50 LB	1	$30.87
PICKLES - DILL - CHIPS	4035	CA 1/5 GAL	1	$30.38
LETTUCE - GEM	4080	CA 8/4 EA	1	$30.11
EGG - WHOLE	4030	CA 1/15 DZ	1	$29.99
SALAD MIX	4080	CA 1/3 LB	3	$29.91
ONION - SWEET	4080	CA 1/50 LB	1	$29.52
BEETS	4080	CA 1/25 LB	1	$29.19
ICE CREAM - VANILLA	4030	CA 1/3 GAL	1	$27.88
TORTILLA - FLOUR - 8"-12"	4020	CA 8/12 EA	1	$26.99
CHEESE - FETA	4030	CA 2/5 LB	1	$25.78
CHIVES	4080	CA 1/1 LB	2	$25.34
CARROTS	4080	CA 1/25 LB	1	$24.77
APPLES - ALL	4080	CA 1/20-22 EA	1	$23.89
GARLIC - PEELED	4080	EA 1/5 LB	1	$23.79
PEPPER - RED	4080	CA 1/10 LB	1	$23.79
CHEESE - CHEDDAR	4030	CA 6/1.5 LB	1	$23.03
ONION - RED	4080	CA 1/25 LB	1	$22.34
SAUCE - BUFFALO	4035	EA 1/1 GAL	1	$21.35
GARLIC - PEELED	4080	EA 1/5.000 LB	1	$19.74
ARUGULA - BABY	4080	CA 2/2 LB	1	$18.85
LIMES	4080	CA 1/48 EA	1	$17.77
VINEGAR - WHITE DISTILLED	4035	CA 4/1 GAL	1	$16.60
PEPPER - JALAPENO - SLICED	4035	EA 1/1 GAL	1	$11.00
BASIL	4080	CA 1/1 LB	1	$9.83
STRAWBERRIES - FRESH	4080	EA 1/1 LB	3	$9.69
CILANTRO	4080	EA 1/1 LB	1	$6.96
MINT	4080	CA 1/4 OZ	1	$6.90
►Ipswich Shellfish Co				$1,771.48
TUNA - SUSHI	4095	LB WEIGHT	46.4	$648.40
HADDOCK	4040	LB WEIGHT	40	$588.00
SALMON	4040	LB WEIGHT	43.15	$453.08
OYSTERS	4040	CA 1/100 CT	1	$82.00
►Baldor Boston				$1,528.34
LETTUCE - GEM	4080	24 CT	4	$194.00
CHEESE - GOAT	4030	CA 2/2 LB	1	$136.17
FRENCH FRIES	4035	6/5 LB	2	$118.58
OIL - TRUFFLE - WHITE	4035	1 LT	2	$88.38
LETTUCE - ARCADIA	4080	CA 4/3 LB	2	$86.00
PUREE - MANGO	4035	EA 6/30 OZ	4	$82.64
BRUSSELL SPROUTS	4080	CA 2/5 LB	2	$66.22
CHEESE - MONTEREY JACK - BLEND	4030	5 LB	4	$65.38
BREAD - GLUTEN FREE - BURGER BUN	4020	24 CT	1	$54.89
CHERRIES - DRIED	4035	5 LB	1	$54.49
SPICE - BLACK PEPPER - FINE	4035	5 LB	1	$53.59
CHEESE - CHEDDAR	4030	CA 4/2.5 LB	1	$53.49
PEPPER - SHISHITO	4080	1/2 BSH	1	$45.50
TOMATO - HEIRLOOM	4080	10 LB	1	$43.00
KALE - BABY	4080	3 LB	2	$37.50
CHEESE - FETA	4030	8 LB	1	$36.49
STRING BEANS	4080	CA 2/5 LB	1	$33.75
SPICE - GARLIC - POWDER	4035	5 LB	1	$32.29
SOUR CREAM	4030	5 LB	3	$31.17
SPICE - ONION POWDER	4035	5 LB	1	$29.79
SPICE - PAPRIKA	4035	5 LB	1	$28.19
LETTUCE - ARCADIA	4080	3 LB	2	$27.28
OIL - EVOO	4035	3 LT	1	$26.93
RICE - JASMIN	4035	CA 25 LB	1	$22.69
HONEY	4035	5 LB	1	$19.49
SPICE - OREGANO - DRIED	4035	1.25 LB	1	$16.29
CUCUMBERS	4080	12 CT	1	$14.13
BALSAMIC GLAZE	4035	8.45 OZ	1	$9.79
GINGER - FRESH	4080	1 LB	1	$8.25
SPICE - CELERY SEED - WHOLE	4035	1 LB	1	$6.79
BASIL - DRIED	4035	5 OZ	1	$5.19
►True World Foods Boston LLC				$1,209.50
SHRIMP - TEMPURA	4095	CA 1/120 EA	4	$268.00
KANIKAMA STICK - IMITATION CRAB	4095	CA 20/1.1 lb	1	$154.00
TUNA - GROUND	4095	LB WEIGHT	22	$152.90
EEL SAUCE	4095	CA 6/.5 GAL	6	$126.00
EDAMAME	4080	LB WEIGHT	40	$114.00
SHALLOTS - PRE FRIED	4035	15 OZ	12	$114.00
RICE - SUSHI	4095	CA 50 LB	2	$90.00
SEAWEED SALAD	4095	LB WEIGHT	17.6	$83.60
MIZKAN JUN GENMAI BLK VINEGAR	4095	3.97 GAL	1	$65.00
GARI - PICKLED GINGER	4095	20 LB	1	$42.00
►Boston Bread Service				$187.20
BREAD - BURGER BUN - ALL	4020	CA 96 ea	2	$114.32
BREAD - CHALLAH - LOAF	4020	LOAF (EA)	4	$27.96
BREAD - RYE - ALL	4020	LOAF (EA)	3	$20.97
BREAD - BAGUETTE	4020	LOAF (EA)	6	$18.96
LAVASH - WHITE - WRAPS	4020	BAG 12 ea	1	$4.99
►Deano's Pasta				$94.00
RAVIOLI - ALL	4035	CA 6 lb	1	$48.00
PASTA - FRESH	4035	EA 1/6LB	2	$46.00

Beverage Subcategories ▲

Beer

27.5%

$3,018 / $10,971

Liquor

21.7%

$4,202 / $19,395

Wine

23.6%

$2,755 / $11,676

NA Beverage

61.3%

$1,981 / $3,231

Week 27 Beverage Purchases — Vendor / Item

Vendor / Item	GL	Pack	Qty	Amount
►US Foods				$676.70
MARASCHINO CHERRIES	4070	3 KG	1	$129.92
SYRUP - DIET PEPSI - BIB	4070	CA 1/5 GAL	1	$115.95
SYRUP - PEPSI - BIB	4070	CA 1/5 GAL	1	$115.95
SYRUP - LEMON LIME - BIB	4070	CA 1/3 GAL	1	$71.94
SYRUP - LEMONADE - BIB	4070	CA 1/3 GAL	1	$71.94
JUICE - PINEAPPLE	4070	CA 48/6 OZ	1	$40.76
ROOT BEER - PACKAGE	4070	CA 6/4/12 OZ	1	$34.67
JUICE - APPLE	4070	CA 8/60 OZ	1	$31.99
MARASCHINO CHERRIES	4070	EA 1/128 OZ	1	$27.16
MILK	4070	CA 4/1 GAL	1	$20.27
WATER - STILL	4070	CA 6/1 GAL	1	$16.15
►M. S. Walker				$666.81
CATENA - MALBEC	4010	CA 12/750ml	1	$124.00
CASAMIGOS - TEQUILA - BLANCO	4005	BTL 1/L	2	$101.78
KONO - SAUVIGNON BLANC	4010	CA 12/750ml	1	$96.00
TITO'S - VODKA	4005	BTL 1/L	3	$70.17
CHARTREUSE - CORDIAL - YELLOW	4005	BTL 1/750ml	1	$57.40
CASAMIGOS - TEQUILA - ANEJO	4005	BTL 1/750ml	1	$53.39
LUNAZUL - TEQUILA - BLANCO	4005	BTL 1/L	2	$38.30
APEROL	4005	BTL 1/L	1	$32.39
LUSTAU - ROJO - VERMUT	4010	BTL 1/750ml	2	$31.47
MATHILDE - CORDIAL - FRAMBOISE	4005	BTL 1/750ml	1	$27.05
EVAN WILLIAMS - BOURBON	4005	BTL 1/L	1	$18.07
CORDIAL - AMARETTO	4005	BTL 1/L	2	$16.79
►Martignetti Companies				$489.52
MICHTERS - WHISKEY - BOURBON US 1	4005	BTL 1/750ml	3	$116.82
OBAN - SCOTCH - 14 YR	4005	BTL 1/750ml	1	$65.54
THE BOTANIST - GIN - ISLAND DRY	4005	BTL 1/L	1	$54.42
DON JULIO - TEQUILA - BLANCO	4005	BTL 1/L	1	$51.87
JAMESON - WHISKEY	4005	BTL 1/L	1	$40.94
BULLEIT - WHISKEY - BOURBON	4005	BTL 1/L	1	$40.00
MILAGRO - TEQUILA - SILVER	4005	BTL 1/L	1	$39.44
DEL MAGUAY - MEZCAL - VIDA	4005	BTL 1/750ml	1	$32.94
TANQUERAY - GIN	4005	BTL 1/L	1	$32.60
MYER'S - RUM - PLATINUM	4005	BTL 1/L	1	$14.95
►Seaboard Products				$410.00
MAINE BEER - KEG	4000	KEG 15.5g	1	$320.00
ALLAGASH - KEG	4000	KEG 5.16g	1	$90.00
►Southern Glazer's Beverage Company				$319.51
JACK DANIELS -WHISKEY	4005	BTL 1/L	3	$103.17
WOODFORD - WHISKEY - BOURBON - RESERVE	4005	BTL 1/L	2	$86.78
BOMBAY SAPPHIRE - GIN	4005	BTL 1/L	2	$67.78
CYNAR - AMARO	4005	BTL 1/L	2	$61.78
►Craft Collective Homegrown				$314.00
AUSTIN STREET BREWERY - KEG	4000	KEG 15.5g	1	$239.00
GRIMM - KEG	4000	KEG 5.2g	1	$75.00
►Atomic Coffee Roasters				$185.00
COFFEE - REGULAR	4070	5 LB	2	$120.00
COFFEE - DECAF	4070	5 LB	1	$65.00
►Merrimack Valley Distributing Co.				$174.60
CORONA - PACKAGE	4000	CA 24/12 fl oz	2	$68.60
YUENGLING - TRADITIONAL LAGER - PACKAGE	4000	CA 24/12 fl oz	2	$56.00
PABST - BLUE RIBBON - PACKAGE	4000	CA 24/16 fl oz	2	$50.00
►Rockport Brewing Company				$95.00
ROCKPORT BREWING - KEG	4000	KEG 1/6 bbl	1	$95.00
►Baldor Boston				$87.59
NATALIES - ORANGE JUICE	4070	CA 4/1 GAL	1	$61.00
JUICE - LIME - BAR	4070	CA 6/32 fl oz	1	$26.59

Paper Goods (GL 6120)

Week	Amount
Wk 24	$820.54
Wk 25	$261.77
Wk 26	$452.52
Wk 27	$630.85
4-Wk Total	$2,165.68

Top 30 Vendors — Week 27

#	Vendor	Week 27 Spend
1	US Foods	$5,113.56
2	Ipswich Shellfish Co	$1,771.48
3	Baldor Boston	$1,615.93
4	True World Foods Boston LLC	$1,209.50
5	TriMark United East	$911.74
6	M. S. Walker	$660.16
7	Martignetti Companies	$484.62
8	Seaboard Products	$410.00
9	Southern Glazer's Beverage Company	$316.31
10	Boston Bread Service	$191.08
11	Atomic Coffee Roasters	$185.00
12	Merrimack Valley Distributing Co.	$181.80
13	Craft Collective Homegrown	$164.00
14	Rockport Brewing Company	$95.00
15	Deano's Pasta	$94.00

Price Increases

Price Decreases

Items Compared

↑ Price Increases (Wk 26 → Wk 27)

Item	Vendor	Prior $/unit	Cur $/unit	Change
OIL - TRUFFLE - WHITE	Baldor Boston	$31.18	$44.19	+$13.01
LETTUCE - GEM	Baldor Boston	$37.62	$48.50	+$10.88
PEPPER - RED	US Foods	$14.34	$23.79	+$9.45
BACON	US Foods	$63.53	$71.67	+$8.14
CHICKEN - BREAST	US Foods	$65.39	$73.17	+$7.78
STRING BEANS	Baldor Boston	$27.57	$33.75	+$6.18
OYSTERS	Ipswich Shellfish Co	$76.00	$82.00	+$6.00
NATALIES - ORANGE JUICE	Baldor Boston	$57.57	$61.00	+$3.43
CREAM - HEAVY	US Foods	$39.21	$42.21	+$3.00
TOMATO - 5x6	US Foods	$29.23	$32.23	+$3.00
SOUR CREAM	Baldor Boston	$8.16	$10.39	+$2.23
TORTILLA - FLOUR - 8"-12"	US Foods	$24.87	$26.99	+$2.12
BRUSSELL SPROUTS	Baldor Boston	$31.31	$33.11	+$1.80

↓ Price Decreases (Wk 26 → Wk 27)

Item	Vendor	Prior $/unit	Cur $/unit	Change
CHEESE - CHEDDAR	US Foods	$62.07	$42.55	$19.52
ICE CREAM - VANILLA	US Foods	$43.45	$27.88	$15.57
AVOCADO	US Foods	$58.95	$50.10	$8.85
CARROTS	US Foods	$31.94	$24.77	$7.17
POTATO - YUKON - GOLD	US Foods	$48.57	$42.58	$5.99
SHRIMP - 16/20	US Foods	$73.46	$68.48	$4.98
CALAMARI	US Foods	$66.96	$62.21	$4.75
PICKLES - DILL - CHIPS	US Foods	$34.99	$30.38	$4.61
PASTA - FRESH	Deano's Pasta	$25.33	$23.00	$2.33
HADDOCK	Ipswich Shellfish Co	$16.43	$14.70	$1.73
MILK	US Foods	$21.47	$20.27	$1.20
LIMES	US Foods	$18.89	$17.77	$1.12

Generated July 07, 2026 • Serenitee Restaurant Group