Inventory Management Ch 12 12.40 Uriel A gourmet coffee shop in downtown San Francisco is open 200 days a year and sells an average of 75 pounds of Kona coffee beans a day. (Demand can be assumed to be distributed normally, with a standard deviation of 15 pounds per day.) After ordering (Fixed cost-$16 per order), beans are always shipped from Hawaii within exactly four days. Per-pound annual holding costs for the beans are $3. a) What is the EOQ for Kona Coffee Beans? b) What are the total annual hoding costs of stock for Kona coffee beans? c) What are the total annual ordering costs for Kona coffee beans? d) Assume the management has specified that no more than a 1% risk during stockout is acceptable. What should the reorder point be? e) What is the safety stock needed to attain a 1% risk of stockout during lead time? f) What is the annual holding cost of maintaining the level of safety stock needed to support a 1% risk? g) If management specified that a 2% risk of stockout during lead time is acceptable, would the safety stock holding costs decrease or increase?

Inventory Management Ch 12 12.40 Uriel A gourmet coffee shop in downtown San Francisco is open 200 days a year and sells an average of 75 pounds of Kona coffee beans a day. (Demand can be assumed to be distributed normally, with a standard deviation of 15 pounds per day.) After ordering (Fixed cost-$16 per order), beans are always shipped from Hawaii within exactly four days. Per-pound annual holding costs for the beans are $3. a) What is the EOQ for Kona Coffee Beans? b) What are the total annual hoding costs of stock for Kona coffee beans? c) What are the total annual ordering costs for Kona coffee beans? d) Assume the management has specified that no more than a 1% risk during stockout is acceptable. What should the reorder point be? e) What is the safety stock needed to attain a 1% risk of stockout during lead time? f) What is the annual holding cost of maintaining the level of safety stock needed to support a 1% risk? g) If management specified that a 2% risk of stockout during lead time is acceptable, would the safety stock holding costs decrease or increase?

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

Only typing answer needed
2. A bakery buys flour in 25-pound bags. The bakery uses 1,215 bags a year. Ordering cost is $10 per order. Annual carrying cost is $75 per bag: 2.1 determine the EOQ 2.2 What is the average number of bags on hand 2.3 How many orders per year will there be 2.4 Compute the total cost of ordering and carrying flour 2.5 If holding costs were to increase by $9 per year, how much would that affect the minimum total annual cost?
What are the Types of Inventory Control Systems ? Perpetual Inventory System When you use a perpetual inventory system, it continually updates inventory records and accounts for additions and subtractions when inventory items are received, sold from stock, moved from one location to another, picked from inventory, and scrapped. • Periodic Inventory System Periodic inventory systems do not track inventory on a daily basis Barcode Inventory Systems Inventory management systems using barcode technology are more accurate and efficient than those using manual processes. Radio Frequency Identification (RFID) Inventory Systems Radio frequency identification (RFID) inventory systems use active and passive technology to manage inventory movements.
Please do not give solution in image format thanku 3. SunValley 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 ordering 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 service level of 95 percent? c. What would be the ROP for the tape if the lead time has a standard deviation of 1 days?
What policy results in stockouts 10% of the time?
What are the disadvantages of abc inventory system
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?
7. Sam's Cat Hotel operates 52 weeks per year, 5 days per week, and uses a continuous review inventory system. It purchases kitty litter for $11.00 per bag. The following information is available about these bags. Refer to the standard normal table for z-values. ≻Demand = 95 bags/week ≻Order cost = $57/order ≻Annual holding cost = 30 percent of cost ≻Desired cycle-service level=98 percent ≻Lead time = 1 week(s) (5 working days) ≻Standard deviation of weekly demand = 20 bags ≻Current on-hand inventory is 350 bags, with no open orders or backorders. a. What is the EOQ? (Enter your response rounded to the nearest whole number.) and (Enter your response rounded to one decimal place.) b. What should R be? (Enter your response rounded to the nearest whole number.) c. An inventory withdrawal of 10 bags was just made. Is it time to reorder? (is or is not)
Exercise 4 Gentle Ben's Bar and Restaurant uses 5.000 quart bottles of an imported wine each year. me effervescent wine costs $3 per bottle and is served only in whole bottles because it loses its bubbles quickly. Ben figures that it costs $10 each time an order is placed, and holding costs are 20% of the purchase price. It takes three weeks for an order to arrive, Weekly demand is 100 bottles (closed two weeks per year) with a standard deviation of 30 bottles. Ben would like to use an inventory system that minimizes inventory cost and will provide a 95% service level. a) What is the economic quantity for Ben to order? b) At what inventory level should he place an order?
3
Help