View the step-by-step solution to:

Problem # 3 A professor has been contacted by four not-for-profit agencies that are willing to work with student consulting teams.

Problem # 3
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.
Projects
Team Budgeting Information Volunteers Forecasting
A 32 35 15 27
B 38 40 18 35
C 41 42 25 38
D 45 45 30 42
1. Define the linear programming model with its decision variables and its constraints.
2. Use the computer solution generated by Excel (Solve) to see which team works with which project. Provide the Excel file.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question