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

Related questions

Q: All Seasons Flower Shop uses 870 clay pots a month. The pots are purchased at $ 6 each. Annual…

A: In inventory management, determine the optimal quantity of goods that a company should order each…

Q: (EOQ model with lead times and integer multiple policy): Consider the EOQ model discussed in class…

A: Find the given details: Fixed ordering cost (K), holding rate cost per unit item per unit of time…

Q: William Beville's computer training school, in Richmond, stocks workbooks with the following…

A: The optimal quantity a business should acquire to reduce its inventory expenses, such as shortfall…

Q: William Beville's computer training school, in Richmond, stocks workbooks with the following…

A: The economic order quantity (EOQ) is a optimal order quantity where logistics costs, stock outs,…

Q: Store A purchases cases of fertilizer for its lawn-care business from a supplier who charges Store A…

A: Ordering cost : $30 Unit cost : $50 Annual demand : 2000 bags Holding cost : 30% EOQ : 20

Q: Rick Jerz is attempting to perform an inventory analysis on one of his most popular products. Annual…

A: From the above given information, Annual demand, d =5000 units Ordering cost, o =$30 Holding cost, h…

Q: Matthew Liotine's Dream Store sells water beds and assorted supplies. His best-selling bed has an…

A: EOQ FormulaWhere:D is the annual demand for the product.S is the ordering cost per order.H is the…

Q: Sam's Pet Hotel operates 52 weeks per year, 6 days per week, and uses a continuous review…

A: Find the given details below:

Q: Under which circumstances would you use single period/newsboy model for inventory management

A: Inventory is the term used to refer to the products that are available for sale and the raw…

Q: The Knight Company operates 365 days a year and uses 210 liners each day. Using a Continuous…

A: ANSWER IS AS BELOW:

Q: The shop sells 5,000 hats. If holding cost is 3$ and cost to place an order is 4. What will be…

A: The formula of calculating the Economic Order Quantity is

Q: 9.4 A florist carries an average inventory of $12,000 in cut flowers. The flowers require special…

A: A firm's numerous expenses for keeping goods on hand are known as carrying costs. Taxes, insurance,…

Q: One reason for authorizing purchases is to enable efficient inventory manager. A) True B) False

A: When purchases are subject to authorization, it ensures a structured and controlled approach to…

Q: O Question 28 A shop that makes candles offers a scented candle, which has a monthly demand of 360…

A: Economic Production Quantity is used in managing the level of inventory in the organization to…

Q: M. Cotteleer Electronics supplies microcomputer circuitry to a company that incorporates…

A: To minimize the costs, I will determine the optimal order quantity, Next, I will determine the…

Q: To minimize cost, how many units should be ordered each time an order is placed? (b) How many orders…

A: Economic order quantity is the number of goods or services that an organization should order from a…

Q: Explain INVENTORY PLANNING AND ACCURACY?

A: Inventory planning is the process that can be used by any organizations in order to determine the…

Q: Myer stores carries a specialty line of flavored syrups. One of the most popular of these is a…

A: given, Given Weekly demand d = 55 bottles Price = $9

Q: How many sheets should you order?

A: Service Level = 90% Annual Demand (D) = 3400 sheets Working Days (W) = 365 days Review Period (R) =…

Q: weekly demand for hamleys (a famous toy brand) at a toy store is normally disrtibuted with a…

Q: A constant amount is order when inventory reaches a preset level in which of these inventory…

A: The EOQ model accepts that the completed products are sold at consistent rate additional time. At…

Question

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?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Summarize given information:

VIEW

Step 2: Determine the solution:

VIEW

Solution

VIEW

Step by step

Solved in 3 steps with 10 images

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

Can you answer E, F & G

Solution

by Bartleby Expert

SEE SOLUTION

Similar questions

12.8 Madeline Thimmes's Dream Store sells water beds and assorted supplies. Her best-selling bed has an annual demand of 400 units. Ordering cost is $40; holding cost is $5 per unit per year. a) To minimize the total cost, how many units should be ordered each time an order is placed? D
Question Two Calculate the Total annual cost D=1,500units Q*= 250 units S = $10 per order N = 5 orders per year H= $.50per unit per year T= 50 days. Question Three The following information is given to you D = 19,000 units/yr; H = $4/unit/year; S=$25/order. Calculate the EOQ, Annual holding cost and annual ordering cost. Question Four The following information is given to you, D = 200 units/yr; H = $4/unit/year; Q= 60. Calculate the annual setup cost.
ECUR UMIC ORDER QUANTITY CALCULATIONS (2 QUESTIONS) Company uses 800 units of a product per year on a continuous basis. The product year and order costs of $300 per order. It takes 30 days to receive a shipment after an order is placed and the a safety stock of 5 days usage in inventory. has carrying costs of $50 A. Calculate the economic order quantity a. 98 B. Determine the reorder a. 150 days (3 CASH DISCOUNTS point. ONS) (Assume (EOQ). a 360-day year.) per unit per firm requires
Experience suggests that usage of surgical gloves at a hospital can be approximated by a Normal distribution with a standard deviation of one-half box of surgical gloves per day and a mean of five boxes of surgical gloves per day.If ordering cost is $10 per order, annual holding cost is $10 per box, two days are required to fill an order surgical glove. a) Determine the economic order quantity, (250 workdays a year). b) If the hospital reorders when the surgical gloves on hand and on order is 12 boxes, calculate the risk of a stock-out during a lead time. c) What shortage risk does the hospital incur if it orders 36 boxes when the amount on hand is 12 boxes If a fixed interval of seven days, instead of the EOQ/ ROP model, is used for reordering
Franz Beckenbauer and Johan Cruyff are purchasing managers for the headquarters of a largesports marketing company chain with a central inventory operation. Their fastest-moving inventory item hasa daily demand of 35 units. The cost of each unit is £200, and the inventory carrying cost is £25 per unitper year. The average ordering cost is £60 per order. It takes about 5 days for an order to arrive, and thereare 252 working days per year. a) To minimize the cost, how many units should be ordered each time an order is placed?What is the total annual inventory cost, including the cost of the units?b) How can they manage the days it takes for an order to arrive? (How does it impact theiroperations and costs?)c) b) Even if there is substantial uncertainty in the parameters in the EOQ-model, it is still quite auseful model. Discuss why.
Sam's Pet Hotel operates 52 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $13.00 per bag. The following information is available about these bags: ≻Demand=75 bags/week ≻Order cost=$55.00/order ≻Annual holding cost=25 percent of cost ≻Desired cycle-service level=80 percent ≻Lead time=4 weeks (24 working days) ≻Standard deviation of weekly demand=15 bags ≻Current on-hand inventory is 320 bags, with no open orders or backorders. Part 2 a. Suppose that the weekly demand forecast of 75 bags is incorrect and actual demand averages only 50 bags per week. How much higher will total costs be, owing to the distorted EOQ caused by this forecast error? The costs will be $enter your response here higher owing to the error in EOQ. (Enter your response rounded to two decimal places.) a. What is the EOQ? What would the average time between orders (in weeks)? b. What should R be? c. An inventory withdraw…
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. d. The store currently uses a lot size of 490 bags (i.e., Q=490). What is the annual holding cost of this policy? (Enter your response rounded to two decimal places.) and (Enter your response rounded to two decimal places.) **select the correct multiple choice answer** e. What would be the annual cost saved by shifting from the 490-bag lot size to the EOQ? (Enter your responses rounded to two decimal places.)
Inventories are estimated more frequently under what inventory system? perpetual periodic wholesale net
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?
Need in Detail (No AI)
Discuss how inventory expenses must be balanced and kept to q minimum through inventory control