EuroFood

EUROFOOD

Eurofood is one of the dominating companies that provides imported goods in Honk Kong. Its growth and success is due to the vision of its founder Mr. Vigneau. Early in 1975 he anticipated the strategic position of the country as a channel for which commerce must pass in the near future. However, as the founder retires from this business line, Mr. Vigneau struggles to show how profitable the company could be to a future buyer due to its huge inventory levels. We consider it is possible to lower inventory levels and improve revenue by doing the following:

INVENTORY REDUCTION PROGRAM

 * PRODUCT CONSOLIDATION **

Most of the product is imported in different quantities. Consolidating the product into 1 or 2 sizes will reduce inventories of the same product. INVENTORY ANALYSIS The inventory carried by Eurofood has a vast diversity. An inventory analysis will show which products to manage efficiently and effectively. Also, since the product takes an average of 21 days to arrive, calculating the proper reordering quantities is imperative. Inventory can be organized into an 20/80 order and close monitoring to the high revenue generating product will help the company to maintain profitability and to avoid excess inventory levels.

SUPPLY CHAIN IMPROVEMENT Definitively, Eurofood must analyze its transportation methods to reduce its lead time. Taxation and importation costs needs to kept tight and a more efficient distribution layout to be put in place.

**INDEX** Total number of product by transportation category and type:
 * Complete || 63 ||
 * Consolidated || 79 ||
 * Airplane || 57 ||
 * Total || 199 ||
 * Average days in transit: 21 days

__Lowest combinations:__ || 1 litter || 10,181,948 || 2,138,209 || 1,980,598 || 20 || L || Complete || Besnier || unsalted 10 Grs || 6,919,080 || 2,075,724 || 1,421,729 || 180 || Case || Complete || Besnier || catering 69X22,6 || 3,641,929 || 1,092,579 || 648,563 || 280 || Case || Complete || Bel || block 25Kg || 2,542,946 || 686,595 || 543,424 || 120 ||  || Complete || Besnier || 120 Grs || 943,670 || 283,101 || 180,978 || 7 ||  || Complete || Bel || Cream 20 CL || 176,036 || 214,811 || 186,366 || 6 ||  || Complete || Besnier || 75Cl || 634,565 || 177,678 || 130,390 || 42 ||  || Complete || George || 75Cl || 610,629 || 170,976 || 113,761 || 42 ||  || Complete || George || Bayonne 4-6 Kg || 551,455 || 165,437 || 135,975 || 220 || Kg || Complete || Bel || Goose liver 320 Grs || 530,053 || 159,016 || 145,220 || 231 ||  || Consolidated ||   || mermemlade || 280,124 || 84,037 || 69,072 || 2.5 ||  || Complete || Andros || president || 275,412 || 82,624 || 47,537 || 18 ||  || Complete || Besnier || 200gr || 251,862 || 75,559 || 97,985 || 12 ||  || Complete || Bel || terrorir normand 250gr || 75,845 || 22,754 || - || 27 ||  || Airplane ||   ||
 * Andros || lle du levant || Sagatrans || 19 ||
 * Bel || lle du levant || Sagatrans || 19 ||
 * Besnier || Aller et Retour || Andelstrom || 19 ||
 * George DeBoeuf || Bretagne || Kunehage || 18 ||
 * __ **Arrivals of complete containers over the last six months** __ ||  ||   ||   ||   ||   ||   ||   ||   ||   ||
 * || ** Departure **
 * date ** || ** Arrival date ** || ** Suppliers ** || ** Boat ** || ** Freight Forwarder ** || ** Days in **
 * transit ** ||  ||   ||
 * || 1/3 || 1/24 || Besnier ||  ||   || 21 ||   ||   ||
 * || 1/6 || 1/25 || Andros || lle du levant || Sagatrans || 19 ||  ||   ||
 * || 1/6 || 1/25 || Bel || lle du levant || Sagatrans || 19 ||  ||   ||
 * || 1/12 || 2/2 || George DeBoeuf || Naissance || Kunehage || 21 ||  ||   ||
 * || 1/25 || 2/15 || Besnier || Soleil levant || SCAC || 21 ||  ||   ||
 * || 1/25 || 2/15 || Bel || Soleil levant || SCAC || 21 ||  ||   ||
 * || 2/2 || 2/24 || George DeBoeuf || Diable au corps || Sagatrans || 22 ||  ||   ||
 * || 2/14 || 3/5 || Besnier || Aller et Retour || Andelstrom || 19 ||  ||   ||
 * || 2/18 || 3/11 || Bel || Tour du Monde || Clasquin || 21 ||  ||   ||
 * || 2/25 || 3/15 || George DeBoeuf || Bretagne || Kunehage || 18 ||  ||   ||
 * || 3/1 || 3/21 || Andros || Naissance || SCAC || 20 ||  ||   ||
 * || 3/5 || 3/25 || Besnier || lle du levant || Sagatrans || 20 ||  ||   ||
 * || 3/5 || 3/25 || Bel || lle du levant || Sagatrans || 20 ||  ||   ||
 * || 3/15 || 4/7 || George DeBoeuf || Normandie || Andelstrom || 23 ||  ||   ||
 * || 3/27 || 4/19 || Besnier || Aller et Retour || Kunehage || 23 ||  ||   ||
 * || 3/29 || 4/21 || Bel || Soleil levant || SCAC || 23 ||  ||   ||
 * || 3/29 || 4/21 || George DeBoeuf || Soleil levant || SCAC || 23 ||  ||   ||
 * || 4/19 || 5/10 || Besnier || Diable au corps || Sagatrans || 21 ||  ||   ||
 * || 4/21 || 5/12 || Bel || Tour du Monde || Clasquin || 21 ||  ||   ||
 * || 4/25 || 5/18 || George DeBoeuf || Naissance || Kunehage || 23 ||  ||   ||
 * || 5/4 || 5/25 || Andros || Bretagne || Sagatrans || 21 ||  ||   ||
 * || 5/10 || 5/30 || Bel || lle du levant || Sagatrans || 20 ||  ||   ||
 * || 5/10 || 5/30 || Besnier || lle du levant || Sagatrans || 20 ||  ||   ||
 * || 5/18 || 6/10 || George DeBoeuf || Aller et Retour || Andelstrom || 23 ||  ||   ||
 * || 5/29 || 6/21 || Bel || Normandie || Kunehage || 23 ||  ||   ||
 * || 5/31 || 6/23 || Besnier || Diable au corps || SCAC || 23 ||  ||   ||
 * || 6/9 || 6/30 || George DeBoeuf || Tour du Monde || Clasquin || 21 ||  ||   ||
 * ||  ||   || Average ||   ||   || 21 ||   ||   ||
 * ||  ||   |||| **__ Lowest combinations: __** ||   ||   ||   ||   ||
 * ||  ||   || Andros || lle du levant || Sagatrans || 19 ||   ||   ||
 * ||  ||   || Bel || lle du levant || Sagatrans || 19 ||   ||   ||
 * ||  ||   || Besnier || Aller et Retour || Andelstrom || 19 ||   ||   ||
 * ||  ||   || **George DeBoeuf** || **Bretagne** || **Kunehage** || **18** ||   ||   ||
 * ||  ||   |||||| __ **Products carried by Eurofood** __ ||   ||   ||   ||
 * ** Product # ** || ** Name **
 * (of product) ** || ** Average Annual **
 * Business Sales (HK$) ** || ** Profit (HK$) ** || ** Inventory (HK$) ** || ** Hong Kong $ ** || ** units ** || ** Comments ** || ** Supplier ** ||
 * 1 || Whipping cream
 * ||  ||   |||||| __ **Products carried by Eurofood** __ ||   ||   ||   ||
 * ** Product # ** || ** Name **
 * (of product) ** || ** Average Annual **
 * Business Sales (HK$) ** || ** Profit (HK$) ** || ** Inventory (HK$) ** || ** Hong Kong $ ** || ** units ** || ** Comments ** || ** Supplier ** ||
 * 1 || Whipping cream
 * ||  ||   |||||| __ **Products carried by Eurofood** __ ||   ||   ||   ||
 * ** Product # ** || ** Name **
 * (of product) ** || ** Average Annual **
 * Business Sales (HK$) ** || ** Profit (HK$) ** || ** Inventory (HK$) ** || ** Hong Kong $ ** || ** units ** || ** Comments ** || ** Supplier ** ||
 * 1 || Whipping cream
 * 1 || Whipping cream
 * 1 || Whipping cream
 * 2 || Portion butter
 * 3 || minibabybel
 * 4 || Butter unsalted
 * 5 || Apple tea 125 Grs || 1,478,886 || 443,666 || 486,209 || 42 ||  || Consolidated ||   ||
 * 6 || Party cube nature
 * 7 || UHT Whipping
 * 8 || Cuvee GD Red
 * 9 || Cuvee GD White
 * 10 || Jambon Cru De
 * 11 || Rolled Mousse of
 * 12 || Laughing Cow 8 || 509,055 || 152,717 || 82,286 || 7 ||  || Complete || Bel ||
 * 13 || Party cube red || 478,589 || 143,577 || 255,685 || 7 ||  || Complete || Bel ||
 * 14 || dried morels || 459,265 || 137,780 || 119,535 || 1,000 ||  || Consolidated ||   ||
 * 15 || Rauw Goose liver || 457,470 || 137,241 || - || 1,200 || Kg || Airplane ||  ||
 * 16 || Soles 450-500 Grs || 405,760 || 162,304 || - || 180 || Kg || Airplane ||  ||
 * 17 || Salmon gutted || 385,012 || 154,005 || - || 250 ||  || Airplane ||   ||
 * 18 || Poully Fuisse || 364,258 || 109,277 || 109,776 || 75 ||  || complete || George ||
 * 19 || Air dried beef || 345,259 || 138,104 || - || 540 ||  || Airplane ||   ||
 * 20 || emmenthal block || 335,692 || 100,708 || 94,730 || 210 ||  || complete || Besnier ||
 * 21 || Laughing Cow 12 || 325,698 || 97,709 || 74,063 || 12 ||  || Complete || Bel ||
 * 22 || Apple tea 250 Grs || 314,526 || 94,358 || 90,480 || 80 ||  || consolidated ||   ||
 * 23 || Camembert || 310,256 || 93,077 || 129,202 || 25 ||  || complete || Besnier ||
 * 24 || Duck fillet || 305,125 || 106,794 || - || 240 ||  || Airplane ||   ||
 * 25 || boursin pepper || 298,521 || 89,556 || - || 21 ||  || Airplane ||   ||
 * 26 || minibabygel || 289,652 || 72,413 || 138,874 || 12 ||  || Complete || Bel ||
 * 27 || orange
 * 28 || camembert
 * 29 || endive || 274,256 || 109,702 || - || 50 ||  || Airplane ||   ||
 * 30 || scotish smoked salmon || 268,541 || 80,562 || - || 240 ||  || Airplane ||   ||
 * 31 || Belon 000 || 265,485 || 92,920 || - || 270 ||  || Airplane ||   ||
 * 32 || Norway smoked salmon || 264,521 || 79,356 || - || 310 ||  || Airplane ||   ||
 * 33 || Roquefort portion 100 gr || 262,485 || 78,746 || 73,352 || 18 ||  || Complete || Bel ||
 * 34 || Raw duck liver || 261,458 || 91,510 || - || 270 ||  || Airplane ||   ||
 * 35 || Fleaurie 1987 || 260,198 || 72,855 || 89,109 || 120 ||  || Complete || George ||
 * 36 || Turbot 3-4 Kg || 258,413 || 103,365 || - || 220 ||  || Airplane ||   ||
 * 37 || red charoky italy || 257,164 || 90,007 || - || 51 ||  || Airplane ||   ||
 * 38 || red turkey ballotine || 256,983 || 77,095 || 278,105 || 210 ||  || consolidated ||   ||
 * 39 || Turbot 4 kg || 256,469 || 89,764 || - || 200 ||  || Airplane ||   ||
 * 40 || Beaujalais Village 1987 || 255,961 || 71,669 || 122,721 || 78 ||  || Complete || George ||
 * 41 || Darjeeling tea 125 gr || 255,120 || 76,536 || 134,899 || 42 ||  || Consolidated ||   ||
 * 42 || Strawberry jam || 254,763 || 76,429 || 62,818 || 2.5 ||  || Complete || Andros ||
 * 43 || honey jam || 254,156 || 76,247 || 205,414 || 2.5 ||  || Complete || Andros ||
 * 44 || garlic and herbs || 253,968 || 76,190 || - || 270 ||  || Airplane ||   ||
 * 45 || cemeaux noix extra || 253,641 || 76,092 || 87,558 || 270 ||  || Consolidated ||   ||
 * 46 || carlton peach || 253,248 || 68,377 || 437,113 || 75 ||  || Consolidated ||   ||
 * 47 || Vegetable terrine || 253,120 || 75,936 || 55,478 || 128 ||  || Consolidated ||   ||
 * 48 || butter unsalted 1 kg || 252,989 || 75,897 || 59,608 || 10 ||  || Complete || Besnier ||
 * 49 || turffle || 252,754 || 75,826 || 55,398 || 1,050 ||  || Consolidated ||   ||
 * 50 || goose liver vs truffles 3% || 252,563 || 75,769 || - || 1,080 ||  || Airplane ||   ||
 * 51 || portion butter salted || 252,436 || 75,731 || 82,993 || 180 ||  || Complete || Besnier ||
 * 52 || androuet cheese || 252,387 || 80,764 || - || 260 ||  || Airplane ||   ||
 * 53 || beluga caviar || 252,358 || 100,943 || - || 780 ||  || Airplane ||   ||
 * 54 || butter unsalted 227 gr || 252,312 || 75,694 || 66,362 || 4 ||  || Complete || Besnier ||
 * 55 || babybel red waxed
 * 56 || red lettuce || 251,126 || 87,894 || - || 50 ||  || Airplane ||   ||
 * 57 || veiga madeira || 250,962 || 75,289 || 85,946 || 125 ||  || Consolidated ||   ||
 * 58 || chablis || 250,123 || 75,037 || 75,380 || 210 ||  || Consolidated ||   ||
 * 59 || Darjeeling tea 250 gr || 246,126 || 73,838 || 64,060 || 80 ||  || Consolidated ||   ||
 * 60 || scallop heart || 245,632 || 73,690 || - || 175 ||  || Airplane ||   ||
 * 61 || brie in tin || 245,365 || 72,410 || 48,273 || 18 ||  || Complete || Besnier ||
 * 62 || snails 6 doz in tin || 239,462 || 71,836 || 114,806 || 65 ||  || Consolidated ||   ||
 * 63 || chef block goose liver || 230,452 || 73,745 || 56,824 || 1,018 ||  || Consolidated ||   ||
 * 64 || Normandie calvados || 229,541 || 68,862 || 75,466 || 250 ||  || Consolidated ||   ||
 * 65 || kiri portions 6 || 241,365 || 68,590 || 41,342 || 12 ||  || complete || Bel ||
 * 66 || fleune 1988 || 245,632 || 68,224 || 52,959 || 79 ||  || complete || George ||
 * 67 || poully fume 1987 || 246,126 || 67,924 || 68,234 || 125 ||  || complete || George ||
 * 68 || morning tea 125gr || 250,123 || 67,689 || 52,544 || 42 ||  || consolidated ||   ||
 * 69 || sancerre blane 1987 || 250,962 || 66,317 || 54,507 || 178 ||  || consolidated ||   ||
 * 70 || soles 300-340 gr || 251,126 || 88,146 || - || 250 ||  || Airplane ||   ||
 * 71 || fine de claire || 215,896 || 75,564 || - || 248 ||  || Airplane ||   ||
 * 72 || brie president 1 kg || 212,369 || 63,711 || 55,274 || 120 ||  || complete || Besnier ||
 * 73 || b de cremant rose || 210,596 || 63,179 || 63,467 || 210 ||  || consolidated ||   ||
 * 74 || potatoes parisienes 1 kg || 200,365 || 60,110 || 68,618 || 54 ||  || consolidated ||   ||
 * 75 || sea bass 1 - 2 kg || 189,821 || 66,332 || - || 289 ||  || Airplane ||   ||
 * 76 || casador red || 187,452 || 56,236 || 102,713 || 58 ||  || consolidated ||   ||
 * 77 || kirschco 75cl || 185,632 || 55,690 || 48,315 || 215 ||  || consolidated ||   ||
 * 78 || vin rouge cousine || 185,421 || 51,918 || 55,880 || 40 ||  || Complete || George ||
 * 79 || fromage || 184,732 || 55,420 || - || 80 ||  || Airplane ||   ||
 * 80 || ronele garlic || 162,085 || 48,656 || 79,044 || 17 ||  || Complete || Besnier ||
 * 81 || fresh troufles || 154,269 || 58,622 || - || 1,080 ||  || Airplane ||   ||
 * 82 || yvonne rouge 75cl || 145,214 || 43,564 || 29,838 || 49 ||  || consolidated ||   ||
 * 83 || girolles 560 gr || 124,685 || 37,406 || 27,328 || 740 ||  || consolidated ||   ||
 * 84 || laughing cow barquette || 112,030 || 330,609 || 29,158 || 18 ||  || Complete || Bel ||
 * 85 || moulin a vent 1987 || 110,854 || 33,256 || 21,260 || 125 ||  || Complete || George ||
 * 86 || bresse chicken || 109,521 || 32,856 || - || 215 ||  || Airplane ||   ||
 * 87 || apricot jam 50gr || 102,584 || 30,775 || 29,510 || 2.5 ||  || Complete || Andros ||
 * 88 || belyga caviar 200gr || 99,521 || 39,808 || - || 250 ||  || Airplane ||   ||
 * 89 || casador white || 97,541 || 27,311 || 26,189 || 48 ||  || Consolidated ||   ||
 * 90 || calvados pays d'auge 1933 || 96,254 || 28,876 || 21,097 || 215 ||  || Consolidated ||   ||
 * 91 || chablis 1987 || 91,256 || 27,377 || 25,002 || 191 ||  || Consolidated ||   ||
 * 92 || minipic || 85,210 || 25,563 || - || 18 ||  || Airplane ||   ||
 * 93 || haricots verts || 82,365 || 28,828 || - || 50 ||  || Airplane ||   ||
 * 94 || butter 49gr || 80,125 || 24,038 || 9,878 || 10 ||  || Complete || Besnier ||
 * 95 || passion fruits puree 6 kg || 78,541 || 23,562 || 20,442 || 315 ||  || Consolidated ||   ||
 * 96 || fraise 5 kg || 78,123 || 23,437 || 23,544 || 60 ||  || Consolidated ||   ||
 * 97 || oliver oil 1 lt || 77,985 || 23,396 || 29,485 || 27 ||  || Consolidated ||   ||
 * 98 || Beaujalais Village 1988 || 76,985 || 23,096 || 9,491 || 110 ||  || Complete || George ||
 * 99 || baby chicken 400-500gr || 76,125 || 24,360 || - || 170 ||  || Airplane ||   ||
 * 100 || camembert
 * 101 || frisee || 75,412 || 24,132 || - || 50 ||  || Airplane ||   ||
 * 102 || framboise 5 kg || 75,125 || 22,538 || 20,582 || 65 ||  || Consolidated ||   ||
 * 103 || champignon paris || 75,012 || 22,504 || - || 115 ||  || Airplane ||   ||
 * 104 || lobster norway || 74,963 || 23,239 || - || 760 ||  || Airplane ||   ||
 * 105 || caprice des dieux 135gr || 72,561 || 21,768 || - || 27 ||  || Airplane ||   ||
 * 106 || pommery mustard 500gr || 65,413 || 19,624 || 19,714 || 49 ||  || Consolidated ||   ||
 * 107 || raspberry jam 50gr || 61,023 || 18,307 || 15,883 || 2.5 ||  || Complete || Andros ||
 * 108 || chateaneuf de pape red 1986 || 58,632 || 17,590 || 28,593 || 180 ||  || Consolidated ||   ||
 * 109 || chande cuvee gd blanc || 54,123 || 15,154 || 7,562 || 51 ||  || Complete || George ||
 * 110 || cotes du rhone red 1987 || 50,874 || 16,262 || 12,962 || 12 ||  || Complete || Besnier ||
 * 111 || finde de claire 1 || 48,632 || 14,590 || 10,393 || 191 ||  || Complete || George ||
 * 112 || rambol walnut || 46,512 || 16,279 || - || 460 ||  || Airplane ||   ||
 * 113 || musghroom || 42,831 || 12,849 || 16,663 || 18 ||  || complete || Besnier ||
 * 114 || dried morales || 39,621 || 11,886 || 11,398 || 540 ||  || Consolidated ||   ||
 * 115 || asperge || 33,165 || 9,950 || 10,722 || 1,100 ||  || consolidated ||   ||
 * 116 || frozen cepes # 0 || 30,895 || 10,813 || - || 75 ||  || Airplane ||   ||
 * 117 || dried cepes || 25,621 || 7,686 || 8,494 || 540 ||  || consolidated ||   ||
 * 118 || blue cheese 30gr || 20,785 || 6,236 || 6,264 || 775 ||  || consolidated ||   ||
 * 119 || pike || 18,631 || 5,589 || - || 12 ||  || Airplane ||   ||
 * 120 || duck liver 1 kg || 16,384 || 4,915 || - || 18 ||  || Airplane ||   ||
 * 121 || broully 1987 || 14,698 || 4,409 || - || 1,075 ||  || Airplane ||   ||
 * 122 || beluga caviar 100 gr || 11,695 || 3,509 || 3,044 || 211 ||  || complete || George ||
 * 123 || brie portion 180gr || 9,321 || 3,728 || - || 195 ||  || Airplane ||   ||
 * 124 || earl grey teae 125 gr || 8,691 || 2,607 || 2,286 || 41 ||  || Complete || Besnier ||
 * 125 || mangos puree 6 kg || 7,963 || 2,389 || 3,818 || 42 ||  || consolidated ||   ||
 * 126 || extra fine pees sweet 1 kg || 7,269 || 2,181 || 4,182 || 318 ||  || consolidated ||   ||
 * 127 || saint paulin 30gr || 6,987 || 2,096 || 6,317 || 75 ||  || consolidated ||   ||
 * 128 || chateaneuf de pape white 1987 || 6,589 || 1,977 || 6,950 || 12 ||  || Complete || Besnier ||
 * 129 || chablies 1987 || 6,125 || 1,838 || 1,846 || 181 ||  || consolidated ||   ||
 * 130 || williams brandy || 6,012 || 1,804 || 4,908 || 53 ||  || consolidated ||   ||
 * 131 || butter 49 kg || 5,869 || 1,761 || 1,624 || 215 ||  || consolidated ||   ||
 * 132 || yvon blanc || 5,421 || 1,518 || 2,347 || 10 ||  || Complete || Besnier ||
 * 133 || mirtilles 5 kg || 5,237 || 1,571 || 2,597 || 48 ||  || consolidated ||   ||
 * 134 || terrien of fish || 5,012 || 1,504 || 1,510 || 318 ||  || Consolidated ||   ||
 * 135 || chabis round white goat 100gr || 5,001 || 1,500 || 1,535 || 175 ||  || Consolidated ||   ||
 * 136 || panna ham || 4,765 || 1,430 || - || 31 ||  || Airplane ||   ||
 * 137 || sancerre blanc 1988 || 4,652 || 1,396 || 1,083 || 318 ||  || Complete || Bel ||
 * 138 || frozen forestiere || 4,215 || 1,265 || 2,425 || 218 ||  || Consolidated ||   ||
 * 139 || ravioli plaque || 3,986 || 1,196 || 2,403 || 115 ||  || Consolidated ||   ||
 * 140 || broil 80gr || 3,745 || 1,124 || - || 91 ||  || Airplane ||   ||
 * 141 || carrots parisiere 1 kg || 3,429 || 1,200 || - || 151 ||  || Airplane ||   ||
 * 142 || bergerac red 1985 || 3,145 || 944 || 2,999 || 78 ||  || Consolidated ||   ||
 * 143 || chasagne 1985 || 3,028 || 908 || 2,895 || 211 ||  || Consolidated ||   ||
 * 144 || cherry jam 50gr || 2,965 || 890 || 1,706 || 561 ||  || Consolidated ||   ||
 * 145 || port salut 200gr || 2,756 || 827 || 740 || 2.5 ||  || Complete || Andros ||
 * 146 || soles 500-600gr || 2,415 || 725 || 298 || 18 ||  || Complete || Besnier ||
 * 147 || cotes du rhone red 1988 || 2,346 || 821 || - || 240 ||  || Airplane ||   ||
 * 148 || chevre cheese || 2,106 || 632 || 1,142 || 175 ||  || Complete || George ||
 * 149 || lobster norway 11-15 || 2,059 || 618 || - || 41 ||  || Airplane ||   ||
 * 150 || airelles 5 kg || 2,018 || 706 || - || 318 ||  || Airplane ||   ||
 * 151 || petit chebles 1986 || 1,985 || 596 || 625 || 315 ||  || Consolidated ||   ||
 * 152 || butter 227 gr || 1,856 || 557 || 702 || 213 ||  || Consolidated ||   ||
 * 153 || peach jam 340 gr || 1,745 || 524 || 904 || 4 ||  || Complete || Besnier ||
 * 154 || present collection || 1,702 || 511 || 1,072 || 51 ||  || Complete || Andros ||
 * 155 || fraise des bois 2 kg || 1,698 || 509 || 977 || 518 ||  || Consolidated ||   ||
 * 156 || salmon presliced smoked || 1,621 || 486 || 866 || 110 ||  || Consolidated ||   ||
 * 157 || xeres vinegar red 50cl || 1,602 || 481 || - || 215 ||  || Airplane ||   ||
 * 158 || banan tea 125gr || 1,542 || 463 || 1,681 || 27 ||  || Consolidated ||   ||
 * 159 || chambolle 1983 || 1,530 || 459 || 734 || 42 ||  || Consolidated ||   ||
 * 160 || bourgogne rouge 1986 || 1,459 || 438 || 839 || 741 ||  || Consolidated ||   ||
 * 161 || bonnel portion 150gr || 1,426 || 428 || 1,293 || 218 ||  || Complete || George ||
 * 162 || cookies 152 gr || 1,407 || 422 || 378 || 45 ||  || Complete || Bel ||
 * 163 || cremant blanc || 1,389 || 417 || 373 || 18 ||  || Consolidated ||   ||
 * 164 || vieux pane || 1,389 || 407 || 427 || 215 ||  || Consolidated ||   ||
 * 165 || sea brim pink || 1,356 || 398 || - || 175 ||  || Airplane ||   ||
 * 166 || hazelnut oil 50cl || 1,327 || 395 ||  || 418 ||   || Airplane ||   ||
 * 167 || laitue || 1,318 || 386 || 415 || 59 ||  || Consolidated ||   ||
 * 168 || slices croque monseur || 1,285 || 407 || - || 41 ||  || Airplane ||   ||
 * 169 || bausejour 1985 || 1,272 || 378 || 2,173 || 18 ||  || Complete || Besnier ||
 * 170 || vielle prune || 1,259 || 371 || 2,032 || 789 ||  || Consolidated ||   ||
 * 171 || swiss cheese || 1,236 || 368 || 1,403 || 218 ||  || Consolidated ||   ||
 * 172 || chablis 1987 || 1,225 || 363 || - || 218 ||  || Airplane ||   ||
 * 173 || tea 125 gr || 1,211 || 360 || 658 || 175 ||  || Consolidated ||   ||
 * 174 || apricot puree 6 kg || 1,200 || 355 || 567 || 42 ||  || Consolidated ||   ||
 * 175 || montrose 1980 || 1,183 || 344 || 894 || 327 ||  || Consolidated ||   ||
 * 176 || henkel troken 20 cl || 1,121 || 336 || 863 || 1,018 ||  || Consolidated ||   ||
 * 177 || youem 1981 || 1,083 || 325 || 326 || 210 ||  || Consolidated ||   ||
 * 178 || coulommers || 1,056 || 317 || 1,094 || 1,025 ||  || Consolidated ||   ||
 * 179 || daneeling tea 25 gr || 1,029 || 309 || - || 52 ||  || Airplane ||   ||
 * 180 || youem 1981 || 1,012 || 304 || 269 || 20 ||  || Consolidated ||   ||
 * 181 || coulummiers s paille || 1,003 || 301 || 324 || 41 ||  || Complete || George ||
 * 182 || covallini pinot grigio 1987 || 968 || 290 || 1,056 || 180 ||  || Consolidated ||   ||
 * 183 || broulilly 1988 || 923 || 277 || 1,037 || 190 ||  || Complete || George ||
 * 184 || ch lagrange 1983 || 910 || 273 || 1,421 || 741 ||  || Consolidated ||   ||
 * 185 || crozes hermitage 1988 || 859 || 258 || 1,318 || 448 ||  || Consolidated ||   ||
 * 186 || macom village 1989 || 847 || 254 || 545 || 152 ||  || Complete || George ||
 * 187 || rabbit saddles || 823 || 247 || - || 218 ||  || Airplane ||   ||
 * 188 || tomatoes beef bb || 811 || 243 || - || 51 ||  || Airplane ||   ||
 * 189 || cassi puree 6kg || 756 || 227 || 238 || 318 ||  || Consolidated ||   ||
 * 190 || griottines || 712 || 214 || 605 || 518 ||  || Consolidated ||   ||
 * 191 || slices hamburger || 689 || 209 || 1,195 || 18 ||  || Complete || Besnier ||
 * 192 || pinot blanc 1987 || 654 || 196 || 385 || 121 ||  || Consolidated ||   ||
 * 193 || cotes de baune village 1983 || 621 || 186 || 541 || 198 ||  || Complete || George ||
 * 194 || oscietra caviar 30gr || 546 || 218 || - || 121 ||  || Airplane ||   ||
 * 195 || sweet butter cookies 125gr || 418 || 125 || 364 || 18 ||  || Consolidated ||   ||
 * 196 || orange sweet tea 125 gr || 356 || 107 || 206 || 42 ||  || Consolidated ||   ||
 * 197 || la fleur bechada 1985 || 298 || 89 || 283 || 782 ||  || Consolidated ||   ||
 * 198 || salmon eggs 30gr || 219 || 66 || - || 75 ||  || Airplane ||   ||
 * 199 || crozes hermitage 1987 || 158 || 47 || 2,045 || 289 ||  || Complete || George ||

Expand on these Ideas:
 * __Objectives__**
 * Create an inventory management system that reduces Eurofood’s inventory levels.**
 * Phase out consolidated deliveries, and attempt to bring in more complete shipments. > VMI, quarterly forecasting, save money.**
 * __Actions to take__**
 * Implement VMI system to phase out consolidated deliveries, make forecast and submit to supplier.**
 * Levy support for an EDI system to use in conjunction with the VMI system over the next 5 years.**
 * __Justifications__**
 * Too many consolidated deliveries, which are 6x the cost of a “complete container” shipment and have a longer lead time. This needs to be reduced. VMI would allow more “Complete container’s” to be shipped, which would reduce overhead cost.**
 * Suppliers would base order amount on the forecasted number obtained from Eurofood versus sending a fixed order quantity every 21 days (average transit time). The fixed order quantity creates redundancies in the inventory levels and is the** source **of the high inventory expenses.**
 * EDI is a long-term solution(5 years+). CPFR is a combination of VMI and EDI. This system would eventually need to be implemented in order to improve communication between Eurofood’s warehouse and suppliers with a focus on maintaining optimal inventory levels.**
 * ...Additional Justifications go here....**

**Executive Summary – Eurofood Outline** xxx Paragraph - no explicit language in the wiki please ...
 * Highlights**
 * Increase Profit Margin**
 * Improved Efficiency and Communication**

