Question

In: Finance

Each pair of LIGHTRUN sneakers costing $100 is ordered in quantities of 500 units with annual...

Each pair of LIGHTRUN sneakers costing $100 is ordered in quantities of 500 units with annual demand is 52000 units.

The carrying costs are 20%, and the cost of placing an order is $30.

1: Assit the retailer to calculate the inventory cost (carrying, ordering and item cost on annual total basis)

2: If the goods delivery is 10 working days, what will be average inventory in transit in dollars?

3:What will it be when the delivery lead time is improve by 20%?

4: Give 2 reasons why the retailer should reduce the in transit inventory?

Solutions

Expert Solution

Answer :

Ordering Cost = (annual demand/order quantity) x cost per order

= (52000 / 500 ) * 30 = 3120

No. of orders = 52000/500 = 104

Time between orders = 365/104 = 3.5

At Economic order quantity level :

Carrying/holding cost = ordering cost

(order quantity/2) x holding cost per unit per year = (annual demand/order quantity) x cost per order

(500/2) x holding cost per unit per year =(52000 / 500 ) * 30

holding cost per unit per year = 12.48

Carrying cost = 500 / 2 *12.48 = 3120

Total cost of sneakers = 52000*100 = 52,00,000

Average inventory in transit in dollars = 3120/3.5 * 10 = 8914

If delivery lead time is improved by 20%, means delivery lead time will be 8 days. Average inventory = 3120/3.5*8

= 7131

The retailer should reduce the in transit inventory to reduce the cost of carrying inventory

And to reduce the loss during transit.


Related Solutions

An insulin drip is ordered at 4 units/hr. Available is Regular insulin 100 units in 100ml...
An insulin drip is ordered at 4 units/hr. Available is Regular insulin 100 units in 100ml of NSS. How many ml/hr will be administered? (answer only with a number) Available: 100 units of Regular insulin mixed in 100ml NSS. Ordered: infuse 8 units insulin/hr. How many ml/hour will you set the pump at? (answer only with a number) Ordered: Insulin 3 units/hr. Available: 125 units of Regular insulin mixed in 250ml NSS. You would set the pump at ____ ml/hr...
a rate of 1500 unit/hr is ordered using 30,000 units in 500 ml solution
a rate of 1500 unit/hr is ordered using 30,000 units in 500 ml solution
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.                      ...
44. Partridge Bookstore had 500 units on hand at January 1, costing $9 each. Purchases and...
44. Partridge Bookstore had 500 units on hand at January 1, costing $9 each. Purchases and sales during the month of January were as follows: Date Purchases Sales Jan. 14    375 @ $14 17    250 @ $10 25    250 @ $11 29    260 @ $16 Partridge does not maintain perpetual inventory records. According to a physical count, 365 units were on hand at January 31. The cost of the inventory at January 31, under the LIFO...
Available: 100 units of Regular insulin mixed in 100ml NSS. Ordered: infuse 8 units insulin/hr. How...
Available: 100 units of Regular insulin mixed in 100ml NSS. Ordered: infuse 8 units insulin/hr. How many ml/hour will you set the pump at? (answer only with a number)
On August 15, 2018 Red Fish Blue Fish consigned 500 electronic play systems, costing $100 each,...
On August 15, 2018 Red Fish Blue Fish consigned 500 electronic play systems, costing $100 each, to Toys R You Company. The cost of shipping the play systems amounted to $1,250 and was paid by RedFish Blue Fish. On December 31, 2018 an account sales summary was received from the consignee,reporting that 420 play systems had been sold for $160 each. Remittance was made by the consignee for the amount due, after deducting a 20% commission. Required Calculate the following...
3. The number of book-case units ordered in any one month varies between 100 and 1400...
3. The number of book-case units ordered in any one month varies between 100 and 1400 units, as per the probability model that is found in the associated RegINdust.csv file. Only the first 6 entries of this probability model are shown below (See associated file for full model). X PrX 100 0.3316 300 0.2558 650 0.0920 800 0.1620 850 0.1412 1050 0.0149 Table 1: First 6 entries of the probability model circumscribing the number of units of book-cases that will...
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...
A company purchased 500 units for $ 30 each on January 31. It purchased 650 units...
A company purchased 500 units for $ 30 each on January 31. It purchased 650 units for $ 39 each on February 28. It sold a total of 640 units for $ 45 each from March 1 through December 31. What is the cost of ending inventory on December 31 if the company uses the firstminus​in, firstminusout ​(FIFO) inventory costing​ method? (Assume that the company uses a perpetual inventory​ system.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT