Question

In: Accounting

Annual demand is 12500 units, cost per order is $60 and carrying cost per unit as...

Annual demand is 12500 units, cost per order is $60 and carrying cost per unit as a    percentage is 8%. The company works 50 weeks a year; the lead-time on all orders placed is 5 weeks.
Assuming constant lead-time demand, and a unit cost of $40 what is the economic order quantity? What is the reorder point.
If lead-time demand shows variability that follows a normal distribution with a mean μ =280 and a standard deviation σ =20, what will the revised reorder point if two stock-outs (shortages) are allowed?
What is the company’s reorder point if the probability of a stock-out on any cycle is restricted to 0.05

Solutions

Expert Solution

EOQ
Details
Annual usgae units                                                    12,500
Cost pr Order $                                                       60
Carrying cost per unit =8% *$40 $                                                    3.20
EOQ = Sq Root of [(2*Order cost*Annual usage)/(Annual Holding cost per unit]
=Sq Rt ( 2*12500*60)/3.2
EOQ =684.65 units
Annual Usage                                                    12,500
No of Working days in a Year =50 weeks =350 days
Usage /Day =12500/350=                                                      35.71
Lead Time =5 weeks =35 days
Reorder Point =Lead Time days*Daily usage=35*35.71=                                                1,250.00
So ROP =1250 Units
When stock out is restricted to 0.05, we can take the stock
out probability as 5%. So service Level will be 95%
Z value at 95% coverage=1.65
Std Deviation =20
Safety Stock =Z*Std deviation=1.65*20=33 units
Mean demand =250 units
Reorder Point =Expected Demand During Lead time+Safety Stock
=250+33=283 Units
ROP =283 units.

Related Solutions

FQ3. Annual demand is 12500 units, cost per order is $60 and carrying cost per unit...
FQ3. Annual demand is 12500 units, cost per order is $60 and carrying cost per unit as a    percentage is 8%. The company works 50 weeks a year; the lead-time on all orders placed is 5 weeks. Assuming constant lead-time demand, and a unit cost of $40 what is the economic order quantity? What is the reorder point. If lead-time demand shows variability that follows a normal distribution with a mean μ =280 and a standard deviation σ =20, what...
Assume: Demand = 3000 units/year Inventory value = $60/unit Order placement cost = $400/order Annual carrying...
Assume: Demand = 3000 units/year Inventory value = $60/unit Order placement cost = $400/order Annual carrying costs = $0.30 per dollar held/yr or “30%” If you supplier calls with a special 1X discount of 10%, what would the savings be?
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?
Assume you have a product with the following parameters: Annual Demand = 360 units Holding cost per year = $1.00 per unit Order cost = $100 per order
Assume you have a product with the following parameters: Annual Demand = 360 units Holding cost per year = $1.00 per unit Order cost = $100 per order a) What is the EOQ for this product?b) In addition, assume a 300-day work year, how many orders should be processed per year? c) What is the expected time between orders?
(7) The annual demand for a product is 500,000 units. The inventory carrying cost for this...
(7) The annual demand for a product is 500,000 units. The inventory carrying cost for this product is 25% per unit per year and the cost of placing one order is $200. The supplier of this product gives quantity discounts outlined in the table below. Level 1 Level 2 Level 3 Level 4 If Quantity is: 1 to 1999 2000 to 9999 10000 to 49999 50000 or higher Price $     20.00 $            19.80 $     19.75 $     19.70 Provide the following...
Demand for an item is 18644 units per year. Each order placed costs $94. The annual carrying cost percentage per item in inventory is 20 percent each.
Demand for an item is 18644 units per year. Each order placed costs $94. The annual carrying cost percentage per item in inventory is 20 percent each. The variable purchase cost is $2.5 per unit if less than 3000units will be ordered, $ 2.4 from 3000 units up to (but not including) 4000 units, and $2.3 for at least 4000 units. These are all-units discounts.(A) What is the optimal order quantity Q* for the unit cost of $2.3? Please round...
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...
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.                      ...
What is the inventory carrying cost per unit per year for this item?
For a certain item, the cost-minimizing order quantity obtained with the basic EOQ model is 200 units, and the total annual inventory (carrying and setup) cost is $600. What is the inventory carrying cost per unit per year for this item?  
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT