COGS Dashboard — 15 Walnut

Week	Dates	Gross Sales	Food %	Bev %	Total COGS $	COGS %
Wk 17	4/19–4/25	$53,640	23.4%	28.2%	$14,090	26.3%
Wk 18	4/26–5/2	$47,500	29.6%	19.1%	$13,569	28.6%
Wk 19	5/3–5/9	$51,718	31.2%	27.7%	$16,598	32.1%
Wk 20	5/10–5/16	$57,211	29.9%	16.9%	$15,623	27.3%
4-Week Average	$52,517	28.5% ↓	22.9% ↑	$14,970	28.5%

Food Detail

$12,315

Wk 20 Purchases

29.9%

Current COGS %

28.5% ↓

4-Week Avg

29.0%

Target

−$779

4wk Var to Target

Vendor / Item	GL	Pack	Qty	Amount
▶ US Foods				$5,220
BACON	Meat	CA 1/15 LB	2	$151
BEEF - BOTTOM SIRLOIN FLAP	Meat	LB WEIGHT	82	$1,262
BEEF - PATTY	Meat	CA 32/8 OZ	4	$324
BEEF - PATTY	Meat	CA 32/8 OZ	2	$162
BEEF - PATTY	Meat	CA 56/4 OZ	2	$130
BEEF - PATTY	Meat	CA 56/4 OZ	-2	$-130
BEEF - COULOTTE	Meat	LB WEIGHT	10	$169
BREAD - NAAN	Bread	CA 36/3.61 OZ	1	$34
BREAD - NAAN	Bread	CA 6/8/4.4 OZ	1	$52
BREAD - GLUTEN FREE - BURGER BUN	Bread	CA 24/3.3 OZ	1	$58
CALAMARI	Fish	CA 2/10/8 OZ	1	$70
CALAMARI	Fish	CA 2/10/8 OZ	1	$70
CHICKEN - BREAST	Meat	CA 4/5 LB	3	$215
CHICKEN - BREAST	Meat	CA 4/5 LB	2	$143
CHICKEN - DICED	Meat	LB WEIGHT	60	$175
CHICKEN - WHOLE	Meat	LB WEIGHT	46	$91
CHICKEN - WINGS	Meat	CA 4/10 LB	1	$55
COOKIE DOUGH - ALL	Dry Goods	CA 32/4 OZ	1	$48
CRANBERRIES - DRIED	Dry Goods	CA 1/10 LB	1	$37
FLOUR - CORN	Dry Goods	CA 1/50 LB	1	$32
KETCHUP - POUCH	Dry Goods	CA 6/114 OZ	2	$68
KETCHUP - POUCH	Dry Goods	CA 6/114 OZ	1	$34
MAYO - HEAVY	Dry Goods	CA 4/1 GAL	1	$39
OIL - BLENDED	Dry Goods	CA 4/1 GAL	1	$72
OIL - EVOO	Dry Goods	EA 1/3 LT	1	$53
PASTA - DRY	Dry Goods	CA 4/5 LB	1	$49
BEEF - PASTRAMI	Meat	LB WEIGHT	14	$97
PEPPER - ROASTED RED - CANNED	Dry Goods	CA 12/28 OZ	1	$52
PORK - BUTT	Meat	LB WEIGHT	37	$113
FRENCH FRIES	Dry Goods	CA 6/5 LB	8	$391
FRENCH FRIES	Dry Goods	CA 6/5 LB	6	$293
DUMPLINGS - ALL	Dry Goods	CA 120/1 OZ	1	$50
SAUCE - BBQ	Dry Goods	EA 1/1 GAL	1	$18
FRY SHORTENING	Dry Goods	CA 1/35 LB	6	$213
FRY SHORTENING	Dry Goods	CA 1/35 LB	5	$177
SHRIMP - 16/20	Fish	CA 5/2 LB	1	$75
SHRIMP - 16/20	Fish	CA 5/2 LB	1	$81
EDAMAME	Produce	CA 6/2.5 LB	1	$31
TORTILLA - FLOUR - 8"-12"	Bread	CA 8/12 EA	1	$38
WALNUT - PIECES	Dry Goods	CA 1/5 LB	1	$59
WALNUT - PIECES	Dry Goods	CA 3/2 LB	1	$70
▶ Baldor Boston				$2,925
CARROTS	Produce	10 LB	1	$11
CARROTS	Produce	10 LB	1	$12
CARROTS	Produce	10 LB	1	$12
CHEESECAKE - ALL	Dry Goods	CA 18 EA	1	$89
TARRAGON	Produce	4 OZ	1	$6
ARUGULA - BABY	Produce	3 LB	1	$18
BROCCOLINI	Produce	18 CT	1	$60
BROCCOLINI	Produce	18 CT	1	$38
BROCCOLINI	Produce	18 CT	1	$40
BROCCOLINI	Produce	18 CT	1	$40
BROCCOLINI	Produce	18 CT	1	$38
AVOCADO	Produce	48 CT	1	$46
AVOCADO	Produce	48 CT	1	$49
BOK CHOY - BABY	Produce	10 LB	1	$27
KALE - BABY	Produce	3 LB	2	$44
KALE - BABY	Produce	3 LB	1	$22
KALE - BABY	Produce	3 LB	2	$44
BASIL	Produce	1 LB	1	$12
BEEF - STRIPLOIN	Meat	LB WEIGHT	14	$248
GARLIC - BLACK	Produce	1 LB	1	$40
CELERY	Produce	3 CT	1	$11
CHIVES	Produce	1 LB	1	$15
CHIVES	Produce	1 LB	1	$17
CHIVES	Produce	1 LB	1	$17
BRUSSELL SPROUTS	Produce	CA 2/5 LB	1	$30
CABBAGE - SLAW MIX	Produce	CA 4/5 LB	1	$25
CREAM - HEAVY	Dairy	CA 12/1 QT	1	$45
CREAM - HEAVY	Dairy	CA 12/1 QT	1	$45
CUCUMBERS	Produce	12 CT	1	$10
CUCUMBERS	Produce	12 CT	1	$10
CUCUMBERS	Produce	12 CT	1	$9
MUSTARD - DIJON	Dry Goods	1 GAL	1	$59
DILL	Produce	1 LB	1	$11
DRESSING - RANCH	Dry Goods	1 GAL	1	$25
CHERRIES - DRIED	Dry Goods	5 LB	1	$54
CHERRIES - DRIED	Dry Goods	5 LB	1	$54
FOIE GRAS	Meat	1 LB	1	$25
CHEESE - GOAT	Dairy	CA 2/2 LB	2	$73
CHEESE - GOAT	Dairy	CA 2/2 LB	-1	$-37
CHEESE - GOAT	Dairy	CA 2/2 LB	1	$37
CHEESE - GOAT	Dairy	CA 2/2 LB	2	$73
CURRY PASTE	Dry Goods	35 OZ	1	$9
HAZELNUT	Dry Goods	4 LB	1	$86
HAZELNUT	Dry Goods	4 LB	1	$86
HONEY	Dry Goods	5 LB	1	$14
PARSLEY	Produce	3 CT	2	$5
LIMES	Produce	48 CT	1	$20
BRUSSELL SPROUTS	Produce	22 LB	1	$44
BRUSSELL SPROUTS	Produce	22 LB	1	$48
MANGOES	Produce	6-9CT	1	$13
MANGOES	Produce	6-9CT	1	$13
LETTUCE - GREEN LEAF	Produce	10 LB	1	$41
LETTUCE - MESLCUN	Produce	3 LB	2	$21
LETTUCE - MESLCUN	Produce	3 LB	1	$10
LETTUCE - MESLCUN	Produce	3 LB	3	$33
CHEESE - MOZZARELLA - FRESH	Dairy	CA 6/8 OZ	1	$43
GINGER - FRESH	Produce	1 LB	1	$7
GINGER - FRESH	Produce	1 LB	1	$7
LETTUCE - GEM	Produce	24 CT	1	$44
LETTUCE - GEM	Produce	24 CT	1	$44
LETTUCE - GEM	Produce	24 CT	1	$44
CHEESE - PARM - GRATED	Dairy	5 LB	1	$25
PASTA - DRY	Dry Goods	CA 4/5 LB	1	$45
GARLIC - PEELED	Produce	5 LB	1	$18
SHALLOTS - PEELED	Produce	5 LB	1	$19
PEPPER - RED	Produce	11 LB	1	$25
PUREE - MANGO	Dry Goods	EA 6/30 OZ	1	$21
PUREE - MANGO	Dry Goods	EA 6/30 OZ	1	$20
POTATO - YUKON - GOLD	Produce	50 LB	1	$23
POTATO - YUKON - GOLD	Produce	50 LB	1	$23
POTATO - YUKON - GOLD	Produce	50 LB	-1	$-24
POTATO - YUKON - GOLD	Produce	50 LB	1	$24
POTATO - YUKON - GOLD	Produce	50 LB	1	$24
SHALLOTS - PRE FRIED	Dry Goods	8 OZ	2	$14
SHALLOTS - PRE FRIED	Dry Goods	8 OZ	2	$14
SHALLOTS - PRE FRIED	Dry Goods	8 OZ	2	$14
PUMPKIN SEED	Dry Goods	5 LB	1	$34
BEETS	Produce	25 LB	1	$27
WATERCRESS	Produce	1.5 LB	1	$15
SAGE	Produce	4 OZ	1	$6
CROUTONS - ALL	Dry Goods	CA 10 LB	1	$43
STRING BEANS	Produce	CA 2/5 LB	1	$28
STRING BEANS	Produce	CA 2/5 LB	1	$27
STRING BEANS	Produce	CA 2/5 LB	2	$55
STRING BEANS	Produce	CA 2/5 LB	1	$28
SQUASH - DELICATA	Produce	18 LB	1	$38
TOMATO - 5x6	Produce	25 LB	1	$47
TOMATO - CHERRY	Produce	CA 12/1 PT	1	$43
OIL - TRUFFLE - WHITE	Dry Goods	1 LT	1	$31
TORTILLA - FLOUR - 8"-12"	Bread	CA 12/6 CT	1	$24
TORTILLA - CORN - 6"	Bread	CA 30 X 32ea	1	$58
▶ Ipswich Shellfish Co				$1,726
SALMON	Fish	LB WEIGHT	23	$236
SALMON	Fish	LB WEIGHT	12	$125
HADDOCK	Fish	LB WEIGHT	30	$352
HADDOCK	Fish	LB WEIGHT	30	$352
HADDOCK	Fish	LB WEIGHT	15	$176
OYSTERS	Fish	CA 1/100 CT	2	$196
TUNA - SUSHI	Sushi	LB WEIGHT	18	$287
▶ Paul W. Marks Co.				$823
BUTTER - ALL	Dairy	CA 36/1 LB	1	$90
BUTTER - ALL	Dairy	CA 36/1 LB	1	$90
PICKLES - DILL - CHIPS	Dry Goods	5 GAL	2	$60
PICKLES - DILL - CHIPS	Dry Goods	5 GAL	2	$60
CHEESE - PARM - GRATED	Dairy	EA 4/5 LB	1	$21
CREAM - HEAVY	Dairy	CA 12/32 OZ	1	$44
CREAM - HEAVY	Dairy	CA 12/32 OZ	1	$44
EGG - WHOLE	Dairy	15 DZ	1	$21
CHEESE - GOAT	Dairy	CA 2/2 LB	1	$35
ICE CREAM - VANILLA	Dairy	CA 3 GAL	1	$42
CHEESE - CHEDDAR	Dairy	CA 4/2.5 LB	1	$56
CHEESE - PARM - GRATED	Dairy	EA 4/5 LB	1	$22
CHEESE - MONTEREY JACK - BLEND	Dairy	CA 6/5 LB	1	$65
CHEESE - MONTEREY JACK - BLEND	Dairy	CA 6/5 LB	1	$65
CHEESE - SWISS	Dairy	CA 6/1.5 LB	1	$31
SOUR CREAM	Dairy	CA 6/5 LB	1	$42
CREAM - WHIPPED	Dairy	CA 12/14 oz	1	$39
▶ Halibut Jack Seafood				$637
SALMON	Fish	LB WEIGHT	16	$180
SALMON	Fish	LB WEIGHT	18	$193
TUNA	Fish	LB WEIGHT	16	$264
▶ True World Foods Boston LLC				$612
EDAMAME	Produce	CA 20 LB	1	$49
SHALLOTS - PRE FRIED	Dry Goods	15 OZ	2	$21
SOY SAUCE - PACKETS - GLUTEN FREE	Sushi	CA 500/EA	3	$124
GARI - PICKELED GINGER	Sushi	20 LB	1	$42
RICE - SUSHI	Sushi	CA 50 LB	2	$90
MIZKAN JUN GENMAI BLK VINEGAR	Sushi	3.97 GAL	1	$65
SHRIMP - TEMPURA	Sushi	CA 1/120 EA	1	$68
TUNA - GROUND	Sushi	LB WEIGHT	22	$153
▶ Boston Bread Service				$230
BREAD - RYE - ALL	Bread	LOAF (EA)	2	$14
BREAD - RYE - ALL	Bread	LOAF (EA)	2	$14
BREAD - BURGER BUN - ALL	Bread	CA 96 ea	2	$114
BREAD - BURGER BUN - ALL	Bread	CA 96 ea	1	$57
BREAD - BAGUETTE	Bread	LOAF (EA)	3	$9
BREAD - CHALLAH - LOAF	Bread	LOAF (EA)	3	$21
▶ Deano's Pasta				$142
RAVIOLI - ALL	Dry Goods	CA 6 lb	2	$96
PASTA - FRESH	Dry Goods	EA 1/6LB	2	$46

