Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

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 hom

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.

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 ($)

Los Angeles Tulsa Denver Seattle Number of trips required

Washington 150 250 200 25 40

Oregon 150 250 200 75 35

California 75 200 150 125 100

Idaho 150 200 125 125 25

Nevada 100 200 125 150 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.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

DISCUSSION Most managers believe that while it is possible to connect logistics decisions to costs, the connection to revenue enhancement is difficult to impossible. Do you agree or disagree? Why? To

DISCUSSION Most managers believe that while it is possible to connect logistics decisions to costs, the connection to revenue enhancement is difficult to impossible. Do you agree or disagree? Why? To earn full credit, post an initial response of 500 words that includes at least one APA citation and the

week 4 DISCUSSION “In today’s competitive business environment, effective logistics management is essential to maintaining operational efficiency and customer satisfaction. How do demand management, o

week 4 DISCUSSION “In today’s competitive business environment, effective logistics management is essential to maintaining operational efficiency and customer satisfaction. How do demand management, order management, customer service, inventory management, and facilities location interact to influence a company’s overall logistics performance?  Can you identify a real-world example where optimizing one

WEEK 5 TO DO DISCUSSION The purpose of the discussion question is to allow you to demonstrate your understanding of the unit’s key learning points and how you might apply them in a given situation. Pa

WEEK 5 TO DO DISCUSSION The purpose of the discussion question is to allow you to demonstrate your understanding of the unit’s key learning points and how you might apply them in a given situation. Participating in the discussion question forum provides you with an opportunity to compare your ideas

DISCUSSION Discuss whether corporate cultures are relevant to supply chain management. In your post, ensure to give concrete examples (you may use Starbucks as your example and assess its supply chain

DISCUSSION Discuss whether corporate cultures are relevant to supply chain management. In your post, ensure to give concrete examples (you may use Starbucks as your example and assess its supply chain or you may use another company as an example). To earn full credit, post an initial response of 500

Week 1 to do DISCUSSION Explain how technological advances have contributed to the increased importance of logistics. In your post, ensure to include at least two solid examples showing the impact of

Week 1 to do DISCUSSION Explain how technological advances have contributed to the increased importance of logistics. In your post, ensure to include at least two solid examples showing the impact of technology on your experience as a consumer.  To earn full credit, post an initial response of 500 words

Pick and clearly describe (in about a paragraph) a situation (preferably but not necessarily in business) that requires a decision necessitating a decision tree with at least two branches, each branch

Pick and clearly describe (in about a paragraph) a situation (preferably but not necessarily in business) that requires a decision necessitating a decision tree with at least two branches, each branch having at least two sub-branches. In another paragraph explain and justify the structure of the decision tree you are

Socio-Cultural Considerations Choose a city in another country (outside the United States). Research tourism in that country, and answer the following questions: Give a small synopsis on the history a

Socio-Cultural Considerations Choose a city in another country (outside the United States). Research tourism in that country, and answer the following questions: Give a small synopsis on the history and demographics of the country. What are the socio-cultural considerations for that country? What is the current climate of tourism in

Unit Outcomes: Describe occupational safety and health regulatory organizations such as OSHA.Describe the function and oversight of occupational safety and health organizations.BI100-5: Describe emplo

Unit Outcomes: Describe occupational safety and health regulatory organizations such as OSHA. Describe the function and oversight of occupational safety and health organizations. BI100-5: Describe employer role in addressing safety in the workplace. Purpose For this assignment, you will use the Reflection Template to provide a reflection on what the readings, learning activities,

Unit 9 Assignment: Addressing Workplace Safety ConcernsOutcomes addressed in this activity: Unit Outcomes: Apply lean safety measures to promote safety.Describe the employer’s role in addressing safet

Unit 9 Assignment: Addressing Workplace Safety ConcernsOutcomes addressed in this activity: Unit Outcomes: Apply lean safety measures to promote safety. Describe the employer’s role in addressing safety concerns in the workplace. Present the safety recommendations to address a safety concern. Use appropriate APA formatting and citations in scholarly writing. BI100-5: Describe

****** THIS ASSIGNMENT HAS 6 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** **** HUMANITIES COURSE **** PART 1- Module 6 – DISCUSSION A Comparable Development Pr

****** THIS ASSIGNMENT HAS 6 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** **** HUMANITIES COURSE **** PART 1- Module 6 – DISCUSSION A Comparable Development  Prompt: Pick one of the developments mentioned in The Renaissance or one of the developments mentioned in The Enlightenment. Then think of

Module 3 – SLPHarnessing the Power of Operations and FinanceAssignment Overview Accounting and Finance Strategies We will address organizational performance from a money perspective. How do accounting

Module 3 – SLPHarnessing the Power of Operations and FinanceAssignment Overview Accounting and Finance Strategies We will address organizational performance from a money perspective. How do accounting and finance functions support a company’s goals and help it move forward according to plan? SLP 3 Resources Contribute to an Ethical Culture (2022) DEI

Module 3 – CaseHarnessing the Power of Operations and FinanceAssignment Overview Strategic Management As your final written case of class, it is time to complete all of the connections regarding how

Module 3 – CaseHarnessing the Power of Operations and FinanceAssignment Overview Strategic Management  As your final written case of class, it is time to complete all of the connections regarding how strategy is implemented in an organization and the roles of the stakeholders across functional areas. Case 3 Resources Corporate-Level

Wall Street Journal Article Analysis: You will be required to read and summarize Wall Street Journal (WSJ) articles.Choose. Choose one WSJ article from the Business, Tech, or Markets section to summar

Wall Street Journal Article Analysis: You will be required to read and summarize Wall Street Journal (WSJ) articles. Choose. Choose one WSJ article from the Business, Tech, or Markets section to summarize. Insert the link to the article, before writing your analysis.  Write.  Write one paragraph on 1) What is the article about, 2)