Reference no: EM131153083
A company is considering opening warehouses in four cities: New York, Los Angeles, Chicago, and Atlanta. 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 40 units per week. The costs (including production and shipping costs) of sending 1 unit from a plant to a region are 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 We wish to meet weekly demands at minimum cost, subject to the preceding information and the following restrictions:
a) Formulate linear mathematical model to help the company meet the demand at the minimum cost (clearly define your decision variable, objective and constraints.
b) use excel to implement the model and solve it using solver to find the optimal solution. Report your results by including a snapshot of your spreadsheet solution.
c) suppose the following restriction must be satisfied simultaneously
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 these restrictions as constraints that can be added to the model. You do not have to repeat the whole formulation; just list the necessary constraint.
|
Techniques are the most valuable for your strategic plan
: What forecasting tools and techniques are the most valuable for your Strategic Plan? What assumptions are you making?
|
|
Recommended daily order quantity for the supermarket
: A perishable dairy product is ordered daily at a particular supermarket. The product, which costs $1.19 per unit, sells for $1.65 per unit. If units are unsold at the end of the day, the supplier takes them back at a rebate of SI per unit. Assume tha..
|
|
Trouble finding the fashion case studies
: “Over the last fifteen years or so there has been a steadily increasing desire for design to prove its commercial value, to demonstrate to clients that their investment is tangibly worth it.” Design Council 2010 Please discuss how design can prove it..
|
|
Necessary for helping dysfunctional group
: What change skills are necessary for helping a dysfunctional group become more effective and what if the problems exist between managers, is this a scenario you can relate to at your present organization?
|
|
Formulate linear mathematical model
: A company is considering opening warehouses in four cities: New York, Los Angeles, Chicago, and Atlanta. 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..
|
|
Three financial ratios
: Select THREE financial ratios that you feel are important to include in your financial analysis for Walmart, include an explanation of WHAT the ratio represents (i.e. what information does it provide) - AND WHY you feel the ratio is important.
|
|
Congress pass the laws and formulate policies
: "Most people believe that the president or Congress pass the laws and formulate policies based on their perceptions of what the public wants and needs. Often it is the result of research or the pressure of groups and individuals lobbying for or again..
|
|
Understanding culture in global business dealings
: Write a page on how you would promote a brand in a foreign country. Be sure to address cultural variances and advertising opportunities, social networking, and avoidance of blunders. Address the following elements: Describe the importance of understa..
|
|
Does yeast need air to make bread rise
: Does yeast need air to make bread rise? After choosing 1 of the above options (observation and question), you will do some library or Internet research about the subject. Once you have become familiar with the topic.
|