Projects: Part 1

What is the linear program that will minimize the total time to do all the projects and involves each team?

Projects: Part 2

Describe the optimal solution: what is the total time, which team should do which project?

Projects: Part 3

Upload a screenshot of your spreadsheet.

Projects: Introduction The next 3 questions refer to the following information: 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. Team Projects Budgeting 40 Information Forecasting 30 Volunteers 12 25 25 35 25 42 32 45 40 38 38