Caring Hospital's dispensary reorders doses of a drug when the supply on hand falls to 18 units. Lead time for resupply is three days.Given the typical usage over the last 10 days, what service level is achieved with the hospital's reorder policy? (Hint. Use the followingformula.) (Do not round intermediate calculations. Round your "z" value and final answer to 2 decimal places.)Use Table.ROP =dLT +2 (od) √LTDayUnits132 344 7 5Service levelClick here for the Excel Data File55%66748394105

The following information is given to us: Based on this information we can calculate the value of…

Answered: Caring Hospital's dispensary reorders…

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

It is due today. Please I need help The images are how you are going to do it. For b, I thought the answer for the reorder point was 132, but it is false(not correct). I find a, but i need help with b. 1. 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 $10.50 per bag. The following information is available about these bags. Refer to the standard normal table for z-values. ≻Demand = 100 bags/week ≻Order cost = $58/order ≻Annual holding cost = 29 percent of cost ≻Desired cycle-service level=92 percent ≻Lead time = 1 week(s) (5 working days) ≻Standard deviation of weekly demand = 18 bags ≻Current on-hand inventory is 300 bags, with no open orders or backorders. a. What is the EOQ? Sam's optimal order quantity is 445 bags. (Enter your response rounded to the nearest whole number.) What would be the average time between orders (in weeks)? The average time between…
A store sells university coffee mugs. Daily demand is 25 mugs with a standard deviation of 4 mugs per day. Each mug costs $7.85. Ordering costs are $11. The carrying costs are $2 per year. The store is open 250 days per year. Lead time is 6 days with a standard deviation of 1.6 days. Desired service level is 98%. Calculate the EOQ (round your answer to the nearest whole number) 2. CAREFUL! YOUR NUMBERS HAVE CHANGED A store sells university logo hats. Daily demand is 22 hats with a standard deviation of 4 hats per day. Each hat costs $7.85. Ordering costs are $12. The carrying costs are $1 per year. The store is open 250 days per year. Lead time is 4 days with a standard deviation of 1.6 days. Desired service level is 98%. Calculate the ROP with safety stock.
Gentle Ben’s Bar and Restaurant uses 5,000-quart bottles of imported wine each year. The 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 percent 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 providea 95 percent service probability.a. What is the economic quantity for Ben to order?b. At what inventory level should he place an order?
Barbara Flynn is in charge of maintaining hospital supplies at General Hospital. During the past year, the mean lead time demand for bandage BX-5 was 60 (and was normally distributed). Furthermore, the standard deviation for BX-5 was 7. Ms. Flynn would like to maintain a 90% service level. Refer to the standard normal table for z-values. a) What safety stock level do you recommend for BX-5? Safety stock =units (round your response to the nearest whole number). b) What is the appropriate reorder point? Reorder Point =units (round your response to the nearest whole number).
Jill's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from two different suppliers. The parts are needed throughout the entire 52-week year. Tegdiws are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. Widgets are ordered from a supplier who stops by every three weeks. Data for both products are as follows: A. Find the total inventory costs if using inventory policy. This is a case considering safety stock (make sure to use the right formula)
Consider a periodic review system, where orders are placed every 20 days. The firm strives to provide a 94.41% cycle service level. Demand averages 415 units per day, and the standard deviation of demand per day is 105 units. Lead time is 12 days (round Z-values, standard deviations to two decimal places). Question content area bottom Part 1 a. How many units of safety stock should be held? enter your response here units (round your response to the nearest integer). b. What should the target inventory level (order-up-to level) be? enter your response here units (round your response to the nearest integer). c. Suppose that it is time to review the item. There are 152 units in inventory, and there is an outstanding backorder for 455 units. An order for 129 units is on the way. How many units should be ordered now? enter your response here units (round your response to the nearest integer).
As the Manager of Branson’s Department Store, you are responsible for ensuring that reorder quantities for the various items have been correctly established. You decide to test one item and choose product Z. A continuous review inventory policy has been used, so you examine this as well as other records and come up with the following data: Cost per unit $35 Holding cost 20 percent of unit cost Average daily demand 10 units Ordering cost $30 per order Standard deviation of daily demand 3 units Delivery lead time 4 days Because customers generally do not wait but go elsewhere, you decide on a service probability of 90 percent. Assume that Branson’s Department Store operates 320 days per year. [What is the annual demand (D)? Determine the optimal order quantity, Q*. Determine the reorder point (R) if demand is constant. Determine the reorder point (R) if demand is varies.
Operation mangement An online shoe retailer's annual cost of holding inventory is 30 percent. The firm operates with a days-of-supply of 23 days, and assume there are 365 days per year. What is the inventory holding cost (in $s) for a pair of shoes that the firm purchased for $53 ? Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
6. Leaky Pipe, a local retailer of plumbing supplies, faces demand for one of its SKUs at a constant rate of 17,000 units per year. It costs Leaky Pipe $5 to process an order to replenish stock and $2.00 per unit per year to carry the item in stock. Stock is received 12 working days after an order is placed. No backordering is allowed. Assume 365 working days a year. d. The demand during lead time is _____ units. (Enter your response rounded to the nearest whole number.) e. The reorder point is ______ units. (Enter your response rounded to the nearest whole number.) f. The inventory position immediately after an order has been placed is _____ units. (Enter your response rounded to the nearest whole number.)
A natural food store carries a brand of coffee called World’s Greatest Coffee. The following data should be used in your calculations. Demand/Sales = 10 cases of coffee per week (you will need to convert this to an annual amount) Ordering Cost = $12 per order Carrying Charge = 18% per year Unit Cost = $75 per case 1. What is the annual cost or ordering the coffee? What is the annual cost of carrying the coffee? And what is the total cost (ordering and carrying costs added together)?2. Name three reasons or factors that might cause the firm to order a larger or smaller amount than the EOQ.
During the last 5 weeks, demands for a certain SKU at a retailer were 7 units (5 weeks ago), 4 units, 4 units, 4 units, and 5 units (last week). The retailer uses a period review model with order-up-to level 71 units, a review period of 2 weeks, and the lead time is 11 weeks. It is time to order. How much should the retailer order?
___ model of inventory control involves placing an order when inventory levels reach re-order level a. Q b. P c. Fixed-time period d. ABC Analysis

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