Homework Help: Business

Posted by Jackson on Monday, September 20, 2010 at 8:19am.

Thomas Kratzer is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation. Thomas’s fastest moving inventory item has a demand of 6000 units per year. The cost of each unit is $100.00, and the inventory carrying cost is $10.00 per unit per year. The average ordering cost is $30.00 per order. It takes about 5 days for an order to arrive, and demand for 1 week is 120 units (this is a corporate operation, there are 250 working days per year).

a. What is the EOQ?
b. What is the average inventory if the EOQ is used?
c. What is the optimal number of orders per year?
d. What is the optimal number of days in between any two orders?
e. What is the annual cost of ordering and holding and holding inventory?
f. What is the total annual inventory cost, including cost of the 6,000 units?

Business - Gin, Wednesday, March 30, 2011 at 12:56pm
a. What is the EOQ? = 189.74 units
Step (1): Determine the Annual Set-up Cost
*Annual set-up cost = (# of orders placed per year) x (Setup or order cost per order)
= Annual Demand
# of units in each order ¡Á (Setup or order cost per order)
= (D/Q) ¡Á(S)
= (6000/Q) x (30)
Step (2): Annual holding cost = Average inventory level x Holding cost per unit per year
= (Order Quantity/2) (Holding cost per unit per year)
= (Q/2) ($10.00)

Step (3):
Optimal order quantity is found when annual setup cost equals annual holding cost:
(D/Q) x (S) = (Q/2) x (H)
(6,000/Q) x (30) = (Q/2) (10)
=(2)(6,000)(30) = Q2 (10)
Q2 = [(2 ¡Á6,000 ¡Á30)/($10)] = 36,000
Q = ¡Ì([(2 ¡Á6,000 ¡Á30)/(10)]) = ¡Ì36,000
Q = 189.736 ¡Ö 189.74 units
EOQ = 189.74 units

b. What is the average inventory if the EOQ is used?
Average inventory level = (Order Quantity/2)
= (189.74) /2 = 94.87
Average Inventory level =94.87 units

c. What is the optimal number of orders per year?
N= ( Demand/ order quantity) = (6000/ 189.736)=31.62
N = 31.62
The optimal number of orders per year = 31.62

d. What is the optimal number of days in between any two orders?
T = (Number of Working Days per year) / (optimal number of orders)
T = 250 days per year / 31.62 = 7.906
T= 7.91
The optimal number of days in between any two orders = 7.91

e. What is the annual cost of ordering and holding inventory?
(Q) x (H)
(189.736 units) x ($10) =$1,897.36
¡Ö $1,897

The annual cost of ordering and holding the inventory = $1,897

f. What is the total annual inventory cost, including cost of the 6,000 units?
TC = setup cost + holding cost
TC = (Dyear/Q) (S) + (Q/2) (H)
TC = (6,000/189.74) ($30.00) + (189.74/2) ($10.00)
TC = $948.67 + $948.7
TC = 1,897.37 ¡Ö $1,897
Purchase cost = (6,000 units) x ($100/unit) = $600,000
Total annual inventory cost = $600,000 + $1,897 = $601,897

Total annual inventory cost = $601,897

Answer this Question

Related Questions

accounting - Can someone please check my answer to this question: In recent ...
statistics - A business researcher wants to estimate the average number of years...
business - Returned $200 of the inventory that it had purchased because the ...
business and finance - The property of Al’s garage is worth $300,000. Al ...
Business Finance - The property of Al's garage is worth $300,000. Al has a ...
Business Finance - The property on Al's garage is worth $300,000. Al has a ...
business math - The property of Al’s garage is worth $300,000. Al has a ...
accounting - The monetary contributions that the owners of IBM pay for shares of...
Home insurance - Another term that means the same thing as "insurance ...
Career - What are the best ways to market a insurance and risk management ...

For Further Reading

First Name:
School Subject:
Answer: