B15 X V fx 12000 B C D E G H K L M N O P Q R S T U V W X Y Z AA Plant Decision A company currently ships its product from 5 plants to 4 warehouses. It is considering closing one or more plants to reduce cost. What plant(s) should the company close, in order to minimize transportation and fixed costs? Transportation Costs (per 1000 products) Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 Demand Warehouse 1 $4,000 $2,000 $3,000 $2,500 $4,500 Warehouse 2 $2,500 $2,600 $3,400 $3,000 $4,000 18 10 Warehouse 3 $1,200 $1,800 $2,600 $4,100 $3,000 14 11 Warehouse 4 $2,200 $2,600 $3,100 $3,700 $3,200 20 13 4 Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 15 Fixed Cost ####### ####### ####### ####### #######) Capacity 20 22 17 19 1815 X V fx 15000 B C D E F G H J K L M N O P Q R S T U V W X Y Z AA AB Plant Decision A company currently ships its product from 5 plants to 4 warehouses. It is considering closing one or more plants to reduce cost. What plant(s) should the company close, in order to minimize transportation and fixed costs? Transportation Costs (per 1000 products) Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 Demand 8 Warehouse 1 $4,000 $2,000 $3,000 $2,500 $4,500 9 Warehouse 2 $2,500 $2,600 $3,400 $3,000 $4,000 18 10 Warehouse 3 $1,200 $1,800 $2,600 $4,100 $3,000 14 11 Warehouse 4 $2,200 $2,600 $3,100 $3,700 $3,200 20 13 14 Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 15 Fixed Cost # # # # ### ####### ####### #HHHHH# ####### 16 Capacity 20 22 17 19 18 17 18 19D15 X fx 17000 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB Plant Decision A company currently ships its product from 5 plants to 4 warehouses. It is considering closing one or more plants to reduce cost. What plant(s) should the company close, in order to minimize transportation and fixed costs? 6 Transportation Costs (per 1000 products) Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 Demand 8 Warehouse 1 $4,000 $2,000 $3,000 $2,500 $4,500 1: 9 Warehouse 2 $2,500 $2,600 $3,400 $3,000 $4,000 18 10 Warehouse 3 $1,200 $1,800 $2,600 $4,100 $3,000 14 11 Warehouse 4 $2,200 $2,600 $3,100 $3,700 $3,200 20 13 14 Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 15 Fixed Cost ####### ####### #######\\####### |####### 16 Capacity 20 22 17 19 18 17 19E15 X v fx 13000 B D E G H K L M N O P R S T U V W X Y Z AA AB Plant Decision 2 A company currently ships its product from 5 plants to 4 warehouses. It is considering closing one or more plants to reduce cost. What plant(s) should the company close, in order to minimize transportation and fixed costs Transportation Costs (per 1000 products) Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 Demand Warehouse 1 $4,000 $2,000 $3,000 $2,500 $4,500 15 9 Warehouse 2 $2,500 $2,600 $3,400 $3,000 $4,000 18 Warehouse 3 $1,200 $1,800 $2,600 $4,100 $3,000 14 11 Warehouse 4 $2,200 $2,600 $3,100 $3,700 $3,200 20 13 14 Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 15 Fixed Cost # # # # # # # # # ##### ####### #######\\####### 16 Capacity 20 22 17 19 18 17 19F15 X V fx 16000 B C D E F G H I J K L M N P Q R S T U V W X Y Z AA AB Plant Decision 2 A company currently ships its product from 5 plants to 4 warehouses. It is considering closing 3 one or more plants to reduce cost. What plant(s) should the company close, in order to minimize transportation and fixed costs? Transportation Costs (per 1000 products) Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 Demand Warehouse 1 $4,000 $2,000 $3,000 $2,500 $4,500 9 Warehouse 2 $2,500 $2,600 $3,400 $3,000 $4,000 18 10 Warehouse 3 $1,200 $1,800 $2,600 $4,100 $3,000 14 11 Warehouse 4 $2,200 $2,600 $3,100 $3,700 $3,200 20 13 14 Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 15 Fixed Cost 16 Capacity 20 22 17 19 18 17 18 20A company currently ships products from 5 plants to 4 warehousesi The company is considering the option of closing down one or more plants. This would increase distribution cost but perhaps lower overall cost. What plants, if any, should the company close? Describe the decision variables Describe the logical objective Describe the logical constraints Develop the mathematical model ( objective function and constraints) solve the problem using the \"Plant" worksheet and the Excel \"Solver"