View the step-by-step solution to:

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 one-year 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 Non-Negative”)
- 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 # 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 Assignments folder As 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 Person-Year units; i.e., a 1 Person- Year 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 Person-Years) Integration Project Type Project Manager Designer Analyst Engineer QA CRM 2 2 4 10 7 Portal 1 1 3 8 5 ERP 3 4 7 12 10 The profit to the company per project type is listed below: Table 2: Profit per project type per year (in thousands of Dollars) Project Type Profit/project CRM $2,780 Portal $1,970 ERP $4,010
Background image of page 1
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 one-year 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 Non-Negative”) - 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).
Background image of page 2
Sign up to view the entire interaction

Top Answer

Dear student, here is your complete solution in... View the full answer

LP-model-Solution.docx

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 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
Ask a homework question - tutors are online