Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

5. Q'Well, located in Guelph, is a large online retailer of refillable water bottles. Q'Well operates 300 days a year and sells an average of

image text in transcribed
image text in transcribed
5. Q'Well, located in Guelph, is a large online retailer of refillable water bottles. Q'Well operates 300 days a year and sells an average of 280 one litre water bottles a day. They order bottles from a manufacturer in China. After ordering, bottles are always shipped within exactly 18 days. Annual holding costs per bottle are estimated to be 15% of the cost of bottles. The ordering cost is $100 per order. The cost of a one litre bottle is $4. a. What is the economic order quantity (EOQ) for Q'Well? What is the average inventory? What is the expected total number of orders per year? b. What are the total annual holding costs of the stock for Q'Well? What are the total annual ordering costs? Using an appropriately labelled diagram, graph setup cost, holding cost, and total inventory cost, and show the optimal economic order quantity (EOQ) and the minimum total inventory cost. c. If Q'Well orders in quantities of 6,000 or more, it can get a $0.20 discount per bottle. Should Q'Well take the quantity discount? How much should Q 'Well order? d. Now assume that the demand for the water bottles is normally distributed with a variance of 25 bottles per day, and lead time is assumed to be normally distributed with a variance of 4 days (instead of the fixed numbers given above). Assume that management has specified that no more than a 5% risk of a stockout is acceptable. What is the standard deviation of demand during lead time? What is the safety stock needed to attain a 5% risk of stockout during lead time? What is the demand during lead time? What should bee the reorder point? What is the annual holding cost of maintaining the level of safety stock neeued to support a 5% risk of a stockout

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

Scheduling In Industry 4.0 And Cloud Manufacturing

Authors: Boris Sokolov, Dmitry Ivanov, Alexandre Dolgui

1st Edition

3030431762, 9783030431761

More Books

Students also viewed these General Management questions

Question

What was the name of the pi pilgrims ship ?

Answered: 1 week ago

Question

First U.S.Dollar printed?

Answered: 1 week ago

Question

Who was the confederate president during the civil war ?

Answered: 1 week ago

Question

The emancipation proclamation issued?

Answered: 1 week ago

Question

What war was declared by James Madison ?

Answered: 1 week ago