Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Management Information System Expert

Assignment : IT Project Management

Instructions: You may use the software tools available to you, including Microsoft Excel, Word, PowerPoint, and Project, as needed. Please include your answers and other results in this document in a different color.

1.The following are data for two IT projects for a new database system. Prepare a spreadsheet for two projects, using the following data. Amounts are in thousands of dollars. Calculate the NPV for each. (Please assume a Discount Rate of 10%)


Year 1

Year 2

Year 3

Year 4

Year 5

Total

Project 1







Benefits

$0

$2,000

$3,000

$4,000

$5,000

tbd

Costs

$5,000

$1,000

$1,000

$1,000

$1,000

tbd

Cashflow

($5,000)

$1,000

$2,000

$3,000

$4,000

$5,000

Project 2







Benefits

$2,000

$3,000

$5,000

$3,000

$1,000

tbd

Costs

$2,000

$2,000

$2,000

$2,000

$1,000

tbd

Cashflow

$0

$1,000

$3,000

$1,000

$0

$5,000

2. Prepare a precedence diagram for the following tasks. All tasks have a finish-to-start relationship.

Task

Duration

Preceded By

Followed By

A

1

None

B, C, D

B

2

A

E

C

3

A

E, F

D

4

A

G

E

5

B, C

F

F

6

C

H

G

7

D

H

H

8

E, F, G

None

3. Prepare a Gantt chart for the tasks shown for question 2. (This can be hand drawn if you have no software to make it, and then you can take a picture of your drawing and included it in this document as an image).

4. Determine the critical path for the tasks shown for question 2.

5. Your company is planning to launch a new IT project starting July 1 that will last one year. You estimate that you will need one full-time project manager, two full-time business analysts for the first six months, two full-time senior systems analysts for the whole year, four programmers for the months of February-May, and one full-time technical writer for the last three months.

Create a stacked column chart using Excel that shows resources by month. Provide appropriate titles, axes labels, and legends.

6. Take the MBTI. There are several websites you can use: humanmetrics, personalitytype, and kiersey. Write a one-page summary discussing your MBTI type and its opposite MBTI type. For example, if you are an INTJ, then its opposite is ESFP. What challenges would you see working with this person on a project? What you think about the MBTI as a team-building tool?

7. Your IT consulting company is trying to decide which of four projects to bid. Information on each is in the table below. Assume that all up-front investments are not recovered, so they are shown as negative profits. Draw a diagram and calculate the expected monetary value (EMV) for each project. Write a paragraph explaining which project(s) you would choose to bid.

Project

Chance of
Outcome

Estimated
Profit

Project 1

50%
50%

$120,000
-$50,000

Project 2

30%
40%
30%

$100,000
$50,000
-$60,000

Project 3

70%
30%

$20,000
-$5,000

Project 4

30%
30%
20%
20%

$40,000
$30,000
$20,000
-$50,000

8. Your company has a technical support line for customers to call. Create a Pareto diagram based on the information in the following table.

Create a spreadsheet using these data. List the most frequent complaint first. Then add a column labeled "% of Total" and another labeled "Cumulative %". Then enter formulas to calculate these items.

Then use the Excel Chart Wizard to create a Pareto diagram based on the data. Use the Line - Column on 2 Axis custom type chart so that your resulting chart looks similar to the one in Figure 8-1.

Customer Complaints

Frequency/Week

Customer is on hold too long

90

Customer gets transferred to wrong number

20

Customer gets cut off

50

Service rep cannot answer customer's question

120

Service rep does not follow through as promised

40

Service rep is rude

10

9. Use the following WBS and duration information for a project to build a new website. Prepare a Gantt chart and a precedence diagram. Determine the critical path.

1.

Initiating

1 week

2.

Planning

4 weeks, starting after Initiating ends

3.

Executing



3.1 Conduct User Interview

6 weeks, starts after Initiating ends


3.2 Conduct User Survey

4 weeks, starts midway through User Interviews


3.3 Site Content




3.3.1 Develop Templates

12 weeks, starts after User Interviews and User Survey end



3.3.2 Write Articles

8 weeks, stats anytime after Site Content begins



3.3.3 Prepare FAQ

2 weeks, starts after User Interviews and User Survey ends


3.4 Design Site

8 weeks, starts after User Interviews and User Survey end


3.5 Build Site

16 weeks, starts after Design Site ends


3.6 Perform Integration Testing

2 weeks, starts after Build Site ends


3.7 Conduct Acceptance Tests

2 weeks, starts after Integration Testing ends

4.

Controlling

runs for entire duration of project

5.

Closing

1 weeks, follows Acceptance Testing

10. Using the following information for a one-year software development project, answer the following four questions.

PV = $23,000

EV = $20,000

AC = $25,000

BAC = $120,000

a. What are the cost variance, schedule variance, cost performance index, and schedule performance index for the project?

b. How is the project doing? Is it ahead of schedule or behind? Is it under budget or over?

c. Use CPI to calculate the estimate at completion (EAC)? Is the project performing better or worse than planned?

d. Use SPI as your guide, how long will it take to finish the project?

Management Information System, Management Studies

  • Category:- Management Information System
  • Reference No.:- M92589796

Have any Question?


Related Questions in Management Information System

Data resources management questionsq1 the dama dmbok

Data Resources Management QUESTIONS Q1. The DAMA DMBOK textbook describes the following two core activities as part of the Data Architecture management exercise: "Understanding enterprise information needs" and "Develop ...

Review the swot analysis microsoftreg powerpointreg prior

Review the SWOT Analysis Microsoft® PowerPoint® prior to completing this assignment. Based on the Community Hospital scenario located in this week's required reading, conduct a SWOT analysis to generate a list of perceiv ...

As a junior congress person you have been asked to help

As a junior congress person you have been asked to help promote a bill to allow casino gambling in your state. There is much opposition to this bill. Using distributive bargaining, discuss the pros and cons which might a ...

Using proper apa formatting write an initial 400-600 word

Using proper APA formatting write an initial 400-600 word discussion paper relating to the following: 1. What are protective barriers and what should they entail? 2. What mitigation procedures can be used to ensure the r ...

Discussion boardfor this discussion board please write

Discussion Board For this discussion board, please write 400-600 words discussing the following. List and discuss some of the natural deterrence provided by topographies. Why should topographies be considered when design ...

Q1 explain how managers strive to understand customers

Q1: Explain how managers strive to understand customers' preferences in the Lumpy market for new technologies? Q2: What are the constraints faced by companies as they strive to meet customers' needs in a lumpy market? Ea ...

Assignmenteach response should be between 25 - 50 words and

Assignment Each response should be between 25 - 50 words and in some cases, include examples.There is no programming necessary to answer these questions; however, you may refer to class or homework to help with the respo ...

Assignment waterfall and agileresearch agile methodologies

Assignment : Waterfall and Agile Research agile methodologies including SCRUM and extreme programming (XP). Write a three to four (3-4) page paper in which you: Explain waterfall methodologies and identify their relation ...

Respectfully please see the structure for the program im

Respectfully, Please see the structure for the program I'm trying to write using Python. Below is how the program should be structured. 1. Program general structure: Function definitions should be at the top of the progr ...

Review the building shared services at rr communications

Review the Building Shared Services at RR Communications case study online, and ansswer the below questions. Describe the advantages of a single customer service center for RR Communications. Devise an implementation str ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As