Alchemy
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.9%-5.9pp
Food COGS %
4-wk avg: 30.6%
↑ worse   ↓ better vs prior 4-wk avg
15.6%-1.0pp
Beverage COGS %
4-wk avg: 20.5%
↑ worse   ↓ better vs prior 4-wk avg
24.0%-4.2pp
Total COGS %
WeekDatesGross Sales Food %Bev % Total COGS $COGS %
Wk 17 4/19–4/25 $94,622 33.9% 24.3% $30,204 31.9%
Wk 18 4/26–5/2 $77,825 28.9% 28.1% $23,321 30.0%
Wk 19 5/3–5/9 $90,414 32.8% 16.6% $25,494 28.2%
Wk 20 5/10–5/16 $110,234 26.9% 15.6% $26,417 24.0%
4-Week Average $93,274 30.6% 20.5% $26,359 28.3%

COGS % Trend

Sales & COGS $ by Week

Food Detail

$19,628
Wk 20 Purchases
26.9%
Current COGS %
30.6%
4-Week Avg
29.0%
Target
+$3,905
4wk Var to Target
Vendor / ItemGLPackQtyAmount
US Foods $7,301
Baldor Boston $3,602
Ipswich Shellfish Co $3,262
New England Mutual Trading $2,124
Paul W. Marks Co. $1,258
True World Foods Boston LLC $903
Island Creek Oysters $770
Boston Bread Service $215
Deano's Pasta $126
Southern Glazer's Beverage Company $68

Beverage Detail

$5,839
Wk 20 Purchases
15.6%
Current COGS %
20.5%
4-Week Avg
Beer
25.0%
$1,739
Liquor
4.5%
$1,014
Wine
35.4%
$2,056
NA Beverage
48.0%
$1,030
Vendor / ItemGLPackQtyAmount
Seaboard Products $2,083
Southern Glazer's Beverage Company $1,530
M. S. Walker $1,144
US Foods $500
Paul W. Marks Co. $187
Baldor Boston $176
Merrimack Valley Distributing Co. $154
Atomic Coffee Roasters $65

Paper Goods

$949
Wk 20 Purchases
0.9%
Current %
1.0%
4-Week Avg %
Vendor / ItemGLPackQtyAmount
TriMark United East $949

Week 20 Purchases by Vendor — All Categories

VendorFoodBeveragePaperTotal
US Foods $7,301 $500 $7,801
Baldor Boston $3,602 $176 $3,778
Ipswich Shellfish Co $3,262 $3,262
New England Mutual Trading $2,124 $2,124
Seaboard Products $2,083 $2,083
Southern Glazer's Beverage Company $68 $1,530 $1,598
Paul W. Marks Co. $1,258 $187 $1,445
M. S. Walker $1,144 $1,144
TriMark United East $949 $949
True World Foods Boston LLC $903 $903
Island Creek Oysters $770 $770
Boston Bread Service $215 $215
Merrimack Valley Distributing Co. $154 $154
Deano's Pasta $126 $126
Atomic Coffee Roasters $65 $65
24
Price Increases
36
Price Decreases
60
Items Compared

↑ Price Increases (Wk 19 → Wk 20)

