Appendix 1: Pallet survey sent to the distributors
April 9, 2002 Dear Valued Distributor,
This survey contains 13 questions and will take around 10 minutes to complete. Please do not leave any questions blank, as every answer is valuable to us. We would be very grateful.
If you are not the appropriate person to answer the questions of this survey, we would appreciate if you would forward it to the appropriate department/individual.
Survey guidelines:
1. Open the survey by clicking twice on the attachment icon with the left mouse button.
2. You will probably be able to choose between open and save. Choose “Open”. You will have to choose between “Disable” and “Enable Macros”. Select “Enable macros”. The survey will appear on your screen.
3. Complete the survey to the best of your ability.
4. Once you’ve completed the survey, go to File and click “Save As” to save the document on your computer.
5. Go back to your email and press Reply or New Email (Compose).
6. Click on “Attach” or on the icon to add attachments. Select the saved survey document and “attach to” the email.
7. Now the survey (with your answers) is attached to the email.
8. Send the email to: wnagtglas@heinekenusa.com before Friday April 12
th2002.
NOTE 1: Do not click “Save” after completing the survey. The answers you have chosen will not be saved on the attachment. So please save the document on your computer and then attach it to your (reply) email.
NOTE 2: If you have problems with the e-mail attachment, you may print the survey, complete it on paper and fax it to the following number: 914-286-4785 or mail it to the address which you can find in the email.
You may always call me for any questions or remarks on: 914-681-4125
Thank you very much in advance.
Regards,
Willemijn Nagtglas
Operation Planning
2 1. General information
Distributor name : Contact person : Email address :
2. Which Demand Point are you supplied from?
Boston Newark (NY) Baltimore Norfolk Charleston Miami Houston Long Beach Oakland Seattle
3. How is the quality of the pallets when they arrive at your location?
5 Excellent 4 Very good 3 Good 2 Satisfactory 1 Poor
4. If the pallets are in poor condition when they arrive at your location, what is usually the problem?
Top board is broken Under board is broken Corner Blocks are broken Other, please explain:
5. How would you rate the quality of the Heineken USA “one way” beer pallets to the “one way” beer pallets of the following beer suppliers?
1:Poor 2: Satisfactory 3: Good 4: Very Good 5: Excellent Have return- able pallet Anheuser-Busch
Miller Coors Corona Other
- General -
- - Pa P al ll le et t Qu Q ua al li it ty y - -
Heineken Pallet Survey
3
6. Do you have excess Heineken USA beer pallets?
Yes No
7. How many excess Heineken USA beer pallets do you have each year?
0 – 500 501 – 1000 1001 – 2000 2001 – 3000 3001 – 4000 4001 – 5000 5001 +
8. What do you currently do with the excess Heineken USA beer pallets?
Sell to a third party
If so, to which third party?
Reuse them
Pay a third party to remove them
If so, to which third party?
Other, if so please explain:
9. What are YOUR current costs associated with the excess Heineken USA beer pallets?
$0 per pallet $0 - $1 per pallet $1 - $2 per pallet $2 - $3 per pallet
Other, if so please explain:
10. Would you be interested in Heineken offering you an alternative solution to your excess pallets?
Yes, if so please explain:
No
Heineken Pallet Survey
- - Em E mp pt ty y b be ee e r r pa p al ll le e ts t s - -
11. Does the current size of the Heineken pallet fit in all of your Delivery trucks?
Yes No
12. Would you recommend a different size pallet for Heineken products to be shipped on?
Yes, if so what size:
No
13. Do you currently collect excess beer pallets from your customers?
Yes, if so from what percentage of your customers? % No
- Customer supplying -
- - A A D DD DI IT TI IO ON NA AL L C C O OM MM ME EN NT TS S - -
4
Heineken Pallet Survey
Appendix 2: List of Interested distributors
Interested Heineken distributors Keg DP State NATIONAL DISTRIBUTING Co of DC Baltimore DC STANDARD DISTRIBUTING C, Delaw Baltimore DE
BOZICK DISTRIBUTORS, IN Baltimore MD
KOHLER DISTRIBUTING COM Baltimore NJ
WARREN DISTRIBUTING CO. Baltimore NJ
BROWN DISTRIBUTING COMPANY Baltimore OH
CITY BEVERAGE COMPANY Baltimore OH
ESBER BEVERAGE COMPANY Baltimore OH
GIL SCHWARTZ DISTRIBUTO Baltimore OH
H. DENNERT DISTRIBUTING Baltimore OH
HILL DISTRIBUTING COMPA Baltimore OH
TRAMONTE DISTRIBUTING C Baltimore OH
BANKO DISTRIBUTING COMP Baltimore PA
DEBLASIO BEVERAGE CO., Baltimore PA
ERME'S BEER DISTRIBUTOR Baltimore PA
GOETTLER DIST., INC. Baltimore PA
ORIGLIO BEVERAGE (ANTONIO, INC Baltimore PA
T. VERRASTRO BEER DIST. Baltimore PA
CHESBAY DISTRIBUTING CO Baltimore VA
FREEMAN BEVERAGE CO., I Baltimore VA
ATOMIC DISTRIBUTING CO. Baltimore WV
CARENBAUER WHOLESALE CO. Baltimore WV
DICHELLO DISTRIBUTORS, Boston CT
DWAN & COMPANY, INC. Boston CT
HARTFORD DISTRIBUTORS, Boston CT
HORIZON BEV. CO. COASTAL BEV. Boston MA
HORIZON BEV. CO. PREMIUM Boston MA
MAINE DISTRIBUTORS, INC Boston ME
SENECAL BEVERAGE CO. Boston NH
BARTYZEL, INC. Boston NY
EAGLE BEVERAGE COMPANY, Boston NY
FINGER LAKES BOTTLING C Boston NY
SANZO BEVERAGE CO., INC Boston NY
TRI-VALLEY BEVERAGE, IN Boston NY
TRY-IT DISTRIBUTING CO. Boston NY
WRIGHT-WISNER DIST. COR Boston NY
ALLSTATE BEVERAGE CO. Charleston AL
GULF DISTRIBUTING CO., INC Charleston AL SUPREME BEVERAGE CO., INC. - H Charleston AL
BETTER BRANDS atlanta Charleston GA
FLINT BEVERAGE CO., INC Charleston GA
GEORGIA CROWN DISTRIBUT Charleston GA
JACKSON BEVERAGE CO., I Charleston GA
MID GEORGIA SALES COMPANY Charleston GA
RIVER CITY DISTRIBUTING Charleston KY
BENNETT DISTRIBUTING CO Charleston NC
BJT INC./ Mutual Distributing: Charleston NC BJT INC./ Mutual Distributing: Charleston NC COASTAL BEVERAGE - Elizabeth C Charleston NC COASTAL BEVERAGE - New Bern Charleston NC
WARD DIST. CO., INC./ A Charleston NC
B & B DISTRIBUTORS, INC Charleston SC
Interested Heineken distributors Keg DP State BUDWEISER OF SPARTANBURG, INC. Charleston SC CHRIS J. YAHNIS COASTAL: Colum Charleston SC CHRIS J. YAHNIS COASTAL: Conwa Charleston SC CHRIS J. YAHNIS COASTAL: Flore Charleston SC
A.S. BARBORO, INC. Charleston TN
AJAX DISTRIBUTING COMPANY, INC Charleston TN
AJAX TURNER CO., INC. Charleston TN
CLYCE DISTRIBUTING CO., Charleston TN
GEORGE DINWIDDIE DIST.(Cherokee) Charleston TN
E & F DISTRIBUTING COMP Chicago IL
GENEVA BOTTLING WORKS, Chicago IL
KOERNER DISTRIBUTOR, IN Chicago IL
MATTHEWS DIST. CO. Chicago IL
PREMIUM BRANDS , LTD Chicago IL
WORKING DISTRIBUTORS, I Chicago IN
O & W, INC. Chicago MI
HOHENSTEINS, INC. Chicago MN
KUETHER DISTRIBUTING CO Chicago MN
THORPE Chicago MN
FISHER BEVERAGE, INC. Chicago SD
LEE BEVERAGE CO., INC. Chicago WI
MILLER BRANDS- MILWAUKEE, LCC Chicago WI
WOW DISTRIBUTORS, INC. Chicago WI
COORS DISTRIBUTING COMP Houston CO
G & G DISTRIBUTION CORP Houston LA
JIM CAREY DISTRIBUTING Houston LA
STREVA DIST. CO. OF NEW Houston LA
MAJOR BRANDS OF ST LOUIS Houston MO
THE BEER COMPANy, LLC Houston MO
BETTER BRANDS verone Houston MS
F.E.B. DISTRIBUTING CO. Houston MS
GULF DISTRIBUTING OF Mississipy Houston MS
MISSISSIPPI BEVERAGE Houston MS
NEW MEXICO BEVERAGE Houston NM
LDF SALES Houston OK
GEORGE DISTRIBUTING Houston TX
GIGLIO DISTRIBUTING CO. Houston TX
HALO DIST. CO. Houston TX
HDC DISTRIBUTING, LTD. Houston TX
MILLER DIST. OF FT. WORTH, INC Houston TX
PRICE DISTRIBUTING COMP Houston TX
WILLOW DISTRIBUTORS, IN Houston TX
WRIGHT DISTRIBUTING CO. Houston TX
FINLEY DISTRIBUTING CO. Los Angeles AZ
FRED NACKARD WHSLE. LIQ Los Angeles AZ
GOLD COAST BEVERAGE DIST., INC Miami FL
J.J. TAYLOR-Tampa Miami FL
JJ TAYLOR - FT. MYERS/NAPLES Miami FL
S.R. PERROTT, INC. Miami FL
SCHENCK DISTRIBUTING - Rockled Miami FL
ADVANCE BEVERAGE CO., INC. Oakland CA
BAY AREA BEVERAGE Oakland CA
Interested Heineken distributors Keg DP State
DONAGHY SALES, INC. Oakland CA
HARBOR DISTRIBUTING, LL Oakland CA
NOR-CAL BEVERAGE COMPAN Oakland CA
REDDING DISTRIBUTING CO Oakland CA
BLACK HILL - CAMMAR Oakland WA
JENNINGS CORPORATION Oakland WA
PHOENIX BEVERAGES, INC. Phoenix XX
BEVERAGE DISTRIBUTORS I Baltimore OH
BOBBY FISHER INC. Baltimore OH
WATSON KUNDA & SONS, IN Baltimore PA
WILLIAM C. KNAUER Baltimore PA
BLUE RIDGE BEV. CO., IN Baltimore VA
NORTHERN VIRGINIA BEV. Baltimore VA
FRANKLIN DISTRIBUTORS, Boston CT
LEVIND DISTRIBUTING CO. Boston CT
MERRIMACK VALLEY DIST. Boston MA
CUMBERLAND & YORK DISTR Boston ME
CLARE ROSE, INC. - Patchouge Boston NY
NORTHERN EAGLE BEVERAGE Boston NY
PREMIUM BEVERAGE CO., I Charleston AL
UNITED DISTRIBUTORS, IN Charleston GA
CLARK DISTRIBUTING CO., Charleston KY
MILLER BRANDS OF NORTHERN KENT Charleston KY
ONSLOW BEVERAGE CO., IN Charleston NC
BREWERS DISTRIBUTING CO Chicago IL
CHICAGO BEVERAGE SYSTEM Chicago IL
LORDEN DISTRIBUTING COM Chicago IL
RA-JAC DISTRIBUTING CO. Chicago IL
BRENTLINGER DIST. CO., Chicago IN
POWERS DISTRIBUTING Chicago MI
B & K DISTRIBUTING, INC Houston CO
MIDWEST DISTRIBUTORS CO Houston KS
GREAT RIVER BEVERAGES, Houston MS
MAGNOLIA BEVERAGE Houston MS
DIENST DISTRIBUTING CO. Houston TX
PARADISE BEVERAGES, INC, Hilo Los Angeles HI PARADISE BEVERAGES, INC, Kailu Los Angeles HI PARADISE BEVERAGES, INC, Lihue Los Angeles HI PARADISE BEVERAGES, INC, Wailu Los Angeles HI PARADISE BEVERAGES, INC, Waipa Los Angeles HI NATIONAL DISTRIBUTING Co, INC. Oakland WA
Appendix 3a: Individual Collecting & Handling Cost per distributor for Scenario 2 and 3.
Distributor
Excess Pallet Quantity per
year
Collection &
Handling per pallet
Collection &
Handling per year MILLER BRANDS- MILWAUKEE, LCC 1513 $3,50 $ 5.295 WOW DISTRIBUTORS, INC. 563 $3,50 $ 1.970 COORS DISTRIBUTING COMP 353 $11,14 $ 3.937 G & G DISTRIBUTION CORP 352 $3,65 $ 1.283 JIM CAREY DISTRIBUTING 840 $3,98 $ 3.343 STREVA DIST. CO. OF NEW 151 $5,52 $ 831 MAJOR BRANDS OF ST LOUIS 1748 $3,89 $ 6.799 THE BEER COMPANy, LLC 216 $5,72 $ 1.234
BETTER BRANDS verone 90 $3,50 $ 315
F.E.B. DISTRIBUTING CO. 1257 $4,03 $ 5.065 GULF DISTRIBUTING OF Mississip 621 $4,34 $ 2.697
MISSISSIPPI BEVERAGE 159 $7,58 $ 1.204
NEW MEXICO BEVERAGE 1748 $4,13 $ 7.219
LDF SALES 255 $6,78 $ 1.730
GEORGE DISTRIBUTING 163 $4,78 $ 781
GIGLIO DISTRIBUTING CO. 428 $3,31 $ 1.416
HALO DIST. CO. 1450 $3,61 $ 5.233
HDC DISTRIBUTING, LTD. 6544 $0,57 $ 3.730 MILLER DIST. OF FT. WORTH, INC 2875 $3,49 $ 10.034 PRICE DISTRIBUTING COMP 127 $5,36 $ 679 WILLOW DISTRIBUTORS, IN 4469 $3,28 $ 14.658 WRIGHT DISTRIBUTING CO. 589 $3,41 $ 2.010 FINLEY DISTRIBUTING CO. 1229 $4,78 $ 5.876 FRED NACKARD WHSLE. LIQ 670 $4,39 $ 2.942 GOLD COAST BEVERAGE DIST., INC 32219 $0,37 $ 11.921
J.J. TAYLOR-Tampa 8556 $1,25 $ 10.695
JJ TAYLOR - FT. MYERS/NAPLES 2975 $3,05 $ 9.074
S.R. PERROTT, INC. 1122 $3,43 $ 3.848
SCHENCK DISTRIBUTING - Rockled 872 $3,25 $ 2.834 ADVANCE BEVERAGE CO., INC. 351 $3,67 $ 1.287
BAY AREA BEVERAGE 3913 $0,57 $ 2.231
DONAGHY SALES, INC. 763 $4,07 $ 3.105
HARBOR DISTRIBUTING, LL 4432 $0,57 $ 2.526 NOR-CAL BEVERAGE COMPAN 321 $4,98 $ 1.600 REDDING DISTRIBUTING CO 243 $4,73 $ 1.151 Black Hill - CAMMAR 210 $5,63 $ 1.184
JENNINGS CORPORATION 230 $6,40 $ 1.469
PHOENIX BEVERAGES, INC. 70784 $0,23 $ 16.280 BEVERAGE DISTRIBUTORS I 4082 $2,57 $ 10.492
BOBBY FISHER INC. 392 $3,76 $ 1.474
WATSON KUNDA & SONS, IN 2052 $3,76 $ 7.715
WILLIAM C. KNAUER 701 $3,70 $ 2.595
Blue Ridge Bev. Co., In 543 $4,18 $ 2.268 NORTHERN VIRGINIA BEV. 9940 $0,80 $ 7.952 FRANKLIN DISTRIBUTORS, 367 $3,29 $ 1.208 Levine Distributing Co. 755 $3,29 $ 2.483 MERRIMACK VALLEY DIST. 3788 $3,02 $ 11.439 CUMBERLAND & YORK DISTR 1316 $3,32 $ 4.371 CLARE ROSE, INC. - Patchouge 6944 $1,25 $ 8.680 NORTHERN EAGLE BEVERAGE 308 $3,70 $ 1.138 PREMIUM BEVERAGE CO., I 163 $4,42 $ 722 UNITED DISTRIBUTORS, IN 1256 $3,77 $ 4.734 CLARK DISTRIBUTING CO., 900 $4,00 $ 3.599 MILLER BRANDS OF NORTHERN KEN 613 $4,24 $ 2.600 ONSLOW BEVERAGE CO., IN 168 $5,66 $ 951 BREWERS DISTRIBUTING CO 255 $3,76 $ 960 CHICAGO BEVERAGE SYSTEM 10412 $2,50 $ 26.030 LORDEN DISTRIBUTING COM 418 $3,53 $ 1.474 RA-JAC DISTRIBUTING CO. 195 $3,76 $ 732 BRENTLINGER DIST. CO., 88 $5,23 $ 461
POWERS DISTRIBUTING 3533 $3,76 $ 13.286
B & K DISTRIBUTING, INC 102 $11,14 $ 1.135 MIDWEST DISTRIBUTORS CO 679 $4,70 $ 3.193 GREAT RIVER BEVERAGES, 426 $7,58 $ 3.229
MAGNOLIA BEVERAGE 224 $4,96 $ 1.111
DIENST DISTRIBUTING CO. 376 $3,29 $ 1.238 PARADISE BEVERAGES, INC, Hilo 5878 $10,10 $ 59.367 PARADISE BEVERAGES, INC, Kailu 406 $10,10 $ 4.098 PARADISE BEVERAGES, INC, Lihue 425 $10,10 $ 4.293 PARADISE BEVERAGES, INC, Wailu 1182 $10,10 $ 11.942 PARADISE BEVERAGES, INC, Waipa 350 $10,10 $ 3.533 NATIONAL DISTRIBUTING Co, INC. 779 $5,81 $ 4.528
Total 329958 $2,19 722536
weighed average:
(722.536/329958) Distributor
Excess Pallet Quantity per
year
Collection &
Handling per pallet
Collection &
Handling per year NATIONAL DISTRIBUTING Co of DC 7224 $0,80 $ 5.779 STANDARD DISTRIBUTING C, Delaw 57 $3,79 $ 216 BOZICK DISTRIBUTORS, IN 482 $3,61 $ 1.740 KOHLER DISTRIBUTING COM 7267 $3,89 $ 28.268 WARREN DISTRIBUTING CO. 3543 $3,79 $ 13.430 BROWN DISTRIBUTING COMPANY 146 $6,24 $ 911 CITY BEVERAGE COMPANY 49 $6,24 $ 304 ESBER BEVERAGE COMPANY 431 $4,57 $ 1.972 GIL SCHWARTZ DISTRIBUTO 476 $4,57 $ 2.173 H. DENNERT DISTRIBUTING 1553 $3,70 $ 5.747 HILL DISTRIBUTING COMPA 2411 $4,00 $ 9.643 TRAMONTE DISTRIBUTING C 1171 $4,67 $ 5.470 BANKO DISTRIBUTING COMP 1484 $4,00 $ 5.938 DEBLASIO BEVERAGE CO., 239 $4,18 $ 998 ERME'S BEER DISTRIBUTOR 129 $4,18 $ 541 GOETTLER DIST., INC. 140 $4,18 $ 583 ORIGLIO BEVERAGE (ANTONIO, INC 9811 $1,14 $ 11.184 T. VERRASTRO BEER DIST. 214 $4,00 $ 856 CHESBAY DISTRIBUTING CO 3465 $4,18 $ 14.482 FREEMAN BEVERAGE CO., I 821 $3,32 $ 2.725 ATOMIC DISTRIBUTING CO. 167 $6,30 $ 1.053 CARENBAUER WHOLESALE CO. 81 $4,57 $ 369 DICHELLO DISTRIBUTORS, 11659 $1,14 $ 13.291 DWAN & COMPANY, INC. 547 $3,52 $ 1.926 HARTFORD DISTRIBUTORS, 5193 $1,25 $ 6.491 Horizon Bev. Co. Coastal Bev. 14329 $3,02 $ 43.274 Horizon Bev. Co. Premium 1835 $3,02 $ 5.542 MAINE DISTRIBUTORS, INC 362 $4,39 $ 1.588 SENECAL BEVERAGE CO. 2153 $3,11 $ 6.695
BARTYZEL, INC. 845 $4,25 $ 3.593
EAGLE BEVERAGE COMPANY, 138 $4,39 $ 605 FINGER LAKES BOTTLING C 98 $5,12 $ 503 SANZO BEVERAGE CO., INC 53 $4,57 $ 243 TRI-VALLEY BEVERAGE, IN 537 $4,25 $ 2.282 TRY-IT DISTRIBUTING CO. 1405 $4,57 $ 6.423 WRIGHT-WISNER DIST. COR 2093 $4,57 $ 9.565 ALLSTATE BEVERAGE CO. 559 $4,57 $ 2.555 GULF DISTRIBUTING CO., INC 570 $4,57 $ 2.605 SUPREME BEVERAGE CO., INC. - H 309 $7,22 $ 2.234 BETTER BRANDS atlanta 2482 $3,77 $ 9.358 FLINT BEVERAGE CO., INC 571 $3,89 $ 2.221 GEORGIA CROWN DISTRIBUT 366 $3,89 $ 1.425 JACKSON BEVERAGE CO., I 464 $3,85 $ 1.785 MID GEORGIA SALES COMPANY 450 $5,70 $ 2.564 RIVER CITY DISTRIBUTING 1132 $4,63 $ 5.241 BENNETT DISTRIBUTING CO 362 $5,66 $ 2.047 BJT INC./ Mutual Distributing: 3171 $3,75 $ 11.890 BJT INC./ Mutual Distributing: 2742 $3,75 $ 10.283 COASTAL BEVERAGE - Elizabeth C 281 $4,06 $ 1.140 COASTAL BEVERAGE - New Bern 47 $3,77 $ 176 WARD DIST. CO., INC./ A 830 $3,31 $ 2.747 B & B DISTRIBUTORS, INC 235 $3,38 $ 794 BUDWEISER OF SPARTANBURG, INC 284 $3,50 $ 993 CHRIS J. YAHNIS COASTAL: Colum 828 $3,61 $ 2.989 CHRIS J. YAHNIS COASTAL: Conwa 833 $3,61 $ 3.006 CHRIS J. YAHNIS COASTAL: Flore 767 $3,61 $ 2.770
A.S. BARBORO, INC. 1958 $5,06 $ 9.908
AJAX DISTRIBUTING COMPANY, INC 162 $7,40 $ 1.202 AJAX TURNER CO., INC. 1929 $5,33 $ 10.280 CLYCE DISTRIBUTING CO., 227 $3,95 $ 896 GEORGE DINWIDDIE DIST.(Cheroke 737 $4,39 $ 3.236 E & F DISTRIBUTING COMP 233 $3,61 $ 842 GENEVA BOTTLING WORKS, 1683 $3,08 $ 5.183 KOERNER DISTRIBUTOR, IN 226 $4,09 $ 924
MATTHEWS DIST. CO. 111 $3,89 $ 432
PREMIUM BRANDS , LTD 288 $3,70 $ 1.067
WORKING DISTRIBUTORS, I 172 $4,00 $ 687
O & W, INC. 1844 $3,61 $ 6.658
HOHENSTEINS, INC. 519 $4,15 $ 2.152
KUETHER DISTRIBUTING CO 2906 $4,18 $ 12.149
THORPE 1255 $4,18 $ 5.246
FISHER BEVERAGE, INC. 92 $8,34 $ 766 LEE BEVERAGE CO., INC. 309 $3,79 $ 1.173
Appendix 3b: Individual Collecting & Handling Cost per distributor for Scenario 1.
Distributor
Excess Pallet Quantity per
year
Collection &
Handling per pallet
Collection &
Handling per year NATIONAL DISTRIBUTING Co of DC 7224 $3,47 $ 25.066
A.S. BARBORO, INC. 1958 $5,06 $ 9.908
ADVANCE BEVERAGE CO., INC. 351 $3,67 $ 1.287 AJAX DISTRIBUTING COMPANY, IN 162 $7,40 $ 1.202 AJAX TURNER CO., INC. 1929 $5,33 $ 10.280 ALLSTATE BEVERAGE CO. 559 $4,57 $ 2.555 ATOMIC DISTRIBUTING CO. 167 $6,30 $ 1.053
B & B DISTRIBUTORS, INC 235 $3,38 $ 794
B & K DISTRIBUTING, INC 102 $11,14 $ 1.135 BANKO DISTRIBUTING COMP 1484 $4,00 $ 5.938 BARTYZEL, INC. 845 $4,25 $ 3.593 BAY AREA BEVERAGE 3913 $3,02 $ 11.819 BENNETT DISTRIBUTING CO 362 $5,66 $ 2.047 BETTER BRANDS atlanta 2482 $3,77 $ 9.358 BETTER BRANDS verone 90 $3,50 $ 315
BEVERAGE DISTRIBUTORS I 4082 $4,57 $ 18.656 BJT INC./ Mutual Distributing: 3171 $3,75 $ 11.890 BJT INC./ Mutual Distributing: 2742 $3,75 $ 10.283 Black Hill - CAMMAR 210 $5,63 $ 1.184 Blue Ridge Bev. Co., In 543 $4,18 $ 2.268 BOBBY FISHER INC. 392 $3,76 $ 1.474 BOZICK DISTRIBUTORS, IN 482 $3,61 $ 1.740 BRENTLINGER DIST. CO., 88 $5,23 $ 461
BREWERS DISTRIBUTING CO 255 $3,76 $ 960
BROWN DISTRIBUTING COMPANY 146 $6,24 $ 911
BUDWEISER OF SPARTANBURG, IN 284 $3,50 $ 993
CARENBAUER WHOLESALE CO. 81 $4,57 $ 369
CHESBAY DISTRIBUTING CO 3465 $4,18 $ 14.482 CHICAGO BEVERAGE SYSTEM 10412 $2,50 $ 26.030 CHRIS J. YAHNIS COASTAL: Colum 828 $3,61 $ 2.989 CHRIS J. YAHNIS COASTAL: Conwa 833 $3,61 $ 3.006 CHRIS J. YAHNIS COASTAL: Flore 767 $3,61 $ 2.770 CITY BEVERAGE COMPANY 49 $6,24 $ 304
CLARE ROSE, INC. - Patchouge 6944 $4,09 $ 28.400 CLARK DISTRIBUTING CO., 900 $4,00 $ 3.599 CLYCE DISTRIBUTING CO., 227 $3,95 $ 896
COASTAL BEVERAGE - Elizabeth C 281 $4,06 $ 1.140 COASTAL BEVERAGE - New Bern 47 $3,77 $ 176
COORS DISTRIBUTING COMP 353 $11,14 $ 3.937 CUMBERLAND & YORK DISTR 1316 $3,32 $ 4.371 DEBLASIO BEVERAGE CO., 239 $4,18 $ 998
DICHELLO DISTRIBUTORS, 11659 $3,64 $ 42.437 DIENST DISTRIBUTING CO. 376 $3,29 $ 1.238 DONAGHY SALES, INC. 763 $4,07 $ 3.105 DWAN & COMPANY, INC. 547 $3,52 $ 1.926 E & F DISTRIBUTING COMP 233 $3,61 $ 842
EAGLE BEVERAGE COMPANY, 138 $4,39 $ 605
ERME'S BEER DISTRIBUTOR 129 $4,18 $ 541
ESBER BEVERAGE COMPANY 431 $4,57 $ 1.972 F.E.B. DISTRIBUTING CO. 1257 $4,03 $ 5.065 FINGER LAKES BOTTLING C 98 $5,12 $ 503
FINLEY DISTRIBUTING CO. 1229 $4,78 $ 5.876 FISHER BEVERAGE, INC. 92 $8,34 $ 766
FLINT BEVERAGE CO., INC 571 $3,89 $ 2.221 FRANKLIN DISTRIBUTORS, 367 $3,29 $ 1.208 FRED NACKARD WHSLE. LIQ 670 $4,39 $ 2.942 FREEMAN BEVERAGE CO., I 821 $3,32 $ 2.725 G & G DISTRIBUTION CORP 352 $3,65 $ 1.283 GENEVA BOTTLING WORKS, 1683 $3,08 $ 5.183 GEORGE DINWIDDIE DIST.(Cheroke 737 $4,39 $ 3.236 GEORGE DISTRIBUTING 163 $4,78 $ 781
GEORGIA CROWN DISTRIBUT 366 $3,89 $ 1.425 GIGLIO DISTRIBUTING CO. 428 $3,31 $ 1.416 GIL SCHWARTZ DISTRIBUTO 476 $4,57 $ 2.173 GOETTLER DIST., INC. 140 $4,18 $ 583
GOLD COAST BEVERAGE DIST., IN 32219 $2,72 $ 87.636 GREAT RIVER BEVERAGES, 426 $7,58 $ 3.229 GULF DISTRIBUTING CO., INC 570 $4,57 $ 2.605 GULF DISTRIBUTING OF Mississip 621 $4,34 $ 2.697 H. DENNERT DISTRIBUTING 1553 $3,70 $ 5.747 HALO DIST. CO. 1450 $3,61 $ 5.233 HARBOR DISTRIBUTING, LL 4432 $2,69 $ 11.922 Distributor Excess Pallet Quantity per year Collection & Handling per pallet Collection & Handling per year HARTFORD DISTRIBUTORS, 5193 $3,29 $ 17.085 HDC DISTRIBUTING, LTD. 6544 $2,92 $ 19.110 HILL DISTRIBUTING COMPA 2411 $4,00 $ 9.643 HOHENSTEINS, INC. 519 $4,15 $ 2.152 Horizon Bev. Co. Coastal Bev. 14329 $3,02 $ 43.274 Horizon Bev. Co. Premium 1835 $3,02 $ 5.542 J.J. TAYLOR-Tampa 8556 $3,25 $ 27.806 JACKSON BEVERAGE CO., I 464 $3,85 $ 1.785 JENNINGS CORPORATION 230 $6,40 $ 1.469 JIM CAREY DISTRIBUTING 840 $3,98 $ 3.343 JJ TAYLOR - FT. MYERS/NAPLES 2975 $3,05 $ 9.074 KOERNER DISTRIBUTOR, IN 226 $4,09 $ 924
KOHLER DISTRIBUTING COM 7267 $3,89 $ 28.268 KUETHER DISTRIBUTING CO 2906 $4,18 $ 12.149 LDF SALES 255 $6,78 $ 1.730 LEE BEVERAGE CO., INC. 309 $3,79 $ 1.173 Levine Distributing Co. 755 $3,29 $ 2.483 LORDEN DISTRIBUTING COM 418 $3,53 $ 1.474 MAGNOLIA BEVERAGE 224 $4,96 $ 1.111 MAINE DISTRIBUTORS, INC 362 $4,39 $ 1.588 MAJOR BRANDS OF ST LOUIS 1748 $3,89 $ 6.799 MATTHEWS DIST. CO. 111 $3,89 $ 432
MERRIMACK VALLEY DIST. 3788 $3,02 $ 11.439 MID GEORGIA SALES COMPANY 450 $5,70 $ 2.564 MIDWEST DISTRIBUTORS CO 679 $4,70 $ 3.193 MILLER BRANDS- MILWAUKEE, LC 1513 $3,50 $ 5.295 MILLER BRANDS OF NORTHERN K 613 $4,24 $ 2.600 MILLER DIST. OF FT. WORTH, INC 2875 $3,49 $ 10.034 MISSISSIPPI BEVERAGE 159 $7,58 $ 1.204 NATIONAL DISTRIBUTING Co, INC. 779 $5,81 $ 4.528 NEW MEXICO BEVERAGE 1748 $4,13 $ 7.219 NOR-CAL BEVERAGE COMPAN 321 $4,98 $ 1.600 NORTHERN EAGLE BEVERAGE 308 $3,70 $ 1.138 NORTHERN VIRGINIA BEV. 9940 $3,61 $ 35.884 O & W, INC. 1844 $3,61 $ 6.658 ONSLOW BEVERAGE CO., IN 168 $5,66 $ 951
ORIGLIO BEVERAGE (ANTONIO, IN 9811 $3,76 $ 36.888 PARADISE BEVERAGES, INC, Hilo 5878 $10,10 $ 59.367 PARADISE BEVERAGES, INC, Kailu 406 $10,10 $ 4.098 PARADISE BEVERAGES, INC, Lihue 425 $10,10 $ 4.293 PARADISE BEVERAGES, INC, Wailu 1182 $10,10 $ 11.942 PARADISE BEVERAGES, INC, Waip 350 $10,10 $ 3.533 PHOENIX BEVERAGES, INC. 70784 $2,18 $ 154.310 POWERS DISTRIBUTING 3533 $3,76 $ 13.286 PREMIUM BEVERAGE CO., I 163 $4,42 $ 722
PREMIUM BRANDS , LTD 288 $3,70 $ 1.067 PRICE DISTRIBUTING COMP 127 $5,36 $ 679
RA-JAC DISTRIBUTING CO. 195 $3,76 $ 732
REDDING DISTRIBUTING CO 243 $4,73 $ 1.151 RIVER CITY DISTRIBUTING 1132 $4,63 $ 5.241 S.R. PERROTT, INC. 1122 $3,43 $ 3.848 SANZO BEVERAGE CO., INC 53 $4,57 $ 243
SCHENCK DISTRIBUTING - Rockled 872 $3,25 $ 2.834 SENECAL BEVERAGE CO. 2153 $3,11 $ 6.695 STANDARD DISTRIBUTING C, Delaw 57 $3,79 $ 216
STREVA DIST. CO. OF NEW 151 $5,52 $ 831
SUPREME BEVERAGE CO., INC. - H 309 $7,22 $ 2.234 T. VERRASTRO BEER DIST. 214 $4,00 $ 856
THE BEER COMPANy, LLC 216 $5,72 $ 1.234 THORPE 1255 $4,18 $ 5.246 TRAMONTE DISTRIBUTING C 1171 $4,67 $ 5.470 TRI-VALLEY BEVERAGE, IN 537 $4,25 $ 2.282 TRY-IT DISTRIBUTING CO. 1405 $4,57 $ 6.423 UNITED DISTRIBUTORS, IN 1256 $3,77 $ 4.734 WARD DIST. CO., INC./ A 830 $3,31 $ 2.747 WARREN DISTRIBUTING CO. 3543 $3,79 $ 13.430 WATSON KUNDA & SONS, IN 2052 $3,76 $ 7.715 WILLIAM C. KNAUER 701 $3,70 $ 2.595 WILLOW DISTRIBUTORS, IN 4469 $3,28 $ 14.658 WORKING DISTRIBUTORS, I 172 $4,00 $ 687 WOW DISTRIBUTORS, INC. 563 $3,50 $ 1.970 WRIGHT DISTRIBUTING CO. 589 $3,41 $ 2.010 WRIGHT-WISNER DIST. COR 2093 $4,57 $ 9.565
145 329958 $3,42 $ 1.128.303
weighed average
$1,128,303/ 329958
Appendix 4: Estimation of the Lead time of the pallet
Appendix 5: Calculation of the Ocean freight cost per port
Keg Port % shipped of total
Carrier freight $ per container
Ocean freight $ per pallet
CSC per pallet (US + NL)
Total Ocean + CSC per pallet
Baltimore 18% $600 $1,36 $0,68 $2,05
Boston 17% $600 $1,36 $0,68 $2,05
Charleston 8% $725 $1,65 $0,68 $2,33
Chicago 8% $650 $1,48 $0,68 $2,16
Houston 8% $650 $1,48 $0,68 $2,16
Los Angeles 3% $1.200 $2,73 $0,68 $3,41
Miami 14% $600 $1,36 $0,68 $2,05
Oakland 3% $1.350 $3,07 $0,68 $3,75
Phoenix 21% $300 $0,68 $0,68 $1,36
Weighed average 100% $597 $1,36 $0,68 $2,04
Calculation
Based on sales figures of the interested distributors
in 2001
Fixed figure given by Carriers
Carrier freight $ divided by 440 pallets
per container
Two times CSC of
$150 each / 440 pallets per container.
$300/440= $0,68
Ocean freight + CSC
Lead time Activities # weeks
Storage at Heineken brewery and transportation to port 1 Average ocean shipment of East and West coast 3 Time at dock in the US before pick up 1 Storage at the Heineken demand points 3
Storage at the Distributor 3
Return to Kegs peditor demand point and wait until full container 2 Average ocean shipement of East and West coast 3 Storage at Port in NL and transport to pallet supplier 1
Total estimated Lead time 17
Appendix 6: Individual Ocean freight & CSC costs per pallet
Appendix 7: Estimated percentages for broken, reparable and good pallets based on previous shipments in the past.
Recover % D/R/G per Shipm. Shipment 1 Shipment 2 Shipment 3 Shipment 4 Shipment 5 Average
% Destroyed 7,1% 3,3% 14,3% 0,4% 3,7% 5,8%
% Repaired 37,1% 20,7% 63,4% 39,6% 20,6% 36,3%
% Good 55,7% 76,0% 22,4% 60,0% 75,7% 58,0%
% Total 100% 100% 100,0% 100,0% 100,0% 100,0%
(500/7000) (49/1465) (303/2126) (8/2249) (13//350) (2600/7000) (303/1465) (1347/2126) (891/2249) (72/350) (3900/7000) (1113/1465) (476/2126) (1350/2249) (265/350)
(Average percentages of the
destroyed/
repaired and good pallets)
# destroyed / # total pallets shipped
# repaired / # total pallets shipped
# good / # total pallets shipped Distributor
Excess Pallet Quantity per
year
Ocean freight
& CSC per pallet
Total Ocean freight & CSC
per year NATIONAL DISTRIBUTING Co of DC 7224 $2,05 $14.809
A.S. BARBORO, INC. 1958 $2,33 $4.562
ADVANCE BEVERAGE CO., INC. 351 $3,75 $1.315
AJAX DISTRIBUTING COMPANY, INC 162 $2,33 $379
AJAX TURNER CO., INC. 1929 $2,33 $4.494
ALLSTATE BEVERAGE CO. 559 $2,33 $1.303
ATOMIC DISTRIBUTING CO. 167 $2,05 $343
B & B DISTRIBUTORS, INC 235 $2,33 $548
B & K DISTRIBUTING, INC 102 $2,16 $220
BANKO DISTRIBUTING COMP 1484 $2,05 $3.043
BARTYZEL, INC. 845 $2,05 $1.733
BAY AREA BEVERAGE 3913 $3,75 $14.675
BENNETT DISTRIBUTING CO 362 $2,33 $843
BETTER BRANDS atlanta 2482 $2,33 $5.784
BETTER BRANDS verone 90 $2,16 $194
BEVERAGE DISTRIBUTORS I 4082 $2,05 $8.369
BJT INC./ Mutual Distributing: 3171 $2,33 $7.388 BJT INC./ Mutual Distributing: 2742 $2,33 $6.389
Black Hill - CAMMAR 210 $3,75 $788
Blue Ridge Bev. Co., In 543 $2,05 $1.112
BOBBY FISHER INC. 392 $2,05 $804
BOZICK DISTRIBUTORS, IN 482 $2,05 $988
BRENTLINGER DIST. CO., 88 $2,16 $190
BREWERS DISTRIBUTING CO 255 $2,16 $551
BROWN DISTRIBUTING COMPANY 146 $2,05 $299
BUDWEISER OF SPARTANBURG, INC 284 $2,33 $661
CARENBAUER WHOLESALE CO. 81 $2,05 $166
CHESBAY DISTRIBUTING CO 3465 $2,05 $7.102
CHICAGO BEVERAGE SYSTEM 10412 $2,16 $22.490
CHRIS J. YAHNIS COASTAL: Colum 828 $2,33 $1.929
CHRIS J. YAHNIS COASTAL: Conwa 833 $2,33 $1.940
CHRIS J. YAHNIS COASTAL: Flore 767 $2,33 $1.788
CITY BEVERAGE COMPANY 49 $2,05 $100
CLARE ROSE, INC. - Patchouge 6944 $2,05 $14.235
CLARK DISTRIBUTING CO., 900 $2,33 $2.096
CLYCE DISTRIBUTING CO., 227 $2,33 $528
COASTAL BEVERAGE - Elizabeth C 281 $2,33 $655
COASTAL BEVERAGE - New Bern 47 $2,33 $109
COORS DISTRIBUTING COMP 353 $2,16 $763
CUMBERLAND & YORK DISTR 1316 $2,05 $2.699
DEBLASIO BEVERAGE CO., 239 $2,05 $489
DICHELLO DISTRIBUTORS, 11659 $2,05 $23.900
DIENST DISTRIBUTING CO. 376 $2,16 $813
DONAGHY SALES, INC. 763 $3,75 $2.861
DWAN & COMPANY, INC. 547 $2,05 $1.122
E & F DISTRIBUTING COMP 233 $2,16 $504
EAGLE BEVERAGE COMPANY, 138 $2,05 $282
ERME'S BEER DISTRIBUTOR 129 $2,05 $265
ESBER BEVERAGE COMPANY 431 $2,05 $884
F.E.B. DISTRIBUTING CO. 1257 $2,16 $2.715
FINGER LAKES BOTTLING C 98 $2,05 $201
FINLEY DISTRIBUTING CO. 1229 $3,41 $4.192
FISHER BEVERAGE, INC. 92 $2,16 $198
FLINT BEVERAGE CO., INC 571 $2,33 $1.330
FRANKLIN DISTRIBUTORS, 367 $2,05 $753
FRED NACKARD WHSLE. LIQ 670 $3,41 $2.285
FREEMAN BEVERAGE CO., I 821 $2,05 $1.682
G & G DISTRIBUTION CORP 352 $2,16 $759
GENEVA BOTTLING WORKS, 1683 $2,16 $3.635
GEORGE DINWIDDIE DIST.(Cheroke 737 $2,33 $1.718
GEORGE DISTRIBUTING 163 $2,16 $353
GEORGIA CROWN DISTRIBUT 366 $2,33 $853
GIGLIO DISTRIBUTING CO. 428 $2,16 $924
GIL SCHWARTZ DISTRIBUTO 476 $2,05 $975
GOETTLER DIST., INC. 140 $2,05 $286
GOLD COAST BEVERAGE DIST., INC 32219 $2,05 $66.049
GREAT RIVER BEVERAGES, 426 $2,16 $920
GULF DISTRIBUTING CO., INC 570 $2,33 $1.328
GULF DISTRIBUTING OF Mississip 621 $2,16 $1.342
H. DENNERT DISTRIBUTING 1553 $2,05 $3.184
HALO DIST. CO. 1450 $2,16 $3.131
HARBOR DISTRIBUTING, LL 4432 $3,75 $16.620
Distributor
Excess Pallet Quantity per
year
Ocean freight
& CSC per pallet
Total Ocean freight & CSC
per year
HARTFORD DISTRIBUTORS, 5193 $2,05 $10.646
HDC DISTRIBUTING, LTD. 6544 $2,16 $14.136
HILL DISTRIBUTING COMPA 2411 $2,05 $4.942
HOHENSTEINS, INC. 519 $2,16 $1.120
Horizon Bev. Co. Coastal Bev. 14329 $2,05 $29.375
Horizon Bev. Co. Premium 1835 $2,05 $3.762
J.J. TAYLOR-Tampa 8556 $2,05 $17.539
JACKSON BEVERAGE CO., I 464 $2,33 $1.080
JENNINGS CORPORATION 230 $3,75 $861
JIM CAREY DISTRIBUTING 840 $2,16 $1.814
JJ TAYLOR - FT. MYERS/NAPLES 2975 $2,05 $6.099
KOERNER DISTRIBUTOR, IN 226 $2,16 $488
KOHLER DISTRIBUTING COM 7267 $2,05 $14.897
KUETHER DISTRIBUTING CO 2906 $2,16 $6.278
LDF SALES 255 $2,16 $551
LEE BEVERAGE CO., INC. 309 $2,16 $668
Levine Distributing Co. 755 $2,05 $1.547
LORDEN DISTRIBUTING COM 418 $2,16 $902
MAGNOLIA BEVERAGE 224 $2,16 $484
MAINE DISTRIBUTORS, INC 362 $2,05 $741
MAJOR BRANDS OF ST LOUIS 1748 $2,16 $3.775
MATTHEWS DIST. CO. 111 $2,16 $240
MERRIMACK VALLEY DIST. 3788 $2,05 $7.765
MID GEORGIA SALES COMPANY 450 $2,33 $1.048
MIDWEST DISTRIBUTORS CO 679 $2,16 $1.467
MILLER BRANDS- MILWAUKEE, LCC 1513 $2,16 $3.268
MILLER BRANDS OF NORTHERN KEN 613 $2,33 $1.429
MILLER DIST. OF FT. WORTH, INC 2875 $2,16 $6.210
MISSISSIPPI BEVERAGE 159 $2,16 $343
NATIONAL DISTRIBUTING Co, INC. 779 $3,75 $2.923
NEW MEXICO BEVERAGE 1748 $2,16 $3.775
NOR-CAL BEVERAGE COMPAN 321 $3,75 $1.205
NORTHERN EAGLE BEVERAGE 308 $2,05 $630
NORTHERN VIRGINIA BEV. 9940 $2,05 $20.377
O & W, INC. 1844 $2,16 $3.984
ONSLOW BEVERAGE CO., IN 168 $2,33 $391
ORIGLIO BEVERAGE (ANTONIO, INC 9811 $2,05 $20.112 PARADISE BEVERAGES, INC, Hilo 5878 $3,41 $20.044 PARADISE BEVERAGES, INC, Kailu 406 $3,41 $1.384 PARADISE BEVERAGES, INC, Lihue 425 $3,41 $1.449 PARADISE BEVERAGES, INC, Wailu 1182 $3,41 $4.032 PARADISE BEVERAGES, INC, Waipa 350 $3,41 $1.193
PHOENIX BEVERAGES, INC. 70784 $1,36 $96.267
POWERS DISTRIBUTING 3533 $2,16 $7.632
PREMIUM BEVERAGE CO., I 163 $2,33 $381
PREMIUM BRANDS , LTD 288 $2,16 $623
PRICE DISTRIBUTING COMP 127 $2,16 $274
RA-JAC DISTRIBUTING CO. 195 $2,16 $420
REDDING DISTRIBUTING CO 243 $3,75 $912
RIVER CITY DISTRIBUTING 1132 $2,33 $2.637
S.R. PERROTT, INC. 1122 $2,05 $2.300
SANZO BEVERAGE CO., INC 53 $2,05 $109
SCHENCK DISTRIBUTING - Rockled 872 $2,05 $1.788
SENECAL BEVERAGE CO. 2153 $2,05 $4.413
STANDARD DISTRIBUTING C, Delaw 57 $2,05 $117
STREVA DIST. CO. OF NEW 151 $2,16 $325
SUPREME BEVERAGE CO., INC. - H 309 $2,33 $721
T. VERRASTRO BEER DIST. 214 $2,05 $438
THE BEER COMPANy, LLC 216 $2,16 $466
THORPE 1255 $2,16 $2.711
TRAMONTE DISTRIBUTING C 1171 $2,05 $2.401
TRI-VALLEY BEVERAGE, IN 537 $2,05 $1.101
TRY-IT DISTRIBUTING CO. 1405 $2,05 $2.881
UNITED DISTRIBUTORS, IN 1256 $2,33 $2.926
WARD DIST. CO., INC./ A 830 $2,33 $1.934
WARREN DISTRIBUTING CO. 3543 $2,05 $7.264
WATSON KUNDA & SONS, IN 2052 $2,05 $4.206
WILLIAM C. KNAUER 701 $2,05 $1.438
WILLOW DISTRIBUTORS, IN 4469 $2,16 $9.653
WORKING DISTRIBUTORS, I 172 $2,16 $371
WOW DISTRIBUTORS, INC. 563 $2,16 $1.216
WRIGHT DISTRIBUTING CO. 589 $2,16 $1.273
WRIGHT-WISNER DIST. COR 2093 $2,05 $4.291
145 distributors 329958 $2,04 $673.401
Appendix 7: Estimated percentages for broken, reparable and good pallets for the three trips in a year (a pallet will be used three times per year).
Away 1 Back Away 2 Back Away 3 Back
26% 5527
47% 10133 2764
13% 6015 3251
21676 15%
26% 6909
34% 27094 47% 12667 3455
43% 13% 7519 4064
63752 9% 15%
15% 14982
49% 7381
31% 4619 734
5419 5% 2981 2247
9563 15%
26% 3459
13565 47% 6342 1730
13% 3764 2035
49% 15%
31% 39897 34% 16956
129395 5% 43% 26% 4324
15% 9% 47% 7927 2162
15% 9376 13% 4705 2543
15%
3391 49% 4619
5985 31% 2891 459
5% 1866 1406
15%
34% 4313
12685 43% 5391 1078
9% 2981 1903
15%
49% 7939
25747 31% 34% 2699
5% 43% 3374 675
15% 5123 9% 1866 1191
15%
1261 49% 2524
6337 3862 31% 1580 251
19409 5% 1019 768
15%
Total: G¹ 63752 Total: G² 47926 Total: G³ 41756
R¹ 39897 R² 51989 R³ 54923
D¹ 6337 D² 10071 D³ 13306
L¹ 19409 L² 19409 L³ 19409
L¹ + D¹ 25747 L² + D² 29480 L³ + D³ 32716
TRIP 1 TRIP 2 TRIP 3
The first percentages were calculated based on previous shipments in the past (see following table).
First trip (first time used and returned) Recover % Shipment
1
Shipment 2
Shipment 3
Shipment 4
Shipment 5
Average % of excess pallets
% of all pallets
% Good 56% 76% 22% 60% 76% 58% 58% 49%
% Repaired 37% 21% 63% 40% 21% 36% 36% 31%
% Destroyed 7% 3% 14% 0% 4% 6% 5,8% 5%
% Total 100% 100% 100% 100% 100% 100% 100% 85%
lost 15%
100%
The following table is a summery of the previous diagram in Appendix 7
Recover % 1st trip % 1st trip # 2nd trip % 2nd trip # 3rd trip % 3rd trip # Total per year
% Good 49,3% 63752 34,0% 47926 25,5% 41756 153433
% Repaired 30,8% 39897 42,5% 51989 46,8% 54923 146809
% Destroyed 4,9% 6337 8,5% 10071 12,8% 13306 29715
% Lost 15% 19409 15% 19409 15% 19409 58228
% Total 100% 129395 100% 129395 100% 129395 388185
Appendix 8: Calculations of the Handling costs for scenario 2
Handling costs of the Fork truck (FT)
Salary per man (incl. all primary and secundary) $ 44.000 Fork truck (wright off, battery, reparation) $ 16.000 Total handling costs per year at brewery $ 60.000
36,5 cycli (10 days per cycli) of 48 hours 1752 hour
minus: 20% (vacation en illness) -350,4 1402 hour
minus: 25% inproductivity -350,4 1051 hour
Productive hours per man per year 1051
Fork Truck (FT) Movement/hour Palletloads/hour
1 FT (= 1 fork = 1 pallet load) 30 30
2 FT (=2 forks = 2 pallet loads) 25 50
3 FT (= 3 forks = 3 pallet loads) 20 60
Productive hours per man per
year per hour Total per year
Pallet loads 1051 60 63060
Movements 1051 20 21020
Handling Cost per pallet with FT
$60.000 / 63060 $0,95 per palletload to move
$60,000 / 21020 $2,85 per movement
$0.95 per pallet load / 15 (# pallets per load) $ 0,06
Handling costs of the Special truck (ST: Buizencar)
Salary man per year $ 44.000 Special truck per year (Buizencar) $ 44.000
Total $ 88.000
Productive hours per man per year (see FT) 1051
Pallets per Special truck (Buizencar) movement Movement/hour Pallets/hour
24 spaces x 15 pallets = 360 10 3600
Total pallets per year calculation
Total movements
per year calculation
3783600 1051 x 3600 pallets/hour 10510 1051 x 10 movement/hour
Handling Cost per pallet with Buizencar
$ 88.000 / 10510 movements $ 8,37
$ 88.000 / 3783600 pallets $ 0,023