Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please use excel solver !thank you! 3. (20 points) Thomas Company plans to order a particular part from a supplier. Demand for the part is
Please use excel solver !thank you!
3. (20 points) Thomas Company plans to order a particular part from a supplier. Demand for the part is constant during the year with an annual demand of 100000 units. The ordering cost is $100, and each part costs the retailer $500. The inventory carrying percentage is 20% and reflects the cost of the money tied up in inventory. Thomas company plans to store the part in one or more warehouses which would be rented. There is a nearby warehouse facility in which four separate and adjacent warehouse units are available. Thomas Company can rent the first warehouse unit for an annual rental fee of $4000. This warehouse unit holds a maximum of 150 parts. Each of the other three units is identical in size to the first and each would hold a maximum of 150 parts and each would rent for $4000 annually. What is the optimal order quantity for Thomas CompanyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started