Calas
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
26.3%-5.3pp
Food COGS %
4-wk avg: 33.4%
↑ worse   ↓ better vs prior 4-wk avg
16.9%-6.8pp
Beverage COGS %
4-wk avg: 19.4%
↑ worse   ↓ better vs prior 4-wk avg
23.9%-6.1pp
Total COGS %
WeekDatesGross Sales Food %Bev % Total COGS $COGS %
Wk 17 4/19–4/25 $35,214 42.9% 19.4% $12,447 35.3%
Wk 18 4/26–5/2 $37,133 34.7% 17.9% $11,056 29.8%
Wk 19 5/3–5/9 $35,886 31.5% 23.7% $10,771 30.0%
Wk 20 5/10–5/16 $42,523 26.3% 16.9% $10,172 23.9%
4-Week Average $37,689 33.4% 19.4% $11,112 29.5%

COGS % Trend

Sales & COGS $ by Week

Food Detail

$6,821
Wk 20 Purchases
26.3%
Current COGS %
33.4%
4-Week Avg
29.0%
Target
+$3,994
4wk Var to Target
Vendor / ItemGLPackQtyAmount
US Foods $3,203
Ipswich Shellfish Co $1,558
Baldor Boston $1,452
Paul W. Marks Co. $433
Boston Bread Service $176

Beverage Detail

$2,802
Wk 20 Purchases
16.9%
Current COGS %
19.4%
4-Week Avg
Beer
18.1%
$1,072
Liquor
14.8%
$965
Wine
21.1%
$660
NA Beverage
10.7%
$105
Vendor / ItemGLPackQtyAmount
M. S. Walker $802
Martignetti Companies $761
Seaboard Products $541
Merrimack Valley Distributing Co. $250
Bent Water Brewing Co $159
Boston Wine Co $136
Rockport Brewing Company $95
US Foods $42
Paul W. Marks Co. $16

Paper Goods

$549
Wk 20 Purchases
1.3%
Current %
1.7%
4-Week Avg %
Vendor / ItemGLPackQtyAmount
TriMark United East $549

Week 20 Purchases by Vendor — All Categories

VendorFoodBeveragePaperTotal
US Foods $3,203 $42 $3,245
Ipswich Shellfish Co $1,558 $1,558
Baldor Boston $1,452 $1,452
M. S. Walker $802 $802
Martignetti Companies $761 $761
TriMark United East $549 $549
Seaboard Products $541 $541
Paul W. Marks Co. $433 $16 $449
Merrimack Valley Distributing Co. $250 $250
Boston Bread Service $176 $176
Bent Water Brewing Co $159 $159
Boston Wine Co $136 $136
Rockport Brewing Company $95 $95
13
Price Increases
17
Price Decreases
30
Items Compared

↑ Price Increases (Wk 19 → Wk 20)

ItemVendorWk 19 $/unitWk 20 $/unitChange
BROCCOLINI Baldor Boston $49.12 $59.46 +$10.34
BEANS - BLACK US Foods $24.70 $28.87 +$4.17
BACON US Foods $71.82 $75.54 +$3.72
LETTUCE - GREEN LEAF Baldor Boston $35.30 $38.48 +$3.18
OIL - BLENDED US Foods $69.13 $72.06 +$2.93
FRY SHORTENING US Foods $42.02 $43.07 +$1.05
LETTUCE - ROMAINE Baldor Boston $48.05 $48.90 +$0.85
FRENCH FRIES US Foods $45.95 $46.65 +$0.70
CUCUMBERS Baldor Boston $8.86 $9.49 +$0.63
HADDOCK Ipswich Shellfish Co $11.33 $11.75 +$0.42
GARLIC - PEELED Baldor Boston $17.15 $17.32 +$0.17
TOMATO - DICED US Foods $35.60 $35.75 +$0.15
MILK Paul W. Marks Co. $2.44 $2.52 +$0.08

↓ Price Decreases (Wk 19 → Wk 20)

ItemVendorWk 19 $/unitWk 20 $/unitChange
TOMATO - 5x6 Baldor Boston $82.79 $50.67 $32.12
TOMATO - PLUM Baldor Boston $72.08 $50.06 $22.02
BEEF - RIBEYE US Foods $15.68 $12.27 $3.41
GREENS - MESCLUN Baldor Boston $24.23 $21.35 $2.88
BEEF - PATTY US Foods $56.19 $53.53 $2.66
PEPPER - GREEN Baldor Boston $19.71 $17.81 $1.90
SPINACH - BABY Baldor Boston $16.39 $14.78 $1.61
PICKLES - DILL - SPEARS/HALVES Baldor Boston $37.99 $37.15 $0.84
PEPPER - RED Baldor Boston $19.71 $19.25 $0.46
CHEESE - MONTEREY JACK - BLEND Paul W. Marks Co. $65.17 $64.75 $0.42
ONION - RED Baldor Boston $18.88 $18.48 $0.40
AVOCADO Baldor Boston $43.11 $42.93 $0.18
PARSLEY Baldor Boston $2.50 $2.38 $0.12
CILANTRO Baldor Boston $10.45 $10.34 $0.11
CHEESE - MOZZARELLA - SHREDDED Baldor Boston $12.44 $12.34 $0.10
SCALLIONS Baldor Boston $1.22 $1.17 $0.05
ARUGULA - BABY Baldor Boston $17.38 $17.36 $0.02