At step 6 where we are using the solver, i did the same and got total different numbers. My total cost is 581.658 etc.? it is in supply chain management Chapter 5, Problem 1E. The Question is A. see pic below.

Here are the pictures and cheggs result as the last one.

7 Chapter 5, Problem 1E 32 Bookmarks Show all steps: ( ON $ SC Consulting, a supply chain consulting firm, must decide on the location of its home offices. Its clients are located primarily in the 16 states listed in Table 5-5. There are four potential sites for home offices: Los Angeles, Tulsa, Denver, and Seattle. The annual fixed cost of locating an office in Los Angeles is $165,428, Tulsa is $131,230, Denver is $140,000, and Seattle is $145,000. The expected number of trips to each state and the travel costs from each potential site are shown in Table 5-5. Each consultant is expected to take at most 25 trips each year. a. If there are no restrictions on the number of consultants at a site and the goal is to minimize costs, where should the home offices be located and how many consultants should be assigned to each office? What is the annual cost in terms of the facility and travel? Los Angeles Seatle Jumber of Trip 200 200 75 150 Travel Costs ($) Tulsa Denver 250 250 200 150 200 200 175 150 100 State 3 Vashington 4 Oregon California Idaho Nevada 8 Montana 9 Wyoming 10 Utah 11 Arizona 12 Colorado 13 New Mexico 14 North Dakota 15 South Dakota 16 Nebraska 17 Kansas 18 Oklahoma 13 Annual fixed cost 200 125 300 200 300 150 125 125 175 100 75 250 250 300 200 200 250 300 300 145000 250 250 250 165428 125 140000 131230 Los Angeles Tulsa Denver Seatle State Select(Y/N) W 22 23 Jumber of Trip 250 26 27 N 20 M 29 WY 30 U 31 A 32 CL 33 NM 34 ND 35 SD 36 N 37 KN 38 OK 39 40 Number of trips 41 Number of consultan 42 Total Fixed cost 43 Travel cost 44 Total cost 0 000 0 0 0 #VALUE! #VALUE! #VALUE! #VALUE! Solver Parameters Set Objective: SBS44 To: O Max Min O Value of: O By Changing Variable Cells: SB$23:SE$38 Subject to the Constraints: $B$23:$E$38 = integer $F$23:$F$38 = SF$3:$F$18 Add Change Delete Reset All Load/Save Make Unconstrained variables Non-Negative Select a Solving GRG Nonlinear Method: Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. Help [ Solve close Los Angeles Denver Seatle State Select (Y/N) 1 Number of Trips 40 ooooo cocco WBA- 14 10 Number of trips 31 Number of consultans E2 Total fixed cost 3 Travel cost 34 Total cost 164 164 165.428 4.875.000 581.658 166 166 131.230 875.000 171 171 140.000 3.500.000 174 174 145.000 1.050.000 1 DV SL Number of States Select (YN) W O C 40 100 0 0 25 0 15 40 0 10 M WY 30 A 0 CL 1 65 40 0 0 0 0 0 NM L ND 30 SD 20 30 0 0 N KN OK 0 0 55 0 40 Number of trips 41 Number of consultants 42 Total fixed cost 43 Travel cost 44 Total cost S 165,428 15,250 633,783 $ $ 131,230 S 7,075'S 140,000 $ 21,175'S 145,000 8,625 From the above results, the Consulting Company should assign 8, 5, 10, and 5 consultants to the states LA, TL, DV, and SL respectively. Thus, the annual total cost in terms of facility and travel remain unchanged at $633,783)