Problem 1. Optimization problem formulation (4 points, Excel not needed) You are the partner of a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Problem 1. Optimization problem formulation (4 points, Excel not needed) You are the partner of a consulting firm. You have five project opportunities in the beginning of the year from four clients A (2 projects), B, C and D. For each project opportunity, you have estimated its professional fees, the probability of winning the project, the consulting staff needed in terms of consultant days, and the level of expertise support needed from experts. The estimates are described in the following table: Opportunity A-P1 A-P2 B-P1 C-P1 D-P1 Professional Fees ($000) 400 500 600 700 1,000 Probability of winning 0.50 0.40 0.35 0.45 0.30 Consulting Staffing Requirement (days) 150 220 240 280 300 Expertise Support Needed (days) 10 5 12 8 10 Your consulting team has a total capacity of 1,000 consultant days and you can get 30 days of the expert's support from the expertise ter. a. Formulate an optimization problem to help you select which project opportunities to pursue to maximize your expected income which is 10% of the total professional fees. Define your variables, show your objective function and the necessary constraints (1 point) b. Suppose project A-P2 is a follow-up project of A-P1, which means you cannot do A-P2 if you don't do A-P1, what constraint do you need to add to the formulation? (1 point) C. If client A and client B are competitors, which means if you do a project for A then you cannot do a project for B and vice versa, what constraint(s) do you need to add? (1 point) d. Suppose that you have only four (4) project managers and each of them can only do one project, what constraint will you need to add to the formulation? (1 point) Problem 1. Optimization problem formulation (4 points, Excel not needed) You are the partner of a consulting firm. You have five project opportunities in the beginning of the year from four clients A (2 projects), B, C and D. For each project opportunity, you have estimated its professional fees, the probability of winning the project, the consulting staff needed in terms of consultant days, and the level of expertise support needed from experts. The estimates are described in the following table: Opportunity A-P1 A-P2 B-P1 C-P1 D-P1 Professional Fees ($000) 400 500 600 700 1,000 Probability of winning 0.50 0.40 0.35 0.45 0.30 Consulting Staffing Requirement (days) 150 220 240 280 300 Expertise Support Needed (days) 10 5 12 8 10 Your consulting team has a total capacity of 1,000 consultant days and you can get 30 days of the expert's support from the expertise ter. a. Formulate an optimization problem to help you select which project opportunities to pursue to maximize your expected income which is 10% of the total professional fees. Define your variables, show your objective function and the necessary constraints (1 point) b. Suppose project A-P2 is a follow-up project of A-P1, which means you cannot do A-P2 if you don't do A-P1, what constraint do you need to add to the formulation? (1 point) C. If client A and client B are competitors, which means if you do a project for A then you cannot do a project for B and vice versa, what constraint(s) do you need to add? (1 point) d. Suppose that you have only four (4) project managers and each of them can only do one project, what constraint will you need to add to the formulation? (1 point)
Expert Answer:
Answer rating: 100% (QA)
a Formulate an optimization problem to help you select which project opportunitie... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
You are the partner on the audit of Datasave, Inc., a small publicly held corporation that manufactures high-speed disk drives for the computer industry. The audit of Datasave had been progressing...
-
You are the partner in charge of management services for a medium- sized public accounting firm. You have contracted with a local manufacturing system to develop a specialized production control...
-
The manager of a consulting firm has asked you to evaluate a database that contains the table structure shown in Table P6.10. Table P6.10 was created to enable the manager to match clients with...
-
What is unrealistic about the domino fault model?
-
Distinguish between certiorari, prohibition, mandamus and a declaration.
-
Which is a better hydraulic cross section for an open channel: one with a small or a large hydraulic radius?
-
El Conquistador, Inc., finances operations with both bonds and stock. Suppose El Conquistador issued \(\$ 500,000\) of 10 -year, \(8 \%\) bonds payable under various market conditions. Match each...
-
Selected comparative financial statements of Sugo Company follow. Required 1. Compute trend percents for all components of both statements using 2006 as the base year. Analysis Component 2. Analyze...
-
As the business in the simulation goes through various generations, it is faced with various external and internal factors that affect its business model in different ways. You may have also made...
-
"Part 1: The Performance Lawn Equipment database contains data needed to develop a pro forma income statement. Dealers selling PLE products all receive 18% of sales revenue for their part of doing...
-
York Corporation has budgeted activity for October to reflect net income $260,000. All sales are credit sales. Receivables are planned to increase by $25,000, payables to increase by $40,000 and...
-
Identify reasons why an operation with a short RTO will require a more expensive BCM than a similar operation but with a longer RTO.
-
Why are all important operations not considered to be critical operations?
-
Identify the business continuity problems associated with the following types of crisis events: a. Community-wide crisis events. b. Crisis events that provide no warning. c. Crisis events that...
-
Has transactional selling gone the way of the dinosaur? That is, are there ever any situations in which a transactional approach to selling would be an appropriate approach today? If so, what are...
-
Consider facility, personnel and IT resources. In general, all the resource components identified above are necessary for most organizations. Can you think of organizations that can operate without...
-
When Ben records data and then replays it against his test website to verify how it performs based on a real production workload, what type of performance monitoring is he undertaking?
-
In a nonmagnetic medium, E = 50 cos (10 9 t 8x) a y + 40 sin (10 9 t 8x) a z V/m find the dielectric constant r and the corresponding H.
-
Imagine that you want a mortgage to buy a house. Many finance companies can lend you the money, but they quote widely differing terms and conditions. Collect information about offers currently...
-
Lawyers are investigating the performance of some company directors and formulate the hypotheses Ho the directors are honest and Ha the directors are stealing from the company'. a. What does it mean...
-
Governments routinely collect huge amounts of data that they often present in extended time series - giving figures for populations, gross domestic product, employment etc. Collect a reasonably long...
-
Electronic devices contain electric circuits etched into wafers made of silicon. These silicon wafers are sealed with an ultrathin layer of silicon dioxide, in a process known as oxidation. This can...
-
Fill in the blank: If large values of one variable are associated with small values of another, then the two variables have a _______________________ association.
-
For each of the following scatterplots, state the type of association that is exhibited: Choices: positive linear, negative linear, positive nonlinear, negative nonlinear, weak linear. b. d. e.
Z Man Cmsh132 04 Micro Headz Glow 1/32oz Jighead Fishing Lures 4 Pack - ISBN: B0CN1NB4SY - Free Book
Study smarter with the SolutionInn App