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

EXCEL EXAMPLE PLEASE

A group of people is to be assembled into a team for a project. Their supervisors have provided the following 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 the members of the team to minimize training time needed. The constrains are as follows:

i. The project will require at least 112 hours.

ii. Andrews and Chu don't get along and should not both be 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 integer programming problem.

Expert Solution

This is solved through Excel solver and sharing below formulae used and reasoning behind.

Criteria used: Training time set to minimize objective

keosha answered 7 months ago

A team of size m has to be chosen from a group of n people (m...

A team of size m has to be chosen from a group of n people (m < n) and a captain chosen for the team. (a) How many ways can the captained team be chosen if the captain is chosen first then the remainder of the team chosen. (b) How many ways can the captained team be chosen if the team is chosen first then the captain chosen from the team? This should give the same number as a) but...

Suppose that you are a member of a team assembled to examine needs and decide on...

Suppose that you are a member of a team assembled to examine needs and decide on an IT strategy of non-profit organization. What are the steps you will take in understanding the needs, the costs, alternatives and implementation?

1. Have you ever been in a group or team (or observed a group or team)...

1. Have you ever been in a group or team (or observed a group or team) that was a victim of "groupthink"? What symptoms did you observe? How did its members behave? What were its goals, and to what extent were they achieved? How did non-members (e.g., outsiders such as other groups/teams/departments) react emotionally and behaviorally (if at all) to the group or team exhibiting groupthink?

Organizational Behavior: Many people use the terms group and team interchangeably. Should they? Distinguish the terms....

Organizational Behavior: Many people use the terms group and team interchangeably. Should they? Distinguish the terms. Propose key ideas for what it takes to build highly productive team.

Many people use the terms team and group synonymously. When working in healthcare, do we use...

Many people use the terms team and group synonymously. When working in healthcare, do we use teams or groups? What makes a group a team? In the first portion of your initial post, present a hypothetical medical situation which describes the difference between a team and a group. For example: In a clinic setting, a group is the 10 patients that are sitting in the waiting room waiting to be seen, but a team is the office staff that support...

what are group bonuses and team awards? how can this encourage group or team performance? How...

what are group bonuses and team awards? how can this encourage group or team performance? How can this hinder group or team performance? what if your pay at your job tied exclusively to the performance of work team? would you like this or dislike this? why or why not?

DO NOT USE EXCEL SHOW STEPS EXPLAIN ALL PARTS A group of 18 people from New...

DO NOT USE EXCEL SHOW STEPS EXPLAIN ALL PARTS A group of 18 people from New York and a group of 15 people from Los Angeles passed the same quiz. The mean grade of group A is 78 points, with the standard deviation σ1=5, the mean grade of group B is 75 points, σ2=4.5. Use α=0.05. Assuming that the subjects are chosen randomly, the cities’ population are independent, and the points are normally distributed: (a) Check if there is a...

Ultimate Corporation has assembled their management team to review their current inventory methods. They wish to...

Ultimate Corporation has assembled their management team to review their current inventory methods. They wish to ensure the optimal reporting figures for the upcoming quarter. Below is a summary of their Inventory transactions: Date Units Purchased Purchase Price Units Sold Selling Price Jan 4 1500 $80 Jan 15 800 $76 Feb 8 700 $120 Feb 15 400 $82 Feb 28 1200 $122 Required: Determing the Ending Inventory and Cost of Goods Sold under: FIFO LIFO Which inventory method results in...

Give one example of a perfectly competitive team and one example of a monopoly team. Explain.

PLEASE MAKE IT IN EXCEL IF REQUIRED FOMULA EXAMPLE What do you understand by the term...

PLEASE MAKE IT IN EXCEL IF REQUIRED FOMULA EXAMPLE What do you understand by the term market efficiency are markets efficient? Can the book value of equity be negative? Can the market vaue of equity be negative? Can the cost of debt be higher than the cost of equity give reason?

Question