15 Walnut

4-Week Rolling COGS Report — Week 40 (9/27–10/3)

Summary

Food Detail

Beverage Detail

Paper Goods

By Vendor

💰 Price Variance

Food COGS (Wk 40)

20.3%

4-wk avg: 25.7% ▼ · tgt 29.0%

▲ worse ▼ better vs prior 4-wk

Beverage COGS (Wk 40)

26.9%

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

▲ worse ▼ better vs prior 4-wk

Total COGS

26.9%

4-wk dollar-weighted

Weekly Detail

Week	Dates	Gross Sales	Food %	Bev %	Total COGS $	COGS %
Wk 37	9/6–9/12	$43,983	22.2%	28.6%	$10,879	24.7%
Wk 38	9/13–9/19	$41,834	33.8%	18.5%	$12,930	30.9%
Wk 39	9/20–9/26	$42,929	26.4%	25.9%	$11,961	27.9%
Wk 40	9/27–10/3	$41,504	20.3%	26.9%	$10,000	24.1%
4-Week Avg		—	25.7% ▼	25.0% ▲	—	26.9%

COGS Trend & Gross Sales

Food Category Trends (4-Week vs Prior) ▼

Category	4-Wk	Prior 4-Wk	Change $
Meat/Poultry	$7,134	$8,196	-1,062
Sushi	$1,410	$1,786	-376
Dry Goods	$7,344	$7,689	-345
Fish/Seafood	$7,309	$7,544	-235
Dairy	$2,097	$2,225	-128
Produce	$4,504	$4,559	-56
Bread/Bakery	$995	$1,002	-7
Food Misc	$0	$0	+0

Week 40 Food Purchases — Vendor / Item

Vendor / Item	GL	Pack	Qty	Amount
►US Foods				$2,299.74
BEEF - PATTY	4065	CA 20/8 OZ	6	$353.90
CHICKEN - BREAST	4065	CA 4/5 LB	4	$299.68
FRENCH FRIES	4035	CA 6/4.5 LB	4	$175.88
CAKE - SPECIALTY	4035	CA 1/160 OZ	2	$133.50
CREAM - HEAVY	4030	CA 12/1 QT	3	$122.99
DUMPLINGS - ALL	4035	CA 120/1 OZ	2	$101.98
PASTA - DRY	4035	CA 4/5 LB	2	$98.46
PROSCIUTTO	4065	LB WEIGHT	8.56	$82.43
BUTTER - ALL	4030	CA 36/1 LB	1	$80.77
PIE - KEY LIME	4035	CA 2/80 OZ	1	$75.71
BACON	4065	CA 1/15 LB	1	$69.91
CHEESE - GOAT	4030	CA 2/2 LB	2	$64.46
CHICKEN - WINGS	4065	CA 4/10 LB	1	$62.78
OIL - BLENDED	4035	CA 4/1 GAL	1	$59.77
CHICKEN - TENDERS	4065	CA 4/10 LB	1	$57.54
SWEET CHILI SAUCE	4095	CA 3/8.8 LB	1	$54.06
CHEESE - MONTEREY JACK - BLEND	4030	CA 4/5 LB	1	$48.80
ICE CREAM - VANILLA	4030	CA 1/3 GAL	1	$45.54
CLAM BASE	4035	CA 6/1 LB	1	$44.98
CRACKERS - OYSTER	4035	CA 150/.5 OZ	2	$41.22
MAYO - HEAVY	4035	CA 4/1 GAL	1	$41.13
KETCHUP - BOTTLE	4035	CA 1000/9 GR	1	$35.61
COCONUT MILK	4035	CA 12/13.5 OZ	1	$34.56
KETCHUP - POUCH	4035	CA 6/114 OZ	1	$33.03
EDAMAME	4080	CA 6/2.5 LB	1	$31.58
ANCHOVY - FILET	4035	EA 1/13 OZ	2	$30.30
PASTA - DRY	4035	CA 2/5 LB	1	$19.17
►Baldor Boston				$1,339.87
ASPARAGUS	4080	11 LB	2	$97.06
NDUJA	4065	CA 6 lb	1	$87.99
BROCCOLINI	4080	CA 3/2 LB	3	$86.46
AVOCADO	4080	48 CT	2	$83.90
LETTUCE - ARCADIA	4080	CA 4/3 LB	2	$69.94
TORTILLA - CORN - 6"	4020	CA 30 X 32ea	1	$59.74
NECTARINES	4080	CA 15 LB	1	$51.25
MANGOES	4080	6-9CT	3	$48.94
BREAD - GLUTEN FREE - BURGER BUN	4020	24 CT	1	$48.04
LETTUCE - GEM	4080	42 CT	1	$38.84
LETTUCE - GEM	4080	32 CT	1	$37.00
TOMATO - HEIRLOOM	4080	10 LB	1	$37.00
LETTUCE - GEM	4080	24 CT	1	$36.97
LIMES	4080	48 CT	2	$36.12
TOMATO - 5x6	4080	25 LB	1	$33.38
SOY SAUCE - PACKETS - GLUTEN FREE	4095	CASE	1	$32.78
BOK CHOY - BABY	4080	10 LB	1	$30.73
OIL - TRUFFLE - WHITE	4035	1 LT	1	$29.28
ONION - SPANISH	4080	CA 50 LB	1	$29.00
SCALLIONS	4080	48 CT	1	$27.03
COCONUT - SHREDDED	4035	CA 5 LB	1	$26.35
CABBAGE - GREEN	4080	3 CT	2	$26.00
ZUCCHINI	4080	CA 18 LB	1	$23.44
CHIVES	4080	1 LB	2	$22.80
POTATO - YUKON - GOLD	4080	50 LB	1	$22.67
TOMATOES - CHERRY - HEIRLOOM	4080	CA 12/1 PT	1	$22.22
GRAPES	4080	5 LB	1	$19.75
SPICE - ALEPPO PEPPER	4035	16 OZ	1	$19.59
SHALLOTS	4080	5 LB	1	$19.25
ORANGE	4080	CA 1/20CT	1	$18.45
ARUGULA - BABY	4080	3 LB	1	$17.56
CORN	4080	48 CT	1	$16.67
GARLIC - PEELED	4080	5 LB	1	$16.57
CUCUMBERS	4080	12 CT	1	$14.67
ARUGULA - BABY	4080	4 LB	1	$14.51
BASIL	4080	1 LB	1	$10.00
WATERMELON	4080	1 PC	1	$9.75
CILANTRO	4080	1 LB	1	$8.05
PEPPER - JALAPENO	4080	1 LB	1	$5.11
CARROTS	4080	10 LB	1	$5.01
►Halibut Jack Seafood				$1,279.88
TUNA	4040	LB WEIGHT	31.6	$567.21
HADDOCK	4040	LB WEIGHT	30	$399.50
SALMON	4040	LB WEIGHT	28.6	$313.17
►Ipswich Shellfish Co				$574.01
HADDOCK	4040	LB WEIGHT	15	$187.50
OYSTERS	4040	CA 1/100 CT	2	$172.00
SALMON	4040	LB WEIGHT	12.81	$134.51
CLAMS - CHOPPED	4040	1 GAL	1	$56.00
MUSSELS	4040	10 LB	1	$24.00
►Boston Bread Service				$255.88
BREAD - BURGER BUN - ALL	4020	CA 96 ea	2	$122.00
BREAD - CIABATTA - ROLL	4020	DOZ	8	$103.92
BREAD - CHALLAH - LOAF	4020	LOAF (EA)	4	$29.96
►Deano's Pasta				$210.00
RAVIOLI - ALL	4035	CA 6 lb	2	$180.00
GNOCCHI - GLUTEN FREE	4035	CA 6 lb	1	$30.00

Beverage Subcategories ▲

Beer

21.2%

$2,196 / $10,362

Liquor

23.2%

$4,798 / $20,679

Wine

23.9%

$3,939 / $16,471

NA Beverage

60.4%

$1,628 / $2,694

Week 40 Beverage Purchases — Vendor / Item

Vendor / Item	GL	Pack	Qty	Amount
►Martignetti Companies				$690.20
KETEL ONE - VODKA	4005	CA 12/1 LTR	1	$366.65
MICHTERS - WHISKEY - BOURBON US 1	4005	BTL 1/750ml	3	$116.82
JAMESON - WHISKEY	4005	BTL 1/L	2	$81.88
BEEFEATER - GIN	4005	BTL 1/L	2	$59.88
CROWN ROYAL - WHISKEY	4005	BTL 1/L	1	$41.00
GINGER BEER	4070	CA 24/12 fl oz	1	$23.97
►M. S. Walker				$536.11
LA CREMA - MONTEREY - CHARDONNAY	4010	CA 12/750ml	1	$132.00
HOFSTATTER - PINOT BIANCO	4010	CA 12/750 ML	1	$124.00
JIM BEAM - WHISKEY	4005	BTL 1/L	2	$50.79
KNOB CREEK - BOURBON	4005	BTL 1/L	1	$48.39
HENDRICKS - GIN	4005	BTL 1/L	1	$42.89
CAMPARI	4005	BTL 1/L	1	$38.39
LUNAZUL - TEQUILA - BLANCO	4005	BTL 1/L	2	$38.30
RITTENHOUSE - WHISKEY - RYE	4005	BTL 1/L	1	$29.89
LUSTAU - BLANCO - VERMUT	4005	BTL 1/750ml	1	$15.73
LUSTAU - ROJO - VERMUT	4010	BTL 1/750ml	1	$15.73
►Southern Glazer's Beverage Company				$525.45
GREY GOOSE - VODKA	4005	CA 6/1L	2	$395.92
MAKER'S MARK - BOURBON	4005	BTL 1/L	3	$111.59
PEYCHAUD'S APERTIVO	4005	BTL 1/750ml	1	$17.94
►Seaboard Products				$404.90
MAINE BEER - KEG	4000	KEG 15.5g	1	$320.00
DOWNEAST - CIDER - PACKAGE	4000	CA 24/12 fl oz	1	$50.40
MANCINO - VERMOUTH - SECCO	4005	BTL 1/750ml	1	$34.50
►Craft Collective Homegrown				$378.00
BISSELL BROTHERS - KEG	4000	KEG 15.5g	1	$289.00
BLACK HOG - KEG	4000	KEG 5.2g	1	$89.00
►Arborway Imports, Inc.				$328.00
LES ATHLETES DU VIN - CHINON ROUGE	4010	CA 12/750ml	1	$168.00
FRANCO SERRA - NEBBIOLO - LANGHE	4010	CA 12/750ml	1	$160.00
►US Foods				$288.75
ROOT BEER - PACKAGE	4070	CA 6/4/12 OZ	4	$143.04
WATER - SPARKLING	4070	CA 12/1 LT	2	$66.54
WATER - STILL	4070	CA 24/12 OZ	1	$29.91
WATER - STILL	4070	CA 12/28 OZ	1	$29.73
MILK	4070	CA 6/.5 GAL	1	$19.53
►Merrimack Valley Distributing Co.				$95.85
CORONA - PACKAGE	4000	CA 24/12 fl oz	2	$68.60
COORS LIGHT - PACKAGE	4000	CA 24/12 fl oz	1	$27.25
►Baldor Boston				$27.73
JUICE - ORANGE	4070	CA 6/32 fl oz	1	$27.73

Paper Goods (GL 6120)

Week	Amount
Wk 37	$318.45
Wk 38	$642.73
Wk 39	$686.60
Wk 40	$765.72
4-Wk Total	$2,413.50

Top 30 Vendors — Week 40

#	Vendor	Week 40 Spend
1	US Foods	$2,612.49
2	TriMark United East	$2,301.69
3	Baldor Boston	$1,367.60
4	Halibut Jack Seafood	$1,279.88
5	Martignetti Companies	$684.49
6	Ipswich Shellfish Co	$574.01
7	M. S. Walker	$530.75
8	Southern Glazer's Beverage Company	$520.19
9	Craft Collective Homegrown	$408.00
10	Seaboard Products	$354.90
11	Arborway Imports, Inc.	$328.00
12	Boston Bread Service	$263.64
13	Deano's Pasta	$210.00
14	Merrimack Valley Distributing Co.	$99.45

Price Increases

Price Decreases

Items Compared

↑ Price Increases (Wk 39 → Wk 40)

Item	Vendor	Prior $/unit	Cur $/unit	Change
CREAM - HEAVY	US Foods	$34.99	$41.12	+$6.13
LIMES	Baldor Boston	$16.52	$18.06	+$1.54
CILANTRO	Baldor Boston	$7.12	$8.05	+$0.93
ARUGULA - BABY	Baldor Boston	$15.21	$16.04	+$0.82

↓ Price Decreases (Wk 39 → Wk 40)

Item	Vendor	Prior $/unit	Cur $/unit	Change
GREY GOOSE - VODKA	Southern Glazer's Beverage Company	$223.44	$197.96	$25.48
ASPARAGUS	Baldor Boston	$67.57	$48.53	$19.04
PASTA - DRY	US Foods	$49.05	$39.21	$9.84
BROCCOLINI	Baldor Boston	$34.89	$28.82	$6.07
CHIVES	Baldor Boston	$15.19	$11.40	$3.79
TOMATOES - CHERRY - HEIRLOOM	Baldor Boston	$25.28	$22.22	$3.06
CORN	Baldor Boston	$19.23	$16.67	$2.56
TOMATO - 5x6	Baldor Boston	$35.60	$33.38	$2.22
CRACKERS - OYSTER	US Foods	$22.77	$20.61	$2.16
WATERMELON	Baldor Boston	$11.75	$9.75	$2.00
ZUCCHINI	Baldor Boston	$25.00	$23.44	$1.56
BASIL	Baldor Boston	$10.90	$10.00	$0.90

Generated October 06, 2026 • Serenitee Restaurant Group