Question 1: The supply capacities at each origin (factory) and demand at each destination (warehouse) are shown and the cost information is given as follows. Cost Information: Factory 1 2 3 Demand Question 2 SUPPLY CHAIN MANAGEMENT Assignment 1 1 4 12 8 80 Washington Oregon California Idaho Nevada Warehouse 2 730 10 90 Los Angeles 150 150 75 150 100 3 7 8 16 120 4 1 8 5 160 Please generate the conceptual model and excel model to decide the optimal transportation decisions. Supply SC Consulting, a supply chain consulting firm, must decide on the location of its home offices. Its clients are located primarily in the 5 states listed below. 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,000, Tulsa is $131,000, 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 below. Each consultant is expected to take at most 40 trips each year. 100 200 150 If at most 3 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? Please generate the conceptual model and excel model to answer these questions. Travel cost (S) Tulsa Denver Seattle 250 200 25 250 200 75 200 150 125 200 125 125 200 125 150 Number of trips required 40 35 100 25 40 Tips: The limit number of consultants and the maximal number of the expected trips for each consultant determine the capacity of the home offices in each area. When you get the number of trips assigned to each office, then divided by 40 and you can get the required number of consultants.

Questien 1: The supply capacites at each origin (factory) and demand at each destination (warehouse) are shown and the cost information is given as follows. Please generate the conceptual model and excel model to decide the optimal transportation decisions. Question 2 SC Consulting, a supply chain consulting firm, must decide on the location of its home offices. Its clients are located primarily in the 5 states listed below. There are four potential sites for bome offices: Los Angeles, Tulsa, Denver, and Seattle. The annual fixed cost of locating an office in Los Angeles is $165,000, Tulsa is $131,000, Denver is $140,000, and Seatule is $145,000. The expected number of trips to each state and the travel costs from each potential site are shown below. Each consultant is expected to take at most 40 trips each year. If at most 3 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? Please generate the conceptual model and excel model to answer these questions. Tips: The limit number of consultants and the maximal number of the expected trips for eacb consultant determine the eapacity of the home offices in each area. When you get the number of trips assigened to each office, then divided by 40 and you can get the required number of consultanis