Formulate a mixed-integer linear program

Assignment Help Operation Management

Reference no: EM131855067

Question: 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: EM131855067

Questions Cloud

Analyze which messages change after we update the parameters : Analyze which messages change after we update the parameters for P(Xi| Ui). Use this analysis to show how, after an initial pre-computation step.

Determine a plan of care for the patient using the nursing : Determine a plan of care for the patient using the nursing process Define each of the nursing process and align each step to critical thinking and clinical

What are the consequences of your decision : What are the consequences (positive and negative) of your decision? How do you know? Cite your resources in APA format.

What does that imply about gradient ascent and em starting : Consider learning the parameters of the network H ? X, H ? Y. What does that imply about gradient ascent and EM starting from this point?

Formulate a mixed-integer linear program : 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.

Examine psychological constructs at various stages of health : Using this example, examine the psychological constructs at the various stages of health. Clearly defines key concepts used in their arguments

Provide constraints that achieve the same guarantee : Consider estimating the parameters of a multivariate Gaussian N (µ; S) from a data set D. Provide constraints on S that achieve the same guarantee.

Define advanced practice nursing : Describe the four roles used to define advanced practice nursing and requirements of each.

Clinical and non-clinical master prepared nurse : Differentiate by history, education, and practice, the role differences between the clinical and non-clinical master's prepared nurse.

User Account

All Pages