User Account

All Pages

Formulate a linear programming (lp) model

Assignment Help Microeconomics
Reference no: EM13915083

1. A company is trying to design its supply chain network in the United States. They are thinking about three possible locations for their warehouses in Denver, Memphis, and Richmond. They have three major markets at New York City, Los Angles and Chicago. If the company decides to have a warehouse at one location, there will be a fixed weekly leasing cost and the weekly flow is restricted by a maximum capacity. The following table summarizes data relevant to the location and distribution problem. The numbers in the following table are the transportation costs per unit from each possible warehouse to each market. The last two columns show the supply capacities and the fixed weekly leasing cost. The last row shows the weekly demand quantities.

333_table1.png

Formulate an optimization model to solve this problem such that the total cost, including transportation costs from warehouses to markets and fixed warehouse costs, is minimized while demand is satisfied and capacity is not exceeded. Please note that there are four parts for an optimization model: notation (decision variable definition), objective function, constraints, and sign restrictions. Please use all numbers in the table rather than define parameters.

a. Formulate a linear programming (LP) model to solve this problem

b. Please use the Excel Solver to solve your model. Please include the spreadsheet in your submission.

Reference no: EM13915083

Questions Cloud

Onus is on the senders of messages. : How well do you respond to honest feedback from someone who sent it? What are some ways in which senders might receive feedback from their messages? How might this feedback affect the sender and the message? Why is this important?
How would you apply confidence intervals : Summarize what the case is about, and what the variables represent. How would you apply confidence intervals? How would you apply hypothesis testing
Why the lcm rule resulted in a write-down in the first year : Explain why the LCM rule resulted in a write-down in the first year. What is the inconsistency between the first- and second- year treatments of the change in the price of oil?
Resistance of the shunt field : Explain the difference in the resistances found for the shunt field, series field, and armature circuits. In particular, why is the resistance of the shunt field so different from the resistances of the armature and series field?
Formulate a linear programming (lp) model : Formulate an optimization model to solve this problem such that the total cost, including transportation costs from warehouses to markets and fixed warehouse costs, is minimized while demand is satisfied and capacity is not exceeded.
Studying the steps of the communication process : Which step in the communication process do you consider to be the most important? Why do you think this? Which of these steps is the most uncomfortable for you? Why is this? How might you work to change this?
Risk assessment-mitigation strategy for a fictional airport : Creation of a risk assessment and mitigation strategy for a fictional airport that includes four distinct organizations. Based on a provided scenario, you will develop a report for the management team that includes personnel recommendations for IT..
Indulge your inner gadget geek : How has technology changed the communication process? Has technology changed the way people communicate in business? Provide at least two examples, whether of gadgets, software, other technologies, or a combination of technologies
Why do you suppose exxonmobil''s management chooses to use : Why do you suppose ExxonMobil's management chooses to use the LIFO inventory method? On what economic conditions, if any, do those reasons depend?

Reviews

Write a Review

Microeconomics Questions & Answers

  Briefly describe the business logics model

What is performance technology and briefly describe the business logics model

  Given the mpc of 8 if equilibrium level of aggregate

given an mpc of .8 if the equilibrium level of aggregate expenditure is 80 billion and there is a reduction in

  Suppose the own price elasticity of demand for good

Suppose the own price elasticity of demand for good X is -4, its income elasticity is 3, its advertising elasticity is 4, and the cross-price elasticity of demand between it and good Y is 4. Determine how much the consumption of this good will change..

  Is the good in question standardized

Choose a market for a good in your area that seems to be a perfectly competitive market. Write four or five substantive paragraphs that describes the market and answers the following questions: Identify the buyers and sellers as well as the goods o..

  Why you believe it will work using the information you found

Government is known to utilize a product's elasticity measures to set taxes and subsidies. Use this information to set policy on one of the following products: tobacco products, petroleum products, agriculture products, or medical products according ..

  The causes of inflation

Which is the considered a cause of inflation. Producers raise prices to meet higher costs,There is not enough money in the economy or else.

  Does economic growth ensure all members of a society will

Why is U.S. economic growth important to the average American and what is the best way to measure standard of living of the average person: (use unemployment rate, inflation, & GDP in your answer)?

  Two fiscal policy options

Which of the following changes to fiscal stimulus package of 2009 for $862 billion (under the bill called American Recovery and Reinvestment Act of 2009) would have a larger overall impact on AD? Explain your answer with credible logic and analysi..

  Discuss the importance of the consumers role in the ecoonmy

Financial markets make it possible for those who have saved money to earn a reward by providing the financing for business formation and expansion. Business owners can seek financing through the stock market, the bond market, or the banking sector..

  Find which are stock variables and which are flow variables

Describe the difference between "stock variables" and "flow variables" in macroeconomic models. Of the following variables: aggregate income, aggregate wealth, aggregate investment, the aggregate money supply, government budget deficit, and govern..

  What are the levels of short run output

According to Okun's law, what unemployment rates would we expect to see in this economy? b. Consider another economy in which the unemployment rate over the next three years is 6%, 7%, and then 4%. According to Okun's Law, what are the levels of s..

  What is the sellers expected revenue from the auction

A seller knows that there are two bidders for the object she is selling. She believes that with probability 1/2, one has a buyer value of £5 and the other has a buyer value of £10 and, with probability 1/2, one has a buyer value of £8 and the other h..

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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