CAN U SOLVE IN EXCEL ??

Travel Costs ($) State Los Angeles Tulsa Number of Trips Denver Seattle 150 250 200 25 40 Washington Oregon California 150 250 200 35 75 125 75 200 150 100 Idaho 150 200 125 125 25 Nevada 100 200 125 150 40 Montana 175 175 125 125 25 150 175 100 150 50 Wyoming Utah 150 150 100 200 30 75 200 100 250 50 Arizona Colorado 150 125 25 250 65 125 125 75 300 40 300 200 150 200 30 New Mexico North Dakota South Dakota Nebraska 300 175 125 200 20 250 100 125 250 30 Kansas 250 75 75 300 40 Oklahoma 250 25 125 300 55 b. If 10 consultants are to be assigned to a home office, at most, where should the offices be set up? How many con- sultants should be assigned to each office? What is the annual cost of this network