Question

. Total Wine is planning to open a megastore in a suburban town. There are currently 6 small stores selling 1.5L bottles of wine. Each store experiences identical supply/demand behavior: Mean demand of 54 bottles/week. The standard deviation of the demand 13 bottles/week is given to you The supply lead time is 4.2 weeks, and the target service level is 90%. () What is the safety stock for each of the small stores? Answer Check i. What is the Big-Box safety stock advantage of Total Wine? Answer: Check

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer i:

  • 43.69299

Explanation:

  • Z value for 90% CI = 1.64
  • Weekly demand = D = 54
  • Standard deviation per store =S.D. = 13 bottles/week
  • Lead time = LT = 4.2 weeks
  • Safety stock for each = Z * S.D. * (LT)1/2 = 1.64*13*(4.2)1/2= 43.69299

Answer ii:

  • 155.1839

Explanation:

  • Z value for 99% CI = 1.64
  • Weekly demand of big box = D*6 = 324
  • Standard deviation for big box =S.D. * (6)^0.5 = 31.843366bottles/week
  • Lead time = LT = 4.2 weeks
  • Safety stock for each = Z * S.D. * (LT)1/2 = 1.64*13*(4.2)1/2= 107.0255
  • Total safety stock in 6 small stores = 43.6999*6 = 262.1994
  • Advantage of big box = 262.1994 -107.0255 = 155.1739
Add a comment
Know the answer?
Add Answer to:
. Total Wine is planning to open a megastore in a suburban town. There are currently...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the inventory of...

    Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the inventory of all the paint located at each of their 15 stores and their distribution warehouse. The Paint Supply Store franchise sells an average of 64 gallons of Green Paint every week (for 52 weeks per year). They purchase Green Paint from their supplier at a price of $3.50 per gallon. [The company does not hold Safety Stock] It takes 2.25 weeks to receive an order...

  • can you show how to do this work Question 13 Using a computerized Inventory Management System,...

    can you show how to do this work Question 13 Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the inventory of all the paint located at each of their 15 stores X and their distribution warehouse. The Paint Supply Store franchise sells an average of 74 gallons of Purple Paint every week (for 52 weeks per year, Standard Deviation of the Demand - 8 gallons). They purchase Purple Paint from their supplier at a price...

  • 1. Consider the market for dried beans in a small town of 9,000 consumers. Let each...

    1. Consider the market for dried beans in a small town of 9,000 consumers. Let each consumer's preferences over beans (B, in pounds and other goods (G) be given by U(B,G) = 12BŽ +G For the rest of this question, fix the price of other goods at PG = 1 and let each consumer have a total weekly budget of I = 100. (a) Write the budget constraint for a consumer in terms of the price of beans, PB, and...

  • Case Study: Heinkel-Fishbein, Inc. Heinkel-Fishbein is a large importer and distributor of robotic toys. The toys...

    Case Study: Heinkel-Fishbein, Inc. Heinkel-Fishbein is a large importer and distributor of robotic toys. The toys are stored in the warehouse and are shipped to a several large retail chains at a standard price.. There is almost no possibility in the near future of changing the prices at which Heinkel-Fishbein supplies the retail stores. Thus there is a need to increase profits by managing total costs. Considering one toy, identified as SKU 2600, the process consists of receiving the boxes...

  • OPS Practice quiz 2. The benefits of risk pooling depend on the behavior of demand from...

    OPS Practice quiz 2. The benefits of risk pooling depend on the behavior of demand from one market relative to demand from another. True False 3. What is Supply Chain Management? A set of approaches utilized to efficiently integrate suppliers, manufacturers, warehouses and stores so that merchandize is produced, distributed at the right quantities, to the right locations and at the right time in order to minimize system wide costs while satisfying service level requirements. The management of the flow...

  • can someone help me figure out where to input the numbers on the excel sheet to...

    can someone help me figure out where to input the numbers on the excel sheet to figure out the carrying cost for question 1 and 2. * Question Completion Status: QUESTION 1 SCENARIO A Acme retail inc. wants to import shampoo from Brazil. The daily demand at Acme stores for shampoo is 1800 bottles per day with a standard deviation of 550. Acme is considering two suppliers to source from. Option 1) Amazon Products Inc. will charge $5 per bottle,...

  • CASE Parts Emporium Parts Emporium, Inc., is a wholesale distributor of automobile parts formed is on...

    CASE Parts Emporium Parts Emporium, Inc., is a wholesale distributor of automobile parts formed is on hand, the firm's customer service is inadequate. Parts Emporium tries to by two disenchanted auto mechanics, Dan Block and Ed Spriggs. Originally backorder the customer orders not immediately filled from stock, but some 10 located in Block's garage, the firm showed slow but steady growth for percent of demand is being lost to competing distributorships. Because stock 7 years before it relocated to an...

  • C++ Lists, and a little queuing theory The MegaMicroMart (a subsidiary of Fly-By-Night Industries) is planning...

    C++ Lists, and a little queuing theory The MegaMicroMart (a subsidiary of Fly-By-Night Industries) is planning their next Big Small-Box Store. They want to ensure good customer service, and you've been hired to do some simulations to advise them on how to set up their checkout lines. This is a discrete-time simulation. This means that for our purposes, time advances in discrete 'ticks'. Each tick, everyone who's going to arrive arrives all at once, while at the same time everyone...

  • please read instructions on the first picture and follow it Discussion Board: Chapter 1 Due: Jun...

    please read instructions on the first picture and follow it Discussion Board: Chapter 1 Due: Jun 28, 2019 at 11:59 PM Please read the article titled Evolution of Operations Planning and Control: from production to supply chains In at least three paragraphs, describe how and why the focus of operations planning and control has changed over time. While one might argue that answers consisting of sentences quoted from articles do not represent plagiarism, I do not consider them acceptable, and...

  • please read instructions on the first picture and follow it Discussion Board: Chapter 1 Due: Jun...

    please read instructions on the first picture and follow it Discussion Board: Chapter 1 Due: Jun 28, 2019 at 11:59 PM Please read the article titled Evolution of Operations Planning and Control: from production to supply chains In at least three paragraphs, describe how and why the focus of operations planning and control has changed over time. While one might argue that answers consisting of sentences quoted from articles do not represent plagiarism, I do not consider them acceptable, and...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT