Le Club Francais Du Vin

5612 Words Jun 23rd, 2014 23 Pages
Club Français du Vin Case study
Inventory Management

“The Club Français du Vin” case study
This case study discusses ordering and forecasting process of the wine company Club Français du Vin. As the name suggests, this is a French company that offers French wines to the consumers trough catalog offers. The main catalog is the Etiquette, which includes a selection of 30 to 40 wines that the clients can then choose and order by mail, phone, fax or by internet. The members also receive other two leaflets, La Selection (shows three recommendations for the season) and La Cave (consists of a list of wines and corresponding prices, that are available also – this are mainly leftovers from the previous season and are heavily discounted).
The
…show more content…
Although if they cannot sell in the appropriate (if they have to sell at discount), they will incur in this cost of capital; * We assume the cost of capital to be a stated annual rate to facilitate calculations; * As stated in the guidelines, we also assume that the mean of the demand is equal to the product of the mean of the forecasting error and the forecast itself, and the same for the standard deviation of demand; * To compute the lost function we use the following formula: UNL(z)=f(z)-z(1-F(z))
Now that we have exposed our assumptions, we can start going into more detail on the case itself. First, as this is an inventory management case study, we are going to determine the optimal order quantity of each type of wine, so that afterwards we can make include a more financial view of the problem and make some recommendations.
Optimal order quantity:
To compute the optimal order quantity of each wine we firstly needed to compute the unit cost per bottle and the salvage value of each. From the description of the case we could easily identify that the unit cost of each bottle was 50% (gross margin) of the price plus the 1,25€ per bottle of the transportation costs. With this we computed the unitary cost of each type of wine.
Afterwards we needed to compute the salvage value. Here the calculations aren’t that simple because we have to account

More about Le Club Francais Du Vin