XYZ Industries, a leading manufacturer of car components, is considering locating several new assembly plants in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
XYZ Industries, a leading manufacturer of car components, is considering locating several new assembly plants in the Southwest. These new plants must have a combined production capacity of at least 450,000 units per year and have a combined operating cost that does not exceed $7.5 million per year. The selection team has narrowed the list to four sites in four cities. The management has established a construction cost limit of $45 million for the project. This money will be used to build the combination of plants that provides the maximum yearly profit. Any one of three different-sized plants can be built on the site in City 1, but only one size plant can be built on each of the other sites. All estimates of production capacity, yearly operating cost, yearly profit and construction cost are as follows: Plant Site Production Capacity Operating Cost Yearly Profit Location (S/year) (S/year) City 1 Size 1 Size 2 Size 3 City 2 City 3 City 4 (units/year) 250,000 225,000 200,000 200,000 200,000 225,000 4,000,000 3,500,000 3,000,000 3,000,000 2,500,000 3,000,000 400,000 350,000 300,000 325,000 325,000 275,000 Construction Cost (S) 25,000,000 22,000,000 19,000,000 22,000,000 20,000,000 23,000,000 (a) (15 points) Develop an integer programming formulation to maximize the total yearly profit. Define your decision variables clearly. (b) (10 points) Solve the model you developed in part (a) using OpenSolver and report the optimal solution. Upload the excel file as well when uploading your solutions. (Hint: Optimal objective function value is $725,000) XYZ Industries, a leading manufacturer of car components, is considering locating several new assembly plants in the Southwest. These new plants must have a combined production capacity of at least 450,000 units per year and have a combined operating cost that does not exceed $7.5 million per year. The selection team has narrowed the list to four sites in four cities. The management has established a construction cost limit of $45 million for the project. This money will be used to build the combination of plants that provides the maximum yearly profit. Any one of three different-sized plants can be built on the site in City 1, but only one size plant can be built on each of the other sites. All estimates of production capacity, yearly operating cost, yearly profit and construction cost are as follows: Plant Site Production Capacity Operating Cost Yearly Profit Location (S/year) (S/year) City 1 Size 1 Size 2 Size 3 City 2 City 3 City 4 (units/year) 250,000 225,000 200,000 200,000 200,000 225,000 4,000,000 3,500,000 3,000,000 3,000,000 2,500,000 3,000,000 400,000 350,000 300,000 325,000 325,000 275,000 Construction Cost (S) 25,000,000 22,000,000 19,000,000 22,000,000 20,000,000 23,000,000 (a) (15 points) Develop an integer programming formulation to maximize the total yearly profit. Define your decision variables clearly. (b) (10 points) Solve the model you developed in part (a) using OpenSolver and report the optimal solution. Upload the excel file as well when uploading your solutions. (Hint: Optimal objective function value is $725,000)
Expert Answer:
Answer rating: 100% (QA)
a Integer Programming Formulation Lets define the decision variables as follows x 1 number of Size 1 ... View the full answer
Related Book For
Principles of Information Systems
ISBN: 978-0324665284
9th edition
Authors: Ralph M. Stair, George W. Reynolds
Posted Date:
Students also viewed these finance questions
-
A user is "having problems" with their WI-Fi internet connection. In your discussion, propose at least three questions you might ask them to narrow down their issue. Then, explain why you would ask...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Mike has the following monthly information: Salary $4,000 Rent 1,800 700 Car payment Investment Income 200 Meals 900 Groceries 700 Student Loan Payment 400 Other Expenses 600 1. What is Mike's...
-
If air resistance can be ignored, how does the acceleration of a ball that has been tossed straight upward compare with its acceleration if simply dropped?
-
How do you suppose that higher tax rates have affected the inventive for Greek residents to engage in tax avoidance, or legally reducing tax liabilities, including earning less income that is...
-
Discuss the pros and cons of a 360 - degree evaluation of the chief executive s performance.
-
Daves Restaurant is a chain that employs independent evaluators to visit its restaurants as customers and assess the quality of the service by filling out a questionnaire. The company evaluates...
-
(LO9.4,LO9.9) On 3 May 20XI, Rav Corp.purchased land for $1.65 million. The company uses the revaluation model for its land. Assume that the land is revalued annually. The fair value of the land at...
-
A taxpayer, who is a lifelong resident of Texas, joins the military at age 21. While stationed in New York, the taxpayer meets and marries a teacher from New Jersey. They both lived in New York al of...
-
Apu has decided to start selling pizza at the Kwik-E-Mart. He recently purchased a pizza oven from Springfield Supply. The sticker price was $15 000 and the delivery charge (which the Kwik-E-Mart had...
-
For the last 2 years sales and profits are as follows: Rs. Rs. 2009 sales 5,00,000 profit - 40,000 2010 sales 6,00,000 profit - 60,000 Calculate P/V ratio, BEP sales, sales to get a profit of Rs....
-
Let f(x)=xe and f(") (x) be the nth derivative of f with respect to x. If f(10)(x)=(x+n) e*, what is the value of n?
-
Walmart is the most common low-active price strategy company. They use this approach to focus on offering everyday low prices. The main advantage of this strategy is that it is simple for the company...
-
Explain how removing water would affect the earth in terms of its hydrosphere, biosphere, and society Relate answer to the impacts of removing water by the three points using cause and effect language
-
Use in calculating NPV for a cash inflow project: The management of Fine Electronics Company is considering to purchase an equipment to be attached with the main manufacturing machine. The equipment...
-
Jimmy invests $15,000 in an account that pays 6.07% compounded quarterly. How long (in years and months) will it take for his investment to reach $22,000? years and months (Round the answer for...
-
What are some of the possible sources of information about a company that could be used for determining the companys competitive stance?
-
To improve service to their customers, the salespeople at the video rental store have proposed a list of changes being considered for the database in the previous exercise. From this list, choose two...
-
What is the difference between a data definition language (DDL) and a data manipulation language (DML)?
-
You are the vice president of information technology for a large, multinational consumer packaged goods company (such as Procter & Gamble or Unilever). You must make a presentation to persuade the...
-
The economy of large-scale production _________ new firms from entering a market because high initial average total costs impose heavy losses on new entrants.
-
Because they are mutually interdependent, oligopolists are tempted to get together and agree to act jointly, or to _________, to reduce uncertainty and raise profits.
-
Mutual interdependence means that no firm knows with _________ what its demand curve looks like. The demand curve and the profit-maximizing price and output will depend on how others _________ to the...
Study smarter with the SolutionInn App