Question

Thomas Kratzer is the purchasing manager for the headquarters of a large insurance company chain with...

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 5,950 units per year. The cost of each unit is $104, and the inventory carrying cost is $11 per unit per year. The average ordering cost is $29 per order. It takes about 5 days for an order to arrive, and the demand for 1 week is 119 units. (This is a corporate operation, and the 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 inventory?
F) What is the total annual inventory cost, including cost of the 6,000 units?

Homework Answers

Answer #1

Annual demand (D) = 5950 units

Ordering cost (S) = $29 per order

Carrying cost (H) = $11

Number of days per year = 250 days

A) Economic order quantity (Q) = sqrt of (2DS / H)

= sqrt of [(2 x 5950 x 29)/11]

= 177 units

B) Average inventory = Q/2 = 177/2 = 88.5

C) Number of orders per year = D/Q = 5950/177 = 33.62

D)Time between orders = (Q/D) number of days per year

= (177/5950)250

= 7.44 days

E) Annual ordering cost = (D/Q) S = (5950/177)29 = $974.86

Annual holding cost = (Q/2)H = (177/2)11 = $973.5

Annual cost of ordering and holding inventory = $974.86+$973.5 = $1948.36

F) Cost of the 6000 units = 6000 x cost per unit = 6000 x $104 = $624000

Total annual inventory cost = Ordering cost + Holding cost + product cost = $974.86+$973.5+$624000 = $625948.36

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
a company decides to establish an EOQ for an item. The annual demand is 200,000 units....
a company decides to establish an EOQ for an item. The annual demand is 200,000 units. The ordering costs are $40 per order, and inventory-carrying costs are $2 per unit per year. Calculate the following: A. The EOQ in units. B. Number of orders per year. C. Annual ordering cost, annual holding cost, and annual total cost.
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...
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...
Michigan State Figurine Inc. (MSF) sells crystal figurines to Spartan fans. MSF buys the figurines from...
Michigan State Figurine Inc. (MSF) sells crystal figurines to Spartan fans. MSF buys the figurines from a manufacturer for $15 per unit. They send orders electronically to the manufacturer, costing $26 per order and they experience an average lead time of six days for each order to arrive from the manufacturer. Their inventory carrying cost is 20 percent. The average daily demand for the figurines is four units per day. They are open for business 250 days a year. The...
16) For supply item ABC, Andrews Company has been ordering 125 units based on the recommendation...
16) For supply item ABC, Andrews Company has been ordering 125 units based on the recommendation of the salesperson who calls on the company monthly. A new purchasing agent has been hired by the company who wants to start using the economic-order-quantity method and its supporting decision elements. She has gathered the following information: Annual demand in units 250 Days used per year 250 Lead time, in days 10 Ordering costs $100 Annual unit carrying costs $20 Required: Determine the...
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...
1. A supermarket stocks Hostess Cakes. The demand for these cakes is 6,000 boxes per year...
1. A supermarket stocks Hostess Cakes. The demand for these cakes is 6,000 boxes per year (365 days). It costs the store $100 per order, and $0.75 per box per year to keep the cakes in stock. Lead time is 4 days. Determine the following: a) The EOQ. b) The average inventory c) The optimal number of orders per year. d) The annual cost of ordering and holding inventory.
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...
The office manager for the Gotham Life Insurance Company orders letterhead stationery from an office products...
The office manager for the Gotham Life Insurance Company orders letterhead stationery from an office products firm in boxes of 500 sheets. The company uses 6,500 boxes per year. Annual carrying costs are $3 per box, and ordering costs are $28. The following discount price schedule is provided by the office supply company: Order Quantity (in boxes) Price per Box 200-999 $16 1000-2999 14 3000-5999 13 6000+ 12 a. Determine the optimal order quantity and the total annual inventory cost....
The Western Jeans Company purchases denim from Cumberland Textile Mills. The Western Jeans Company uses 35,000...
The Western Jeans Company purchases denim from Cumberland Textile Mills. The Western Jeans Company uses 35,000 yards of denim per year to make jeans. The cost of ordering denim from the textile company is $500 per order. It costs Western $0.35 per yard annually to hold a yard of denim in inventory. Determine the optimal number of yards of denim the Western Jeans Company should order, the minimum total annual inventory cost, the optimal number of orders per year, and...