Question

In: Accounting

Bell Computers purchases integrated chips at $350 per chip. The holding cost is $37 per unit per year, the ordering cost is $123 per order, and sales are steady at 405 per month.



Bell Computers purchases integrated chips at $350 per chip. The holding cost is $37 per unit per year, the ordering cost is $123 per order, and sales are steady at 405 per month. The company's supplier, Rich Blue Chip Manufacturing, Inc., decides to offer price concessions in order to attract larger orders. The price structure is shown below. 

Rich Blue Chip's Price Structure 


Quantity PurchasedPrice/Unit
1-99 units$350
100-199 units$325
200 or more units$300


a) What is the optimal order quantity and the minimum annual cost for Bell Computers to order, purchase, and hold these integrated chips? 

The optimal order quantity after the change in pricing structure is units (enter your response as a whole number). 

The total annual cost for Bell computers to order, purchase, and hold the integrated chips is $ (round your response to the nearest whole number). 


b) Bell Computers wishes to use a 10% holding cost rather than the fixed $37 holding cost in part a. What is the optimal order quantity, and what is the optimal annual cost? 

The optimal order quantity after the change in the holding cost calculation is units (enter your response as a whole number). 

The total annual cost for Bell computers to order, purchase, and hold the integrated chips is $ (round your response to the nearest whole number).

Solutions

Expert Solution

Considering the following values:

Annual Demand (405 x 12) 4,860 per year
Holding Cost (H) $ 37 per year
Ordering Cost (S) $ 123 per order
Purchase cost $ 350 per chip

(a) Initially determine the Optimal Order Quantity (EOQ) as below:

Now, determine the minimum cost for the Bell Company to order:

Quantity Ordered (Q) Order Cost Purchasing Cost Holding Cost Total Cost
(A) (B) = (4,860 / A x 123) (C) = (4,860 x Price) (D) = (A / 2) x 37 (A) + (B) + (C) + (D)
180 3,321 1,579,500 3,330.00 1,586,151.00
99 6,038.1818 1,701,000 1,831.50 1,708,869.68
199 3,003.9196 1,579,500 3,681.50 1,586,185.42
200 2,989.9 1,458,000 3,700.00 1,464,689.90

Hence the optimal Order Quantity for Bell Computers is 200 units. The minimum cost to order , purchase, and hold these integrated chips is $1,464,689.90.

.

(b) Bell Computers wishes to use a 10% holding cost rather than fixed holding cost. Determine the Optimal order quantity and optimal cost as beloe:

In this case, holding cost will be calculated using the given formula:

Quantity Ordered (Q) Order Cost Purchasing Cost Holding Cost Total Cost
(A) (B) = (4,860 / A x 123) (C) = (4,860 x Price) (D) = (A / 2) x (0.10 x Price) (A) + (B) + (C) + (D)
180 3,321 1,579,500 2,925.00 1,585,746.00
99 6,038.1818 1,701,000 1,732.50 1,708,770.68
199 3,003.9196 1,579,500 3,233.75 1,585,737.67
200 2,989.9 1,458,000 3,000.00 1,463,989.90

Hence the optimal Order Quantity for Bell Computers is 200 units. The minimum cost to order , purchase, and hold these integrated chips is $1,463,989.90.


Related Solutions

Bell Computers purchases integrated chips at $350 per chip. The holding cost is $33 per unit...
Bell Computers purchases integrated chips at $350 per chip. The holding cost is $33 per unit per year, the ordering cost is $122 per order, and sales are steady, at 395 per month. The company's supplier, Rich Blue Chip Manufacturing Inc., decides to offer price concessions in order to attract larger orders. The price structure is shown below.Quantity Purchased1-99 units= $350 price/unit100-199 units= $325 price/unit200 or more units= $300 price/unita) What is the optimal order quantity and the minimum cost...
Bell Computers purchases integrated chips at ?$350 per chip. The holding cost is ?$35 per unit...
Bell Computers purchases integrated chips at ?$350 per chip. The holding cost is ?$35 per unit per? year, the ordering cost is ?$118 per? order, and sales are steady at 405 per month. The? company's supplier, Rich Blue Chip? Manufacturing, Inc., decides to offer price concessions in order to attract larger orders. The price structure is shown below. 1-99 units- $350 100-199- $325 200 or more units- $300 a. What is the optimal order quantity and the minimum annual cost...
What is the optimal order quantity and the minimum annual cost for Bell Computers to order, purchase, and hold these integrated chips?
Bell Computers purchases integrated chips at $350 per chip. The holding cost is $34 per unit per year, the ordering cost is $121 per order, and sales are steady at 400 per month. The company's supplier, Rich Blue Chip Manufacturing, Inc., decides to offer price concessions in order to attract larger orders. The price structure is shown below .Rich Blue Chip's Price StructureQuantity PurchasedPrice/Unit1-99 units$350100-199 units$325200 or more units$300a) What is the optimal order quantity and the minimum annual cost...
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?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT