Comp507 ITPM – Quantitative Analysis COMP507
1
Assessment 2 – ITPM Quantitative Analysis 50%
COMP507 IT Project Management
Version 1.0



The objective of this assignment is to practice using various quantitative analysis tools discussed in
this course to support decision making in ITPM. Five areas are covered including:
? Financial analysis using ROI and payback
? Cost control using Earned Value Management
? Schedule management using Critical Path Analysis
? Project selection using Weighted Scoring Model, and
? Risk analysis using Expected Monetary Value

Task 1: Business case financial anaylsis (15 marks)

The Business Case (MYH)
Manage Your Health, Inc. (MYH) is listed in the Fortune 500 Company that provides a variety of
healthcare service across the globe. They have 25,000 full-time and 12,000 part-time employees. A
study found that MYH, Inc. pays 45% more than the industry average for their employee healthcare
premiums, due to the poor health of its employees. Therefore, the company has planned to provide a
web application that provides online functionalities to help their employees enrol and manage their
health-management and recreational programs. This application will have the following capabilities:
? Allow employees to register for company-sponsored recreational programs such as soccer,
netball, bowling, jogging and walking etc.
? Allow employees to register for company-sponsored classes and programs to help them
manage their weight, reduce stress, and stop smoking etc.
? Track employees’ involvement in these recreational and health-management programs
? Over incentives for people to join the programs and do well in them

Project’s financial information
The project is expected to cost the company $1,500,000 for the web application development and
$800,000 for web and database servers. The project is expected to take 11 months to complete. They
believe that this application will help improve their employees’ health after a year of its rollout so that
the company can negotiate lower healthy insurance premiums, providing a net saving of at $600 per
employee per year for full-time employees and $300 per employee per year for part-time employees
This assignment is worth 50% of your overall final grade and is submitted on Blackboard. It is due
at 6pm on Sunday 17 October 2021 New Zealand Standard Time (NZST) (end of week 12).

Submission Requirements:
? This is an individual assignment. The cover page (template provided in the last page of this
document) must be fully filled and signed.
? Please use 1.5-line spacing and 12pt font size (no handwritten assignment will be marked
except for drawing the AOA (Activity-On-Arrow) diagram)

Comp507 ITPM – Quantitative Analysis COMP507
2
over next five years. The company does not expect any savings in employee healthcare premiums for
the first year when the application will be up and running. A yearly budget of $600,000 has been set
aside for the next five years for system maintenance. A new role “Application Support Engineer” has
been created with the responsibility to work with the software engineering team to develop the
application and to provide on-going application support after the roll out of the application. This role
will cost the company $100,000 with a 6% yearly increase in the annual salary. Assume that the
discount rate is 10%.

1.1 You are required to prepare a financial analysis up to year 5 using the table provided below for
the MYH’s project to find the Return on Investment (ROI) and payback period of the project
based on the financial information provided. (7 marks)

Discount rate 10%
PROJECT 1 Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Total
Benefit
Discount Factor
Discount benefit
Costs
Discount factor
Discount Cost
Discount benefit -
Discount Cost

Cumulative benefit
- Cumulative cost



1.2 Calculate the ROI of the project (3 marks)

1.3 Calculate the payback period of the project (3 marks)

1.4 Justify if the proposed project is worthwhile undertaking (2 marks)


Comp507 ITPM – Quantitative Analysis COMP507
3
Task 2: Project cost control (25 marks)

You are required to control the budget for the MYH project described in Task 1.

2.1 What is the total budget at completion (BAC) for the project? (3 marks)

2.2 Assume that the work for the first week is completed in the project. The following information has
been provided as a result of work done so far.

Plan Value (PV) = $400, 000
Earned Value (EV) = $250, 000
Actual Cost (AC) = $600, 000

Answer the following questions 2.2.1 - 2.2.5 (must show all the working).

2.2.1 Explain a likely reason for the difference between PV and AC for the first week of this
project. (4 marks)

2.2.2 Calculate the cost variance (CV) and the cost performance index (CPI) for the first week
in this project? Is the project under or over budget? (6 marks)

2.2.3 Calculate the schedule variance (SV) and the schedule performance index (SPI) for the
first week in this project? Is the project ahead of or behind schedule? (6 marks)

2.2.4 Calculate the new estimate at completion (EAC) for this project after the completion of
first week’s work. (3 marks)

