Page 529 - Onboarding May 2017
P. 529
Applebee’s Monthly Distributor Service Report
Applebee's SERVICE LEVEL REPORT FSA SSA SSA SSA Sysco Sysco
Portland Glazier Maines NY McLane OH McLane WI Fontana Milpitas Phoenix Atlanta Lincoln
PERIOD 03 - 2017
Period Total Period Total Period Total Period Total Period Total Period Total Period Total Period Total Period Total Period Total
March March March March March March March March March March
Applebee's Stores Serviced 304 638 1766 1240 580 221 284 156 240 700
Avg. Deliveries/Store 2.0 2.0 2.1 1.8 1.9 2.0 2.0 2.0 1.6 2.1
Avg. Cases/Store 252 232 299 297 234 265 258 264 242 311
Total Sales (Applebee's Only) $ 3,272,713 $ 6,384,438 $ 21,871,113 $ 14,723,543 $ 5,589,350 $ 2,559,440 $ 3,173,244 $ 1,775,500 $ 2,458,310 $ 7,817,670
Avg. Selling Price/Case $ 42.69 $ 43.08 $ 41.36 $ 39.92 $ 41.12 $ 43.77 $ 43.28 $ 43.05 $ 42.37 $ 35.92
Total # of Applebee's Invoices 1,005 1,566 4,054 2,691 1,183 603 786 412 394 1,541
Invoices with Errors 0 421 948 384 87 0 0 0 10 214
Clean Invoice % 100.0% 73.1% 76.5% 85.7% 92.6% 100.0% 100.0% 100.0% 97.5% 86.1%
TOTAL CASES SHIPPED 76,666 148,211 527,319 368,809 135,933 58,474 73,322 41,240 58,017 217,638
TOTAL # OF SCHEDULED DELIVERIES 609 1272 3634 2289 1103 450 567 316 394 1454
AVG. CASES PER DELIVERY 126 117 145 161 123 130 129 131 147 150
ON TIME DELIVERIES 576 1168 3463 2006 1037 444 501 309 384 1430
ON TIME DELIVERIES % 94.6% 91.8% 95.3% 87.6% 94.0% 98.7% 88.4% 97.8% 97.5% 98.3%
RETURNS - STORE ORDER ERROR 84 4 758.082 64 30 98 46 42 112 161
RETURNS - QA 0 3 25.013 39 18 0 0 0 1 1
TOTAL RETURNS 84 7 783.095 103 48 98 46 42 113 162
RETURNS % 0.11% 0.00% 0.46% 0.03% 0.04% 0.17% 0.06% 0.10% 0.19% 0.07%
Restaurant Service Level 99.89% 100.00% 99.54% 99.97% 99.96% 99.83% 99.94% 99.90% 99.81% 99.93%
MISPICKS 9 14 24 64 18 4 6 7 12 27
SHORT AT STOP - FOUND LATER 0 2 288.833 40 19 0 0 0 1 19
SHORT ON TRUCK 62 79 145 220 36 6 34 7 44 134
MISPICKS & SHORTS - TOTAL 71 95 458 324 73 10 40 14 57 180
MISPICKS & SHORTS % 0.09% 0.06% 0.09% 0.09% 0.05% 0.02% 0.05% 0.03% 0.10% 0.08%
DAMAGES 25 18 129 86 27 10 20 9 3 80
DAMAGES % 0.03% 0.01% 0.02% 0.02% 0.02% 0.02% 0.03% 0.02% 0.01% 0.04%
BUYER OUTS 149 210 160 4 9 32 10 3 121 83
BUYER OUTS % 0.19% 0.14% 0.03% 0.00% 0.01% 0.05% 0.01% 0.01% 0.21% 0.04%
WAREHOUSE OUTS 0 52 190 0 0 0 1 0 0 0
WAREHOUSE OUTS % 0.00% 0.04% 0.04% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
TOTAL MISPICKS-SHORTS-DAMAGES-OUTS 245 375 937 414 109 52 71 26 181 343
TOTAL MISPICKS-SHORTS-DAMAGES-
OUTS % 0.32% 0.25% 0.18% 0.11% 0.08% 0.09% 0.10% 0.06% 0.31% 0.16%
DISTRIBUTOR Fill Rate 99.68% 99.75% 99.82% 99.89% 99.92% 99.91% 99.90% 99.94% 99.69% 99.84%