Beverage Detail

$2,705

Wk 20 Purchases

16.9%

Current COGS %

22.9% ↑

4-Week Avg

Beer

22.8%

$750

Liquor

10.3%

$745

Wine

16.1%

$708

NA Beverage

45.5%

$502

Vendor / Item	GL	Pack	Qty	Amount
▶ M. S. Walker				$852
CORDIAL - AMARETTO	Liquor	BTL 1/L	1	$15
CORDIAL - TRIPLE SEC	Liquor	BTL 1/L	2	$20
DON Q - RUM - CRYSTAL	Liquor	BTL 1/L	1	$19
EVAN WILLIAMS - BOURBON	Liquor	BTL 1/L	1	$18
FRANCIS COPPOLA - PINOT NOIR	Wine	CA 12/750ml	1	$108
GILBERTS - FRENCH BRANDY	Liquor	BTL 1/L	1	$13
KONO - SAUVIGNON BLANC	Wine	CA 12/750ml	1	$96
LA CREMA - MONTEREY - CHARDONNAY	Wine	CA 12/750ml	1	$132
LUNAZUL - TEQUILA - BLANCO	Liquor	BTL 1/L	4	$77
LUNAZUL - TEQUILA - REPOSADO	Liquor	BTL 1/L	1	$22
MOUNT GAY - RUM - ECLIPSE	Liquor	BTL 1/L	1	$26
PLYMOUTH - GIN	Liquor	BTL 1/L	1	$37
PRIMA PERLA - PROSECCO	Wine	CA 12/750ml	1	$84
SCARPETTA - PINOT GRIGIO	Wine	CA 12/750ml	1	$120
ST. ELDER - CORDIAL - ELDERFLOWER	Liquor	BTL 1/750ml	1	$18
TITO'S - VODKA	Liquor	BTL 1/L	2	$47
▶ Seaboard Products				$656
DOWNEAST - CIDER - PACKAGE	Beer	CA 24/12 fl oz	1	$50
GUINNESS - KEG	Beer	KEG 20L	1	$81
MAINE BEER - KEG	Beer	KEG 15.5g	1	$320
MICHELOB ULTRA - PACKAGE	Beer	CA 24/12 fl oz	1	$29
VON TRAPP - KEG	Beer	KEG 15.5g	1	$175
▶ Martignetti Companies				$611
BITTERS	NA Bev	BTL 4 fl oz	1	$10
ALEXANDER VALLEY - CABERNET SAUVIGNON	Wine	CA 12/750 ML	1	$168
BEEFEATER - GIN	Liquor	BTL 1/L	1	$30
CAPTAIN MORGAN - RUM	Liquor	BTL 1/L	1	$27
DON JULIO - TEQUILA - BLANCO	Liquor	BTL 1/L	1	$52
FAMOUSE GROUSE - WHISKEY	Liquor	BTL 1/L	1	$32
LICOR 43 - CORDIAL	Liquor	BTL 1/L	1	$32
MICHTERS - WHISKEY - BOURBON US 1	Liquor	BTL 1/750ml	1	$39
MILAGRO - TEQUILA - SILVER	Liquor	BTL 1/L	1	$39
MYER'S - RUM - DARK	Liquor	BTL 1/L	1	$35
NEW AMSTERDAM - GIN	Liquor	BTL 1/L	3	$49
NEW AMSTERDAM - VODKA	Liquor	BTL 1/L	6	$98
▶ US Foods				$307
SYRUP - LEMONADE - BIB	NA Bev	CA 1/3 GAL	1	$72
SYRUP - GINGER ALE - BIB	NA Bev	CA 1/2.5 GAL	1	$64
TEA - ICED TEA	NA Bev	CA 96/3.5 OZ	1	$101
WATER - SPARKLING	NA Bev	CA 24/16.9 OZ	1	$40
WATER - STILL	NA Bev	CA 12/28 OZ	1	$30
▶ Baldor Boston				$159
AGAVE	NA Bev	1 GAL	1	$39
LEMONS - BAR	NA Bev	165 CT	1	$47
LIMES - BAR	NA Bev	48 CT	1	$22
MINT - BAR	NA Bev	4 OZ	1	$5
ORANGES - BAR	NA Bev	20 CT	1	$24
PUREE - MANGO - BAR	NA Bev	EA 30 OZ	1	$21
▶ Rockport Brewing Company				$95
ROCKPORT BREWING - KEG	Beer	KEG 1/6 bbl	1	$95
▶ Paul W. Marks Co.				$25
MILK	NA Bev	EA 9/.5 GAL	10	$25

