Math Problem Solver

Homework 5: Transportation Problem A company wants to minimize the cost of shipping a product from 2 different factories to 5 different customers. Each factory has a limited supply and each customer a certain demand. How should the company distribute the product? Step 1: Describe the decision variables Step 2: Describe the logical objective Step 3: Describe the logical constraints Step 4: Create the mathematical model (i.e., objective function and constraints) Step 5: Solve the problem using the Excel "Solver" Cost of shipping ($per product) Destinations Customer 1 Customer 2 Customer 3 Customer 4 Customer 5 Capacity Factory 1$1.75 $2.25$1.50 $2.00$1.50 60,000 Factory 2 $2.00$2.50 $2.50$1.50 $1.00 60,000 Demand 30,000 23,000 15,000 32,000 16,000 A company wants to minimize the cost of shipping a product from 2 different factories to 5 different customers. Each factory has a limited supply and each customer a certain demand. How should the company distribute the product? Step 1: Describe the decision variables Step 2: Describe the logical objective Step 3: Describe the logical constraints Step 4: Create the mathematical model (i.e., objective function and constraints) Step 5: Solve the problem using the Excel "Solver" Cost of shipping ($ per product) Destinations Customer 1 Customer 2 Customer 3 Customer 4 Customer 5 Capacity Factory 1 $1.75$2.25 $1.50$2.00 $1.50 60,000 Factory 2$2.00 $2.50$2.50 $1.50$1.00 60,000 Demand 30,000 23,000 15,000 32,000 16,000