Question

Inventory Control a. A department store in the town of Napar sells cell a popular brand...

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]

Homework Answers

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

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
The manager of a company is facing an inventory problem with regard to an item whose...
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...
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...
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...
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...
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...
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...
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...
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...
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                               &
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
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT