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?

User Account

All Pages