A supplier offers you the following discount table for the purchase of your main product, whose...

A supplier offers you the following discount table for the purchase of your main product, whose annual demand you have estimated at 5,000 units. The cost of issuing a purchase order is $ 49, and it has also been estimated that the annual cost of storing a unit in inventory is 20% of the cost of purchasing the product. What is the order quantity that minimizes the total cost of inventory?

Q ( Cantidad)	Discount %	Costo Unitario
0 - 999	0 %	5
1 000 - 1 999	2 %
2 000 o más	3 %

Solutions

Expert Solution

Answer: 1000 units

Explanation:

Annual Demand (D) = 5000

Price per unit (P) =(1 - Discount %/100)*5

Annual Holding Cost per unit = 20% of P

Cost per order (S) = $49

EOQ = SQRT(2*S*D/H)

If EOQ > the upper limit of the range then there is no feasible solution

If EOQ < lower limit of the range then lower limit is the Feasible EOQ

Annual Ordering Cost = (D/Q)*S

Annual Holding Cost = (Q/2)*H

Annual Purchasing Cost = D*P

Total Cost = Annual Ordering Cost + Annual Holding Cost + Annual Purchasing Cost

Total cost for Q=1000 is the lowest

so, Optimal Order Quantity = 1000 units

keosha answered 1 year ago

Next > < Previous

Related Solutions

A store will give you a 4.75% discount on the cost of your purchase if you...

A store will give you a 4.75% discount on the cost of your purchase if you pay cash today. Otherwise, you will be billed the full price with payment due in 1 month. What is the implicit borrowing rate being paid by customers who choose to defer payment for the month? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)

A store will give you a 4.25% discount on the cost of your purchase if you...

A store will give you a 4.25% discount on the cost of your purchase if you pay cash today. Otherwise, you will be billed the full price with payment due in 1 month. What is the implicit borrowing rate being paid by customers who choose to defer payment for the month? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) Effective Annual Rate =

You are a Supplier: A retailer requests to purchase supplies on credit from your company. You...

You are a Supplier: A retailer requests to purchase supplies on credit from your company. You have no prior experience with this retailer. The retailer’s current ratio is 2.1, its acid-test ratio is 0.5, and inventory makes up most of its current assets. Do you extend credit? You are the Financial Officer: Your company has a 36% gross margin ratio and a 17% net profit margin ratio. Industry averages are 44% for gross margin and 16% for net profit margin....

Sysco purchases 10,000 units of a product each year. The supplier offers the units for sale...

Sysco purchases 10,000 units of a product each year. The supplier offers the units for sale at $10.00 per unit for up to 999 units and $9 per units for orders of 1,000 units or more. What is the economic order quantity if the order cost is $10.00 per order and the holding cost is 40 percent per unit per year? A. 1,000 units B. 236 units C. 999 units D. 224 units

Roberts currently manufactures a subcomponent that is used in its main product. A supplier has offered...

Roberts currently manufactures a subcomponent that is used in its main product. A supplier has offered to supply all the subcomponents needed at a price of $42. Roberts currently produces 100,000 subcomponents at the following manufacturing costs: Per unit Direct materials $ 15.00 Direct labor 9.00 Variable manufacturing overhead 10.00 Fixed manufacturing overhead 15.00 Unit cost $ 49.00 If Roberts has no alternative (no opportunity costs) uses for the manufacturing capacity, what would be the profit impact of buying the...

Your factory manufactures tricycles. You need to purchase front wheels from the supplier. The expected annual...

Your factory manufactures tricycles. You need to purchase front wheels from the supplier. The expected annual demand is D units; the setup or ordering cost is $Sper order; and the holding cost per unit per year is $H. Based on the number given in the table below: a.Determine optimal number of wheels to order b.Determine the reorder point (ROP) (without safety stock)assuming that the average lead time is Ldays, and your factory works 250 days a year. c.Based on your...

A retailer purchases a certain type of chemical from a supplier on the following quantity discount...

A retailer purchases a certain type of chemical from a supplier on the following quantity discount schedule: • If the order amount is less than 100 kg.s, the supplier charges $30 per kg. • If the order amount is at least 100 kg.s and less than 500 kg.s, the supplier applies an incremental discount where the ﬁrst 100 kg. costs $30 per kg. and the remaining amount costs $28 per kg. • If the order amount is at least 500...

Bancroft currently manufacture a subcomponent that is used in its main product. q supplier has offered...

Bancroft currently manufacture a subcomponent that is used in its main product. q supplier has offered to supply all the subcomponents needed at a price of $120. Bancroft currently produces 20,700 subcomponents at the following manufacturing costs. direct materials $40 direct labor 32 variable manufacturing overhead 35 fixed manufacturing overhead 22 unit cost $129 a. if bancroft has no alternative uses for then manufacturing capacity. what would be the profit impact of buying the subcomponents? (less or more profit) b....

A type of deposit product that banks will encourage the customer to purchase whose primary goal...

A type of deposit product that banks will encourage the customer to purchase whose primary goal is to save rather than make payments is: Checking account. Non-interest bearing deposit. Non-transaction deposit. Either (a) or (b).

Chapter 16 Problem 1 1. A supplier is offering your firm a cash discount of 2...

Chapter 16 Problem 1 1. A supplier is offering your firm a cash discount of 2 percent if purchases are paid for within ten days; otherwise, the bill is due at the end of 60 days. Would you recommend borrowing from a bank at an 18 percent annual interest rate to take advantage of the cash discount offer? Explain your answer.

Subjects