With a fixed cost of $100 per order, Nathan decided it was vital to get his...

With a fixed cost of $100 per order, Nathan decided it was vital to get his money's worth. His monthly demand for energy drinks was 10,000 bottles and holding cost was estimated at 20% of unit cost. The mail-order company offered him a couple of possibilities — he could pay $4.00 per bottle for orders of up to 10,000 bottles. After that threshold, he would pay only $3.98 per bottle, and if he ordered 20,000 or more bottles in a order, he would pay only $3.96 per bottle.

A. What is the best order quantity for Nathan to use?

B. What is the best total cost that Nathan can incur?

Expert Solution

a) Best order quantity = 10000 (See table below) (Lowest cost)

b) Quantity of 10000 has the lowest cost of = Holding cost + order cost + product cost = (10000/2) *0.796+(120000/10000)*100+(120000*3.98) = $482780

Annual demand, D = Months * Monthly demand =	120000
Order cost, S	100
Quantity	1 to 10000	10000 to below 20000	20000 or more
Cost, C	4.00	3.98	3.96
Holding cost, H = 20%	0.80	0.796	0.792
EOQ = sqrt(2DS/H),	5477.23	5490.97	5504.82
Considered Order quantity - Q for calculation	5477.00	10000.00	20000
	Considered Q = 5477 as EOQ is within range	Consider Q = 10000, for discount	Consider Q = 20000, for discount

Order size	1 to 10000	10000 to below 20000	20000 or more
*Product cost = D (120000) Respective cost for order quantity**	480000.00	477600.00	475200.00
*Holding cost = (Q/2) Holding cost**	2190.80	3980.00	7920.00
*Ordering cost = (D/EOQ) S**	2190.98	1200.00	600.00
Total cost	484381.78	482780.00	483720.00

keosha answered 4 months ago

A company has a holding cost per unit of $5. Each order has a fixed cost...

A company has a holding cost per unit of $5. Each order has a fixed cost of $8 and the annual demand quantity is 150,000 units. What is the company's optimal order quantity?

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?

1. A) If a company makes 100 units of product, the allocated fixed cost per unit...

1. A) If a company makes 100 units of product, the allocated fixed cost per unit is $5 and the variable cost per unit is $6. What will be the per-unit total cost (fixed plus variable cost) if the company makes 200 units? B) At a production and sales level of 1,000 units, the company’s costs are as follows: Variable manufacturing costs per unit $20 Allocated fixed manufacturing cost per unit $10 Variable selling costs per unit $ 5 Allocated...

1. A. (EOQ) Calculate the EOQ quantity given: a. Fixed cost per order of $40 b....

1. A. (EOQ) Calculate the EOQ quantity given: a. Fixed cost per order of $40 b. holding cost per inventory unit of $2.00 c. estimated demand for inventory of 200,000 Solve EOQ using the information listed above: B. Calculate the total cost associated the EOQ amount calculated in part A: C. The company wants to keep Safety Stock of an additional; 8 units. Calculate the cost associated with the safety stock and the total cost of the EOQ amount...

Now that you are going to save 100 €/month, you decided to save those 100€ per...

Now that you are going to save 100 €/month, you decided to save those 100€ per month in a bank account that offers a 2% interest rate compounded monthly, till the day you retire (that is to say, in 20 years). Please answer the following questions: If you decide to do your deposits at the end of every month (similarly to ex.1, so your first deposit will be in one month from today) in a bank account that offers a...

show the fixed cost are fixed in total but is variable on a per unit basis...

show the fixed cost are fixed in total but is variable on a per unit basis and that variable in total but is fixed on a per unit basis

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

Fixed cost is fixed in total but varies on a per-unit basis. Does this mean that...

Fixed cost is fixed in total but varies on a per-unit basis. Does this mean that as your sales increase, your contribution towards covering fixed costs and earning a profit increases? Beyond a range that sales and variable costs increase, fixed costs may change.

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

A firm has a fixed cost of $100 and average variable cost of $5xq, where q...

A firm has a fixed cost of $100 and average variable cost of $5xq, where q is the number of units produced. a. Construct a table showing total cost for q from 0 to 10. b. Graph the firms marginal cost and average total cost curves. c. How does marginal cost change with q? What does this suggest about the firm’s production process?

Question