Question: Problem 1: Global Sourcing Cost, Time & Ethics You must source a required quantity Q (choose a realistic number, e.g.,10,000 units) from the suppliers below.
Problem 1: Global Sourcing Cost, Time & Ethics You must source a required quantity Q (choose a realistic number, e.g.,10,000 units) from the suppliers below. Leadership cares about total cost, average delivery time, and average ethical rating. SupplierUnit Cost ($)Delivery (weeks)Ethical Rating (15)Supplier A (Vietnam)844Supplier B (China)632Supplier C (Germany)1025Supplier D (Mexico)753Supplier E (USA)914 Tasks Continuous LP (start here): Decision cells =Units from each supplier. Goal = minimize Total Cost. Add constraints: Total units purchased equals Q.Average delivery time at or below your chosen target (explain your choice).Average ethical rating at or above 4.0. Deliver: solution table + LP Sensitivity Report. In plain English, explain what the report says about relaxing/tightening the time and ethics requirements.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
