Question

Inventory Control

a. A department store in the town of Napar sells cell a popular brand of cell phones to customers in the area. This cell phone is fairly durable and it has lots of features. The demand for this phone is normally distributed with a mean of 50 cell phones per day and a standard deviation of 10 phones. The store operates 350 days per year. Ordering cost is $300 per order and the holding cost is 5% of the cost of the phone. The store sells the phone for $800. The lead time is 4 days and the store would like to have a 95% cycle time which is equivalent to 2 standard deviations. Current on-hand inventory is 200 cell phones with no open orders or back orders.

Calculate the EOQ? [3 marks]

ii. Calculate the number of order placed per year? [2 marks]

iii. Calculate the average time between orders? [2 marks]

iv. Calculate the ROP? [4 marks]

v. An inventory withdrawal of 200 units was just made. - Is it time to reorder? [2 marks]

vi. Calculate the total annual cost of using the EOQ. [2 marks]

Answer #1

Demand, d = 50 per day

Std dev of demand, s = 10 per day

Operating days per year, n = 350

Annual demand, D = n*d = 350*50 = 17,500

Ordering cost, S = $ 300 per order

Holding cost, H = Unit cost * Holding cost rate = 800*5% = $ 40
*(considering holding cost rate is 5% per
year)*

Lead time, L = 4 days

z value = 2 *(for 95% service level)*

--------------------------------------------

i)

EOQ = sqrt(2DS/H)

= sqrt(2*17500*300/40)

= **512**

--------------------------------------------

ii)

Number of orders placed per year = D/Q

= 17500/512

= **34** *(rounded-off)*

--------------------------------------------

iii)

Average time between orders = Q/d

= 512/50

= **10.24** days

--------------------------------------------

iv)

ROP = d*L+z*s*sqrt(L)

= 50*4+2*10*sqrt(4)

= **240**

--------------------------------------------

v)

Current inventory position = Current on hand inventory + open orders - backorders - withdrawals

= 200 + 0 - 0 - 200

= 0

Current inventory position is less than ROP.

Therefore, it is time to order.

--------------------------------------------

vi)

Total annual cost of using the EOQ = Holding cost + Ordering cost

= H*Q/2 + S*D/Q

= 40*512/2+300*17500/512

= $ **20,494**

The manager of a company is facing an inventory
problem with regard to an item whose demand is known to be evenly
distributed with an annual value of
8,000 units. The cost of placing an order is Rs 50 while the annual
carrying cost of one unit in inventory is Rs 5. Further it is known
that the lead time is uniform and equals 8 working days and that
the total working days in a year is 320 days.
Using...

1. A hardware store sells paint that has a demand of 10,568
gallons per year. The store purchases the paint from a supplier for
15.0 dollars per gallon The unit holding cost per year is 19
percent of the unit purchase cost. while the ordering cost is 134
dollars per order. The paint supplier has a lead time of 8 days.
What is the annual holding cost if the store uses the order
quantity of 1,147 gallons per order? Assume...

Ross White’s machine shop uses 2,500 brackets during the course
of a year, and this usage is relatively constant throughout the
year. These brackets are purchased from a supplier 100 miles away
for $15 each, and the lead time is 2 days. The holding cost per
bracket per year is $1.50 (or 10% of the unit cost) and the
ordering cost per order is $18.75. There are 250 working days per
year.
(a) What is the EOQ?
(b) Given the...

Antonio White’s machine shop uses 3,500 brackets during the
course of a year. These brackets are purchased from a supplier 80
miles away. The following information is known about the
brackets:
Annual demand:
3,500
Holding cost per bracket per year:
$1.45
Order cost per order:
$15.50
Lead time:
2 days
Working days per year
260
Given the above information, what would be the economic order
quantity (EOQ)?
Given the EOQ, what would be the average inventory? What would
be the...

Mama Leone's Frozen Pizzas uses 59,000 pounds of cheese per
year. Each pound costs $5.50. The ordering cost for the cheese is
$657.90 per order, and its carrying cost is $1.29 per pound per
year. Calculate the firm's economic order quantity (EOQ) for the
cheese. Mama Leone's operates 260 days per year and maintains a
minimum inventory level of 55 days' worth of cheese. Assuming that
the lead time to receive orders of cheese is 33 days, calculate the
reorder...

Mama Leone's Frozen Pizzas uses 41,000 pounds of cheese per
year. Each pound costs $5.50. The ordering cost for the cheese is
$1357.30 per order, and its carrying cost is $2.77 per pound per
year. Calculate the firm's economic order quantity (EOQ) for the
cheese. Mama Leone's operates 220 days per year and maintains a
minimum inventory level of 4 days' worth of cheese. Assuming that
the lead time to receive orders of cheese is 3 days, calculate the
reorder...

Question 1
Khalil is the owner and manager of a hardware store.
He sells on average 50 industrial hammers per month. He places an
order to buy 50 hammers from a wholesaler at a cost of 20 OMR per
unit at the end of each month. However, Khalil orders everything
himself and finds that it takes a long time. He estimates that the
value of his time spent placing each order is 75 OMR. a. What
should be the unit...

Need answers ASAP!!!!!! Joe Henry's machine shop uses 2 comma
550 brackets during the course of a year. These brackets are
purchased from a supplier 90 miles away. The following information
is known about the brackets: Annual demand 2 comma 550 Holding
cost per bracket per year $ 1.60 Order cost per order $ 18.75 Lead
time 2 days Working days per year 250 a) What is the EOQ? units
(round your response to two decimal places). b) What is...

Solve in ExcelQM
Barbara Bright is the purchasing agent for West Valve Company.
West Valve sells industrial valves and fluid control devices. One
of the most popular valves is the Western, which has an annual
demand of 4,000 units. The cost of each valve is $90, and the
inventory carrying cost is estimated to be 10% of the cost of each
valve. Barbara has made a study of the costs involved in placing an
order for any of the valves...

OM 540: Supply Chain Management
Assignment 6: Inventory and Risk Pooling
Question #1
Harley-Davidson has its engine
assembly plant in Milwaukee, and its motorcycle assembly
plant in York, Pennsylvania. Engines are transported between the
two plants using trucks, with each trip costing
$1,600. The motorcycle plant assembles and sells 100
motorcycles each day. (Assume 300 workdays in a
year.) Each engine costs $600, and Harley incurs a
holding cost of 25 percent per year.
How many engines should Harley load onto...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 26 minutes ago

asked 28 minutes ago

asked 30 minutes ago

asked 34 minutes ago

asked 46 minutes ago

asked 56 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago