Linear programming with decision variables and constraints

Assignment Help Operation Management

Reference no: EM1323557

Linear Programming with decision variables and constraints

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.

Reference no: EM1323557

Questions Cloud

Explain key elements of e-business strategy framework : Explain Key Elements of E-Business Strategy Framework with references and specific examples

Explain e-business market segmentation matrix : Explain E-business Market Segmentation Matrix and Outline the e-business market segmentation matrix based on its two underlying dimensions

Concept regarding corpus callosum : Cerebral hemispheres are joined by a large band of fibers termed as the corpus callosum and several small connections termed commissures.

Show the developments in telecommunications : This solution shows the major developments in telecommunications technologies and describes their effects on the industry.

Linear programming with decision variables and constraints : Illustrate the linear programming model with its decision variables and its constraints. Use the computer solution generated by Excel (Solve) to see which team works with which project. Provide the Excel file.

Describe the concept of software as a service : Software as a Service (SaaS) - Describe the concept of Software as a Service (SaaS), and describe at least one application area

Explain meaning of web 2.0 : Explain Meaning of Web 2.0 consumer behaviours that have existed since the 1990s

Training your brain : Do you feel that these tasks/experiments can be mastered? Do you believe we can teach ourselves to perform these tasks after getting our brain to separate the two movements?

Graph constraints-find optimal solution : Graph the constraints for this problem. Indicate all feasible solutions. Find out the optimal solution to LP Relaxation. Round down to find out a feasible integer solution. Is this solution optimal?

User Account

All Pages