Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel Sports (ES) operates a megastore featuring sports merchandise. It uses an EOQ decision model to make inventory decisions. It is now considering inventory decisions
Excel Sports (ES) operates a megastore featuring sports merchandise. It uses an EOQ decision model to make inventory decisions. It is now considering inventory decisions for its Los Angeles Galaxy soccer jerseys product line. This is a highly popular item. Data for 2017 are as follows: (Click the icon to view the data.) Read the requirements. Requirement 1. Calculate the EOQ. Begin by selecting the formula used to calculate EOQ. (D = Demand in units for one year, P = Ordering cost per purchase order, C = Carrying cost of one unit in stock, Q = Any order quantity.) Data table Requirements 1. Calculate the EOQ. 2. Calculate the number of orders that will be placed each year, 3. Calculate the reorder point. Expected annual demand for Galaxy jerseys 9,000 Ordering cost per purchase order $250 Carrying cost per year $8 per jersey Each jersey costs ES $45 and sells for $90. The 8 carrying cost per jersey per year consists of the required return on investment of $5.85 (13% - $45 purchase price) plus $2.15 in relevant insurance, handling, and storage costs. The purchasing lead time is 6 days. ES is open 365 6 days a year Print Done Print Done
Step 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