The soft goods department of a large department store sells 175 units per month of a certain large bath towel. The unit cost of a towel to the store is $2.50 and the cost of placing an order has been estimated to be $12.00. The store uses an inventory carrying charge of 1 = 27% per year. Determine (a) the optimal order quantity, (b) the order frequency, and (c) the annual holding and setup cost. If, through automation of the purchasing process, the ordering cost can be cut to $4.00, what will be (d) the new economic order quantity, (e) the order frequency, and (f) annual holding and setup costs?

Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Chapter16: Lean Supply Chain Management
Section: Chapter Questions
Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...
icon
Related questions
Question

Please solve using excel. Thank you.

The soft goods department of a large department store sells 175 units per month of a certain large bath towel.
The unit cost of a towel to the store is $2.50 and the cost of placing an order has been estimated to be $12.00.
The store uses an inventory carrying charge of 1 = 27% per year.
Determine (a) the optimal order quantity, (b) the order frequency, and (c) the annual holding and setup cost.
If, through automation of the purchasing process, the ordering cost can be cut to $4.00, what will be (d) the new economic order quantity, (e) the order frequency, and (f) annual holding and setup costs?
Transcribed Image Text:The soft goods department of a large department store sells 175 units per month of a certain large bath towel. The unit cost of a towel to the store is $2.50 and the cost of placing an order has been estimated to be $12.00. The store uses an inventory carrying charge of 1 = 27% per year. Determine (a) the optimal order quantity, (b) the order frequency, and (c) the annual holding and setup cost. If, through automation of the purchasing process, the ordering cost can be cut to $4.00, what will be (d) the new economic order quantity, (e) the order frequency, and (f) annual holding and setup costs?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning