Page 570 - Board Member Onboardin August 2019

IHOP Monthly Distributor Service Report

PFG
FSA FSA Gordon Gordon McLane McLane Carroll PFG PFG PFG SSA No. SSA Sysco Sysco USF USF Port USF Van
IHOP SERVICE LEVEL REPORT Billings Portland Dallas Houston Maines NY OH WI Co. Florence Hickory Richmond Soto California Phoenix Intermountain Lincoln Austin Orange Wixom Eerden
PERIOD 6 - 2019
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 Period Total Period Total Period Total Period Total Period Total Grand Totals
June June June June June June June June June June June June June June June June June June June June June
IHOP Stores Serviced 25 235 882 631 429 367 250 878 580 500 325 405 318 144 687 85 714 70 150 7675
Avg. Deliveries/Store 2.0 1.9 2.0 1.9 2.0 1.7 1.7 1.3 1.5 1.9 2.0 2.0 2.0 1.8 1.9 2.0 2.1 2.0 1.9
Avg. Cases/Store 164 229 264 248 257 215 185 306 240 227 270 198 241 184 242 297 243 215 219 246
Total Sales (IHOP Only) $ 144,555 $ 1,763,282 $ 7,881,318 $ 5,357,771 $ 3,662,230 $ 2,676,432 $ 1,551,589 $ 8,760,852 $ 4,723,622 $ 3,753,283 $ 2,767,183 $ 2,748,630 $ 2,582,960 $ 868,538 $ 5,243,332 $ 910,638 $ 5,750,380 $ 542,047 $ 1,076,011 $ 62,764,653
Avg. Selling Price/Case $ 35.34 $ 32.79 $ 33.91 $ 34.22 $ 33.19 $ 33.85 $ 33.62 $ 32.61 $ 33.97 $ 33.06 $ 31.57 $ 34.28 $ 33.68 $ 32.85 $ 31.54 $ 36.02 $ 33.13 $ 36.09 $ 32.78 $
Total # of IHOP Invoices 67 593 2,243 1,418 873 696 488 2,224 909 976 964 976 760 350 1,325 206 1,808 197 324 17,397
Invoices with Errors 0 0 327 126 276 120 71 66 0 0 158 0 0 125 158 20 283 71 0 1,801
Clean Invoice % 100.0% 100.0% 85.4% 91.1% 68.4% 82.8% 85.5% 97.0% 100.0% 100.0% 83.6% 100.0% 100.0% 64.3% 88.1% 90.1% 84.3% 64.0% 100.0% 89.6%
TOTAL CASES SHIPPED 4,091 53,778 232,445 156,556 110,102 79,057 46,145 268,636 139,073 113,537 87,660 80,181 76,685 26,442 166,269 25,284 173,595 15,021 32,821 1,887,378
TOTAL # OF SCHEDULED DELIVERIES 50 455 1736 1175 850 625 437 1126 876 938 658 793 635 264 1300 170 1466 140 291 13985
AVG. CASES PER DELIVERY 82 118 134 133 130 126 106 239 159 121 133 101 121 100 128 149 118 107 113 135
ON TIME DELIVERIES 47 408 1630 1139 791 526 381 1118 872 925 631 776 634 230 1280 159 1297 97 257 13198
ON TIME DELIVERIES % 94.0% 89.7% 93.9% 96.9% 93.1% 84.2% 87.2% 99.3% 99.5% 98.6% 95.9% 97.9% 99.8% 87.1% 98.5% 93.5% 88.5% 69.3% 88.3% 94.4%
RETURNS - STORE ORDER ERROR 0 13.3 45 7 26 6 98 71 130 52 69 345 56 70.25 11 2 69 35 24 1129.55
RETURNS - QA 0 0 5 12 15 0 2 4 26 5 0 0 0 0 2 0 15 1 0 87
TOTAL RETURNS 0 13.3 50 19 41 6 100 75 156 57 69 345 56 70.25 13 2 84 36 24 1216.55
RETURNS % 0.00% 0.02% 0.02% 0.01% 0.25% 0.01% 0.22% 0.03% 0.11% 0.05% 0.08% 0.43% 0.07% 0.27% 0.01% 0.01% 0.05% 0.24% 0.07% 0.06%
Restaurant Service Level 100.00% 99.98% 99.98% 99.99% 99.75% 99.99% 99.78% 99.97% 99.89% 99.95% 99.92% 99.57% 99.93% 99.73% 99.99% 99.99% 99.95% 99.76% 99.93% 99.94%
MISPICKS 0 5 26 9 5 21 4 113 72 30 50 10 44 5 7 0.13 40 22.66 0 463.79
SHORT AT STOP - FOUND LATER 0 0 78 23 60 10 8 146 8 83 24 0 0 0 42 0 20 3 5 510
SHORT ON TRUCK 3 56 121 48 92 85 9 196 97 132 78 42 34 18 100 17 53 56 9 1246
MISPICKS & SHORTS - TOTAL 3 61 225 80 157 116 21 455 177 245 152 52 78 23 149 17 113 81 14 2220
MISPICKS & SHORTS % 0.07% 0.11% 0.10% 0.05% 0.14% 0.15% 0.05% 0.17% 0.13% 0.22% 0.17% 0.06% 0.10% 0.09% 0.09% 0.07% 0.07% 0.54% 0.04% 0.12%
DAMAGES 0 40 19 17 42 59 14 86 31 5 30 27 32 5 64 3 61 13 12 560
DAMAGES % 0.00% 0.07% 0.01% 0.01% 0.04% 0.07% 0.03% 0.03% 0.02% 0.00% 0.03% 0.03% 0.04% 0.02% 0.04% 0.01% 0.04% 0.09% 0.04% 0.03%
BUYER OUTS 10 24 145 8 25 24 11 0 224 65 27 0 4 66 113 21 60 95 59 981
BUYER OUTS % 0.24% 0.04% 0.06% 0.01% 0.02% 0.03% 0.02% 0.00% 0.16% 0.06% 0.03% 0.00% 0.01% 0.25% 0.07% 0.08% 0.03% 0.63% 0.18% 0.05%
WAREHOUSE OUTS 0 0 10 0 53 0 30 0 358 89 0 0 0 2.25 14 124.66 49 6.33 0 736.24
WAREHOUSE OUTS % 0.00% 0.00% 0.00% 0.00% 0.05% 0.00% 0.07% 0.00% 0.26% 0.08% 0.00% 0.00% 0.00% 0.01% 0.01% 0.49% 0.03% 0.04% 0.00% 0.04%
TOTAL MISPICKS-SHORTS-DAMAGES-OUTS 13 125 399 105 277 199 76 541 790 404 209 79 114 96.5 340 166.06 283 195.49 85 4496.966
TOTAL MISPICKS-SHORTS-DAMAGES-OUTS 0.32% 0.23% 0.17% 0.07% 0.25% 0.25% 0.16% 0.20% 0.57% 0.36% 0.24% 0.10% 0.15% 0.36% 0.20% 0.66% 0.16% 1.30% 0.26% 0.24%
DISTRIBUTOR Fill Rate 99.68% 99.77% 99.83% 99.93% 99.75% 99.75% 99.84% 99.80% 99.43% 99.64% 99.76% 99.90% 99.85% 99.64% 99.80% 99.34% 99.84% 98.70% 99.74% 99.76%