Share
Explore BrainMass

Inventory Management in Excel

Using Excel, Determine the following:

The Western Jeans Company purchases denim from Cumberland Textile Mills. The Western Jeans Company uses 35,000 yards of denim per year to make jeans. The cost of ordering denim from the textile company is $500 per order. It costs Western $0.35 per yard annually to hold a yard of denim in inventory. Determine the optimal number of yards of denim the Western Jeans Company should order, the minimum total annual inventory cost, the optimal number of orders per year, and the optimal time between orders.

Solution Preview

Hello

Please find the details of this posting in the first excel ...

Solution Summary

Solution contains calculations of the optimal number of yards of denim the Western Jeans Company should order, the minimum total annual inventory cost, the optimal number of orders per year, and the optimal time between orders.

$2.19