Question

Lilibeth works as a purchasing officer in a hardware store. She has determined that the annual...

Lilibeth works as a purchasing officer in a hardware store. She has determined that the annual demand for number 8 tek screws is 150,000 screws. She estimates that it costs P500 every time an order is placed. This cost includes her salary, the cost of the forms used in placing the order, and so on. Furthermore, she estimates that the cost of carrying one screw in inventory for a year is P2.50. Assume that the demand is constant throughout the year.

a. How many number 8 tek screws should Lilibeth order at a time if she wishes to minimize total inventory cost?

b. How many orders per year should be placed? What would the annual ordering cost be?

c. What would the average inventory be? What would the annual holding cost be?

IN EXCEL  plsss>>>>>>>>>>>>>>>>>>

Homework Answers

Answer #1

Holding Cost = P2.50 = 2.50 per unit

(a) EOQ = Sqrt ((2 * Annual Demand * Ordering Cost) / (Holding Carrying))

= sqrt ((2 * 150,000 * 500) / (2.50)

= 7,746 units

7,746 number 8 screws should Lila order at a time if she wishes to minimize total inventory cost.

(b) Number of Order = Annual demand / EOQ

= 150,000 / 7,746 = 19.36~20

Total ordering Cost = $500 * 20 = $10000

(c) Average Inventory = 1/2 ( Order Quantity) = 0.5 * 7,746 = 3,873

Holding Cost = 2.50* 3,873= $9682.5

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

DEAR STUDENT,

IF YOU HAVE ANY QUERY ASK ME IN THE COMMENT BOX,I AM HERE TO HELPS YOU.PLEASE GIVE ME POSITIVE RATINGS

*****************THANK YOU***************

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
Lila Battle has determined that the annual demand for number 6 screws is 100,000 screws. Lila,...
Lila Battle has determined that the annual demand for number 6 screws is 100,000 screws. Lila, who works in her brother’s hardware store, is in charge of purchasing. She estimates that it costs $10 every time an order is placed. This cost includes her wages, the cost of the forms used in placing the or-der, and so on. Furthermore, she estimates that the cost of carrying one screw in inventory for a year is one-half of 1 cent. Assume that...
A hardware store obtains its bagged cement from a single supplier. Demand is reasonably constant throughout...
A hardware store obtains its bagged cement from a single supplier. Demand is reasonably constant throughout the year, and last year the company sold 1,000 bags of this product. The costs of placing an order is estimated at RM50 and the annual inventory holding cost of is 5% of purchase cost. The store purchases the cement at RM50 per bag. (a) Determine the optimum order size that the store should order at a time. (b) Calculate the total annual inventory...
. A store that sells healthy food has an annual demand for a specific item 810...
. A store that sells healthy food has an annual demand for a specific item 810 units. The cost of placing an order is $20, while holding cost per unit per year is $4. How many orders per year should they have What is the minimum total cost of inventory (ordering and holding)
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...
Inventory Management 1. Ayo is the Purchasing Officer for a company that assembles desktop computers. The...
Inventory Management 1. Ayo is the Purchasing Officer for a company that assembles desktop computers. The computers come with 4 to 6 USB ports. The annual demand for the computers is 600 units. The cost of each computer is $1700, and the inventory carrying cost is estimated to be 10% of the cost of each computer. Ayo has made a study of the costs involved in placing an order and has concluded that the average ordering cost is $50.00 per...
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...
Chris Froome is a purchasing agent for a firm that sells components for high-performance bicycles. One...
Chris Froome is a purchasing agent for a firm that sells components for high-performance bicycles. One of the most popular components is the TDF bicycle frame which has an annual demand of 1,750 units. The cost of each frame is $675 and the inventory carrying cost is estimated to be 18% of the cost of each frame. Chris has made a study of the costs involved in placing an order for any of the frames the firm stocks, and he...
Purinnerds Dog Food is a very popular product at Kay Gnetin’s corner grocery. Demand for this...
Purinnerds Dog Food is a very popular product at Kay Gnetin’s corner grocery. Demand for this is relatively constant, and the total demand for the year is 1,200 bags. The cost of placing an order is $50, while the holding cost is $3 per unit per year. The store is open 300 days per year. Lead-time for this is 8 days. Currently, Kay orders 50 time per year. If Kay places 50 orders per year, what would her annual total...
The annual demand of a good is 8000 ​units, the fixed cost of placing an order...
The annual demand of a good is 8000 ​units, the fixed cost of placing an order is ​$100 and the annual cost of storing an item is ​$70. The same​ order, Q, is placed at regular intervals throughout the​ year, and the firm waits for stock levels to reduce to zero before ordering new stock. ​(a) Obtain an​ expression, for the total ordering cost​ C, in terms of Q. ​(b) Work out how many items should be ordered each time...
The annual demand of a good is 10,000 ​units, the fixed cost of placing an order...
The annual demand of a good is 10,000 ​units, the fixed cost of placing an order is ​$90 and the annual cost of storing an item is ​$30. The same​ order, Q, is placed at regular intervals throughout the​ year, and the firm waits for stock levels to reduce to zero before ordering new stock. ​(a) Obtain an​ expression, for the total ordering cost​ C, in terms of Q. ​(b) Work out how many items should be ordered each time...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT