History:
EuroFood was created by French restaurateur, Mr Vigneau which specializes in the importing and distributing of food products from Europe to Hong Kong.EuroFood has faced a problem with inventory costs. The Olivier Company decided to buy EuroFood on the condition that inventory levels has to be reduced from its current level of 11 million Hong Kong Dollars to at least 4 million Hong Kong Dollars (assumption).In order to achieve the inventory reduction a plan of action has to proposed which details the solution to the current high levels of inventory. All the products brought to Hong Kong are shipped either by plane or through cargo boats (channels of distribution). The exclusively perishable products shipped through airplanes have no inventory records to be kept. The only inventory of Euro Foods is the products shipped via boats. The products shipped through boats are divided mainly into two types: 1. Complete Container: Contains products shipped from the same supplier. Complete container takes about 20 days to ship from Europe to Hong Kong and costs 0.5 Hong Kong Dollars per kilogram 2. Consolidated container: Contains products shipped from a group of suppliers using the same container as a rented facility. This shipping takes about 30 days to reach the customer and costs about 3 Hong Kong Dollars per kilogram.
Main Problem: * The current level of inventory of Euro Foods is worth $11 million. This is too much compared to the Olivier Company which has the same volume of business as Euro Foods with a corresponding inventory level of only $4 million. * The order quantity is high due to wrong forecasting which leads to high inventory costs * Some products have higher inventory costs than its annual sales( Eg: The product Carton Peach has an inventory cost of $437,113 and an annual sale of $ 253,248 which led to profits of only $68,377) * Due to higher inventory levels of the products the annual profit from