Maggies Farm
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
23.9%-8.8pp
Food COGS %
4-wk avg: 28.6%
↑ worse   ↓ better vs prior 4-wk avg
11.3%-4.6pp
Beverage COGS %
4-wk avg: 17.2%
↑ worse   ↓ better vs prior 4-wk avg
21.6%-7.0pp
Total COGS %
WeekDatesGross Sales Food %Bev % Total COGS $COGS %
Wk 17 4/19–4/25 $148,248 28.2% 16.8% $38,845 26.2%
Wk 18 4/26–5/2 $123,785 30.2% 25.5% $37,627 30.4%
Wk 19 5/3–5/9 $128,267 32.7% 15.9% $36,738 28.6%
Wk 20 5/10–5/16 $137,100 23.9% 11.3% $29,650 21.6%
4-Week Average $134,350 28.6% 17.2% $35,715 26.6%

COGS % Trend

Sales & COGS $ by Week

Food Detail

$23,369
Wk 20 Purchases
23.9%
Current COGS %
28.6%
4-Week Avg
29.0%
Target
−$1,477
4wk Var to Target
Vendor / ItemGLPackQtyAmount
US Foods $11,088
Performance Food Group Inc $4,486
Baldor Boston $3,326
Ipswich Shellfish Co $2,091
True World Foods Boston LLC $1,555
Boston Bread Service $700
Richardson Farms $123

Beverage Detail

$4,458
Wk 20 Purchases
11.3%
Current COGS %
17.2%
4-Week Avg
Beer
11.8%
$1,389
Liquor
7.1%
$1,396
Wine
13.8%
$668
NA Beverage
33.0%
$1,005
Vendor / ItemGLPackQtyAmount
Seaboard Products $1,589
M. S. Walker $1,003
Martignetti Companies $912
US Foods $536
Baldor Boston $266
Performance Food Group Inc $153

Paper Goods

$1,823
Wk 20 Purchases
1.3%
Current %
1.3%
4-Week Avg %
Vendor / ItemGLPackQtyAmount
TriMark United East $1,720
US Foods $103

Week 20 Purchases by Vendor — All Categories

VendorFoodBeveragePaperTotal
US Foods $11,088 $536 $103 $11,727
Performance Food Group Inc $4,486 $153 $4,638
Baldor Boston $3,326 $266 $3,592
Ipswich Shellfish Co $2,091 $2,091
TriMark United East $1,720 $1,720
Seaboard Products $1,589 $1,589
True World Foods Boston LLC $1,555 $1,555
M. S. Walker $1,003 $1,003
Martignetti Companies $912 $912
Boston Bread Service $700 $700
Richardson Farms $123 $123
38
Price Increases
39
Price Decreases
77
Items Compared

↑ Price Increases (Wk 19 → Wk 20)

ItemVendorWk 19 $/unitWk 20 $/unitChange
CHEESE - BURRATA US Foods $17.10 $25.16 +$8.06
ZUCCHINI Baldor Boston $27.31 $32.25 +$4.94
TOMATO - BEEFSTEAK Baldor Boston $68.07 $72.46 +$4.39
CRAB - CLAW Performance Food Group Inc $78.78 $82.17 +$3.39
PARSNIP Baldor Boston $27.31 $30.64 +$3.33
LETTUCE - GREEN LEAF Baldor Boston $36.02 $38.48 +$2.46
CARROTS Baldor Boston $38.48 $40.93 +$2.45
LETTUCE - ICEBURG US Foods $37.02 $39.30 +$2.28
OYSTERS Ipswich Shellfish Co $94.00 $96.00 +$2.00
CHEESE - BURRATA Baldor Boston $37.90 $39.89 +$1.99
PEPPER - SERRANO Baldor Boston $6.65 $8.33 +$1.68
CHICKEN - TENDERS US Foods $74.94 $76.13 +$1.19
HARICOT VERT Baldor Boston $12.51 $13.52 +$1.01
TUNA - SUSHI Ipswich Shellfish Co $14.50 $15.50 +$1.00
BEEF BASE US Foods $46.97 $47.93 +$0.96
SOUR CREAM Performance Food Group Inc $41.43 $42.36 +$0.93
BUTTER - ALL US Foods $85.59 $86.49 +$0.90
FRENCH FRIES US Foods $45.86 $46.56 +$0.70
ROSEMARY Baldor Boston $10.45 $11.04 +$0.59
BACON US Foods $76.30 $76.88 +$0.58
FRENCH FRIES Performance Food Group Inc $44.90 $45.47 +$0.57
FLOUR - CORN US Foods $31.41 $31.97 +$0.56
CARROTS - BABY Baldor Boston $17.12 $17.61 +$0.49
CHICKEN - WINGS Performance Food Group Inc $55.12 $55.56 +$0.44
OIL - CANOLA Baldor Boston $48.29 $48.59 +$0.30
GARLIC - PEELED Baldor Boston $17.13 $17.41 +$0.28
MANGOES Baldor Boston $11.88 $12.15 +$0.27
CHEESE - CHEDDAR - SHREDDED US Foods $47.31 $47.55 +$0.24
ONION RINGS US Foods $25.98 $26.21 +$0.23
CELERY Baldor Boston $39.90 $40.09 +$0.20
LETTUCE - ARCADIA Baldor Boston $11.47 $11.60 +$0.13
KETCHUP - POUCH US Foods $33.90 $33.99 +$0.09
LEMONS Baldor Boston $37.58 $37.66 +$0.08
BEEF - CORNED BOTTOM ROUND Performance Food Group Inc $6.34 $6.41 +$0.07
BEANS - BLACK - CANNED US Foods $37.76 $37.81 +$0.05
CHEESE - CHEDDAR US Foods $29.76 $29.80 +$0.04
CHICKEN - DICED US Foods $2.90 $2.92 +$0.02
CREAM - WHIPPED Performance Food Group Inc $36.85 $36.87 +$0.02

