Purchase Solution

Operations Research and Profit Maximization

Not what you're looking for?

Ask Custom Question

In a particular engineering project team, four design jobs can be performed by any of the five resident experts. The profit generated by each individual resident expert for each design job is presented in the following table:

Resident Experts
Jobs Tom Robert John Albert Chris
1 $ 10,000.00 $ 12,000.00 $ 16,000.00 $ 10,000.00 $ 14,000.00
2 $ 14,000.00 $ 13,000.00 $ 15,000.00 $ 12,000.00 $ 16,000.00
3 $ 16,000.00 $ 12,000.00 $ 12,000.00 $ 10,000.00 $ 18,000.00
4 $ 13,000.00 $ 16,000.00 $ 11,000.00 $ 11,000.00 $ 16,000.00

You are required to select resident experts for the available jobs such that the profit generated is maximized by formulating and setting up the appropriate model to find the best solution.

Provide the written formulation in a Word document. (Provide a complete description of the decision variables used along with their units and also label the constraints mentioned in the problem as completely as possible.

The Excel set-up should provide clearly labeled values used for the decision variables, constraints, and objective function.

Purchase this Solution

Solution Summary

This solution involving maximizing profit through assignment of employees. The problem is addressed to Integer Programming and solved using Excel.

Solution Preview

Please find attached detailed help on your question. The response consists of a word file that provides math formulation. The Excel file demonstrates how to solve such problems.

Profit ($)
Job Tom Robert John Albert Chris
1 10000 12000 16000 10000 14000
2 14000 13000 15000 12000 16000
3 16000 12000 12000 10000 18000
4 13000 16000 11000 11000 16000
Problem description: Four jobs needs to be performed. There are five engineers who can do either of the jobs and generate profit. The jobs, engineers and profit are presented in the following ...

Purchase this Solution

Free BrainMass Quizzes
Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Operations Management

This quiz tests a student's knowledge about Operations Management


This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.