SC Consulting has to decide on the location of its home offices….

Question Answered step-by-step SC Consulting has to decide on the location of its home offices…. SC Consulting has to decide on the location of its home offices. Their clients are located in the 15 states listed in the table below and there are four potential sites for home offices: Los Angeles, Tulsa, Denver and Seattle. The annual fixed cost of operating 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 also given in the table. Each consultant is expected to take at most 25 trips each year and at most 10 consultants are to be assigned to a home office.  Note: Don’t define the capacity of the offices in terms of consultants, rather define it in terms of total number of trips possible out of an office. Travel Costs per Trip ($) Office LocationLATulsaDenverSeattleNumber of TripsWashington1502502002540Oregon1502502007535California75200150125100Idaho15020012512525Nevada10020012515040Montana17517512512525Wyoming15017510015050Utah15015010020030Arizona7520010025050Colorado1501252525065New Mexico1251257530040North Dakota30020015020030South Dakota30017512520020Nebraska25010012525030Kansas250757530040 Please, solve this problem using Solver in Excel (also upload the xls file) and answer the following questions:a) Where the offices should be set up? b) How many consultants should be assigned to each office? c) What is the annual cost of this network in terms of facility and travel?  Engineering & Technology Industrial Engineering Supply Chain Management BUSINESS 2021 Share QuestionEmailCopy link Comments (0)