Question

In: Operations Management

Your firm uses a continuous review system and operates 52 weeks per year. One of the...

Your firm uses a continuous review system and operates 52 weeks per year. One of the SKUs has the following characteristics. Refer to the Z values.

>Demand (D) = 20,600units / (year)

>Ordering cost (S) = $45.00/order

>Holding cost (H)=$3.00/unit/year

> Lead (L) = 1 weeks

>Cycle-service |evel=96%

>Demand is normally distributed, with a standard deviation of weekly demand of 103 units.

>Current on-hand inventory is 1,040 units, with no scheduled receipts and no backorders.

The item's economic order quantity is ___ units.

The average time between orders is ___ weeks

To provide a 96 percent cycle-service level the safety stock for this item is _____ units.

To provide a 96 percent cycle-service level, the reorder point for this item is ______.

For these policies the annual cost of holding the cycle inventory is _______ and annual cost of placing orders is______.

Solutions

Expert Solution

(A)

Annual demand (D) = 20,600 units

Ordering cost per order (S) = $ 45

Annual Holding cost per unit (H) = $ 3

EOQ = 786.13 units

EOQ = 786 Units (rounded off to nearest whole number)

EOQ = 786 units

(B)

Given number of weeks = 52

Average time between orders = (Q/D) × Number of weeks

Average time between ordere = (786/20,600) × 52

Average time between orders = 1.98 weeks (rounded off to 2 decimals)

(C)

Given Standard Deviation () = 103 units

Lead time (L) = 1 week

Service level = 96%

Value of Z corresponding to service level of 96% = 1.75

Safety Stock = 1.75 × 103 × 1

Safety Stock = 180.25 units

Safety Stock = 180 (rounded off to nearest whole number)

Safety Stock = 180 units

(C)

Annual demand (D) = 20,600

Number of weeks = 52

Daily demand (d) = 20,600/52

Daily demand (d) = 396.154 units

Re-Order Point = (d × L) + Safety Stock

Re-Order Point = (396.154 × 1) + 180

Re-Order Point = 576.154 units

Re-Order Point = 576 units (rounded off to next whole number)

Re-Order Point = 576 units

(D)

Annual Holding cost = (Q/2) × H

Annual Holding cost = (786/2) × 3

Annual Holding cost = $ 1,179

Annual cost of placing order = (D/Q) × S

Annual cost of placing order = (20,600/786) × 45

Annual cost of placing order = $ 1,179.389

Annual cost of placing order = $ 1,179.39 (rounded off to 2 decimals)


Related Solutions

Your firm uses a continuous review system and operates 52 weeks per year. One of the...
Your firm uses a continuous review system and operates 52 weeks per year. One of the SKUs has the following characteristics. Demand (D) = 20,000 units/year Ordering cost (S) = $40/order Holding cost (H) = $2/unit/year Lead time (L) = 2 weeks Cycle-service level = 95 percent Demand is normally distributed, with a standard deviation of weekly demand of 100 units. Current on-hand inventory is 1,040 units, with no scheduled receipts and no backorders. a. Calculate the item’s EOQ. What...
Sam's Cat Hotel operates 52 weeks per? year, 5 days per? week, and uses a continuous...
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.50 per bag. The following information is available about these bags. Refer to the standard normal table LOADING... for? z-values. Demand ?= 80 ?bags/week Order cost? = ?$58?/order Annual holding cost? = 30 percent of cost Desired ?cycle-service levelequals90 percent Lead time? = 2 ?week(s) ?(10 working? days) Standard deviation of weekly demand? = 16 bags...
Sam's Cat Hotel operates 5252 weeks per? year, 77 days per? week, and uses a continuous...
Sam's Cat Hotel operates 5252 weeks per? year, 77 days per? week, and uses a continuous review inventory system. It purchases kitty litter for ?$10.7510.75 per bag. The following information is available about these bags. Refer to the standard normal table LOADING... for? z-values. Demand = 100 bags/weeks Order cost = $56/order Annual Holding Cost = 30 percent of cost Desired cycle-service level =99 percent Lead time = 2 weeks (14 working days) Standard deviation of weekly demand = 10...
Problem 13: Sam's Cat Hotel operates 52 weeks per year, 6 days per week, and uses...
Problem 13: Sam's Cat Hotel operates 52 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $11.70 per bag. The following information is available about these bags. Demand = 90 bags/week Order Cost= $54/0rder Annual Holding cost = 27% of cost Desired cycle-service level = 80% Lead time = 3 weeks (18 working days) Standard deviation of weekly demand = 15 bags Current on-hand inventory is 320 bags, with no...
Sam's Cat Hotel operates 52 weeks per year, 7 days per week
Sam's Cat Hotel operates 52 weeks per year, 7 days per week, and uses a continuous review inventory system. It purchases kitty litter for $10.75 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 $56/order >Annual holding cost = 30 percent of cost >Desired cycle-service level = 99 percent >Lead time = 4 week(s) (28 working days) >Standard deviation of weekly demand = 20 bags >Current on-hand inventory is 325 bags, with no...
Problem 1:    An ophthalmologist’s office operates 52 weeks per year. It purchases disposable contact lenses...
Problem 1:    An ophthalmologist’s office operates 52 weeks per year. It purchases disposable contact lenses for $11.70 per pair. The following information is available about these lenses. Demand = 90 pairs/week Order cost = $54/order Annual holding cost = 27% of purchasing cost Desired cycle-service level = 80% Lead time = 3 weeks Standard deviation of weekly demand = 15 pairs Current on-hand inventory is 320 pairs, with no open orders or backorders. Part I   Currently, the company uses...
1: A museum of natural history opened a gifl shop which operates 52 weeks per year....
1: A museum of natural history opened a gifl shop which operates 52 weeks per year. managing invertories has become a problem.Top-selling SKU is a bird feeder. sale are 18 uits per week, the supplier charges $60 per unit. Ordering cost is $45. annual holding cost 25 percernt of a feeder's value. management chose a 390-unit lot size what is the annual cycle-inventory cost of the current policy of using a 390-unit lot size? would a lot size of 468...
​The Discount Appliance Store uses a continuous review system (Q system).
The Discount Appliance Store uses a continuous review system (Q system).One of the company's items has the following characteristics:- Demand =10 units/week (assume 52 weeks per year)- Ordering or Setup Cost (S)=$ 45) order- Holding cost (H)=$12 unit/year- Lead Time (L)=3 weeks (constant)- Standard Deviation in Weekly Demand = 8 units- Cycle-Service Level =70%What is the EOQ for this item?What is the desired safety stock?What is the desired reorder point R?What is the total annual cost?Suppose that the current policy...
A company orders every 8 weeks. 52 weeks/8 weeks per order = 6.5 orders per year....
A company orders every 8 weeks. 52 weeks/8 weeks per order = 6.5 orders per year. Explain the non-integer value for number of orders per year.
for a firm that assumes 52 weeks a year, every 6 years there will be extra...
for a firm that assumes 52 weeks a year, every 6 years there will be extra days that accumulates 53 weeks in a year. which one of the following financial statement does this uneven number of week in a year affect the least a. balmace sheet b. income statement c. other compreohensive imcome statement
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT