Considering opening warehouses in four cities

Assignment Help Operation Management
Reference no: EM131441107

A company is considering opening warehouses in four cities: New York, Los Angeles, Chicago, and Atlanta to serve three different demand regions. Each warehouse can ship 100 units per week. The weekly fixed cost of keeping each warehouse open is $400 for New York, $500 for Los Angeles, $300 for Chicago, and $150 for Atlanta. Region 1 of the country requires 80 units per week, region 2 requires 70 units per week, and region 3 requires 70 units per week. The cost (including production and shipping costs) of sending one unit from a plant to a demand region is shown in the following table. To From Region 1 Region 2 Region 3 New York $20 $40 $50 Los Angeles $48 $15 $26 Chicago $26 $35 $18 Atlanta $24 $50 $35 The company wants to meet weekly demands at minimum cost, subject to the following additional restrictions: 1. If the New York warehouse is opened, then the Los Angeles warehouse must be opened. 2. At most two warehouses can be opened. 3. Either the Atlanta or the Los Angeles warehouse must be opened. Formulate a mixed-integer linear program IN EXCEL to determine which warehouses to open and how to service demand at a minimum total cost.

Reference no: EM131441107

Questions Cloud

Pay for perfect market research : A plant manager wants to know how much he should be willing to pay for perfect market research. Currently there are two states of nature facing his decision to expand or do nothing. Under unfavorable market conditions the large plant would lose $50,0..
Difference between extrinsic and intrinsic rewards : Please explain why you think that learning how to better motivate people is such a skill? In addition, please explain the difference between extrinsic and intrinsic rewards/recognition and indicate which you think is more effective in motivating peop..
Current customer service trend is offering : A current customer service trend is offering same-day transportation. Please describe how transportation services within a supply chain would need to be reconfigured to support this performance and whether you believe it would be economically viable.
Considering opening warehouses in four cities : A company is considering opening warehouses in four cities: New York, Los Angeles, Chicago, and Atlanta to serve three different demand regions. Each warehouse can ship 100 units per week. The company wants to meet weekly demands at minimum cost, sub..
Minimizes sum of operating costs-passengers time costs : An urban bus route has a patronage of 500 passengers/h and a cycle time of 2.5 h. It is operated with buses having a seating capacity of 50 passengers. Determine the capacity headway, the headway that minimizes the sum of operating costs and passenge..
Additional information systems-related reasonable assumption : Two years ago, Susie Hernandez knitted a pink sweater for her poodle and posted it on Instagram. The picture of the snarling beast in its cute sweater went viral and orders for similar sweaters poured in. In addition to the information provided in th..
Supplier extra to use her as part of a hybrid strategy : For the Supply Chain Management solutions 6th edition, problem set 2cs, what is the correct answer to #3, What do you think of the hybrid approach? Is it worth it paying the local supplier extra to use her as part of a hybrid strategy?
Pros and cons of outsourcing information systems development : Research, analyze, and discuss the pros and cons of outsourcing information systems development. What issues should management consider when making the decision to outsource?

Reviews

Write a Review

Operation Management Questions & Answers

  What volume of output would two locations have same cost

A small producer of machine tools wants to move to a larger building, and has identified two alternatives. Location A has annual fixed costs of $115,000 and variable costs of $9,000 per unit; location B has annual fixed costs of $315,000 and variable..

  Advantage of forming strategic alliance with competitor

What is the advantage of forming a strategic alliance with a competitor or supplier?

  Basic household goods-groceries-health and beauty products

You currently work for a retail store that carries basic household goods, some groceries and health and beauty products. The store is located in a small community (approximately 5,000 total residents) in which you live and is looking to expand its op..

  Discuss several characteristics of communication

Luthans and Doh (2012) discuss several characteristics of communication. More specifically, they discuss verbal communication styles. For this question, describe your own verbal communication style by using the major characteristics listed by Luthans..

  Demonstrate what type of legal or political information

Pick a country of your choice and demonstrate what type of legal or political information you would have to collect to be able to advertise a product within the country. You may pick any kind of product for your example and you may consider any media..

  Expalin premium goods also services for premium price

In your judgement, also from an ethical point of view, should turner contraction also or B&C steel pay for all or part of $2428000 explain your view.

  Putting human resources at the heart of cyber security

Putting human resources at the heart of cyber security The UK government considers cyber security as a tier-one national security priority alongside international terrorism, with an annual cost of around £27 billion. Yet research shows that 96 per ce..

  Provide a brief summary of the facts

Provide a brief summary of the facts and discuss the standards that were used in determining that a breach had occurred. Also discuss whether you agree or disagree with the findings.

  Macro-economic-cultural-financial and political variables

Select one of the BRIC countries. Outline and organize a list of macro-economic, cultural, financial and political variables you would need to check before considering a foreign investment in such a country. Limit your list to approximately 20 variab..

  Identify factors contributing to rising cost of health care

Identify the factors contributing to the rising cost of health care. When did rising health care costs become an issue? Why are health care costs continuing to rise? What can be done to address this issue?

  Discuss the advantages and disadvantages of automation

Briefly describe the FIVE process types, and indicate the kinds of situations in which each would be used. Briefly discuss the advantages and disadvantages of automation. Briefly describe computer-assisted (CAD) approaches to production.

  Business market using the characteristics indentified

Describe your business market using the characteristics indentified in your text. Think about yourself and how you would describe yourself using these characteristics if you were a buyer for your company. Are there other characteristics that you coul..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd