Purchase Solution

inventory cost

Not what you're looking for?

Ask Custom Question

The need of a company is 16000 units/year, demand is constant throughout the year, ordering cost is $25 per order, and the holding cost is 20% per unit. These suppliers below are offering discount. So which of the two suppliers should be selected to minimize total inventory cost, and what would be the inventory cost?

supplier A supplier B

Quantity Price Quantity Price
1-199 38.40 1-299 39.50
200-499 35.60 300-999 35.40
500 or more 34.70 1000 or more 34.60

Purchase this Solution

Solution Summary

In this tutorial, inventory costs are evaluated. The minimized total inventory costs are provided.

Solution Preview

Please see below and the attached document.

The attached spreadsheet shows the total inventory cost under each supplier, based on the number of units per shipments (in increments of 20 units). We see that the lowest total inventory cost ($557,460) is achieved by using Supplier B, and making 16 orders of 1,000 units each per ...

Purchase this Solution

Free BrainMass Quizzes
Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.


This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.