Question: PLEASE HELP 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

PLEASE HELP A professor has been contacted by
PLEASE HELP
PLEASE HELP A professor has been contacted by
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 45 32 97 56 35 51 25 96 97 The answer should be given in the following format: Team A (Project): Team B (Project); Team C (Project); Team D (Project); Time 87 B D 18 10 87 34 7 Team A (Budgeting); Team B (Forecasting): Team C (Volunteers); Team D (Information); 120 Team A (Budgeting); Team B (Information); Team C (Volunteers); Team D (Forecasting): 109 Team A (Volunteers); Team B (Information); Team C (Forecasting); Team D (Budgeting): 145 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 45 32 97 56 51 25 96 7 97 The answer should be given in the following format: Team A (Project); Team B (Project); Team C (Project); Team D (Project); Time A 60 18 87 B 10 34 87 35 D Team A (Budgeting); Team B (Forecasting): Team C (Volunteers); Team D (Information); 120 Team A (Budgeting): Team B (Information); Team C (Volunteers): Team D (Forecasting): 109 Team A (Volunteers); Team B (Information); Team C (Forecasting); Team D (Budgeting): 145

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!