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.                      ...
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...
Project Q                      Project R Investment                &n
Project Q                      Project R Investment                    100,000                        500,000 IRR                              15.5%                           12.3% NPV                             $5500.00                      $6750.00 Profitability Index         1.055                            1.014 If the projects are mutually exclusive, which one should be selected? Why?
Determine cash flows, r, and n You are considering an investment that has a payoff of...
Determine cash flows, r, and n You are considering an investment that has a payoff of $4,707.79 in 2 years.  If the interest rate is 11.68%, and interest is compounded annually, then what is this investment worth to you today?
Demand for an item is 1,000 units per year. Each order placed costs $10, the annual...
Demand for an item is 1,000 units per year. Each order placed costs $10, the annual cost to carry items in inventory is $2 each. Suppose the lead time is 6 days. Assume sales occur over 360 days of the year. In what quantities should the item be ordered based on the EOQ model? (2 points) What is the reordering point? (2 points) Explain the inventory management policy. (1 point)
Annual demand 144495 units Carrying costs $3.36 per unit Fixed Costs per order $7.8 Number of...
Annual demand 144495 units Carrying costs $3.36 per unit Fixed Costs per order $7.8 Number of orders 38 What are the total costs?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT