PLEASE SHOW STEPS ON EXCEL SOLVER

1. (20 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. Develop a linear programing model and use the computer solution to see which team works with which project. Team A B D Budgeting 32 38 41 44 Projects Information Volunteers 35 40 42 25 45 30 21 19 Forecasting 27 35 38 42