Hale Street Tavern
COGS Dashboard — Week 20 (5/10–5/16) · 4-Week Window: Wks 17–20
Week 20
Summary
Food Detail
Beverage Detail
Paper Goods
By Vendor
💰 Price Variance
24.5%-8.0pp
Food COGS %
4-wk avg: 27.7%
↑ worse   ↓ better vs prior 4-wk avg
26.0%+4.5pp
Beverage COGS %
4-wk avg: 21.5%
↑ worse   ↓ better vs prior 4-wk avg
26.4%-4.0pp
Total COGS %
WeekDatesGross Sales Food %Bev % Total COGS $COGS %
Wk 17 4/19–4/25 $71,135 27.5% 22.2% $19,334 27.2%
Wk 18 4/26–5/2 $66,237 25.8% 17.1% $16,678 25.2%
Wk 19 5/3–5/9 $69,944 32.5% 21.5% $21,292 30.4%
Wk 20 5/10–5/16 $64,711 24.5% 26.0% $17,093 26.4%
4-Week Average $68,007 27.7% 21.5% $18,599 27.3%

COGS % Trend

Sales & COGS $ by Week

Food Detail

$11,836
Wk 20 Purchases
24.5%
Current COGS %
27.7%
4-Week Avg
29.0%
Target
−$2,600
4wk Var to Target
Vendor / ItemGLPackQtyAmount
Performance Food Group Inc $3,666
US Foods $2,024
Baldor Boston $1,619
Ipswich Shellfish Co $1,178
Paul W. Marks Co. $998
Halibut Jack Seafood $808
True World Foods Boston LLC $693
Island Creek Oysters $504
Boston Bread Service $268
Boston Artisan Breads, Inc $78

Beverage Detail

$4,287
Wk 20 Purchases
26.0%
Current COGS %
21.5%
4-Week Avg
Beer
20.7%
$950
Liquor
22.4%
$1,572
Wine
36.7%
$1,431
NA Beverage
34.3%
$333
Vendor / ItemGLPackQtyAmount
Martignetti Companies $1,595
Seaboard Products $1,132
M. S. Walker $836
21st Century Wine $232
Atlantic Beverage Distributors $158
US Foods $144
Baldor Boston $75
Performance Food Group Inc $75
Paul W. Marks Co. $39

Paper Goods

$970
Wk 20 Purchases
1.5%
Current %
1.4%
4-Week Avg %
Vendor / ItemGLPackQtyAmount
TriMark United East $970

Week 20 Purchases by Vendor — All Categories

VendorFoodBeveragePaperTotal
Performance Food Group Inc $3,666 $75 $3,741
US Foods $2,024 $144 $2,168
Baldor Boston $1,619 $75 $1,694
Martignetti Companies $1,595 $1,595
Ipswich Shellfish Co $1,178 $1,178
Seaboard Products $1,132 $1,132
Paul W. Marks Co. $998 $39 $1,037
TriMark United East $970 $970
M. S. Walker $836 $836
Halibut Jack Seafood $808 $808
True World Foods Boston LLC $693 $693
Island Creek Oysters $504 $504
Boston Bread Service $268 $268
21st Century Wine $232 $232
Atlantic Beverage Distributors $158 $158
Boston Artisan Breads, Inc $78 $78
20
Price Increases
34
Price Decreases
54
Items Compared

↑ Price Increases (Wk 19 → Wk 20)

