Homework # 1 Due Date: March 10, 2013 Please save your Word document and Excel file as your name (plus the file extension) and upload them to the...
Determine how many of each project type your team should take on in order to maximize the profit to your unit given that your marketing team requires you to do at least 1 CRM project, 2 Portal projects, and 1 ERP project each year.
 First, write the formulas to solve this problem in your Word document
 Next, set up the model in Excel. Please use Solver to solve and save the solution.
o Note that your decision variables here should generally be integers; but because we have defined a oneyear limit on the analysis, we can accept fractional values. (Use the Simplex LP method to solve the problem and place a checkmark on the option “Make Unconstrained Variables NonNegative”)
 Either highlight with a color or place a text box at the top or right side of the worksheet to summarize the following:
(a) How many projects in each category should your team take on?
(b) What would be the total profit for your unit?
 In a special case of this problem, you have been told that all of your project managers may not be able to handle all project types. Only 8 of the project managers could work on all projects (i.e., the rest of the project managers can only handle CRM and Portal projects). Express this additional constraint as a formula in your Word document. (If you wish, you can solve the problem with this additional constraint and report the answer in your Word document).
Homework # 1Due Date: March 10, 2013Please save your Word document and Excel file as your name (plus the file extension) and upload them to the Assignments folderAs a manager of a delivery in an IT consultancy firm (A1Integrators, Inc.), you have a delivery team that specializes in executing integration projects (with CRM, Portal, and ERP systems). There are enough clients (and projects) in the pipeline that you have the luxury of choosing the projects you want to take on. Yet, you are unsure which projects to pick to maximize profit to your unit.You have 267 staff members: 25 project managers, 24 designers, 50 analysts, 100 engineers, and 68 QA specialists. Here is a table that details the level of effort needed for a “typical” project in each category: (note that the level of effort is expressed in PersonYear units; i.e., a 1 PersonYear effort takes a person one year to complete). Also you can assume that each resource can work on any of the three projects. Table 1: Effort needed for each project type (Effort is expressed in PersonYears)Integration Project TypeProject ManagerDesignerAnalystEngineerQACRM224107Portal11385ERP3471210The profit to the company per project type is listed below:Table 2: Profit per project type per year (in thousands of Dollars)Project TypeProfit/projectCRM$2,780Portal$1,970ERP$4,010
Determine how many of each project type your team should take on in order to maximize the profit to your unit given that your marketing team requires you to do at least 1 CRM project, 2 Portal projects, and 1 ERP project each year.First, write the formulas to solve this problem in your Word documentNext, set up the model in Excel. Please use Solver to solve and save the solution. oNote that your decision variables here should generally be integers; but because we have defined a oneyear limit on the analysis, we can accept fractional values. (Use the Simplex LP method to solve the problem and place a checkmark on the option “Make Unconstrained Variables NonNegative”)Either highlight with a color or place a text box at the top or right side of the worksheet to summarize the following: (a) How many projects in each category should your team take on? (b) What would be the total profit for your unit?In a special case of this problem, you have been told that all of your project managers may not be able to handle all project types. Only 8 of the project managers could work on all projects (i.e., the rest of the project managers can only handle CRM and Portal projects). Express this additional constraint as a formula in your Word document. (If you wish, you can solve the problem with this additional constraint and report the answer in your Word document).
Solution
Problem Formulation
Maximize profit function
P = 2780*CRM + 1970*PP + 4010*ERP
Subject to constraints
2CRM + 1PP + 3ERP ≤ 25
2CRM + 1PP + 4ERP ≤ 24
4CRM + 3PP + 7ERP ≤ 50
10CRM + 8PP...
Sign up to view the full answer
Why Join Course Hero?
Course Hero has all the homework and study help you need to succeed! We’ve got coursespecific 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.
Get oneonone homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!