question #5Same problem statement:Weekly demand for DVD-Rs at a retailer is normally distributed with a mean of 1,000 boxes and a standard deviation of 150. Currently, the store places orders to the supplier,with a reorder point of 4,200 boxes. The order quantity to the supplier is fixed at 5,000 boxes. Replenishment lead time is 4 weeks, fixed order cost per order is $100, each boxcosts the retailer $10, and the inventory holding cost is 25% per year.Under the current order quantity of 5,000 boxes and current reorder point of 4,200 boxes, what would be the order-up-to level S that the retailer should use as a baseline tocalculate how much inventory to order when conducting a periodic review?Numeric Response1500f4*****LAf540%f64-0C+&7< Prev.門fgKAA*85 of 5DIIhpf10DDI9NextfiWf12.insertprt sc+11(←deletebackspacehomenumlockend1:24 PM11/15/2022pg up question #4Same problem statement:Weekly demand for DVD-Rs at a retailer is normally distributed with a mean of 1,000 boxes and a standard deviation of 150. Currently, the store places orders to the supplier,with a reorder point of 4,200 boxes. The order quantity to the supplier is fixed at 5,000 boxes. Replenishment lead time is 4 weeks, fixed order cost per order is $100, each boxcosts the retailer $10, and the inventory holding cost is 25% per year. Assume 50 weeks in a year.Given the problem parameters, what is the optimal order quantity the retailer should order?Numeric Response2040f4f5f604-f74+< PrevPfgfg94 of 5hpf10Next >MODDIf11Wf12.insertprt scdeletehome4x Dend1:25 PM11/15/2022pg u

Answered: Image /qna-images/answer/9d20b0e7-78f3-40b2-a4ff-12f3323579d0.jpg

Answered: at a retailer is normally distributed…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

03) Halifax Souvenir Company currently orders 500 units four times each year. Each order costs $12 and each unit costs $1.20 per year to carry. On average, it takes 5 days to receive an order from the supplier. The company operates 250 days per year. Required: 1. What is the EOQ? 2. Calculate total annual inventory cost under EOQ. 3. What is the current inventory cost? 4. What is the re-order point?
Economic Order QuantityA pipe manufacturer requires a chemical for making plastic at the rate of 6000gallons per year. The cost of keeping the chemical storage is $10 per gallon peryear. Ordering costs are $200 per order. The chemical is bought at $45 pergallon.What is the EOQ and the Annual Total Cost?
Use ABC analysis to determine the items deserving mostattention and tightest inventory control
A. Ltd buys 400 units of an item at a purchase cost Sh.5000 per unit and ordering cost of Sh.2,000 per order placed. The carrying cost is estimated at 24% of cost of an item p.a. The Co. has received a 2% discount offer for purchases of 100 or more units. Required: a) Determine the best inventory policy for this item. b) Determine the discount level at which the firm will be indifferent between taking and not taking the discount offer.
K William Beville's computer training school, in Richmond, stocks workbooks with the following characteristics: Demand D 19,400 units/year Ordering cost S $27/order Holding cost H $5/unit/year a) The EOQ for the workbooks is 458 (round your response to the nearest whole number) b) What are the annual holding costs for the workbooks? $ (round your response to the nearest whole number).
XYZ Pharmaceuticals sells COVID testing kits. Calculate the Economic Order Quantity, or EOQ, if annual demand is 20,000 testing kits, inventory storage costs average 20 percent, the unit price per kit is $50, and ordering costs are $25.
Discuss what is meant by ABC analysis of inventory.Name several measures that can determine ABCstatus
A company has been approached by their supplier who would be willing to offer a discount of 5% on orders over 500 units. Information regarding current inventory costs is as follows: Holding cost per unit per annum 10% of purchase price Ordering costs = $2 per order Annual demand = 15,000 units Purchase price 200 units Identify which option is better for the company. $15 per unit Current EOQ quantity = = =
K Cesar Rego Computers, a Mississippi chain of computer hardware and software retail outlets, supplies both educational and commercial customers with memory and storage devices. It currently faces the following ordering decision relating to purchases of disks: D S I Purchase price Discount price Quantity needed to qualify for the discount = 5,900 disks. What is the EOQ? 36,100 disks $25 22% $0.87 $0.81 EOQ = units (round your response to the nearest whole number). ncorrect
Regional Supermarket is open 360 days per year. Daily use of cash register tape averages 10 rolls. Usage appears normally distributed with a standard deviation of 2 rolls per day. The cost of order-ing tape is $1, and carrying costs are 40 cents per roll a year. Lead time is three days. a. What is the EOQ?b. What ROP will provide a lead time service level of 96 percent?
The Allianz Company produces a specialty wood furniture product, and has the following information available concerning its inventory items: Relevant ordering costs per purchase $550 order Relevant carrying costs per year for each package: Required annual return on investment Required other costs per year 17% $7 Annual demand is 30,000 packages per year. The purchase price per package is $53. Which of the following statements is true of Allianz's EOQ system costs? O At EOQ, the annual relevant ordering costs is exactly the half of annual relevant carrying costs. O At EOQ, the annual relevant carrying costs is exactly the half of the annual relevant total costs. O At EOQ, the annual relevant carrying costs is higher than the annual relevant ordering costs. O At EOQ, the annual relevant carrying costs is equal to the annual relevant total costs.
6. Wang Distributors has an annual demand for an airport metal detector of 1,000 units. The cost of a typical detector to Wang is $50. Carrying cost is estimated to be 25% of the unit cost, and the ordering cost is $40 per order. If Ping Wang, the owner, orders in quantities of 200 or more, he can get a 3% discount on the cost of the detectors. Should Wang take the quantity discount?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

at a retailer is normally distributed with a mean of 1,000 ba O boxes. The order quantity to the supplier is fixed at 5,000- he inventory holding cost is 25% per year. antity of 5,000 boxes and current reorder point of 4,200 boz ory to order when conducting a periodic review?