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 $(10$ points$)$

Step $2$: Describe the logical objective $(10$ points$)$

Step $3$: Describe the logical constraints $(10$ points$)$

Step $4$: Create the mathematical model $($i$.$e$.,$ objective function and constraints$)(10$ points$)$

Step $5$: Solve the problem using the "Transportation" worksheet and the Excel "Solver" $(30$ points$)$