Case Study

profilejmason04
5.3CaseStudySupplierSelection.xlsx

Sheet1

Cost Per Truck Producer A Producer B Producer C
Cost / Unit $3.25 $2.00 $1.50
Completion Cost / Unit $0.00 $0.50 $1.10
Distance / Miles / Kilometers 600 100 150
Distance / Port to Facility 0 35 35
Cost / Port to Facility $0.00 $1.25 $1.25
Transportation Cost $1.25 $1.50 $0.20
Transportation Cost to Neareast Port $0.00 $43.75 $43.75
Transportation Cost to Destination $750.00 $150.00 $30.00
Insurance Cost / Container $200.00 $850.00 $900.00
Handling Fee / Total Raw Material Cost 1.00% 1.25% 1.25%
Additional Cost for Shipping / Container $0.00 $2,000.00 $2,500.00
Import Duty / Total Raq Material Cost 0% 10% 10%
Safety Stock Required per Order $0.00 $3,000.00 $3,000.00