Plan vs Actual

Forecast-to-invoice variance analysis — May 2026 pricing cycle vs actual DC invoices

Year
Month
Version
Forecast Total
$4,178.98
Weekly extended at forecast prices
Actual Total
$4,349.63
Weekly extended at invoiced prices
Net Variance
$170.65+4.1% vs forecast
Material Variances
6>3% variance items

Forecast vs Actual Trend

Monthly comparison — Jan to May 2026 (actuals)

Variance by Driver

Extended weekly impact by cause

Catch Weight$93.04
Fee$31.10
Freight$29.78
FOB Change$15.60
None$1.13
Net Total$170.65

Item-Level Variance Detail

Sorted by absolute extended variance — click a row for details

ItemCategoryDCForecast $/CaseActual $/CaseΔ $/CaseΔ %Forecast $/WkActual $/WkExt ΔDriver
Roast Beef 40lbBeefMcLane Dallas$186.00$192.35$6.35+3.4%$1,843.26$1,927.35$84.09Catch Weight
Curly Fries 6/5lbFries & SidesMcLane Dallas$34.00$36.80$2.80+8.2%$449.14$480.24$31.10Fee
Bacon Thick Slab 15lbPorkPFG Atlanta$92.40$98.10$5.70+6.2%$267.96$289.40$21.44Freight
Cheddar Cheese Block 40lbCheese & DairyPFG Atlanta$102.50$105.80$3.30+3.2%$220.38$232.76$12.38FOB Change
Chicken Strip Breaded 25lbPoultryUS Foods Chicago$61.00$63.50$2.50+4.1%$295.85$304.80$8.95Catch Weight
Fry Oil Soybean 35lb JIBFry OilMcLane Dallas$42.00$43.15$1.15+2.7%$218.40$225.24$6.84FOB Change
Turnover Apple 48ctDessertsSYGMA Denver$22.30$24.90$2.60+11.7%$40.14$44.32$4.18Freight
Ham Deli Style 8lbPorkPFG Atlanta$78.00$79.80$1.80+2.3%$249.60$253.76$4.16Freight
Ground Beef 80/20 10lbBeefMcLane Dallas$56.50$58.10$1.60+2.8%$185.32$183.02-$2.30FOB Change
Pepsi Syrup 5gal BIBFountain BevMcLane Dallas$67.50$67.50$0.00+0.0%$209.25$210.60$1.35None
Arby's Sauce Gallon 4ctSaucesMcLane Dallas$22.00$21.50-$0.50-2.3%$105.60$104.28-$1.32FOB Change
Sesame Seed Bun 4in 12ctBreadUS Foods Chicago$11.20$11.20$0.00+0.0%$94.08$93.86-$0.22None
Total$4,178.98$4,349.63$170.65