#4)Don't use the QM program to solve this, please use regular Excel Solver, as shown in the lesson. A company ships cases of baseballs from its factories to its warehouses, then to its retail outlets. The cost or a case to be shipped on each route is given below. How many cases should be shipped on each route 0 minimize cost, exactly meet demand, and satisfy all constraints? Seattle to Dallas route needs a minimum of 1000 cases shipped. Kanas City to Atlanta route can only have a maximum of 1200 units shipped. Cost to ship ($/case): Warehouses Factory Dallas 3 Kansas City 4 Seattle 1 Reno 2 Cost to ship ($/case): Retail Outlets Retail Outlets Warehouse Atlanta 5 Tampa 6 Cleveland 7 Pittsburgh 8 Dallas 3 UI 10 Kanas City 4 12 14 Factory Supply Retail Outlet Demand Seattle 1 1600 Atlanta 5 1500 Reno 2 2000 Tampa 6 600 Cleveland 7 700 Pittsburgh 8 800