CST 182. IT Project Management.;;.;;.;;.;;.;;.;;.;;.;;.;;;.;;.;;.;;.;;.;;.;;.;;.;;.;;;;;o;;;;;;;;;;;;;;;;;.;;.;;.;;.;;.;;.;;.;;.;;.;;;.;;.;;.;;.;;.;;.;;.;;.;;.;;;.;;.;;.;;.;;.;;.;;.;;.;;.;;;.;;.;;.;;.;;.;;.;;.;;.;;.;;;.;;.;;.;;.;;.;;.;;.;;.;;.;;;.;;.;;.;;.;;.;;.;;.;;.;;.;;;.;;.;;.;;.;;.;;.;;.;;.;;.;;;.;;.;;.;;.;;.;;.;;.;;.;;.;;;.;;.;;.;;.;;.;;.;;.;;.;;.;;;.;;.;;.;;.;;.;;.;;.;;.;;.;;;.;;.;;.;;.;;.;;.;;.;;.;;.;;;CST 182. IT Project ManagementAssignmentInstructions: You may use the software tools available to you, includingMicrosoft Excel, Word, PowerPoint, and Project (comes with the textbook), asneeded.1. The following are data for two IT projects for a new database system. Preparea spreadsheet for two projects, using the following data. Amounts are inthousands of dollars. Calculate the NPV for each. (Please assume a DiscountRate of 10%)Year 1Year 2 Year 3 Year 4 Year 5TotalProject 1Benefits$0 $2,000 $3,000 $4,000 $5,000$5,000 $1,000 $1,000 $1,000 $1,000CoststbdtbdCashflow ($5,000) $1,000 $2,000 $3,000 $4,000 $5,000Project 2Benefits$2,000 $3,000 $5,000 $3,000 $1,000tbdCosts$2,000 $2,000 $2,000 $2,000 $1,000tbdCashflow$0 $1,000 $3,000 $1,000$0 $5,0002. Prepare a precedence diagram for the following tasks. All tasks have a finishto-start relationship.Task Duration Preceded By Followed ByA1NoneB, C, DB2AEC3AE, FD4AGE5B, CF1F6CHG7DHH8E, F, GNone3. Prepare a Gantt chart for the tasks shown for question 2.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 willlast one year. You estimate that you will need one full-time project manager, twofull-time business analysts for the first six months, two full-time senior systemsanalysts 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 stackedcolumn chart using Excel that shows resources by month. Provide appropriatetitles, axes labels, and legends.6. Take the MBTI. There are several websites you can use:www.humanmetrics.com, www.personalitytype.com, and www.kiersey.com. Writea one-page summary discussing your MBTI type and its opposite MBTI type. Forexample, if you are an INTJ, then its opposite is ESFP. What challenges wouldyou see working with this person on a project? What you think about the MBTI asa 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 investmentsare not recovered, so they are shown as negative profits. Draw a diagram andcalculate the expected monetary value (EMV) for each project. Write a paragraphexplaining which project(s) you would choose to bid.ProjectChance of EstimatedOutcomeProfitProject 150%50%$120,000-$50,000Project 230%40%30%$100,000$50,000-$60,000CST 182. IT Project ManagementProject 370%30%$20,000-$5,000Project 430%30%20%20%$40,000$30,000$20,000-$50,0008. Your company has a technical support line for customers to call. Create aPareto diagram based on the information in the following table. Create aspreadsheet using these data. List the most frequent complaint first. Then add acolumn labeled "% of Total" and another labeled "Cumulative %". Then enterformulas to calculate these items. Then use the Excel Chart Wizard to create aPareto diagram based on the data. Use the Line – Column on 2 Axis custom typechart so that your resulting chart looks similar to the one in Figure 8-1.Customer ComplaintsFrequency/WeekCustomer is on hold too long90Customer gets transferred to wrong number20Customer gets cut off50Service rep cannot answer customer’s question120Service rep does not follow through as promised40Service rep is rude109. Use the following WBS and duration information for a project to build a newwebsite. Prepare a Gantt chart and a precedence diagram. Determine the criticalpath.1. Initiating1 week2. Planning4 weeks, starting after Initiating ends3. Executing3.1 Conduct User Interview 6 weeks, starts after Initiating ends3.2 Conduct User Survey4 weeks, starts midway through User Interviews3.3 Site Content3.3.1 DevelopTemplates12 weeks, starts after User Interviews and UserSurvey end3.3.2 Write Articles8 weeks, stats anytime after Site Content begins33.3.3 Prepare FAQ2 weeks, starts after User Interviews and UserSurvey ends3.4 Design Site8 weeks, starts after User Interviews and UserSurvey end3.5 Build Site16 weeks, starts after Design Site ends3.6 Perform IntegrationTesting2 weeks, starts after Build Site ends3.7 Conduct AcceptanceTests2 weeks, starts after Integration Testing ends4. Controllingruns for entire duration of project5. Closing1 weeks, follows Acceptance Testing10. Using the following information for a one-year software development project,answer the following four questions.PV = $23,000EV = $20,000AC = $25,000BAC = $120,000What are the cost variance, schedule variance, cost performance index, andschedule performance index for the project?How is the project doing? Is it ahead of schedule or behind? Is it underbudget or over?Use CPI to calculate the estimate at completion (EAC)? Is the projectperforming better or worse than planned?Use SPI as your guide, how long will it take to finish the project?
