Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The I-75 Carpet Discount Store has an annual demand of 10,000 yards of Super Shag carpet. The annual carrying cost for a yard of this
The I-75 Carpet Discount Store has an annual demand of 10,000 yards of Super Shag carpet. The annual carrying cost for a yard of this carpet is $0.75, and the ordering cost is $150. The carpet manufacturer normally charges the store $8 per yard for the carpet; however, the manufacturer has offered a discount price of $6.50 per yard if the store will order 5,000 yards. How much should the store order, and what will be the total annual inventory cost for that order quantity.
please put in excel format
ORDERING | ORDERING | |||
EOQ | 5,000 | |||
= | ||||
Average inventory = Q/2 = | ||||
Annual carrying cost = | ||||
Number of orders = | ||||
Annual order cost = | ||||
Total inventory purchase cost = | ||||
Total inventory cost = |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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