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

Question 12 (15 points) A professor has been
Question 12 (15 points) A professor has been
Question 12 (15 points) 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. Projects Team Budgeting Information Volunteers Forecasting 60 97 35 25 The answer should be given in the following format: Team A (Project) Team B (Project): Team C (Project); Team D (Project); Time 87 A B C D 32 56 18 10 87 96 45 34 51 97 15 7 18 21 Team A (Volunteers); Team B (Forecasting): Team (Budgeting); Team D (Information): 92 24 Team A (Budgeting): Team B (Information), Team (Volunteers): Team D (Forecasting): 109 Team A (Budgeting): Team B (Volunteers): Team C (Information); Team D (Forecasting): 134 3 Team A (Budgeting); Team B (Information); Team C (Volunteers); Team D (Forecasting): 109 Team A (Budgeting): Team B (Volunteers); Team C (Information); Team D (Forecasting): 134 Team A (Volunteers); Team B (Information); Team C (Forecasting); Team D (Budgeting): 145 12 Team A (Budgeting); Team B (Forecasting); Team C (Volunteers); Team D (Information); 120 15 Team A (Forecasting): Team B (Budgeting); Team (Volunteers): Team D (Information); 88 18 Team A (Forecasting); Team B (Volunteers): Team (Budgeting): Team D (Information); 95 Team A (Forecasting): Team B (Information); Team (Budgeting): Team D (Volunteers): 107 21 23 24 Team A (Forecasting): Team B (Volunteers): Team C (Budgeting): Team D (Information): 85 Team A (Information): Team B (Budgeting): Team C (Forecasting): Team D (Volunteers): 108

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!