**Body Outline** What is Vendor Managed Inventory? Copyright Dr. Edmund Prater, University of Texas at Arlington Short-term solution “VMI is now being more readily used. Using a VMI program, a company outsourcers its inventory control to their supplier while only needing to handle sales and forecasting data. VMI allows manufacturers to respond to customer demand and goods are only sent when needed from VMI locations that are run by the manufacturer. VMI programs can result in inventory reduction due to the supplier handing inventory tracking and replenishment planning and collaboration”

Better Forecast >Quarterly Forcast made by Eurofood. > Suppliers ship inventory based on figures forecasted by Eurofood. Increased Profit Margin >Currently PM is 30%, reduced inventory would result in an increase. What is Electronic Data Interchange? Copyright Dr. Edmund Prater, University of Texas at Arlington 5 year plan (EDI) is helping a lot of business in sharing data. It involves the transfer of data between different companies using a network. EDI helps with buying, selling and sharing information. A supplier can access their customers inventory data and know when their inventory needs replenishing and can adjust their near term manufacturing forecast plan to this information. When a company needs to place an order, they can do this through an EDI system and avoid a paper trail of  purchase orders because the system will automatically save the information. It provides faster communication from one entity to another and companies can access real time data.
 * Immediate Benefits of VMI **

Long Term Combined, these systems make.. 5 year plan, ensures long-term success. Collaborative Planning, Forecasting and Replenishment (CPFR) combines EDI and VMI. It is different because it allows more shared information between two entities and increases collaboration. It links the supply and demand of a product so that the retailer is more involved in the supply chain because both companies will be able to see the entire supply chain from one end to the other. The final retailer will be able to be involved from the manufacturing of raw materials to the final product. All the suppliers that are involved in the process of making an item are linked together and can get information about the other. This helps to determine short comings of material of any manufacture in the chain so that companies can plan accordingly


 * INFORMATION IN RED IS COPYRIGHT** NEED CITATION