ItemVendorWk 19 $/unitWk 20 $/unitChange
OIL - BLENDED US Foods $89.24 $106.88 +$17.64
CHICKEN - BREAST US Foods $76.95 $86.42 +$9.47
CARROTS Baldor Boston $38.00 $40.93 +$2.93
BRUSSELL SPROUTS Baldor Boston $42.21 $45.08 +$2.87
FRY SHORTENING Paul W. Marks Co. $33.30 $35.90 +$2.60
LETTUCE - GREEN LEAF Baldor Boston $36.23 $38.20 +$1.97
BROCCOLI Baldor Boston $42.31 $44.20 +$1.89
PEPPER - SERRANO Baldor Boston $6.65 $8.33 +$1.68
OYSTERS Ipswich Shellfish Co $75.33 $77.00 +$1.67
SWEET POTATO FRIES US Foods $44.69 $45.82 +$1.13
KETCHUP - JUG US Foods $48.37 $49.35 +$0.98
FRENCH FRIES US Foods $45.95 $46.65 +$0.70
LETTUCE - ROMAINE Baldor Boston $48.66 $49.35 +$0.69
BUTTERMILK Paul W. Marks Co. $15.09 $15.75 +$0.66
FRY SHORTENING Paul W. Marks Co. $33.51 $34.13 +$0.62
SCALLIONS Baldor Boston $23.78 $24.38 +$0.60
FLOUR - CORN US Foods $31.41 $31.97 +$0.56
TUNA - SUSHI Ipswich Shellfish Co $14.50 $14.95 +$0.45
QUINOA US Foods $40.97 $41.16 +$0.19
AVOCADO Baldor Boston $42.79 $42.91 +$0.12
MILK Paul W. Marks Co. $2.57 $2.66 +$0.09
GARLIC - PEELED Baldor Boston $17.38 $17.46 +$0.08
SALMON - SUSHI True World Foods Boston LLC $7.42 $7.50 +$0.08
OYSTERS Island Creek Oysters $1.21 $1.28 +$0.07

↓ Price Decreases (Wk 19 → Wk 20)

ItemVendorWk 19 $/unitWk 20 $/unitChange
TOMATO - 5x6 Baldor Boston $85.48 $50.67 $34.81
CAULIFLOWER Baldor Boston $68.72 $55.26 $13.46
MUSHROOM - OYSTER Baldor Boston $31.35 $26.85 $4.50
LETTUCE - FRISEE Baldor Boston $36.58 $32.10 $4.48
TOMATOES - CHERRY - HEIRLOOM Baldor Boston $22.95 $18.78 $4.17
EGG - WHOLE Paul W. Marks Co. $24.00 $20.57 $3.43
SPINACH Baldor Boston $26.60 $23.80 $2.80
TOBIKO - ALL New England Mutual Trading $32.00 $30.00 $2.00
BUTTER - ALL Paul W. Marks Co. $91.45 $89.51 $1.94
FARRO Baldor Boston $23.46 $21.54 $1.92
THYME Baldor Boston $5.23 $3.36 $1.87
SALMON Ipswich Shellfish Co $12.25 $10.50 $1.75
PASTA - DRY US Foods $30.88 $29.16 $1.71
BEAN SPROUTS Baldor Boston $23.04 $21.74 $1.30
CHIVES Baldor Boston $15.44 $14.39 $1.05
TORTILLA - CORN - 6" Baldor Boston $55.58 $54.55 $1.03
TOMATO - RED GRAPE Baldor Boston $28.26 $27.31 $0.95
PORK - RACK Baldor Boston $11.58 $10.66 $0.92
POTATO - YUKON - GOLD Baldor Boston $23.12 $22.35 $0.77
BANANAS Baldor Boston $10.69 $10.02 $0.67
ROSEMARY Baldor Boston $5.46 $4.92 $0.54
MANGOES Baldor Boston $12.66 $12.15 $0.51
HAMACHI - YELLOWTAIL New England Mutual Trading $15.50 $15.00 $0.50
TASSO HAM Baldor Boston $8.82 $8.33 $0.49
CHEESE - MONTEREY JACK - BLEND Paul W. Marks Co. $65.17 $64.76 $0.41
BRUSSELL SPROUTS Baldor Boston $29.16 $28.86 $0.30
CILANTRO Baldor Boston $10.45 $10.23 $0.22
JUICE - PINEAPPLE Baldor Boston $35.73 $35.57 $0.16
OIL - TRUFFLE - WHITE Baldor Boston $29.86 $29.77 $0.09
PARSLEY Baldor Boston $2.46 $2.38 $0.08
CUCUMBERS Baldor Boston $13.02 $12.95 $0.07
COD Ipswich Shellfish Co $14.00 $13.97 $0.03
SHRIMP - 21/25 Ipswich Shellfish Co $6.45 $6.42 $0.03
SHALLOTS - PEELED Baldor Boston $17.73 $17.70 $0.03
CHEESE - GRANA PADANO Paul W. Marks Co. $6.48 $6.45 $0.03
POTATO - YAM Baldor Boston $22.16 $22.15 $0.01