Assume the fixed costs of offices exist regardless if open or closed. The decision variables (the optimal solution) are located in the blue shaded cells.To complete H5A, determine 1) where the offices should be set up, 2) how many consultants should be assigned to each office, and 3) the annual cost of this network,separately for each of the following two scenarios by modifying the model/constraints in Solver: a. the cost from Denver to Kansas drops to $60/trip b. no office can be set up in Tulsa, but the fixed cost of the Tulsa office remains fixed at $131,230.

State Total # of Trips from Cost from Trips from Cost from Trips from Cost From Trips from Cost from trips LA LA Tulsa Tulsa Denver Denver Seattle Seattle Demand Constrain Washington 40 0 150 0 250 0 200 40 25 0 Oregon 35 0 150 0 250 0 200 35 75 0 California 100 100 75 0 200 0 150 0 125 0 Idaho 25 0 150 0 200 0 125 25 125 0 Nevada 40 40 100 0 200 0 125 0 150 0 Montana 25 0 175 0 175 0 125 25 125 0 Wyoming 50 0 150 0 175 50 100 0 150 0 Utah 30 0 150 0 150 30 100 0 200 0 Arizona 50 50 75 0 200 0 100 0 250 0 Colorado 65 0 150 125 65 25 0 250 0 New Mexico 40 0 125 0 125 40 75 0 300 0 North Dakota 30 0 300 0 200 30 150 0 200 0 South Dakota 20 0 300 0 175 20 125 0 200 0 Nebraska 30 0 250 30 100 0 125 0 250 0 Kansas 40 250 40 75 0 75 0 300 0 Oklahoma 55 0 250 55 25 0 125 0 300 Assuming 2 consultant # of trips # of Consultants Fixed Cost of office ($) 190 125 235 125 8 5 10 5 165,428 Cost of Trips ($) Total Office Cost ($) 15,250 131,230 7,375 140,000 145,000 19,625 9,875 Solver to minin total cost of ne 180,678 138,605 159,625 Fixed cost+cost of Total System Cost ($) trips 154,875 H5a: Thorou accurately m 633,783 open or close Decision Variables in Blue 1) where the 3) the annua a. the c b. no of