ItemVendorWk 19 $/unitWk 20 $/unitChange
BEANS - BLACK US Foods $24.70 $28.87 +$4.17
LETTUCE - GREEN LEAF Baldor Boston $34.86 $38.48 +$3.62
BRUSSELL SPROUTS Baldor Boston $42.21 $45.08 +$2.87
PEPPER - SERRANO Baldor Boston $6.65 $8.33 +$1.68
CHEESE - GOAT Performance Food Group Inc $28.23 $29.15 +$0.92
PREPARED - EGG ROLLS - FROZEN - ALL US Foods $82.14 $83.00 +$0.86
MILK Paul W. Marks Co. $21.96 $22.68 +$0.72
EDAMAME US Foods $30.41 $31.03 +$0.62
FRY SHORTENING Paul W. Marks Co. $33.51 $34.13 +$0.62
CHEESE - SWISS Paul W. Marks Co. $30.30 $30.89 +$0.59
TUNA - SUSHI Halibut Jack Seafood $16.95 $17.45 +$0.50
SALMON - SUSHI True World Foods Boston LLC $7.50 $7.85 +$0.35
FRENCH FRIES Performance Food Group Inc $45.35 $45.55 +$0.20
FLOUR - ALL PURPOSE Performance Food Group Inc $20.41 $20.58 +$0.17
AVOCADO Baldor Boston $42.79 $42.88 +$0.09
KETCHUP - POUCH US Foods $33.90 $33.99 +$0.09
OYSTERS Island Creek Oysters $1.17 $1.26 +$0.09
BUTTERMILK Paul W. Marks Co. $1.26 $1.32 +$0.06
CHICKEN - WINGS Performance Food Group Inc $55.05 $55.10 +$0.05
BEEF - TERES MAJOR Performance Food Group Inc $8.58 $8.61 +$0.03

↓ Price Decreases (Wk 19 → Wk 20)

ItemVendorWk 19 $/unitWk 20 $/unitChange
TOMATO - PLUM US Foods $66.88 $45.61 $21.27
TOMATO - 5x6 US Foods $79.86 $60.96 $18.90
TOMATO - PLUM Baldor Boston $60.80 $50.06 $10.74
LETTUCE - ROMAINE - HEARTS Baldor Boston $41.61 $33.42 $8.19
OYSTERS Ipswich Shellfish Co $86.00 $80.67 $5.33
ORANGES - BAR Baldor Boston $22.56 $18.36 $4.20
TOMATOES - CHERRY - HEIRLOOM Baldor Boston $22.84 $18.78 $4.05
LIMES - BAR Baldor Boston $20.66 $18.34 $2.32
SQUASH - SUMMER Baldor Boston $5.22 $3.10 $2.12
ONION - SPANISH Baldor Boston $32.61 $30.49 $2.12
SPINACH - BABY Baldor Boston $16.39 $14.78 $1.61
CAULIFLOWER Baldor Boston $54.43 $53.38 $1.05
CABBAGE - NAPA Baldor Boston $6.89 $5.88 $1.01
CELERY Baldor Boston $10.69 $9.69 $1.00
BACON Baldor Boston $71.62 $70.91 $0.71
POTATO - YUKON - GOLD Baldor Boston $22.70 $22.05 $0.65
CILANTRO Baldor Boston $5.23 $4.68 $0.55
ZUCCHINI Baldor Boston $3.80 $3.31 $0.49
BEETS Baldor Boston $9.50 $9.06 $0.44
SCALLIONS Baldor Boston $1.61 $1.18 $0.43
PEPPER - JALAPENO Baldor Boston $5.23 $4.95 $0.28
ONION - RED Baldor Boston $9.30 $9.12 $0.18
CHEESE - CHEDDAR Paul W. Marks Co. $23.87 $23.74 $0.13
POTATO - SWEET Baldor Boston $5.70 $5.58 $0.12
LETTUCE - MESLCUN Baldor Boston $9.88 $9.79 $0.09
LEMONS - BAR Baldor Boston $38.87 $38.79 $0.08
MANGO - SUSHI Baldor Boston $12.22 $12.15 $0.07
SPICE - CAJUN Baldor Boston $7.12 $7.05 $0.07
CHEESE - MONTEREY JACK - BLEND Paul W. Marks Co. $10.86 $10.79 $0.07
STRING BEANS Baldor Boston $26.10 $26.04 $0.06
SHALLOTS - PEELED Baldor Boston $17.73 $17.67 $0.06
CREAM - WHIPPED Paul W. Marks Co. $38.62 $38.57 $0.05
CHEESE - PARM - GRATED Baldor Boston $23.73 $23.69 $0.04
ARUGULA - BABY Baldor Boston $17.38 $17.36 $0.02