Hi,

BEFORE YOU ANSWER IT PLEASE READ MY NOTES BELOW. THANKS!

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?

b. If, at most, 10 consultants are to be assigned to a home office, where should the offices be set up? How many consultants should be assigned to each office? What is the annual cost of this network?

c. What do you think of a rule by which all consulting projects out of a given state are assigned to one home office? How much is this policy likely to add to cost compared to allowing multiple offices to handle a single state?

-----------------------------------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------------------------------

THE QUESTIONS ABOVE HAVE BEEN ANSWERED ALREADY BY AN EXPERT, BUT THE IMAGES HE SENT ME CONTAINING THE EXCEL FORMULAS ARE BLURRY, SO I CANT SEE. FOR EXAMPLE THIS IMAGE HE SENT IS BLURRY, I CANT SEE THE FORMULAS:

ALSO THE SOLUTION ARE DIFFERENT FROM OTHER WEBSITES LIKE COURSE HERO AND OTHERS, FOR EXAMPLE: for Question A, he has $633,783 as total cost, and also he has all offices opened, whereas other websites have as total cost $219,500 and only one office opened. so how do i know you have the right answers?

PLEASE DON'T COPY AND PASTE THE SOLUTIONS FROM CHEGG LIKE THE OTHER EXPERT DID (IF YOU DON'T KNOW ITS FINE, BUT JUST LET ME KNOW SO I CAN TRY TO DO IT MYSELF BECAUSE I HAVE A DEADLINE TO SUBMIT MY ASSIGNMENT).

MY QUESTIONS ARE TO DO WITH THE

(1) IMAGES BEING BLURRY AND

(2) THE DIFFERENT SOLUTIONS FROM OTHER WEBSITES AND I AM WONDERING HOW CAN I KNOW YOU HAVE THE CORRECT SOLUTIONS.

apie I LIL Table 5-5 Travel Costs and Number of Trips for SC Consulting Travel Costs (5) Tulsa Denver Seattle Number of Trips Los Angeles 150 150 250 40 35 250 75 150 100 200 200 200 200 200 150 125 125 25 75 125 125 150 100 25 40 175 175 125 25 125 100 175 150 50 State Washington Oregon California Idaho Nevada Montana Wyoming Utah Arizona Colorado New Mexico North Dakota South Dakota Nebraska Kansas Oklahoma 150 150 150 100 200 30 200 75 150 125 300 300 50 65 40 125 125 200 175 100 100 25 75 150 125 125 250 250 300 200 200 250 300 300 30 20 30 250 75 75 40 250 250 25 125 55 D TL DN ER FO 1230 200 1390 1900 13 25 135 513 6 12 In B3 IF 1913 19 195 12 11 11 25 120 131 FRO 53 1900 JAN IN 15 IN 125 35 IMO 1. 171 135 14.20 135 11 9 20 21 DN GEOT 24 SUBS IN43 SIRENE -SERYE 25 27 26 29 30 31 Ok. EN IN 35 -103 37 40-50243230 SUMC2)CH SUMDU DI -SUM23 41 ROUNDUP31023 -ROUNDUPLCD25 -ROUNDLAD 23.00 -ROUNDUPLO 25.00 F.132.0 FCCIPC320 DODPD22.00 P2.00 SUNODUCTOS PRODUCTICZECHCICURUCOUTDOODIDINTRODUCTED 41 SUMBA apie I LIL Table 5-5 Travel Costs and Number of Trips for SC Consulting Travel Costs (5) Tulsa Denver Seattle Number of Trips Los Angeles 150 150 250 40 35 250 75 150 100 200 200 200 200 200 150 125 125 25 75 125 125 150 100 25 40 175 175 125 25 125 100 175 150 50 State Washington Oregon California Idaho Nevada Montana Wyoming Utah Arizona Colorado New Mexico North Dakota South Dakota Nebraska Kansas Oklahoma 150 150 150 100 200 30 200 75 150 125 300 300 50 65 40 125 125 200 175 100 100 25 75 150 125 125 250 250 300 200 200 250 300 300 30 20 30 250 75 75 40 250 250 25 125 55 D TL DN ER FO 1230 200 1390 1900 13 25 135 513 6 12 In B3 IF 1913 19 195 12 11 11 25 120 131 FRO 53 1900 JAN IN 15 IN 125 35 IMO 1. 171 135 14.20 135 11 9 20 21 DN GEOT 24 SUBS IN43 SIRENE -SERYE 25 27 26 29 30 31 Ok. EN IN 35 -103 37 40-50243230 SUMC2)CH SUMDU DI -SUM23 41 ROUNDUP31023 -ROUNDUPLCD25 -ROUNDLAD 23.00 -ROUNDUPLO 25.00 F.132.0 FCCIPC320 DODPD22.00 P2.00 SUNODUCTOS PRODUCTICZECHCICURUCOUTDOODIDINTRODUCTED 41 SUMBA