(all work in excel please)

SC Consulting, a supply chain consulting firm, must decide on the location of its home offices. Its clients are located primarily in the 9 states listed in Table 1. 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 1. Each consultant is expected to take at most 25 trips each year. The goal is to minimize costs. If 10 consultants are to be assigned to a home office, at most, where should the offices be set up? How many consultants should be assigned to each office? What is the annual cost of this network? o. 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? SC Consulting, a supply chain consulting firm, must decide on the location of its home offices. Its clients are located primarily in the 9 states listed in Table 1. 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 1. Each consultant is expected to take at most 25 trips each year. The goal is to minimize costs. If 10 consultants are to be assigned to a home office, at most, where should the offices be set up? How many consultants should be assigned to each office? What is the annual cost of this network? o. 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