Question: A professor has been contacted by four not - for - profit agencies that are willing to work with student consulting teams. The agencies need

A professor has been contacted by four not-for-profit agencies that are willing to work with student consulting teams. The agencies need help with such things as budgeting, information systems, coordinating volunteers, and forecasting. Although each of the four student teams could work with any of the agencies, the professor feels that there is a difference in the amount of time it would take each group to solve each problem. The professor's estimate of the time, in days, is given in the table below. Use either Hungarian Algorithm or Excel solver to see which team works with which project, and what is the total minimized time for all these assignments.
\table[[,Projects],[Team,Budgeting,Information,Volunteers,Forecasting],[A,87,76,18,28],[B,47,44,26,19],[C,59,76,67,30],[D,53,64,90,62]]
The answer should be given in the following format: Team A (Project); Team B (Project); Team C (Project); Team D (Project); Time
Team A (Volunteers); Team B (Information); Team C (Forecasting); Team D (Budgeting); 145
Team A (Forecasting); Team B (Volunteers); Team C (Budgeting); Team D (Information); 166
Team A (Information); Team B (Volunteers); Team C (Budgeting); Team D
A professor has been contacted by four not - for

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!