Factory 1 is in McKinney, just north of Dallas, and drivers have been complaining about having to ma

Factory 1 is in McKinney, just north of Dallas, and drivers have been complaining about having to make deliveries from Factory 1 to the Oklahoma cities when there are other deliveries to be made in Dallas and Fort Worth. Because of current conditions in the transportation market, your manager is especially eager to make his drivers happy, as long as it doesn’t cost too much extra. Your manager asks you to determine how much more costly it would be to restrict Factory 1 to deliver only to Dallas and Fort Worth, while Factories 2 and 3 continue to be able to make deliveries to any of the four cities.

With these new constraints added, what is the new optimal shipping plan? What is the new optimal cost? (Hint: the new optimal cost should be higher than the cost without these new constraints.

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

 

Looking for a Similar Assignment? Let us take care of your accounting classwork while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today! Active Discount Code FREE15