Page 526 - Onboarding May 2017

Applebee’s Monthly Distributor Service Report

===> INDICATES DC ENTRY
Applebee's SERVICE LEVEL FONTANA REQUIRED
REPORT
SSA FONTANA
PERIOD 4 - April 2017 Week 1 Week 2 Week 3 Week 4 Week 5 Period Total Period Average
03/26 - 04/01 04/02 - 04/08 04/09 - 04/15 04/16 - 04/22 04/23 - 04/29 03/26 - 04/29 03/26 - 04/29
Applebee's Stores Serviced 56 56 56 56 56 280 56
Avg. Deliveries/Store 2.02 2.00 2.04 1.96 2.04 2.01 2.01
Avg. Cases/Store 261 265 265 226 260 255 255
Total Sales (Applebee's Only) $631,818 $655,367 $649,325 $555,952 $646,788 3139250 627850
Avg. Selling Price/Case $43.27 $44.11 $43.77 $43.94 $44.44 $43.90 $43.90
Total # of Applebee's Invoices 138 146 144 125 141 694 139
Invoices with Errors 0 0 0 0 0 0 0
Clean Invoice % 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
TOTAL CASES SHIPPED 14602 14857 14836 12652 14555 71502 14300
TOTAL # OF SCHEDULED DELIVERIES 113 112 114 110 114 563 113
AVG. CASES PER DELIVERY 129 133 130 115 128 127 127
ON TIME DELIVERIES 110 111 114 110 113 558 112
ON TIME DELIVERIES % 97.35% 99.11% 100.00% 100.00% 99.12% 99.11% 99.11%
RETURNS - STORE ORDER ERROR 6 0 20 0 0 26 5
RETURNS - QA 0 0 0 0 0 0 0
TOTAL RETURNS 6 0 20 0 0 26 5.2
RETURNS % 0.04% 0.00% 0.13% 0.00% 0.00% 0.04% 0.04%
Applebee's CASE ACCURACY 99.96% 100.00% 99.87% 100.00% 100.00% 99.96% 99.96%
MISPICKS 0 0 2 3 1 6 1
SHORT AT STOP - FOUND LATER 0 0 0 0 0 0 0
SHORT ON TRUCK 6 9 2 0 2 19 4
MISPICKS & SHORTS - TOTAL 6 9 4 3 3 25 5
MISPICKS & SHORTS % 0.04% 0.06% 0.03% 0.02% 0.02% 0.03% 0.03%
DAMAGES 2 3 0 2 0 7 1
DAMAGES % 0.01% 0.02% 0.00% 0.02% 0.00% 0.01% 0.01%
BUYER OUTS 0 0 3 2 1 6 1
BUYER OUTS % 0.00% 0.00% 0.02% 0.02% 0.01% 0.01% 0.01%
WAREHOUSE OUTS 0 0 0 0 0 0 0
WAREHOUSE OUTS % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
TOTAL MISPICKS-SHORTS-DAMAGES-OUTS 8 12 7 7 4 38 7.6
TOTAL MISPICKS-SHORTS-DAMAGES-OUTS % 0.05% 0.08% 0.05% 0.06% 0.03% 0.05% 0.05%
DISTRIBUTOR FILL RATE 99.95% 99.92% 99.95% 99.94% 99.97% 99.95% 99.95%