You are planning your project selection for the next year. Potential projects are classified in three...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are planning your project selection for the next year. Potential projects are classified in three types: New, Remake, and Extension. You have gathered different information for these projects and summarized it in the table below: Project A B C D E F G Profit $150,000 $90,000 $60,000 $80,000 $30,000 $40,000 $160,000 Cost $350,000 $165,000 $100,000 $60,000 $70,000 $240,000 $400,000 Туре New Remake New Remake New Extension Extension Risk of failure Low Low Medium Low Medium Low Medium You would like to satisfy the below conditions: A budget of $1,000,000 Include at least one of each project type. • Do not include more than one project with a medium risk of failure, if any. Project C requires input from Project D to be completed, so if Project D is selected, then Project D must also be selected. • Select only one of the high cost / high profit projects (i.e., A or G) Formulate an IP model that will assist you in selecting which projects to select such that profits are maximized. (Do not solve using excel solver). 1 1 You are planning your project selection for the next year. Potential projects are classified in three types: New, Remake, and Extension. You have gathered different information for these projects and summarized it in the table below: Project A B C D E F G Profit $150,000 $90,000 $60,000 $80,000 $30,000 $40,000 $160,000 Cost $350,000 $165,000 $100,000 $60,000 $70,000 $240,000 $400,000 Туре New Remake New Remake New Extension Extension Risk of failure Low Low Medium Low Medium Low Medium You would like to satisfy the below conditions: A budget of $1,000,000 Include at least one of each project type. • Do not include more than one project with a medium risk of failure, if any. Project C requires input from Project D to be completed, so if Project D is selected, then Project D must also be selected. • Select only one of the high cost / high profit projects (i.e., A or G) Formulate an IP model that will assist you in selecting which projects to select such that profits are maximized. (Do not solve using excel solver). 1 1
Expert Answer:
Related Book For
Practical Management Science
ISBN: 978-1305250901
5th edition
Authors: Wayne L. Winston, Christian Albright
Posted Date:
Students also viewed these general management questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
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...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
Products are 1. Lip gloss or lipstick with SPF 2. Custom facial sheets you can make online or in store pickup and have it send to your home based on your needs 3. A foundation sunscreen Price Provide...
-
Installment and cost recovery methods of income recognition. During the year ended December 31, 2007. Boeing sold a jet to the chief executive officer (CEO) of a local bank for $72 million; assume...
-
Find the area of a square as a function of its perimeter.
-
Texas Inpatient Consultants, LLLP, is a partnership that employs physicians to deliver medical care to hospitalized patients of other physicians. Texas Inpatient recruited Julius Tabe, M.D., to work...
-
Trendy Toes, Co., produces sports socks. The company has fixed costs of $95,000 and variable costs of $0.95 per package. Each package sells for $1.90. Requirements 1. Compute the contribution margin...
-
If taxpayers rent their second home out for up to 14 days per year, they can _______. Unset starred question Avoid paying taxes on the rental income Deduct employment income from taxes Join a...
-
Assume you have an graph as following. Use Dijkstra Algortihm to calculate shortest path from vertex A to every vertex (manuel calculation). Write the Dijkstra code to generate this graph and find...
-
5. As a financial manager of Mango PLC your task is to analyze all financial decisions of the firm. According the financial statements, Mango revenues last year reached 1,500 mln, operating costs...
-
Question 2 (2 points) If you borrow $39,802 at a simple interest rate of 9% for 11 year(s) the total amount you will owe is (round answer to 2 decimal places): Your Answer:
-
Why are dress code policies important to have in place in small companies?
-
What kind of training did you receive? Was it effective? Did you use your new knowledge at work or at school?
-
$80,000 is borrowed at 4% compounded monthly with regular monthly payments fully amortizing over 30 years. What is the monthly payment?
-
To determine his net worth, Adam has gathered information on all of his assets and liabilities. He has $6,240 in household assets, $850 in liquid assets, and Series EE bonds currently worth $825....
-
Paul Duggan is the manager of a software development section. On Tuesday at 11 a.m. he and his fellow section heads have a meeting with their group manager about the staffing requirements for the...
-
Problem 3.5 (4 points). We will prove, in steps, that rank (L) = rank(LT) for any LE Rnxm (a) Prove that rank (L) = rank (LTL). (Hint: use Problem 3.4.) (b) Use part (a) to deduce that that rank(L) =...
-
Consider the exponential curve y = 1000e 0.014x . Calculate y when x = 5; when x = 10; and when x = 20. For each of these values of x, find the percentage change in y when x increases by one unit....
-
The Amorco Oil Company controls two oil fields. Field 1 can produce up to 20 million barrels of oil per day, and field 2 can produce up to 15 million barrels of oil per day. At field 1, it costs...
-
In Example 11.3, suppose you want to run five simulations, where the probability of passing inspection is varied from 0.6 to 1.0 in increments of 0.1. Use the RISKSIMTABLE function appropriately to...
-
What makes channel stuffing illegal by comparison to a car dealership that runs mega end-of-year sales?
-
How would an audit not catch missing cash amounts of this magnitude?
-
While Al Capone was clearly the leader of his organization and benefited extensively, what enticed others to participate in his illegal activities?
Study smarter with the SolutionInn App