Question

A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a...

A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of .98. The order interval is 14 days, and lead time is 3 days. Average demand for one item is 68 units per day, and the standard deviation of demand is 12 units per day. Given the on-hand inventory at the reorder time for each order cycle shown in the following table.

Use Table.


Cycle On Hand
1 46      
2 10      
3 99      


Determine the order quantities for cycles 1, 2, and 3: (Round your answers to the nearest whole number)


Cycle           Units
1   
2   
3   

Homework Answers

Answer #1

Given are following data :

Order interval = 14 days

Lead time = 3 days

Therefore, Protection period = P = Order interval + Lead time = 14 + 3 = 17 days

Required service level = 0.98

Corresponding Z value = NORMSINV ( 0.98 ) = 2.0537

Standard deviation of daily demand = 12 units

Therefore, standard deviation of demand during protection period

= Standard deviation of daily demand x square root ( Protection period )

= 12 x square root ( protection period )

= 12 X square root ( 17 )

= 12 x 4.123

= 49.476

Therefore, safety stock = Z value x standard deviation of demand during protection period = 2.0537 x 49.476 = 101.60 ( 102 rounded to nearest whole number )

Reorder point = Daily demand x Protection period + safety stock = 68 x 17 + 102 = 1156 + 102 = 1258

Order quantity = Reorder point – Quantity on hand

Accordingly, please find below required answers :

CYCLE

UNITS

1

1212

2

1248

3

1159

Know the answer?
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
Similar Questions
A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a...
A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of .98. The order interval is 10 days, and lead time is 3 days. Average demand for one item is 66 units per day, and the standard deviation of demand is 2 units per day. Given the on-hand inventory at the reorder time for each order cycle shown in the following table. Use Table. Cycle On Hand 1     46 2    14...
A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a...
A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of .95. The order interval is 14 days, and lead time is 2 days. Average demand for one item is 65 units per day, and the standard deviation of demand is 3 units per day. Given the on-hand inventory at the reorder time for each order cycle shown in the following table. Cycle On Hand 1 40 2 12 3 95 Determine...
Problem 14-3 (Algorithmic) The reorder point r = dm is defined as the lead-time demand for...
Problem 14-3 (Algorithmic) The reorder point r = dm is defined as the lead-time demand for an item. In cases of long lead times, the lead-time demand and thus the reorder point may exceed the economic order quantity Q*. In such cases, the inventory position will not equal the inventory on hand when an order is placed, and the reorder point may be expressed in terms of either the inventory position or the inventory on hand. Consider the economic order...
Consider an inventory system whereby an inventory replenishment order for Q units is placed whenever inventory...
Consider an inventory system whereby an inventory replenishment order for Q units is placed whenever inventory reaches ROP units. The lead time for the order is LT days and daily demand is d units. Beginning on-hand inventory at time=0 is OH units. Use these parameters: Q = 500; ROP = 1,200; LT = 9; d = 100; OH = beginning on-hand inventory = 1,400. and provide an answer for each of the following: Long-run average inventory on-hand (note – don't...
Consider an inventory system whereby an inventory replenishment order for Q units is placed whenever inventory...
Consider an inventory system whereby an inventory replenishment order for Q units is placed whenever inventory reaches ROP units. The lead time for the order is LT days and daily demand is d units. Beginning on-hand inventory at time=0 is OH units. Use these parameters: Q = 500; ROP = 1,200; LT = 9; d = 100; OH = beginning on-hand inventory = 1,400. and provide an answer for each of the following: Long-run average inventory on-hand (note – don't...
Q. Daily demand for a product is normally distributed with a mean M= 12 units and...
Q. Daily demand for a product is normally distributed with a mean M= 12 units and standard deviation Q= 4 units. Lead time is 9 days. The order quantity for this item is set at a 12-day supply. a. If a minimum probability of satisfying demand per cycle of 0.80 is desired, what is the reorder point? b. If a fill rate of 9% is desired, what is the reorder point?
Retailers Warehouse (RW) is an independent supplier of household items to department stores. RW attempts to...
Retailers Warehouse (RW) is an independent supplier of household items to department stores. RW attempts to stock enough items for a 90 percent service probability. A stainless steel knife set is one item it stocks. Demand (1,800 sets per year) is relatively stable over the entire year. Whenever new stock is ordered, a buyer must assure that numbers are correct for stock on hand and then phone in a new order. The total cost involved to place an order is...
Southeastern Bell stocks a certain switch connector at its central warehouse for supplying field service offices....
Southeastern Bell stocks a certain switch connector at its central warehouse for supplying field service offices. The yearly demand for these connectors is 16,000 units. Southeastern estimates its annual holding cost for this item to be $25 per unit. The cost to place and process an order from the supplier is $70. The company operates 300 days per year, and the lead time to receive an order from the supplier is 2 working days. a. Find the economic order quantity....
A company begins a review of ordering policies for a sample of items. The company operates...
A company begins a review of ordering policies for a sample of items. The company operates 52 weeks a year. The following are the characteristics of one item: Demand = 3,380 units/year Ordering cost = $50/order Holding cost = $13/unit/year Lead time = 3 weeks Standard deviation of weekly demand = 16 units Desired cycle service level = 98% a) Calculate EOQ and use it to find the order interval (OI). Round the number to the nearest integer week. Hint:...
A firm uses 200,000 units of an inventory item evenly throughout the year. The firm’s order...
A firm uses 200,000 units of an inventory item evenly throughout the year. The firm’s order cost is $400 per order and carrying cost is $40 per unit per year. (A) Suppose an order placed at the end of the day will arrive in time before the next day’s production begins and the firm does not keep a safety stock. How many units of this inventory item should the firm order each time? (B) Suppose it takes the supplier two...