2. Stacey is forming a team to develop a new product for her company. To ensure...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. Stacey is forming a team to develop a new product for her company. To ensure that her team incorporates a diverse range of viewpoints, she has been allowed to select team members from across three departments. After speaking with several other managers, Stacey has identified 10 potential team members: Name Alvin Bernie Carlos Department Years Marketing Accounting 4 Engineering 5 Marketing Engineering 3 Marketing Accounting Accounting Marketing Engineering 6 Gender Male Female Male Commitment 6 5 9 6. Drew 10 Male Elena Female 7. Fiona 8 Female 10 Guillaume Male Hilda Isabel 7 Female 5 4 Female 7. Jing Female 9 The Commitment score for each person is Stacey's estimate, on a scale of 1-10, of how committed the person would be to the project. The "Years" column shows how many years of experience the person has. Using the three steps, formulate an optimization model using binary decision variables to help Stacey form a team that will maximize the total commitment level subject to the follow constraints: Make sure to include type of constraint (k out of n, conditional, etc.! • The team must have exactly five members. • The team must have at least one member from each of the three departments (Marketing, Engineering, and Accounting). • The average of the number of years of experience of the team members must be at least 6. • The team must have at least two women. • The team must have at least two men. • If Jling is chosen for the team, Guillaume must also be chosen. • Bernie and Hilda can't both be chosen. • Alvin and Drew must either both be chosen or both left off. 2. Stacey is forming a team to develop a new product for her company. To ensure that her team incorporates a diverse range of viewpoints, she has been allowed to select team members from across three departments. After speaking with several other managers, Stacey has identified 10 potential team members: Name Alvin Bernie Carlos Department Years Marketing Accounting 4 Engineering 5 Marketing Engineering 3 Marketing Accounting Accounting Marketing Engineering 6 Gender Male Female Male Commitment 6 5 9 6. Drew 10 Male Elena Female 7. Fiona 8 Female 10 Guillaume Male Hilda Isabel 7 Female 5 4 Female 7. Jing Female 9 The Commitment score for each person is Stacey's estimate, on a scale of 1-10, of how committed the person would be to the project. The "Years" column shows how many years of experience the person has. Using the three steps, formulate an optimization model using binary decision variables to help Stacey form a team that will maximize the total commitment level subject to the follow constraints: Make sure to include type of constraint (k out of n, conditional, etc.! • The team must have exactly five members. • The team must have at least one member from each of the three departments (Marketing, Engineering, and Accounting). • The average of the number of years of experience of the team members must be at least 6. • The team must have at least two women. • The team must have at least two men. • If Jling is chosen for the team, Guillaume must also be chosen. • Bernie and Hilda can't both be chosen. • Alvin and Drew must either both be chosen or both left off.
Expert Answer:
Answer rating: 100% (QA)
Step1 decide the decision variables J1 if person i selected for the team l0if person ... View the full answer
Related Book For
Fundamentals of corporate finance
ISBN: 978-0470876442
2nd Edition
Authors: Robert Parrino, David S. Kidwell, Thomas W. Bates
Posted Date:
Students also viewed these accounting questions
-
Micks Soft Lemonade is starting to develop a new product for which the cash fixed costs are expected to be $80,000. The projected EBIT is $100,000, and the Accounting DOL is expected to be 2.0. What...
-
Imagine that you are on a project team to develop a new information system to support the functionality described below, for Fast Freddys, a local hamburger chain. This is a business automation...
-
On December 15, 1997, Hilda Forbes and her three grandchildren were traveling to Columbia, Mississippi, in her 1992 Oldsmobile Delta 88. Mrs. Forbes was driving behind a 1981 Chevrolet Chevette,...
-
Water is pumped out of a holding tank at a rate of 5 5e 0.12t liters/minute, where t is in minutes since the pump is started. If the holding tank contains 1000 liters of water when the pump is...
-
Compute the IRR statistic for project F and note whether the firm should accept or reject the project with the cash flows shown as follows if the appropriate cost of capital is 12percent. Project F...
-
Faye Jaworski, CPA, is auditing the financial statements of Fulbright Company. As she is nearing the audit completion date, Jaworski realizes that she needs to evaluate whether all material...
-
We have \(100 \mathrm{~kg} / \mathrm{h}\) of a feed that is \(60 \mathrm{wt} \%\) methylcyclohexane (A) and \(40 \mathrm{wt} \% \mathrm{n}\)-heptane (D) and \(50 \mathrm{~kg} / \mathrm{h}\) of a feed...
-
1. Which of the following statements is true? a. Job-order costing is used only in manufacturing firms. b. The job cost sheet is subsidiary to the work-in-process account. c. Job-order costing is...
-
Watercraft's predetermined overhead rate is 200% of direct labor. Information on the company's production activities during May follows. a. Purchased raw materials on credit, $260,000. b. Materials...
-
The Cincinnati Zoo and Botanical Gardens had a record attendance of 1.87 million visitors in 2017 (Cincinnati Business Courier website). Nonprofit organizations such as zoos and museums are becoming...
-
Design a multiple-output combinational network that has to input signals x0 andx1, two control signals c0 and c1, and two output functions f0 and f1. The control signals have the following effect on...
-
For the equation, find the slope m and y-intercept (0, b) (when they exist). (If an answer does not exist, enter DNE.) slope x+5 y= 2 m = y-intercept (x, y) Draw the graph. No Solution -5 4 -3 -2 -1...
-
Applies to Acapulco Store an export / import business. Sales are 4 0 % cash and 6 0 % credit. Of the credit sales, 7 5 % are collected in the first month following the sales and 2 5 % in the second...
-
4. We know that x + y = 4 describe a circle of radius 2 centered at (0,0) in plane. a) What do the following two equations x + y = 4 and z= 0 describe in space? b) What do the following two equations...
-
Southern Company issued a $600,000 bond at 99% on January 1st. The bond has a two year life and pays 5% interest annually each December 31s t. Prepare the Appropriate Journal entries 2. Magnolia...
-
Digging Deeper: Interdependences between Practical components and other components 1. The author suggests that the nine components of the deliberations dimension "should not be thought of as...
-
Start a wizard that allows you to calibrate the color on your display device. (Hint: Use the Ask me anything box to open the Display Color Calibration window.) Follow the instructions to calibrate...
-
Activator rod AB exerts on crank BCD a force P directed along line AB. Knowing that P must have a 100-N component perpendicular to arm BC of the crank, determine (a) The magnitude of the force P, (b)...
-
Which investment category has shown the greatest degree of risk in the United States since 1926? Explain why that makes sense in a world where the value of an asset in this investment category is...
-
What is interest rate risk?
-
Give an example of a conflict of interest in a business setting, other than the one involving the real estate agent discussed in the text.
-
Because you own the common stock of Jacob Corporation, a paper manufacturer, you decide to analyze the firm's performance for the most recent year. The following data are taken from the firm's latest...
-
Quarterly data are presented below for Company A and Company B. One of these companies is Gibson Greetings, Inc., which manufactures and sells greeting cards. The other company is Hon Industries,...
-
Adams Plastics, Inc., manufactures various plastic and synthetic products. Financial statement data for the firm follow: Required a. Using the given data, calculate items 1 through 8 below for 2019....
Study smarter with the SolutionInn App