Did I do this question correctly? If not please show where I went wrong and how to fix it.

Question: A truck must travel from New York to Los Angeles. As shown in Figure 5.44, several routes are available. The number associated with each arc is the number of gallons of fuel required by the truck to traverse the arc. Determine the route from New York to Los Angeles that uses the minimum amount of gas.

** part Function 832 LA Neville 10 Dalm 11 264 i AutoSum Recently Financial Logical Used : x fx A Traveling from New York LA Labeling of de Los Ange City Gallons a Ready . 12 PLA PS-43 Org - PS-62 Formulas W Destination ACERDIEDER ST5,2 Data 28 Date&Lookup & Math & Time Reference Kule Anderson SE/UCLA na Review W View Functions More SolverTable for Mac M04, Colbert Tell me De Usein m Manager Create mo Name Bow ROUND 2 4 S o Node ce Dep LAMBE A 160 Mak Show Ferma Checking BUICKS. Damien Inglis SEFrance M & P C N Tue Jun 28 3:54 PN 9 Shere B 1 Traveling from New York to LA 2 3 Labeling of nodes 4 City 5 New York 6 Cleveland 7 St. Louis 8 Nashville 9 Phoenix 10 Dallas 11 Salt Lake City 12 Los Angeles 13 14 Network formulation 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Origin 1 1 1 2 2 3 3 4 4 fx 5 6 6 6 7 Index 1 2 3 4 5 6 7 8 Destination 2 3 4 5 6 5 6 6 7 8 5 7 8 8 30 31 Gallons used 2450 12 Route: New York St Louis-Phoenix-LA 33 34 35 C Gallons 400 950 800 1800 900 1100 500 600 1200 400 500 1000 1300 600 D Flow 0 1 0 0 0 1 0 0 10 0 O 0 Reference Node balance constraints Node 1 2 3 4 5 6 Trig 7 8 More Functions G Net inflow/outflow 1 0 0 0 0 0 1 0 Name Manager ***.... . H Required 1 0. 0 0 0 O Use in Formula Create from Selection 0 1 K ecedents Trace Dependents Remove Arrows Formulas C Show L M N 5 must be at least $85,000 for students of each school. Each school must have at least 10% minorities. Determine an optimal assignment of students to schools. Then provide a one-paragraph summary of how the optimal solution changes as the required minority percentage varies from 5% to 11%. Figure 5.44 Network for Truck Problem New York 400 950 800 Cleveland 1800 St. Louis Nashville 1100 600 600 1200 Site 1 can process 10,000 checks per day, and site 2 has two check-processing sites. can process 6000 checks per day. The bank processes three types of checks: vendor, salary, and personal. The processing cost per check depends on the site, as listed in the file P05_47.xlsx. Each day, 5000 checks of each type must be processed. Develop a network model to determine how to minimize the daily cost of processing checks. 900 268 Chapter 5 Network Models his part the s Copyright 2018 Compage Loaning. All Righs Bed May be copied, and, or de le has deed that any mpcially at the main experien Cape Lig Phoenix 900 Dallas 1000 Salt Lake City 400 1300 600 Los Angeles 268 /824 >