Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. general management
  3. excel example please a group of people is to be a

EXCEL EXAMPLE PLEASE A group of people is to be assembled into a team for a project. Their...

80.2K

Verified Solution

Question

General Management

EXCEL EXAMPLEPLEASE

A group of people is to be assembledinto a team for a project. Their supervisors have provided thefollowing information about them. (10 points)

Name

Training Time Needed

Project Time Available

Andrews

8 hours

24 hours

Bailey

10 hours

40 hours

Chu

5 hours

20 hours

Darnell

12 hours

30 hours

Elliott

9 hours

24 hours

Fenton

14 hours

48 hours

     

The task is to select themembers of the team to minimizetraining time needed. The constrains are asfollows:

           i.    The project will require at least 112hours.

           ii.   Andrews and Chu don't get along and should not bothbe assigned.

           iii. For diversity, at least 4 people should be on the team.

           iv. If Bailey is chosen, Elliott should be chosen also.

Using Excel, solve the above integerprogramming problem.

Answer & Explanation Solved by verified expert
3.9 Ratings (430 Votes)
This is solved through    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Consider the split of an unviable bank into a Good Bank and a bad bank in...

Finance
Q

In what ways is this antibiotic resistance acquired specifically? What genetic elements does it have and...

Biology
Q

An industry consists of three firms with sales of $205,000, $745,000, and $305,000. a. Calculate the...

Economics
Q

10 effects and consequences of family planning? Explain

Medical Sciences
Q

Identify the synthesis method that has the best chance to yield nanoparticles of a uniform size....

Physics
Q

This is a discussion question for global technology. You should think about the SYSTEM of technology....

General Management
Q

Find the sum of 2 8 162 13122 discrete functions Show all steps

Basic Math
Q

Determine the logarithmic regression of the data below using either a calculator or spreadsheet program...

Statistics
Q

8 The Dakotas rented a minivan for their family vacation When they returned from vacation...

Algebra
Q

no other info besides this Current Attempt in Progress Starbucks sells coffee beans, which...

Accounting
Q

Bethesda Mining Company reports the following balance sheet information for 2018 and 2019 Assets Current...

Finance
Q

The company has paid a constant cash dividend of 7$ on an annual basis for...

Finance