Question: A buyer received bids and other relevant information from two suppliers for a vital component part for its latest product. Given the following information, use

A buyer received bids and other relevant information from two suppliers for a vital component part for its latest product. Given the following information, use a total cost analysis to determine which supplier should be chosen. Late delivery of the component results in 40 percent lost sales and 60 percent back orders of finished goods.

Order lot size 500 units
Annual demand 10,000 units
Weight per part 90 lbs
Order processing cost 30 $/order
Inventory carrying rate 22 %/year
Cost of working capital 28 %/year
Profit Margin 17 %/unit
Price of finished goods 5000 $/unit
Backorder Cost 300 $/unit

Supplier 1 is located 300 miles away. They have a quality rating of 2.5% and a delivery rating of 1%. The terms they offer are 1%10, net 30. The unit cost from supplier 1 is $110 per unit if they order 1 to 999, $108 per unit if they order between 1000 to 2999 units, and $106 per unit if they order more than 3000 at a time.

Supplier 2 is located 280 miles away. They have a quality rating of 2% and a delivery rating of 4%. The terms they offer are 2%15, net 30. The unit cost from supplier 2 is $115 per unit if they order 1 to 999, $112 per unit if they order between 1000 to 2999 units, and $106 per unit if they order more than 3000 at a time.

Assume 365 days/year. Note: per ton-mile = 2,000 pounds per mile

For shipping the costs are:

Truckload (TL 40,000 lbs): $0.91 per ton-mile

Less-than-truckload (LTL): $1.15 per ton-mile

What is the expected cost of lost sales if the company uses supplier 1? (Round to the nearest whole number)

a.

$34,000

b.

$136,000

c.

$51,000

d.

$85,000

e.

None of these

What are the inventory holding costs if the company uses supplier 2? (Round to the nearest whole number)

a.

$6,050

b.

$6,160

c.

$6,325

d.

None of these

e.

$12,650

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!