Question

In: Advanced Math

Sorur Inc. has gone out on bid for an electronic component. Expected demand is 500 units...

  1. Sorur Inc. has gone out on bid for an electronic component. Expected demand is 500 units per month. The item can be purchased from either Asha Manufacturing or Brian Manufacturing. Their price schedule is shown below. Ordering cost is $25, and annual holding cost per unit is $15.

Ahsa Mfg.                                                           Brian Mfg.  

Quantity              Price/unit                           Quantity              Price/unit

1- 199                    $20.00                                   1 – 299                 $20.00

200 – 399             $19.80                                   300 – 599             $19.75

400+                      $19.60                                   600+                      $19.50

What is the optimal order quantity? Which supplier should be used?

Solutions

Expert Solution

Monthly demand = 500 units

Yearly demand = 500 x 12 = 6000 Units

Ordering cost = $25

Holding cost = $15 per unit per year

Optimal Order quantity = EOQ = Sqrt [(2 x Annual demand x Ordering cost) / Holding cost]

= Sqrt [(2 x 6000 x 25) / 15]

= 141.42 Units (Approx.)

Number of orders per year = Annual demand / EOQ

= 6000 / 141.42          

= 42.43 orders (Approx.)

Annual Ordering cost = No of orders per year x Per order cost

= 42.43 x 25 = $1060.75

Average annual inventory = 141.42 / 2 = 70.71 Units (Approx.)

Annual Holding cost = Average annual inventory x Holding cost per unit per year

= 70.71 x 15

= $1060.65

CASE 1: ASHA MANUFACTURING

Purchase price = $20

Total cost of purchasing = Annual demand x price per unit

= 6000 x 20

= $120,000

Total Annual cost = Total cost of purchasing + Annual holding cost + Annual ordering cost

= 120,000 + 1060.75 + 1060.65

= $122121.40

CASE 2: BRIAN MANUFACTURING

Purchase price = $20

Total cost of purchasing = Annual demand x price per unit

= 6000 x 20

= $120,000

Total Annual cost = Total cost of purchasing + Annual holding cost + Annual ordering cost

= 120,000 + 1060.75 + 1060.65

= $122121.40

Both Brian and Asha Manufacturing have the same total cost. Either of them can be chosen


Related Solutions

M. P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is...
M. P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 725725 units per month. The item can be purchased from either Allen Manufacturing or Baker Manufacturing. Their price lists are shown in the table. Ordering cost is ?$5555?, and annual holding cost per unit is ?$55. ??????????????????????????????????????????????????????????????????????????????????????   ?????????????????????????????????????????????????? Allen Mfg. Baker Mfg. Quantity Unit Price Quantity Unit Price ?1-499 ?$16.00?? ?1-399 ?$16.10?? ?500-999 15.50 ?400-799 15.60 ?1000+ 15.00 ?800+ 15.10 ?a) What is the...
M. P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is...
M. P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 700700 units per month. The item can be purchased from either Allen Manufacturing or Baker Manufacturing. Their price lists are shown in the table. Ordering cost is ​$5555​, and annual holding cost per unit is ​$66.                                                                                                                                                Allen Mfg. Baker Mfg. Quantity Unit Price Quantity Unit Price ​1-499 ​$16.00   ​1-399 ​$16.10   ​500-999 15.50 ​400-799 15.60 ​1000+ 15.00 ​800+ 15.10 ​a) What is the...
M. P. Van Oyen Manufacturing has gone out on bid for a regulator component. Expected demand...
M. P. Van Oyen Manufacturing has gone out on bid for a regulator component. Expected demand is 675 units per month. The item can be purchased from either Allen Manufacturing or Baker Manufacturing. Their price lists are shown in the table. Ordering cost is $50, and annual holding cost per unit is $7.     Allen Mfg.Baker Mfg.QuantityUnit PriceQuantityUnit Price1-499$16.00  1-399$16.10  500-99915.50400-79915.601000+15.00800+15.10a) What is the economic order quantity if price is not a consideration? _______ units (round your response to the nearest...
A. The expected demand for a regular component is 2000 units per year. The item can...
A. The expected demand for a regular component is 2000 units per year. The item can be purchased from Bonjo Limited. Their lists are shown in the table below. The ordering cost is $200 and the carrying cost per unit is 75%. The cost is $20. BONJO LIMITED QUANTITY DISCOUNT 1 - 199 0% 200 - 499 2% 500 - more 5% You have just been promoted as the operations manager for this firm. Advise the purchasing manager in making...
Suppose that the annual demand for a component is approximately56,000 units. The company orders the...
Suppose that the annual demand for a component is approximately 56,000 units. The company orders the component from a supplier who has offered the following quantity discount schedule.Order Quantity0-9991,000-1,4991,500-3,4993,500or morePrice Per Unit$33$31$29$27If the company's carrying charge is 25% of the item's price and the cost per order is $330, determine the order quantity that would minimize the total related inventory costs for this component.The company's decision would be to order ____ Units.The total annualized ordering costs for this quantity is____
Fisher is an electronic supplier has annual demand 9000 units. The supplier pays $2000 for each...
Fisher is an electronic supplier has annual demand 9000 units. The supplier pays $2000 for each unit and estimate that the annual holding cost 1% of the price. It costs approximately $200 to place an order (managerial and clerical cost). Assume the operates on a 300 day working year. Apply the economic order quantity model to determine Q* How many expected orders be placed per year using the calculated EOQ? Determine the annual ordering, holding and total inventory costs for...
Keystone Manufacturing, Inc., is analyzing a new bid to supply the company with electronic control systems....
Keystone Manufacturing, Inc., is analyzing a new bid to supply the company with electronic control systems. Alpha Corporation has been supplying the systems and Keystone is satisfied with its performance. However, a bid has just been received from Beta Controls, Ltd., a firm that is aggressively marketing its products. Beta has offered to supply systems for a price of $120,000. The price for the Alpha system is $160,000. In addition to an attractive price, Beta offers a money-back guarantee. That...
Suppose that the annual demand for a component is approximately 60,000 units. The company orders the...
Suppose that the annual demand for a component is approximately 60,000 units. The company orders the component from a supplier who has offered the following quantity discount schedule. Order Quantity Price per Unit 0-999 $30 1,000-1,999 $29 2,000-3,999 $28 4,000 or more $27 If the company’s carrying charge is 15 percent of the item’s price and the cost per order is $150, determine the order quantity that would minimize the total related inventory costs for this component.
Suppose that the annual demand for a component is approximately 63,000 units. The company orders the...
Suppose that the annual demand for a component is approximately 63,000 units. The company orders the component from a supplier who has offered the following quantity discount schedule. Order Quantity Price Per Unit 0-999 $31 1,000-1,999 $29 2,000-3,499 $27 3,500 or more $25 If the​ company's carrying charge is 16% of the​ item's price and the cost per order is ​$170​, determine the order quantity that would minimize the total related inventory costs for this component.
Suppose that the annual demand for a component is approximately 60,000 units. The company orders the...
Suppose that the annual demand for a component is approximately 60,000 units. The company orders the component from a supplier who has offered the following quantity discount schedule. Order Quantity Price per Unit 0–999 $30 1,000–1,999 $29 2,000–3,999 $28 4,000 or more $27 If the company’s carrying charge is 15 percent of the item’s price and the cost per order is $150, determine the order quantity that would minimize the total related inventory costs for this component.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT