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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Statistics
1.2K views

Scientists want to test a new pair of running shoes A speed test is performed...

Chemistry
1.2K views

When calcium carbonate is added to hydrochloric acid, calcium chloride, carbon dioxide, and water are produced....

Biology
1.2K views

Myoglobinproduces the end plate potentialis a protein involved in the direct phosphorylation of ADPstores oxygen...

Physics
1.2K views

Calculate the Electric Field at P Show calculation of the vector components net x and...

Calculus
1.2K views

Find the area bounded by y x 27x 54 the x axis and the first...

Accounting
1.2K views

Question 11 While Julia is shopping to purchase ingredients to make some fine French cuisine,...

Accounting
1.2K views

Myer's Treats makes institutional cakes. Finished cakes must pass through two departments: Mixing and Baking....

Accounting
1.2K views

Can someone please explain if dividends, profits and earnings are taxed similarly, and how they...

Accounting
1.2K views

A company paid $300 cash for freight charges on a purchase of inventory. What is...

Accounting
1.2K views

A fire department bought a $30,000 machine for $30,000 cash. What fund would this be...

Accounting
1.2K views

The additional tax on excess contributions to a health savings account (HSA) is calculated on...

Accounting
1.2K views

On January 1, McNeil Company borrows $127,000 cash by signing a four-year, 7% installment note....