Millennium Liquors:-
Millennium Liquors is a wholesaler of sparkling wines. Their most popular product is the French Bete Noire 1 989. Weekly demand is for 45 cases. Assume demand occurs over 50 weeks per year. The wine is shipped directly from France. Millenniums annual cost of capital is 15 percent, which also includes all other inventory-related costs. Below are relevant data on the costs of shipping and handling. These costs include the usual ordering and handling costs, plus the cost of refrigeration, which includes a fixed component (mainly depreciation of the cooling equipment) and a variable component that depends on the number of cases in inventory.
• Cost per case: $120
• Shipping cost ( for any size shipment): $290
• Cost of labor to place and process an order: $10
• Cost of labor to place cases into warehouse: $2/case
• Cost of labor to pick case when sold: $2/case
• Fixed cost for refrigeration: $75/week
• Variable cost for refrigeration: $3/case/week
a. Calculate the weekly holding cost for one case of wine.
b. Use the EOQ model to find the number of cases per order and the average number of orders per year.
c. Currently orders are placed by calling France and then following up with a letter. Millennium and its supplier may switch to a simple ordering system using the Internet. The new system will require much less labor. What would be the impact of this system on the ordering pattern?