A soda company owns three factories and supplies to four cities: Dallas, TX; Fort Worth, TX; Oklahoma City, OK; and Tulsa, OK. The shipping costs per truckload together with the annual output of each factory and the annual demand of each city are given in transportation soda data.xlsx.
Demand and output are both in units of truckloads.
Suppose that you are asked to determine the optimal shipping plan to minimize the total transportation cost, while exactly meeting the demand of each city, and not exceeding the capacity of any of the plants.
Which constraints are binding at the optimal solution, and how can you tell?
Sign in transportation_soda_data (B – Protected View – Excel AutoSaveO File Home Insert Page Layout Formulas Data Review View Help lell me what you want to do PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit its safier to stay in Protected view. Enable Editing 83 Cost (S/Truckload) Factory 1 Factory 2 Factory 3 2 Dallas, TX 3 Fort Worth, TX 4 Oklahoma City, OK 5 Tulsa, OK 6 Annual Output 300 650 450 480 520 690 360 1130 390 315 280 250 660 780 420 Annual Demana 400 280 315 135 + 295% 厤E匹- Data 49 9/19/2018 Type here to search