Paper Goods

$603

Wk 20 Purchases

1.1%

Current %

1.6%

4-Week Avg %

Vendor / Item	GL	Pack	Qty	Amount
▶ TriMark United East				$603
020212 BLACK CKTL NAPS 1M/CS	Paper	CASE	2	$56
4690911 CL 9X9 BLK HNG CNT	Paper	CASE	1	$40
7303282 18X2000 .32 CRYSTL WRP	Paper	ROLL	1	$17
7X7 SANDWICH BG W/ FLIP TOP	Paper	CASE	1	$16
AST004NAB93 5' BAMB PADDLE PICK	Paper	PAK 100pc	3	$15
BAMK45 4.5" BAMBOO KNOT PICK	Paper	PAK	1	$3
BOUNTY BASIC 40SHT/RL	Paper	CASE	1	$49
CHX WHT W/RD STRP FDSRV TWL	Paper	CASE	1	$34
D1324S4 FILTER PAPER 13.5X24	Paper	CASE	1	$50
EC404612K LINER 1.2 40X46	Paper	CASE	1	$25
HVY WHT 6 IN 1 KT 250 PS	Paper	CASE	1	$26
IT110116 DISLVBL SHLF LIFE LBL 125/ROLL	Paper	ROLL	3	$24
J6200 KRFT MULTIFLD TWL 4M	Paper	CASE	1	$26
LRG VINYL RWDRFREE GLOVE 1M	Paper	CASE	1	$25
NP72 10X7X12 HNDL KRAFT BAG 250/CS	Paper	CASE	1	$42
PP206 9X6 HINGED CONT WHITE 150/CS	Paper	CASE	2	$51
TRIMARK #4 ECO-BOX CNTR KRAFT	Paper	CASE	1	$52
V421I MED VINYL PWDRFREE GLOVE	Paper	CASE	1	$25
V4231 XLG VINYL PWDRFREE GLOVE	Paper	CASE	1	$25

Week 20 Purchases by Vendor — All Categories

Vendor	Food	Beverage	Paper	Total
US Foods	$5,220	$307	—	$5,527
Baldor Boston	$2,925	$159	—	$3,084
Ipswich Shellfish Co	$1,726	—	—	$1,726
M. S. Walker	—	$852	—	$852
Paul W. Marks Co.	$823	$25	—	$849
Seaboard Products	—	$656	—	$656
Halibut Jack Seafood	$637	—	—	$637
True World Foods Boston LLC	$612	—	—	$612
Martignetti Companies	—	$611	—	$611
TriMark United East	—	—	$603	$603
Boston Bread Service	$230	—	—	$230
Deano's Pasta	$142	—	—	$142
Rockport Brewing Company	—	$95	—	$95

Price Increases

Price Decreases

Items Compared

↑ Price Increases (Wk 19 → Wk 20)

Item	Vendor	Wk 19 $/unit	Wk 20 $/unit	Change
LEMONS - BAR	Baldor Boston	$39.26	$47.44	+$8.18
CABBAGE - SLAW MIX	Baldor Boston	$18.47	$25.11	+$6.64
BROCCOLINI	Baldor Boston	$37.17	$42.99	+$5.82
AVOCADO	Baldor Boston	$43.05	$47.67	+$4.62
CHEESECAKE - ALL	Baldor Boston	$84.35	$88.79	+$4.44
HAZELNUT	Baldor Boston	$82.07	$86.39	+$4.32
LETTUCE - GEM	Baldor Boston	$42.28	$44.50	+$2.22
LIMES - BAR	Baldor Boston	$19.71	$21.75	+$2.04
GARLIC - BLACK	Baldor Boston	$38.48	$40.50	+$2.02
WATERCRESS	Baldor Boston	$13.10	$15.08	+$1.98
CHEESE - GOAT	Baldor Boston	$34.71	$36.54	+$1.83
BRUSSELL SPROUTS	Baldor Boston	$28.85	$30.38	+$1.53
STRING BEANS	Baldor Boston	$26.05	$27.39	+$1.33
OIL - TRUFFLE - WHITE	Baldor Boston	$29.86	$31.17	+$1.31
CHIVES	Baldor Boston	$15.44	$16.65	+$1.21
ORANGES - BAR	Baldor Boston	$22.56	$23.75	+$1.19
MANGOES	Baldor Boston	$11.77	$12.87	+$1.10
TUNA - SUSHI	Ipswich Shellfish Co	$14.50	$15.50	+$1.00
SHRIMP - TEMPURA	True World Foods Boston LLC	$67.00	$68.00	+$1.00
SHALLOTS - PEELED	Baldor Boston	$17.73	$18.66	+$0.93
GARLIC - PEELED	Baldor Boston	$16.80	$17.60	+$0.80
ARUGULA - BABY	Baldor Boston	$17.48	$18.28	+$0.80
LETTUCE - MESLCUN	Baldor Boston	$9.91	$10.56	+$0.66
POTATO - YUKON - GOLD	Baldor Boston	$22.79	$23.41	+$0.63
FLOUR - CORN	US Foods	$31.41	$31.97	+$0.56
DILL	Baldor Boston	$10.45	$11.00	+$0.55
PUREE - MANGO	Baldor Boston	$20.32	$20.86	+$0.54
BEEF - PASTRAMI	US Foods	$6.30	$6.73	+$0.43
CARROTS	Baldor Boston	$10.93	$11.31	+$0.38
GINGER - FRESH	Baldor Boston	$6.89	$7.07	+$0.18
KETCHUP - POUCH	US Foods	$33.90	$33.99	+$0.09
MILK	Paul W. Marks Co.	$2.44	$2.52	+$0.08
CHEESE - PARM - GRATED	Paul W. Marks Co.	$21.51	$21.52	+$0.01

↓ Price Decreases (Wk 19 → Wk 20)

Item	Vendor	Wk 19 $/unit	Wk 20 $/unit	Change
TOMATO - 5x6	Baldor Boston	$72.17	$47.13	$25.04
CALAMARI	US Foods	$81.58	$69.60	$11.98
KALE - BABY	Baldor Boston	$29.21	$22.25	$6.96
BOK CHOY - BABY	Baldor Boston	$33.49	$26.75	$6.74
LIMES	Baldor Boston	$22.56	$19.71	$2.85
PEPPER - RED	Baldor Boston	$25.91	$24.68	$1.23
HADDOCK	Ipswich Shellfish Co	$12.25	$11.75	$0.50
TUNA	Halibut Jack Seafood	$17.45	$16.95	$0.50
CHEESE - MONTEREY JACK - BLEND	Paul W. Marks Co.	$65.17	$64.76	$0.41
CUCUMBERS	Baldor Boston	$9.97	$9.62	$0.35

COGS % Trend

Sales & COGS $ by Week

Food Detail

Beverage Detail

Paper Goods

Week 20 Purchases by Vendor — All Categories

↑ Price Increases (Wk 19 → Wk 20)

↓ Price Decreases (Wk 19 → Wk 20)