↓ Price Decreases (Wk 19 → Wk 20)

ItemVendorWk 19 $/unitWk 20 $/unitChange
POTATO - YAM Baldor Boston $80.51 $35.71 $44.80
TOMATO - PLUM US Foods $66.88 $45.61 $21.27
PEACHES Baldor Boston $77.66 $59.25 $18.41
BACON BITS Performance Food Group Inc $69.18 $55.86 $13.32
BROCCOLINI Baldor Boston $45.60 $33.78 $11.82
TOMATO - RED GRAPE Baldor Boston $27.31 $17.77 $9.54
CABBAGE - SLAW MIX Baldor Boston $16.39 $6.88 $9.51
LETTUCE - HYDRO BOSTON Baldor Boston $22.56 $14.93 $7.63
LETTUCE - ROMAINE - HEARTS Baldor Boston $41.14 $35.57 $5.58
TOMATO - PLUM Baldor Boston $65.46 $60.80 $4.66
LIMES - BAR Baldor Boston $21.14 $17.33 $3.81
SPICE - BLACK PEPPER - FINE Baldor Boston $50.91 $47.34 $3.57
BASIL Baldor Boston $11.88 $8.90 $2.98
AVOCADO Baldor Boston $39.88 $37.10 $2.78
BOK CHOY - BABY Baldor Boston $3.56 $1.02 $2.54
LIMES Baldor Boston $19.71 $17.33 $2.38
ONION - SPANISH Baldor Boston $32.61 $30.49 $2.12
EGGPLANT Baldor Boston $32.30 $30.41 $1.89
APPLE CIDER Baldor Boston $10.06 $8.18 $1.88
MUSHROOM - CREMINI Baldor Boston $29.69 $28.13 $1.56
POTATO - 60 Baldor Boston $23.56 $22.03 $1.52
THYME Baldor Boston $10.45 $8.94 $1.51
PUREE - PASSION FRUIT - BAR Baldor Boston $21.94 $20.66 $1.28
MILK Performance Food Group Inc $17.49 $16.37 $1.12
BACON Performance Food Group Inc $71.52 $70.48 $1.04
TAHINI PASTE Baldor Boston $5.79 $5.06 $0.72
PUREE - BLOOD ORANGE - BAR Baldor Boston $19.37 $18.73 $0.64
POTATO - PEE-WEE Baldor Boston $15.91 $15.41 $0.50
SCALLIONS Baldor Boston $1.58 $1.17 $0.41
ONION - RED Baldor Boston $18.88 $18.48 $0.40
BEEF - CORNED BOTTOM ROUND US Foods $7.77 $7.45 $0.32
CHEESE - CHEDDAR Performance Food Group Inc $25.57 $25.27 $0.30
CUCUMBERS Baldor Boston $9.75 $9.49 $0.26
PEPPER - RED Baldor Boston $19.71 $19.48 $0.23
CILANTRO Baldor Boston $10.45 $10.23 $0.22
BEAN SPROUTS Baldor Boston $11.48 $11.33 $0.15
MUSHROOM - CREMINI Baldor Boston $12.58 $12.46 $0.12
ARUGULA - BABY Baldor Boston $17.45 $17.36 $0.10
BRUSSELL SPROUTS Baldor Boston $28.91 $28.86 $0.05