Question

1.
**For product M, a firm has an annual holding cost that is
25% of the item cost, an ordering cost of $10 per order, and annual
demand of 1560 units. If ordering at least 85 units, the price per
unit is $16; if ordering at least 95 units, the price per unit is
$14.5. Lead time is 5 days. The firm operates 260
days.**

a) Determine the most cost-effective ordering quantity

b) What is the total cost for the order quantity determined in a).

c) Calculate reorder point

Summarize the inventory policy based on your calculation results

Answer #1

Following data are provided :

Annual demand for product M = D = 1560 units

Ordering cost = Co = $10

Annual unit holding cost = Ch = 25% of price / unit

Since , price per unit varies depending on quantity slabs, Ch will also vary depending on quantity slabs

The formula for optimum order quantity ( EOQ ) = Square root ( 2 x Co x D / Ch )

Since Ch will vary with price/ unit , EOQ also will change with changing price .

Following table presents different values of EOQ at different price levels corresponding to quantity slabs .

Order quantity |
Price / unit ( $) |
Ch ( 25% of price / unit) |
EOQ ( ROUNDED TO NEAREST WHOLE NUMBER) |

85 – 94 |
16 |
4 |
88 |

95 units and more |
14.5 |
3.625 |
93 |

Since calculated value of EOQ = 88 matches with corresponding Order quantity slab of 85 – 94 , it should be the optimum order quantity which minimizes annual ordering cost plus annual inventory cost.

However , we need to minimize sum of annual purchasing cost , annual ordering cost and annual holding cost.

Such analysis will be done for order quantity of 88 ( EOQ ) and 95 units ( beginning of next quantity slab)

Order quantity = 88 :

Annual purchasing cost = Annual demand x Price/ unit = $ 1560 x 16 = $ 24960

Annual ordering cost = Ordering cost x Number of orders = Co x annual demand / order qty = $10 x 1560 / 88 = $177.27

Annual inventory holding cost = Ch x Average inventory = Ch x Order quantity / 2 = 4 x 88 / 2 = $ 176

Total cost = $24960 + $177.27 + $176 = $25313.27

Order quantity = 95 :

Annual purchasing cost = Annual demand x Price/ unit = $ 1560 x 14.5 = $ 22620

Annual ordering cost = Ordering cost x Number of orders = Co x annual demand / order qty = $10 x 1560 / 95 = $164.21

Annual inventory holding cost = Ch x Average inventory = Ch x Order quantity / 2 = 3.625 x 95/2 = $172.18

Total cost = $22620 + $164.21 + $172.18 = $22956.39

Since total annual cost for order quantity of 95 < Total annual cost of order quantity of 88 , the most cost effective order quantity will be 95

MOST COST EFFECTIVE ORDER QUANTITY = 95 UNITS OF PRODUCT M |

TOTAL COST OF ORDR QUANTITY = $22956.39 |

Daily demand = 1560 units/ 260 days = 6 units

Reorder point = Daily demand x Lead time = 6 units/ day x 5 days = 30 days

REORDER POINT = 30 DAYS |

We therefore have now a continuous inventory review policy of ( 95, 30 ) i.e. order 95 units every time and order this quantity of 95 everytime order quantity in hand becomes 30 units

Southeastern Bell stocks a certain switch connector at its
central warehouse for supplying field service offices. The yearly
demand for these connectors is 16,000 units. Southeastern estimates
its annual holding cost for this item to be $25 per unit. The cost
to place and process an order from the supplier is $70. The company
operates 300 days per year, and the lead time to receive an order
from the supplier is 2 working days.
a. Find the economic order quantity....

A larger distributor of workbooks based on an annual
holding cost rate of 20%. The demand is 7,000 per month, with an
order cost of $40.00 per order, the cost of the item is
$9.50.
Calculate the EOQ
Calculate the reorder point with the lead time is 4
days, and the distributor works 300 days a year.
How many times per year the distributor will order the
workbooks?
What is the total order cost?
What is the total holding cost?...

R & B beverage company has a soft drink product that has a
constant annual demand rate of 3600 cases. A case of the soft drink
costs R & B $3. Ordering costs are $20 per order and holding
costs are 25% of the value of the inventory. R & B has 250
working days per year, and the lead time is 5 days. Identify the
following aspects of the inventory policy: a. Economic order
quantity b. Reorder point d....

A jewelry firm buys semiprecious stones to make bracelets and
rings. The supplier quotes a price of $8 per stone for quantities
of 600 stones or more, $9 per stone for orders of 400 to 599
stones, and $10 per stone for lesser quantities. The jewelry firm
operates 200 days per year. Usage rate is 25 stones per day, and
ordering costs are $48.
a.
If carrying costs are $2 per year for each stone, find the order
quantity that...

In a large law firm, the demand for copier paper has normally
distributed with an average of 10 packages of a day with the
standard deviation of 2. Each package contains 500 sheets. The firm
operates 255 days a year. Holding cost for the paper is $1 per year
per package, and ordering cost is $10 per order.
a) What order quantity would minimize total annual ordering and
holding cost?
b) What is the total annual inventory cost associated with...

3. The annual demand for an item is 10,000 units. The cost to
process an order is $75 and the annual inventory holding cost is
20% of item cost. (a) What is the optimal order quantity for range
1?
Quantity Price
1-9 $2.95 per unit
10 - 999 $2.50 per unit
1,000 - 4,999 $2.30 per unit
5,000 or more $1.85 per unit
A) 1805.788 B) Needs to be discarded. C) First, all EOQs need to
be determined. D) 2254.938...

URGENT
A, If EOQ of a company is 1,000 units, holding cost per unit per
year is Rs.10. What is total ordering
cost?
[2 Marks]
B, COMPANY annually consumes 10,000 units of component P. The
carrying cost of this component is Rs.2 per unit per year and the
ordering costs are Rs.100 per order. PoMA uses an order quantity of
500 units. The company operates 200 days per year, and the lead
time for ordering component P is 14 days....

Assume the following:
Fixed Ordering Cost: $100
Unit product cost to obtain: $2.00
Sell Price: $5.00
Annual holding cost: 30%
Daily Demands: 50 units
Daily demand variance: 4 units
Leadtime: 4 weeks
Service level: 99%
What is the optimal reorder point, R? What is
the optimal order quantity?

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...

The annual demand for an item is 40,000 units. The ordering cost
is $40 and the carrying cost is assumed to be 20% of the price.
a) What is the optimal order quantity, given the following price
schedule for purchasing the item?
b) Should we take advantage of the quantity discount? Show your
work.
Quantity
Price
1-1,499
$2.50 per unit
1,500 - 4,999
$2.30 per unit
5,000 or more
$2.00 per unit

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 46 minutes ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 3 hours ago

asked 4 hours ago

asked 4 hours ago

asked 4 hours ago

asked 4 hours ago

asked 4 hours ago

asked 4 hours ago