Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Chief Value Officer Accountants Can Save The Planet

Authors: Mervyn King, Jill Atkins

1st Edition

1783532939, 978-1783532933

More Books

Students also viewed these Accounting questions

Question

7. Identify four antecedents that influence intercultural contact.

Answered: 1 week ago

Question

5. Describe the relationship between history and identity.

Answered: 1 week ago