Question

In: Accounting

R and N Investment Corp. has an annual demand of 1,500, ordering costs of $15/order, and...

R and N Investment Corp. has an annual demand of 1,500, ordering costs of $15/order, and inventory carrying costs of 25% of item price. Price is established by the following quantity discount schedule. What should the order quantity be in order to minimize the total annual cost? When we use the quantity discount model, what are the two basics elements to take into consideration? Why?

Quantity

1 to 499

500 to 999

1,000 to 1,499

1,500 and up

Price

$15.00 per unit

$14.50 per unit

$14.00 per unit

$13.75 per unit

Solutions

Expert Solution

data given :

annual demand (D) = 1500

ordering cost per order / set up cost (S) = $15 per order

inventory carrying cost = 25% of item price

R and N Investment Corp. would pay $13.75 per unit by ordering 1500 units at a time.

EOQ = √(2 D S) / I

EOQ = √(2 x 1500 x 15) / (13.75 x 25%)

EOQ = √45000 / 3.4375

EOQ = 114.4155 or 114 units

we should order EOQ on which ordering cost and inventory carrying cost will BE MINMUM OR EQUAL.

company is not ordering EOQ in range 2,3 and 4 so ordering cost and inventory carrying cost will not equal.

particular range 1 range 2 range 3 range 4
minimum quantity 1 500 1000 1500
unit price $15 $14.50 $14 $13.75
results:
quantity (EOQ = √(2 D S) / I) (i) 109.5445 111.4172 113.3893 114.4155
order quantity (ii) 1 500 1000 1500
EOQ (i or ii which ever is higher) 109.5445 500 1000 1500
ordering cost per order / set up cost (annual demand x ordering cost per order /order quantity) (a) $205.39 = 1500 x 15 / 109.5445 $45 = 1500 x 15 / 500 $22.5 = 1500 x 15 / 1000 $15 = 1500 x 15 / 1500
inventory carrying cost (EOQ x unit price x inventory carrrying cost in % / 2) (b) $205.39 = 109.5445 x 15 x 25% / 2 $906.25 = 500 x 14.5 x 25% / 2 $1750 = 1000 x 14 x 25% / 2 $2578.125 = 1500 x 13.75 x 25% / 2
unit cost (c) $22500 = 1500 x $15 $21750 = 1500 x $14.50 $21000 = 1500 x $14 $20625 = 1500 x $13.75
total cost (a+b+c) $22910.78 $22701.25 $22772.5 $23218.125

so we should order that quantity of EOQ on which ordering cost and inventory carrying cost will minimum or equal.

EOQ = 109.5445 units or 110 units (round off)

inventory carrying cost and ordering cost are two element which is considered to for quantity discount model because we have to order the quantity on which ordering cost and inventory carrying cost will minimum or equal. on there costs we have to invest very high amount for maintenece,carrying and placing order when we order quantity and our try to reduce these cost to minimum.

please give your feed back and rating


Related Solutions

Ricky Orange’s annual demand is 12 500 units. Ordering cost is RO. 100 per order. Holding...
Ricky Orange’s annual demand is 12 500 units. Ordering cost is RO. 100 per order. Holding cost is estimated at 20% of product cost which is RO. 50 per unit. The firm works for 50 weeks per year and each week has 5 days. Calculate: a)   Economic order quantity.                                 b)   Number of orders to be placed per year.                    c)   Daily usage quantity.                      ...
Economic Order Quantity (EOQ) is the order quantity that minimizes the total holding costs and ordering...
Economic Order Quantity (EOQ) is the order quantity that minimizes the total holding costs and ordering costs. 1) What's the impact of a positive lead time on EOQ? 2) Can supply chain managers in fast-fashion industries apply the EOQ model to manage their inventories? If yes, how? If no, why?
A product has a daily demand of 26 units per day. Ordering costs are $60 per...
A product has a daily demand of 26 units per day. Ordering costs are $60 per order. The annual carrying costs are measured at 20% of item value. Your supplier has offered you three item cost/price and quantity scenarios (1) you pay $150 per unit if your order quantity is 199 units or less, (2) you pay $121 per unit if your order quantity is between 200 and 4999 units, and (3) you pay $114 per unit if your order...
A company manufacturing bicycles has a current annual demand of 1,500 bikes. In buying bike tires,...
A company manufacturing bicycles has a current annual demand of 1,500 bikes. In buying bike tires, they pay $14 per tire with an estimated carrying cost of 20% of the tire’s cost. Each order cost $25 to process. Orders are placed on the first of each month for an equal amount every month. Determine the current ordering cost, carrying cost and total inventory cost each year using the current order quantity. Calculate the EOQ. Determine the current ordering cost, carrying...
A project has fixed costs of $1,500 per year, depreciation charges of $500 a year, annual...
A project has fixed costs of $1,500 per year, depreciation charges of $500 a year, annual revenue of $9,000, and variable costs equal to two-thirds of revenues. a. If sales increase by 13%, what will be the percentage increase in pretax profits? (Round to 2 decimal places) b. What is the degree of operating leverage of this project? (round to 2 decimal places)
There is an order for Humulin R U-100 8 units and Humulin N U-100 15 units...
There is an order for Humulin R U-100 8 units and Humulin N U-100 15 units sub q a.c. a. What are the steps to draw up the two insulins?
The annual demand for a certain product sold in a department store is 1,000 units. Ordering...
The annual demand for a certain product sold in a department store is 1,000 units. Ordering cost per order is $50, holding rate is 40%, and unit cost is $200. The department store currently is ordering every two months, but now is offered the following quantity discount scheme: For an order of up to 99 units no discount. For an order up to 699 units-a discount of 25%, and for a larger order -a discount of 30%. What is the...
The annual demand for a certain product sold in a department store is 1,000 units. Ordering...
The annual demand for a certain product sold in a department store is 1,000 units. Ordering cost per order is $50, holding rate is 40%, and unit cost is $200. The department store currently is ordering every two months, but now is offered the following quantity discount scheme: For an order of up to 99 units no discount. For an order up to 699 units-a discount of 25%, and for a larger order -a discount of 30%. What is the...
An annual demand for an item is 500 units, ordering cost is 8 $, inventory carrying...
An annual demand for an item is 500 units, ordering cost is 8 $, inventory carrying interest is 20% of the purchase price per year. Purchase prices are as follows as proposed by the vendor/supplier; where the value of unit cost=10 without any discount? Discount 0% 000≤Q<300    Discount 2% 300≤Q<450 Discount 3% 450≤Q
An annual demand for an item is 500 units, ordering cost is 8 $, inventory carrying...
An annual demand for an item is 500 units, ordering cost is 8 $, inventory carrying interest is 20% of the purchase price per year. Purchase prices are as follows as proposed by the vendor/supplier; where the value of unit cost=10 without any discount? Discount 0% 000≤Q<300    Discount 2% 300≤Q<450 Discount 3% 450≤Q a) for inventory model with no discount====================================================================== a1) The economic order quantity = [EOQ] units a2) The total ordering costs = [TOC] $ a3) The total...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT