COGS Dashboard — Minglewood Harborside

Week	Dates	Gross Sales	Food %	Bev %	Total COGS $	COGS %
Wk 17	4/19–4/25	$79,421	32.1%	19.2%	$23,731	29.9%
Wk 18	4/26–5/2	$79,576	31.6%	23.3%	$23,352	29.3%
Wk 19	5/3–5/9	$72,616	36.0%	23.2%	$24,303	33.5%
Wk 20	5/10–5/16	$97,996	19.1%	14.3%	$18,667	19.0%
4-Week Average	$82,402	28.9% ↓	19.7% ↓	$22,513	27.3%

Food Detail

$12,738

Wk 20 Purchases

19.1%

Current COGS %

28.9% ↓

4-Week Avg

29.0%

Target

−$146

4wk Var to Target

Vendor / Item	GL	Pack	Qty	Amount
▶ US Foods				$4,966
ANCHOVY - FILET	Dry Goods	EA 1/13 OZ	1	$16
AVOCADO - PULP	Dry Goods	CA 8/2 LB	1	$60
BEEF - BOTTOM SIRLOIN FLAP	Meat	LB WEIGHT	59	$905
BEEF - PATTY	Meat	CA 56/4 OZ	8	$520
BEEF - SHORT RIB - BONELESS	Meat	LB WEIGHT	62	$772
BEEF - SHAVED STEAK	Meat	CA 4/10 LB	1	$235
BREAD - GLUTEN FREE - BURGER BUN	Bread	CA 32/3 OZ	1	$39
BREAD - BURGER BUN - ALL	Bread	CA 4/8/3.4 OZ	3	$87
BREAD - BURGER BUN - ALL	Bread	CA 4/8/3.4 OZ	4	$116
CHICKEN - BREAST	Meat	CA 4/5 LB	2	$143
CHICKEN - THIGHS	Meat	CA 4/10 LB	1	$87
CHICKEN - TENDERS	Meat	LB WEIGHT	40	$164
CHICKEN - WINGS	Meat	CA 4/10 LB	7	$387
CORNMEAL	Dry Goods	CA 1/50 LB	1	$24
COOKIE DOUGH - ALL	Dry Goods	CA 80/4 OZ	1	$77
FLOUR - CORN	Dry Goods	CA 1/50 LB	1	$32
HORSERADISH	Dry Goods	CA 6/32 OZ	1	$33
ICE CREAM - SANDWICH	Dry Goods	CA 2/24/3.5 OZ	2	$68
KETCHUP - POUCH	Dry Goods	CA 6/114 OZ	2	$68
MAYO - HEAVY	Dry Goods	CA 4/1 GAL	2	$92
MAYO - HEAVY	Dry Goods	CA 4/1 GAL	2	$92
OIL - PAN SPRAY	Dry Goods	CA 6/17 OZ	1	$24
PASTA - DRY	Dry Goods	CA 2/10 LB	2	$58
PEPPER - CHIPOTLE - CANNED	Dry Goods	CA 12/12 OZ	1	$39
POTATO - DICED	Produce	CA 2/10 LB	1	$29
FRENCH FRIES	Dry Goods	CA 6/5 LB	6	$272
SWEET POTATO FRIES	Dry Goods	CA 3/5 LB	2	$69
SWEET POTATO FRIES	Dry Goods	CA 3/5 LB	6	$208
BREAD - SLIDER	Bread	CA 7/12/1.5 OZ	1	$28
SALT - KOSHER	Dry Goods	CA 9/3 LB	1	$66
SUGAR - BROWN	Dry Goods	CA 12/2 LB	1	$37
TOMATOES - PEELED - CANNED	Dry Goods	CA 6/#10 CN	1	$37
TORTILLA - FLOUR - 8"-12"	Bread	CA 16/12 EA	1	$41
TORTILLA - FLOUR - 8"-12"	Bread	CA 8/12 EA	1	$38
▶ Baldor Boston				$1,942
LETTUCE - GEM	Produce	42 CT	1	$33
LETTUCE - GEM	Produce	42 CT	1	$33
LETTUCE - GEM	Produce	42 CT	1	$33
ARUGULA - BABY	Produce	3 LB	1	$17
ARUGULA - BABY	Produce	3 LB	1	$17
ARUGULA - BABY	Produce	3 LB	1	$17
AVOCADO	Produce	48 CT	1	$43
AVOCADO	Produce	48 CT	1	$43
BANANAS	Produce	CA 10 LB	1	$11
PICKLE - BREAD & BUTTER - CHIP	Dry Goods	5 GAL	1	$55
CABBAGE - GREEN	Produce	14-16 CT	1	$28
CARROTS	Produce	50 LB	1	$41
CAULIFLOWER	Produce	12 CT	1	$55
CAULIFLOWER	Produce	CA 1/16CT	1	$56
CELERY	Produce	3 CT	1	$9
CELERY	Produce	3 CT	1	$9
CHIVES	Produce	1 LB	1	$13
CHIVES	Produce	1 LB	1	$13
CHEESE - MOZZARELLA - FRESH	Dairy	3 LB	1	$21
CUCUMBERS	Produce	12 CT	2	$19
CUCUMBERS	Produce	12 CT	1	$9
CUCUMBERS	Produce	12 CT	2	$19
GYOZA	Dry Goods	CA 150/EA	3	$141
FENNEL	Produce	2 CT	2	$10
BREAD - SOURDOUGH - LOAF	Bread	6 CT	1	$57
EGG NOODLES	Dry Goods	1 LB	4	$8
EGG NOODLES	Dry Goods	1 LB	6	$11
CABBAGE - GREEN	Produce	3 CT	1	$11
PARSLEY	Produce	3 CT	1	$2
LEMONS	Produce	165 CT	1	$39
LIMES	Produce	CA 175 CT	1	$63
LETTUCE - GREEN LEAF	Produce	10 LB	1	$38
LETTUCE - MESLCUN	Produce	3 LB	1	$10
LETTUCE - MESLCUN	Produce	3 LB	1	$10
LETTUCE - MESLCUN	Produce	3 LB	2	$20
LETTUCE - MESLCUN	Produce	3 LB	1	$10
CABBAGE - NAPA	Produce	2 CT	1	$6
CABBAGE - NAPA	Produce	2 CT	2	$12
ONION - SPANISH	Produce	CA 1/50LB	1	$30
ONION - SPANISH	Produce	CA 1/50LB	1	$30
ONION - RED	Produce	25 LB	1	$18
ORANGE	Produce	56 CT	1	$45
GARLIC - PEELED	Produce	5 LB	1	$17
PEPPER - RED	Produce	11 LB	1	$30
PEPPER - RED	Produce	11 LB	1	$30
PEPPER - JALAPENO	Produce	10 LB	1	$18
CHEESE - CREAM	Dairy	3 LB	1	$15
POTATO - YUKON - GOLD	Produce	50 LB	1	$22
POTATO - YUKON - GOLD	Produce	50 LB	1	$22
CARROT - LARGE RAINBOW	Produce	25 LB	1	$42
RAISINS	Produce	5 LB	1	$25
SCALLIONS	Produce	48 CT	1	$24
STRING BEANS	Produce	CA 2/5 LB	1	$26
STRING BEANS	Produce	CA 2/5 LB	1	$26
STRING BEANS	Produce	CA 2/5 LB	1	$26
STRING BEANS	Produce	CA 2/5 LB	1	$26
BROCCOLI	Produce	CA 20 LB	1	$44
TOMATOES - CHERRY - HEIRLOOM	Produce	CA 12/1 PT	1	$19
TOMATOES - CHERRY - HEIRLOOM	Produce	CA 12/1 PT	1	$19
TOMATO - PLUM	Produce	25 LB	1	$50
TOMATO - PLUM	Produce	25 LB	1	$61
TOMATO - 5x6	Produce	25 LB	1	$51
HUMMUS - PREPARED	Dry Goods	5 LB	1	$17
WALNUT - PIECES	Dry Goods	CA 5 LB	1	$29
OIL - TRUFFLE - WHITE	Dry Goods	1 LT	1	$29
TORTILLA - CORN - 6"	Bread	CA 30 X 32ea	1	$55
PEPPER - YELLOW	Produce	CA 11 LB	1	$26
PEPPER - YELLOW	Produce	CA 11 LB	1	$26
▶ Ipswich Maritime				$1,858
HADDOCK	Fish	LB WEIGHT	25	$274
HADDOCK	Fish	LB WEIGHT	30	$375
HADDOCK	Fish	LB WEIGHT	30	$375
CALAMARI	Fish	LB WEIGHT	50	$398
SALMON	Fish	LB WEIGHT	25	$228
SALMON	Fish	LB WEIGHT	11	$98
SALMON	Fish	LB WEIGHT	12	$111
▶ Ipswich Shellfish Co				$1,079
MUSSELS	Fish	10 LB	1	$23
SEA SCALLOP - IQF	Fish	1 GAL	1	$188
SHRIMP - 16/20	Fish	LB WEIGHT	20	$144
SHRIMP - 21/25	Fish	LB WEIGHT	20	$127
CLAMS - CHOPPED	Fish	1 GAL	1	$53
OYSTERS - SHUCKED	Fish	1 GAL	1	$190
OYSTERS - SHUCKED	Fish	1 GAL	1	$190
SEA SCALLOP - IQF	Fish	LB WEIGHT	8	$164
▶ True World Foods Boston LLC				$1,053
TUNA - SUSHI	Sushi	LB WEIGHT	20	$346
TUNA - SUSHI	Sushi	LB WEIGHT	17	$281
SHRIMP - EBI - RAW	Sushi	CA 24 EA	1	$147
SALMON - SUSHI	Sushi	LB WEIGHT	37	$279
▶ Performance Food Group Inc				$853
FRENCH FRIES	Dry Goods	6/5 LB	16	$717
KETCHUP - POUCH	Dry Goods	6/114 OZ	4	$136
▶ Paul W. Marks Co.				$718
CHEESE - AMERICAN - SLICED	Dairy	CA 4/5 LB	1	$56
BUTTER - ALL	Dairy	CA 36/1 LB	1	$90
BUTTER - ALL	Dairy	CA 36/1 LB	1	$90
CHEESE - CREAM	Dairy	EA 10/3 LB	2	$12
CHEESE - PARM - GRATED	Dairy	CA 4/5 LB	1	$86
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
ICE CREAM - VANILLA	Dairy	CA 3 GAL	1	$42
CHEESE - MONTEREY JACK - BLEND	Dairy	CA 4/5 LB	1	$43
CHEESE - MONTEREY JACK - BLEND	Dairy	CA 4/5 LB	2	$86
CHEESE - CHEDDAR	Dairy	CA 6/1.5 LB	1	$24
CHEESE - SWISS	Dairy	CA 6/1.5 LB	1	$31
CHEESE - SWISS	Dairy	CA 6/1.5 LB	1	$31
CRACKERS - OYSTER	Dry Goods	CA 150/.5 OZ	1	$19
▶ Boston Artisan Breads, Inc				$236
BREAD - BURGER BUN - ALL	Bread	DOZ	15	$142
BREAD - BURGER BUN - ALL	Bread	BAG 12 ea	10	$95
▶ Virgilio's Bakery				$33
BREAD - 8" SUB	Bread	DOZ	6	$33

Beverage Detail

$4,499

Wk 20 Purchases

14.3%

Current COGS %

19.7% ↓

4-Week Avg

Beer

20.4%

$2,044

Liquor

11.4%

$1,788

Wine

8.4%

$354

NA Beverage

20.5%

$312

Vendor / Item	GL	Pack	Qty	Amount
▶ M. S. Walker				$1,727
ST. ELDER - CORDIAL - ESPRESSO LIQUEUR	Liquor	BTL 1/750ml	13	$193
APEROL	Liquor	CA 6/1L	1	$171
BLACK INFUSIONS - FIG VODKA	Liquor	BTL 1/750ml	1	$29
CASAMIGOS - TEQUILA - BLANCO	Liquor	CA 6/1 LT	1	$183
ELIJAH CRAIG - WHISKEY - RYE	Liquor	BTL 1/L	1	$38
ELIJAH CRAIG - BOURBON - SMALL BATCH	Liquor	BTL 1/L	1	$38
ERATH - PINOT NOIR - RESPLENDENT	Wine	CA 12/750ml	3	$234
HENDRICKS - GIN	Liquor	BTL 1/L	1	$43
MILAGRO - TEQUILA - SILVER	Liquor	CA 12/1 LTR	1	$426
STONELEIGH - SAUVIGNON BLANC	Wine	CA 12/750ml	1	$120
TITO'S - VODKA	Liquor	CA 12/1 LTR	1	$252
▶ Seaboard Products				$1,071
ANZA - TEQUILA - BLANCO	Liquor	CA 12/1 LTR	1	$105
BUD LIGHT - PACKAGE	Beer	CA 24/12 fl oz	2	$56
BUDWEISER - PACKAGE	Beer	CA 24/12 fl oz	1	$28
GUINNESS - PUB CAN - PACKAGE	Beer	CA 24/14.9 fl oz	1	$43
MAINE BEER - KEG	Beer	KEG 15.5g	1	$320
MICHELOB ULTRA - PACKAGE	Beer	CA 24/12 fl oz	1	$31
CORDIAL - BLUE CURACAO	Liquor	BTL 1/L	1	$5
CORDIAL - TRIPLE SEC	Liquor	CA 6/1L	1	$22
WATER - SPARKLING	NA Bev	CA 24/12 fl oz	1	$27
STELLA ARTOIS - PACKAGE	Beer	CA 24/11.2 fl oz	1	$36
TRUE NORTH - KEG	Beer	KEG 15.5g	1	$172
TRUE NORTH - SHEAR HOPPINESS - KEG	Beer	KEG 15.5g	1	$225
▶ Merrimack Valley Distributing Co.				$585
COORS LIGHT - PACKAGE	Beer	CA 24/12 fl oz	3	$82
CORONA - PACKAGE	Beer	CA 24/12 fl oz	1	$34
MILLER LITE - PACKAGE	Beer	CA 24/12 fl oz	1	$27
NOTCH - IPA - NON-ALCOHOLIC - PACKAGE	Beer	CA 24/12 fl oz	1	$38
NOTCH - KEG	Beer	KEG 1/2 BBL	2	$370
WHITE CLAW - HARD SELTZER - ALL - PACKAGE	Beer	CA 24/12 fl oz	1	$33
▶ Martignetti Companies				$471
FERNET BRANCA	Liquor	BTL 1/750ml	1	$34
HIGH NOON - HARD SELTZER - VARIETY PACK	Beer	CA 24/355 ML	4	$188
KETEL ONE - VODKA	Liquor	BTL 1/L	3	$100
CORDIAL - POMEGRANATE	Liquor	BTL 1/750ml	4	$60
TANQUERAY - GIN	Liquor	BTL 1/L	1	$33
TRIPLE EIGHT - VODKA - BLUEBERRY	Liquor	BTL 1/750ml	2	$56
▶ Rockport Brewing Company				$360
HATCHET CASE - IPA - PACKAGE	Beer	CA 24/16 fl oz	1	$70
ROCKPORT BREWING - IPA - JETTY JUICE - PACKAGE	Beer	CA 24/16 fl oz	2	$150
ROCKPORT BREWING - HARD SELTZER - ALL - PACKAGE	Beer	CA 24/16 fl oz	2	$140
▶ US Foods				$262
MARASCHINO CHERRIES	NA Bev	EA 1/128 OZ	2	$54
ROOT BEER - PACKAGE	NA Bev	CA 6/4/12 OZ	1	$36
ROOT BEER - PACKAGE	NA Bev	CA 6/4/12 OZ	1	$36
JUICE - PINEAPPLE	NA Bev	CA 12/46 OZ	1	$50
JUICE - CRANBERRY	NA Bev	CA 1/2 GAL	1	$87
▶ Paul W. Marks Co.				$23
MILK	NA Bev	CA 9/.5 GAL	1	$23

Paper Goods

$1,431

Wk 20 Purchases

1.5%

Current %

1.4%

4-Week Avg %

Vendor / Item	GL	Pack	Qty	Amount
▶ TriMark United East				$1,431
05629 MINI-MAX 2PLY TT 18/750'	Paper	CASE	1	$60
07655 WHITE SWAN DINNER NAPKIN	Paper	CASE	1	$50
12" PLAIN KRAFT CORRG PIZZA BOX 50/CS	Paper	BUNDLE	1	$25
231 2PLY BLK BEV NAPKINS 2M	Paper	CASE	2	$85
4017521 ERC30 RD/BLK REG RIBN 6 PAK	Paper	BOX (EA)	1	$15
4656912 9X6 CULINARY CLR CTR 120/CS	Paper	CASE	3	$125
4700911 CL 9X9 CLR/CLR HNG CNT 120/CS	Paper	CASE	3	$129
4700911 CL 9X9 CLR/CLR HNG CNT 120/CS	Paper	CASE	2	$86
7383 3" 2PLY W/C 100' 50CS	Paper	CASE	1	$64
BAMK45 4.5" BAMBOO KNOT PICK	Paper	PAK	4	$12
BAMP45PR 4.5 ALLERGEN PICK PRP	Paper	PAK	2	$8
CHX WHT W/RD STRP FDSRV TWL	Paper	CASE	1	$34
EC385812K 38X58 BLK 1.2MIL LNR	Paper	CASE	3	$79
EC385812K 38X58 BLK 1.2MIL LNR	Paper	CASE	1	$26
ECO1C963CL 9X6 CLR/CLR HINGED	Paper	CASE	1	$70
FU5040 4OZ PP PORTION CUP CLR 2.5M	Paper	CASE	1	$42
NC12S NEX 12/14OZ CLEAR CUP 1M	Paper	CASE	1	$75
NC12S NEX 12/14OZ CLEAR CUP 1M	Paper	CASE	1	$75
NP141 14X10X15 HNDL KRAFT BAG 200/CS	Paper	CASE	1	$54
NP141 14X10X15 HNDL KRAFT BAG 200/CS	Paper	CASE	1	$54
NP3 10X5X13 HANDL KRAFT BAG 250/CS	Paper	CASE	1	$45
REG WHT 6-1 MEAL KT PP 250CS	Paper	CASE	1	$16
Straws - Unwrapped - 7.75" 5M	Paper	CASE	1	$26
TMHD8180 8HR FUEL CELL	Paper	CASE	1	$70
TRIMARK #4 ECO-BOX CNTR KRAFT	Paper	CASE	2	$105

Week 20 Purchases by Vendor — All Categories

Vendor	Food	Beverage	Paper	Total
US Foods	$4,966	$262	—	$5,228
Baldor Boston	$1,942	—	—	$1,942
Ipswich Maritime	$1,858	—	—	$1,858
M. S. Walker	—	$1,727	—	$1,727
TriMark United East	—	—	$1,431	$1,431
Ipswich Shellfish Co	$1,079	—	—	$1,079
Seaboard Products	—	$1,071	—	$1,071
True World Foods Boston LLC	$1,053	—	—	$1,053
Performance Food Group Inc	$853	—	—	$853
Paul W. Marks Co.	$718	$23	—	$741
Merrimack Valley Distributing Co.	—	$585	—	$585
Martignetti Companies	—	$471	—	$471
Rockport Brewing Company	—	$360	—	$360
Boston Artisan Breads, Inc	$236	—	—	$236
Virgilio's Bakery	$33	—	—	$33

Price Increases

Price Decreases

Items Compared

↑ Price Increases (Wk 19 → Wk 20)

Item	Vendor	Wk 19 $/unit	Wk 20 $/unit	Change
CABBAGE - GREEN	Baldor Boston	$23.51	$28.03	+$4.52
LETTUCE - GREEN LEAF	Baldor Boston	$35.30	$38.48	+$3.18
CARROTS	Baldor Boston	$38.48	$40.93	+$2.45
PEPPER - RED	Baldor Boston	$28.38	$30.49	+$2.11
BROCCOLI	Baldor Boston	$42.31	$44.20	+$1.89
MAYO - HEAVY	US Foods	$44.67	$46.17	+$1.50
SCALLIONS	Baldor Boston	$23.09	$24.39	+$1.30
MILK	Paul W. Marks Co.	$21.96	$22.68	+$0.72
BREAD - BURGER BUN - ALL	US Foods	$28.30	$28.90	+$0.60
FLOUR - CORN	US Foods	$31.41	$31.97	+$0.56
CABBAGE - GREEN	Baldor Boston	$10.45	$11.00	+$0.55
CHICKEN - THIGHS	US Foods	$86.91	$87.31	+$0.40
ORANGE	Baldor Boston	$44.18	$44.57	+$0.39
SALMON	Ipswich Maritime	$8.57	$8.95	+$0.38
CUCUMBERS	Baldor Boston	$9.18	$9.49	+$0.31
LETTUCE - MESLCUN	Baldor Boston	$9.79	$9.80	+$0.01

↓ Price Decreases (Wk 19 → Wk 20)

Item	Vendor	Wk 19 $/unit	Wk 20 $/unit	Change
TOMATO - 5x6	Baldor Boston	$82.79	$50.67	$32.12
CAULIFLOWER	Baldor Boston	$85.03	$55.84	$29.19
TOMATO - PLUM	Baldor Boston	$67.17	$55.43	$11.74
CHICKEN - BREAST	US Foods	$82.21	$71.70	$10.51
LETTUCE - GEM	Baldor Boston	$42.28	$32.55	$9.73
PEPPER - JALAPENO	Baldor Boston	$27.31	$18.04	$9.27
PEPPER - YELLOW	Baldor Boston	$34.91	$25.79	$9.12
TOMATOES - CHERRY - HEIRLOOM	Baldor Boston	$22.95	$18.78	$4.17
EGG - WHOLE	Paul W. Marks Co.	$24.00	$20.57	$3.43
CHIVES	Baldor Boston	$15.76	$13.34	$2.42
ONION - SPANISH	Baldor Boston	$32.61	$30.49	$2.12
BUTTER - ALL	Paul W. Marks Co.	$91.45	$89.51	$1.94
LIMES	Baldor Boston	$64.18	$62.99	$1.19
TORTILLA - CORN - 6"	Baldor Boston	$55.58	$54.55	$1.03
POTATO - YUKON - GOLD	Baldor Boston	$22.90	$22.05	$0.85
BREAD - SOURDOUGH - LOAF	Baldor Boston	$57.37	$56.61	$0.76
HADDOCK	Ipswich Maritime	$12.50	$11.98	$0.52
OIL - TRUFFLE - WHITE	Baldor Boston	$29.86	$29.39	$0.47
CHEESE - AMERICAN - SLICED	Paul W. Marks Co.	$56.52	$56.19	$0.33
CHEESE - MONTEREY JACK - BLEND	Paul W. Marks Co.	$43.45	$43.17	$0.28
AVOCADO	Baldor Boston	$43.13	$42.88	$0.25
ARUGULA - BABY	Baldor Boston	$17.60	$17.35	$0.25
GARLIC - PEELED	Baldor Boston	$17.50	$17.32	$0.18
SALMON - SUSHI	True World Foods Boston LLC	$7.65	$7.50	$0.15
CHEESE - CHEDDAR	Paul W. Marks Co.	$23.87	$23.74	$0.13
PARSLEY	Baldor Boston	$2.50	$2.38	$0.12
STRING BEANS	Baldor Boston	$26.13	$26.02	$0.11
LEMONS	Baldor Boston	$38.89	$38.79	$0.10

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)