Solve in ExcelQM

Barbara Bright is the purchasing agent for West Valve Company. West Valve sells industrial valves and fluid control devices. One of the most popular valves is the Western, which has an annual demand of 4,000 units. The cost of each valve is $90, and the inventory carrying cost is estimated to be 10% of the cost of each valve. Barbara has made a study of the costs involved in placing an order for any of the valves that West Valve stocks, and she has concluded that the average ordering cost is $25 per order. Furthermore, it takes about two weeks for an order to arrive from the supplier, and during this time, the demand per week for West valves is approximately 80.

(a) What is the EOQ?

(b) What is the ROP?

(c) Is the ROP greater than the EOQ? If so, how is this situation handled?

(d) What is the average inventory? What is the annual holding cost?

(e) How many orders per year would be placed? What is the annual ordering cost?

Solve in ExcelQM