2.2.5 Calculate how long it will now take to finish this project after working on the project for
a week. (3 marks)


Comp507 ITPM – Quantitative Analysis COMP507
4
Task 3: Project schedule development (30 marks)

The Table shown below provides the activities (A to L) and their three-point estimates for an Auckland
city IT infrastructure (LAN Network) project.

Task Predecessor Optimistic
duration (Day)
Most Likely
duration (Day)
Pessimistic
duration (Day)
Task effort
A - 12 14 26
B - 14 18 24
C A 21 23 32
D A 12 17 26
E C 11 13 16
F D 16 19 21
G B 8 6 11
H B 6 4 12
I E,F, G 8 6 13
J H 8 7 16
K J 9 7 13
L I, K 10 8 12

3.1 Complete the PERT estimation to show the duration of each activity. (8 marks)

3.2 Draw the network (AOA) diagram to show the order in which all the activities will be undertaken
in this project. The diagram must be clearly labelled. (6 marks)
3.3 List all the possible paths for this project with their total durations. (5 marks)
3.4 Clearly identify and briefly explain the critical path for this project. (7 marks)
3.5 This network is expected to be up and running within 4 months from the time the work on the
project is started. Does this opening date appear feasible? (4 marks)

Comp507 ITPM – Quantitative Analysis COMP507
5
Task 4: Project selection (30 marks)

You are required to perform some analysis to help identify the order in which the projects will be
undertaken from the available four projects.

4.1 Use the information below to create a table that must show the weighted score and priority for
each project for a software vendor environment. (7 marks)
The factors that impact the success of a project include (a) the availability of a principle engineer
(20%); (b) development team assigned based on at least 4 senior software engineers with local
development experience (20%); (c) availability of a product manager as a on-site customer) (20%);
(d) support for the project from sales & marketing team (20%); (e) availability of an agile tester
(10%); and (f) an established product backlog based on high level requirements (10%). Table below
provides the scores based on these factors for each project.
Project / Criteria a b c d e f
Project 1 65 45 45 60 55 60
Project 2 70 65 55 65 85 70
Project 3 75 70 75 75 85 50
Project 4 60 70 75 75 85 70

4.2 Explain the order in which the four projects should be undertaken. (3 marks)
4.3 Based on the information provided below, perform a quantitative risk analysis using a decision
tree diagram to calculate the Expected Monetary Value (EMV) and the contingency reserve for
each project. (10 marks)
Project

Risks
Chance
of
Outcome
Estimated
Impact
Expected monetary
value (EMV)

Contingency
reserve

Project 1
Risk 1 40% -$ 60,000
Risk 2 60% -$ 70,000
Project 2
Risk 1 20% -$ 100,000
Risk 2 25% $ 60,000
Risk 3 55% $ 80,000
Project 3
Risk 1 20% $ 60,000
Risk 2 25% $ 75,000
Risk 3 55% -$ 30,000
Project 4
Risk 1 40% $ 60,000
Risk 2 35% $ 40,000
Risk 3 25% -$ 80,000

4.4 Explain the contingency reserve for each project (10 marks)
Comp507 ITPM – Quantitative Analysis COMP507
6
INDIVIDUAL ASSIGNMENT COVERSHEET
COMP507 ITPM Assignment 2
Student ID


First Name


Surname


Lab/Tutorial class



Please read the following and place an X next to each statement to indicate your
understanding:
I understand it is my responsibility to keep a copy of my assignment.
I have signed and read the Student’s Statement below.
I understand that a software program (Turnitin) that detects plagiarism and
copying may be used on my assignment. ?

Plagiarism and Dishonesty are methods of cheating for the purposes of General Academic
Regulations (GAR) http://www.aut.ac.nz/students/regulations.html

Student’s Statement: This assessment is entirely my own work and has not been submitted
in any other course of study. I will submit a copy of this assessment to Turnitin, if required. In
this assessment I have acknowledged, to the best of my ability
? The source of direct quotes from the work of others.
? The ideas of others (includes work from private or professional services, past
assessments, other students, books, journals, cut/paste from internet sites and/or
other materials).
? The source of diagrams.
Signature: _______________________________________ Date: _____________________
The information on this form is collected for the primary purpose of submitting your assignment for
assessment. Other purposes of collection include receiving your acknowledgement of plagiarism polices and
attending to administrative matters. If you choose not to complete all questions on this form, it may not be
程序代写