Page 337 - Tom Finocchiaro - RPI Apple Onboarding

Applebee’s Monthly Distributor Service Report

FSA FSA Gordon Gordon McLane McLane SSA SSA No. SSA SYGMA Sysco Sysco USF Port
Applebee's SERVICE LEVEL REPORT Billings Portland Dallas Houston Maines NY OH WI PFG Fontana California Phoenix Carolina Intermountain Lincoln Orange
PERIOD 07 - 2018
Period Total Period Total Period Total Period Total Period Total Period Total Period Total Period Total Period Total Period Total Period Total Period Total Period Total Period Total Period Total Grand Totals
July July July July July July July July July July July July July July July July
Applebee's Stores Serviced 24 198 288 148 1389 882 384 231 167 201 103 454 57 495 357 5,378
Avg. Deliveries/Store 2.4 2.0 2.0 2.0 2.0 1.7 1.8 2.0 2.0 2.0 2.0 2.0 2.0 2.1 2.0 2.0
Avg. Cases/Store 284 231 212 204 277 250 211 192 249 244 240 200 249 285 252 247
Total Sales (Applebee's Only) $ 322,162 $ 2,131,253 $ 2,751,111 $ 1,363,048 $ 17,214,575 $ 9,845,642 $ 3,561,581 $ 2,719,636 $ 2,031,429 $ 2,250,020 $ 1,135,091 $ 4,167,869 $ 611,430 $ 5,489,077 $ 3,942,994 $ 59,536,918
Avg. Selling Price/Case $ 47.32 $ 46.54 $ 45.04 $ 45.24 $ 44.53 $ 44.59 $ 43.91 $ 61.21 $ 48.88 $ 45.89 $ 45.85 $ 46.01 $ 43.10 $ 38.91 $ 43.77 $ 44.90
Total # of Applebee's Invoices 76 574 686 344 3,444 1,933 781 630 599 523 364 1,011 139 1,130 865 13,099
Invoices with Errors 0 0 65 79 930 403 54 57 0 0 0 159 34 99 127 2,007
Clean Invoice % 100.0% 100.0% 90.5% 77.0% 72.3% 79.2% 93.1% 91.0% 100.0% 100.0% 100.0% 84.3% 75.5% 91.2% 85.3% 84.7%
TOTAL CASES SHIPPED 6,809 45,792 61,083 30,131 384,572 220,819 81,116 44,429 41,557 49,035 24,754 90,594 14,187 141,057 90,092 1,326,027
TOTAL # OF SCHEDULED DELIVERIES 57 395 576 293 2842 1466 687 468 336 399 207 903 113 1026 724 10,492
AVG. CASES PER DELIVERY 119 116 106 103 135 151 118 95 124 123 120 100 126 137 124 126
ON TIME DELIVERIES 57 378 550 277 2208 1339 612 437 328 390 199 824 113 1013 669 9,394
ON TIME DELIVERIES % 100.0% 95.7% 95.5% 94.5% 77.7% 91.3% 89.1% 93.4% 97.6% 97.7% 96.1% 91.3% 100.0% 98.7% 92.4% 89.5%
RETURNS - STORE ORDER ERROR 0 4 1 21 431 65 27 60 13 8 6 38 72.58 84 69 900
RETURNS - QA 0 10 6 1 32.777 45 45 2 0 0 0 1 0 0 0 143
TOTAL RETURNS 0 14 7 22 463.777 110 72 62 13 8 6 39 72.58 84 69 1042.357
RETURNS % 0.00% 0.03% 0.01% 0.07% 0.24% 0.05% 0.09% 0.14% 0.03% 0.02% 0.02% 0.04% 0.51% 0.06% 0.08% 0.08%
Restaurant Service Level 100.00% 99.97% 99.99% 99.93% 99.76% 99.95% 99.91% 99.86% 99.97% 99.98% 99.98% 99.96% 99.49% 99.94% 99.92% 99.92%
MISPICKS 0 2 5 15 26 38 9 40 1 0 17 19 6 20 36 234
SHORT AT STOP - FOUND LATER 0 0 7 3 358 37 11 7 0 0 0 77 0 38 7 545
SHORT ON TRUCK 3 33 22 31 776 228 34 86 3 70 35 96 10 70 49 1,546
MISPICKS & SHORTS - TOTAL 3 35 34 49 1160 303 54 133 4 70 52 192 16 128 92 2,325
MISPICKS & SHORTS % 0.04% 0.08% 0.06% 0.16% 0.30% 0.14% 0.07% 0.30% 0.01% 0.14% 0.21% 0.21% 0.11% 0.09% 0.10% 0.18%
DAMAGES 4 12 15 11 454 81 14 18 11 18 17 24 2 39 20 740
DAMAGES % 0.06% 0.03% 0.02% 0.04% 0.12% 0.04% 0.02% 0.04% 0.03% 0.04% 0.07% 0.03% 0.01% 0.03% 0.02% 0.06%
BUYER OUTS 5 2 0 0 63 129 2 281 1 0 0 105 26 33 33 680
BUYER OUTS % 0.07% 0.00% 0.00% 0.00% 0.02% 0.06% 0.00% 0.63% 0.00% 0.00% 0.00% 0.12% 0.18% 0.02% 0.04% 0.05%
WAREHOUSE OUTS 0 0 0 0 142 0 2 0 0 3 0 67 0 0 5 219
WAREHOUSE OUTS % 0.00% 0.00% 0.00% 0.00% 0.04% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% 0.07% 0.00% 0.00% 0.01% 0.02%
TOTAL MISPICKS-SHORTS-DAMAGES-OUTS 12 49 49 60 1819 513 72 432 16 91 69 388 44 200 150 3,964
TOTAL MISPICKS-SHORTS-DAMAGES-OUTS % 0.18% 0.11% 0.08% 0.20% 0.47% 0.23% 0.09% 0.97% 0.04% 0.19% 0.28% 0.43% 0.31% 0.14% 0.17% 0.30%
DISTRIBUTOR Fill Rate 99.82% 99.89% 99.92% 99.80% 99.53% 99.77% 99.91% 99.03% 99.96% 99.81% 99.72% 99.57% 99.69% 99.86% 99.83% 99.70%