NEED THIS DONE BY TODAY 10pm at MAX.
SC consulting, a supply chain consulting firm, has to decide on the location of its home offices. Their clients are
primarily located in the 16 states in Table 1 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,428, Tulsa is
$131,230, Denver is $140,000 and Seattle is $145,000. The expected numbers of trips to each state and the
travel costs from each potential site are also shown in Table 1. Each consultant is expected to take at most 25
trips each year.
1. If there are no restrictions on the number of consultants at a site and the goal is to minimize costs:
? Construct the mathematical model for this setting.
? Find out where the home offices should be located using MS Excel Solver.
? How many consultants should be assigned to each office?
? What is the annual cost in terms of the facility and travel?
2. If at most 10 consultants are to be assigned to a home office and the goal is to minimize costs:
? Construct the mathematical model for this setting.
? Find out where the home offices should be located using MS Excel Solver.
? How many consultants should be assigned to each office?
? What is the annual cost in terms of the facility and travel?
3. If all consulting projects out of a given state should be assigned to exactly one home office (i.e., cannotbe partially done by an office and completed by another):
? Construct the mathematical model for this setting.
? Find out where the home offices should be located using MS Excel Solver.
ScholarMatic | 24/7 Homework Help
ScholarMatic Will Help You Write Your Essays and Term Papers
Answered » You can buy a ready-made answer or pick a professional tutor to order an original one.
Supply chain optimization – Capacitated Plant Location Model
How fast can you do this? I need it done today, money is not an issue as long as I get this by today 10pm at the maximun.
Document Preview:
HOME TO CERTIFIED WRITERS

Why Place An Order With Us?
- Certified Editors
- 24/7 Customer Support
- Profesional Research
- Easy to Use System Interface
- Student Friendly Pricing
Have a similar question?
ScholarMatic: Get Started
Assignment Writing Service
Feel safe and secure when placing an order on our portal!
Fruitful cooperation begins with solid guarantees, and we are professional enough to promise perfect results. Let’s get it started!




