Casey Js
4-Week Rolling COGS Report — Week 40 (9/27–10/3)
Casey Js food cost is structurally elevated — catering purchases inflate food costs while catering revenue is excluded from the sales denominator.
Summary
Food Detail
Beverage Detail
Paper Goods
By Vendor
💰 Price Variance
Food COGS (Wk 40)
30.4%
4-wk avg: 27.4% ▶ · tgt 29.0%
▲ worse ▼ better vs prior 4-wk
Beverage COGS (Wk 40)
18.6%
4-wk avg: 33.8% ▼ · tgt 21.5%
▲ worse ▼ better vs prior 4-wk
Total COGS
30.6%
4-wk dollar-weighted
Weekly Detail
| Week | Dates | Gross Sales | Food % | Bev % | Total COGS $ | COGS % |
|---|
| Wk 37 | 9/6–9/12 | $36,231 | 26.8% | 74.9% | $12,849 | 35.5% |
| Wk 38 | 9/13–9/19 | $20,642 | 24.5% | 2.0% | $5,294 | 25.6% |
| Wk 39 | 9/20–9/26 | $43,201 | 26.9% | 29.3% | $12,772 | 29.6% |
| Wk 40 | 9/27–10/3 | $34,078 | 30.4% | 18.6% | $10,182 | 29.9% |
| 4-Week Avg | — | 27.4% ▶ | 33.8% ▼ | — | 30.6% |
Food Category Trends (4-Week vs Prior) ▶
| Category | 4-Wk | Prior 4-Wk | Change $ |
|---|
| Fish/Seafood | $1,973 | $1,173 | +801 |
| Meat/Poultry | $14,004 | $13,348 | +656 |
| Produce | $3,293 | $3,158 | +135 |
| Sushi | $0 | $102 | -102 |
| Dairy | $1,020 | $1,104 | -83 |
| Bread/Bakery | $1,471 | $1,416 | +55 |
| Dry Goods | $8,158 | $8,148 | +10 |
| Food Misc | $100 | $100 | +0 |
Week 40 Food Purchases — Vendor / Item
| Vendor / Item | GL | Pack | Qty | Amount |
|---|
| BEEF - BRISKET | 4065 | LB WEIGHT | 193.6 | $1,106.82 |
| BEEF - BOTTOM SIRLOIN FLAP | 4065 | LB WEIGHT | 78.3 | $988.15 |
| PORK - BUTT | 4065 | LB WEIGHT | 223.36 | $489.01 |
| BREAD - BURGER BUN - ALL | 4020 | CA 5/12/2.12 OZ | 10 | $311.30 |
| FRENCH FRIES | 4035 | CA 6/5 LB | 6 | $279.90 |
| BEEF - PATTY | 4065 | CA 56/4 OZ | 4 | $253.12 |
| SALMON | 4040 | CA 1/10 LB | 2 | $197.86 |
| CHICKEN - WINGS | 4065 | CA 4/10 LB | 3 | $190.12 |
| MACARONI & CHEESE - PREPARED | 4035 | CA 4/5 LB | 4 | $175.48 |
| APPLES - ALL | 4080 | CA 6/2.5 LB | 2 | $123.60 |
| HADDOCK | 4040 | CA 1/10 LB | 1 | $117.55 |
| BRUSSELL SPROUTS | 4080 | CA 2/5 LB | 4 | $112.84 |
| BROWNIE MIX | 4035 | CA 4/120 OZ | 1 | $98.05 |
| COOKIE DOUGH - ALL | 4035 | CA 240/1.33 OZ | 1 | $96.05 |
| KETCHUP - BOTTLE | 4035 | CA 30/20 OZ | 1 | $88.69 |
| CHICKEN - TENDERS | 4065 | LB WEIGHT | 20 | $79.80 |
| CRAB CAKE | 4035 | CA 100/.75 OZ | 1 | $77.25 |
| CHICKEN - BREAST | 4065 | CA 4/5 LB | 1 | $74.56 |
| BEEF - PATTY | 4065 | CA 20/8 OZ | 1 | $73.28 |
| BEANS - KIDNEY | 4035 | CA 6/#10 CN | 2 | $67.24 |
| TOMATO - DICED | 4035 | CA 6/#10 CN | 1 | $57.95 |
| PRETZEL | 4035 | CA 50/5 OZ | 1 | $57.94 |
| CHEESE - AMERICAN - SLICED | 4030 | CA 4/5 LB | 1 | $57.75 |
| PICKLES - DILL - CHIPS | 4035 | 4 GAL | 1 | $52.73 |
| KETCHUP - CANNED | 4035 | CA 6/#10 CN | 1 | $46.25 |
| MAYO - HEAVY | 4035 | CA 4/1 GAL | 1 | $41.13 |
| SUGAR | 4035 | CA 1/50 LB | 1 | $29.46 |
| SAUERKRAUT - SHREDDED | 4035 | CA 1/2 GAL | 1 | $27.96 |
| CHICKEN - WHOLE | 4065 | LB WEIGHT | 320.56 | $426.34 |
| SAUSAGE - BRATWURST | 4065 | LB WEIGHT | 18.98 | $159.24 |
| FRY SHORTENING | 4035 | 35 LB | 4 | $150.56 |
| PORK - BUTT | 4065 | LB WEIGHT | 46.31 | $124.11 |
| BRESAOLA | 4065 | CA 12/2 oz | 1 | $77.89 |
| BREAD - SUB - SLICED | 4020 | 45 CT | 2 | $75.18 |
| BACON | 4065 | CA 15 LB | 1 | $73.12 |
| TOMATO - PLUM | 4080 | 25 LB | 2 | $68.42 |
| FINOCCHIONA | 4065 | CA 12/3 OZ | 1 | $66.79 |
| SOPRESSATA | 4065 | CA 12/3 OZ | 1 | $66.79 |
| SAUSAGE - CHORIZO | 4065 | CA 12/3 OZ | 1 | $64.19 |
| GREENS - MESCLUN | 4080 | 3 LB | 3 | $64.05 |
| BRUSSELL SPROUTS | 4080 | CA 2/5 LB | 1 | $64.02 |
| POTATO - YUKON - GOLD | 4080 | CA 50 LB | 3 | $61.02 |
| TORTILLA - CORN - 6" | 4020 | CA 30 X 32ea | 1 | $59.74 |
| SPINACH - BABY | 4080 | CA 2/2 LB | 4 | $59.15 |
| OIL - CANOLA | 4035 | CA 6/1 GAL | 1 | $53.56 |
| SPICE - MUSTARD SEED - POWDER | 4035 | 1 LB | 2 | $51.18 |
| SPICE - BLACK PEPPER - FINE | 4035 | 5 LB | 1 | $47.34 |
| COLLARD GREENS | 4080 | 12 CT | 2 | $40.24 |
| POTATO - 90 | 4080 | 50 LB | 1 | $33.90 |
| TOMATO - 5x6 | 4080 | 25 LB | 1 | $33.38 |
| ONION - SPANISH | 4080 | 50 LB | 1 | $26.41 |
| TOMATOES - CHERRY - HEIRLOOM | 4080 | CA 12/1 PT | 1 | $25.10 |
| CORNICHONS | 4035 | 4.87 LB | 1 | $23.69 |
| SPICE - CAYENNE | 4035 | 5 LB | 1 | $22.99 |
| RICE - JASMIN | 4035 | CA 25 LB | 1 | $20.34 |
| SYRUP - CINNAMON | 4035 | BTL 1/L | 2 | $19.98 |
| WATERMELON | 4080 | 1 PC | 2 | $19.50 |
| CUCUMBERS | 4080 | 1 BSH | 1 | $18.92 |
| LETTUCE - HYDRO BOSTON | 4080 | CA 12 EA | 1 | $17.39 |
| ONION - RED | 4080 | 25 LB | 1 | $16.53 |
| FIG SPREAD | 4035 | 9 OZ | 1 | $7.59 |
| CHEESE - GOAT | 4030 | EA 10.5oz | 1 | $7.29 |
| CHEESE - BRIE | 4030 | 8.8 OZ | 1 | $6.79 |
| ROSEMARY | 4080 | 4 OZ | 1 | $5.63 |
| SCALLIONS | 4080 | 5.5 OZ | 2 | $2.88 |
| LOBSTER - CLAW/KNUCKLE - FROZEN | 4040 | LB WEIGHT | 20 | $860.00 |
Beverage Subcategories ▼
Liquor
32.4%
$2,283 / $7,035
NA Beverage
38.0%
$2,529 / $6,657
Week 40 Beverage Purchases — Vendor / Item
| Vendor / Item | GL | Pack | Qty | Amount |
|---|
| WATER - STILL | 4070 | CA 2/12/12 OZ | 22 | $281.44 |
| SYRUP - DIET PEPSI - BIB | 4070 | CA 1/5 GAL | 1 | $115.95 |
| RED BULL - ALL | 4070 | CA 24/8.4 OZ | 2 | $105.98 |
| SYRUP - LEMONADE - BIB | 4070 | CA 1/3 GAL | 1 | $71.94 |
| AGAVE | 4070 | CA 4/1 LT | 1 | $53.35 |
| COKE - PACKAGE | 4070 | CA 12/12 FL OZ | 16 | $182.24 |
| SPRITE - PACKAGE | 4070 | CA 12/12 FL OZ | 12 | $140.28 |
| DIET COKE - PACKAGE | 4070 | CA 12/12 FL OZ | 12 | $136.68 |
| GINGER ALE - PACKAGE | 4070 | CA 12/12 FL OZ | 5 | $58.45 |
| APPLE CIDER | 4070 | CA 4/1 GAL | 1 | $29.99 |
| CREAMERS | 4070 | CASE | 1 | $22.69 |
| MILK | 4070 | .5 GAL | 2 | $5.54 |
Paper Goods (GL 6120)
| Week | Amount |
|---|
| Wk 37 | $162.34 |
| Wk 38 | $1,079.31 |
| Wk 39 | $940.62 |
| Wk 40 | $583.92 |
| 4-Wk Total | $2,766.19 |
Top 30 Vendors — Week 40
| # | Vendor | Week 40 Spend |
|---|
| 1 | US Foods | $6,037.50 |
| 2 | Baldor Boston | $2,737.11 |
| 3 | TriMark United East | $1,077.92 |
| 4 | Ipswich Shellfish Co | $860.00 |
↑ Price Increases (Wk 39 → Wk 40)
| Item | Vendor | Prior $/unit | Cur $/unit | Change |
|---|
| BRUSSELL SPROUTS | Baldor Boston | $28.58 | $64.02 | +$35.44 |
| APPLE CIDER | Baldor Boston | $8.09 | $29.99 | +$21.90 |
↓ Price Decreases (Wk 39 → Wk 40)
| Item | Vendor | Prior $/unit | Cur $/unit | Change |
|---|
| GREENS - MESCLUN | Baldor Boston | $95.75 | $21.35 | $74.40 |
| MAYO - HEAVY | US Foods | $56.78 | $41.13 | $15.65 |
| FRENCH FRIES | US Foods | $52.38 | $46.65 | $5.73 |
| ONION - SPANISH | Baldor Boston | $29.17 | $26.41 | $2.76 |
| TOMATO - 5x6 | Baldor Boston | $35.19 | $33.38 | $1.81 |
| LETTUCE - HYDRO BOSTON | Baldor Boston | $18.84 | $17.39 | $1.45 |