Unit1 Unit2 Unit3 Transportation Problem Unit Cost Customer 1 Factory 1 Factory 2 72 Factory 3 24 40 Customer 2 47 36 61 Customer 3 80 58 71 Total Out Shipments Factory 1 Factory 2 Factory 3 Customer 1 0 0 Supply 100 Customer 2 0 0 0 Customer 3 0 0 0 OOO 200 0 = 300 Total in 0 0 0 E Total Cost 0 Demand 200 200 200 For this problem, we need to find out how many units to strip from each factory to each customer (the YELLOW range). Set up the needed formulas and then use the Excel Solver to find out the minimum Total Cost with the following constrain: a. Each factory has a fixed supply and each customer has a fixed demand