Demonstrate your understanding on project management by


Company Background

Tan Hui Hui is a newly appointed Director of IT in one of the largest pharmaceutical companies in Singapore. The company provides a comprehensive pharmaceutical care services to a large number of Singapore's residents. Some of the services include Hypertension-Diabetes-Lipidemia clinic, Smoking Cessation clinics and consultancy services for treatment of minor ailments, travel or nutritional advice. The company also provides an online shopping portal where their customers can order their medications and have them delivered to their home via the company's home delivery service.

The company relies heavily on IT to achieve the company's mission to improve the health and well-being of their customers through a high-quality patient-centric healthcare approach that emphasize on accessible, effort-free and cost-effective services. One month into her job, she realized there were some challenges in the way how IT projects were being selected and managed in her company.

First, she noticed that there were a large number of IT projects that were on-going across her department. Many of her staff constantly complained to her that the resources in the department were simply insufficient to cope with the demands from managing such large numbers of IT projects implementing concurrently.

Second, staff in her department was often involved in multiple projects at any one time. They frequently complained about how inefficient and political their project meetings had become. People often fought over the best way to implement a project. As a result of the talent crunches, project managers in the department were also found competing fiercely for the best to be involved in their own projects.

Third, senior management often did not provide a clear strategic priority on many of the IT projects in her company. This has resulted in some of her department's project managers deciding to make their own choices on which projects that they should prioritize to work on. The consequences are severe as some of the projects are left to their demise over time. Finally, the constant infighting among project managers has led to a low morale and mistrusting environment across her department that consists of around 200 staff.

Together, these factors have led to many of the IT projects not being able to meet its project's schedule and budget. The Chief Operating Officer fired the previous Director of IT exactly because of these factors and hired Hui Hui specially to resolve these challenges in the company.

As Hui Hui takes stock of the current situation in her company, she knows that a project portfolio management system will be one of the solutions that she should consider.

Hui Hui compiled all the recommendations provided by your team into a presentation for the management.

While doing so, she realized that she would need to estimate the amount of resources (e.g. manpower and finances) that she would need for her project portfolio management project.

She worked closely with your team to come up with the following task responsibility matrix and the type of expertise that she would need for each task.

Activity

1

2

3

4

5

6

Table 1: Project's tasks information

DescriptionDurationPredecessor

(Man-days)

Project Portfolio Management Project

Assemble project team10 days

Develop project priority scheme5 days2

Develop project screening process10 days2,3

Develop project schedule5 days2

Compile project system requirements18 days5,3,4

Resource

7

8

9

Compute project costing

Seek senior management approval

Purchase system

5 days

2 days

15 days

3,4,6

7

8

Project Manager

Project Manager

Project Manager

Project Manager

Senior System

Analyst, Senior

System

Administrator,

Project Manager

Project Manager

Project Manager

Senior System

Analyst, Senior

System

Administrator,

Software: One-

time investment

S$25,000/=

Hardware: One-

time investment,

S$100,000.

Senior System

Administrator

System Analyst

A, System

Analyst B, Senior

System Analyst,

Senior System

Administrator

Project Manager,

Senior System

Administrator,

Senior System

Analyst, System

Analyst A,

System Analyst B

Project Manager

Senior System

Administrator,

Senior System

Analyst, System

Analyst A,

System Analyst B

Page 7 of 10

10

11

Install system

Develop & configure system

18 days

12 days

8,9

8,9,10

12

Perform system test

10 days

10

13

14

Communicate to key stakeholders

Prepare system for go live

8 days

18 days

8,12

12

Activity

15

Go live

Description

Duration

(Man-days)

20 days

Predecessor

13,14

Resource

Project Manager,

Senior System

Administrator,

Senior System

Analyst, Business

Analyst A,

Business Analyst

B, Business

Analyst C,

Business Analyst

D

Project Manager,

Senior System

Administrator,

Senior System

Analyst

16

Document project for closure

4 days

15

The unit cost for each of the resources is shown in the table below. Assume each working day

starts at 8 am and ends at 5 pm and includes lunch time of 1 hour (12 pm to 1 pm).

Title

Project Manager

Senior System Analyst

Senior System Administrator

System Analyst

Business Analyst

Software Cost

Hardware Cost

Cost

S$50/hr

S$30/hr

S$30/hr

S$20/hr

S$20/hr

S$25,000

S$100,000

Overtime Cost

S$80/hr

S$50/hr

S$50/hr

S$30/hr

S$30/hr

N.A.

N.A.

Question 1

Using the information above, demonstrate your understanding on project management by the estimated total cost for the project and the corresponding costs of each task in MS project. You must arrange the appropriate tools in MS Projects to answer the question.

Present your answer using screen captured from MS Project. Answer not using MS project will get zero mark.

Question 2

After allocating the resources into each of the task, Hui Hui realized that there were some resource allocation issues in the project.

(a) Using MS Project, identify and analyse all the tasks that have resource overallocation issues. Present your answer using a screen capture of the MS Project information.

(b) For each of identified resource overallocation issue, examine and appraise what would be your strategy to address each one of them.

ECA - January Semester 2015

(c) For each of your strategy, analyse and discuss what would be the impact, in terms of cost, quality, scope or risk, of your strategies to the project.

Hui Hui subsequently realized that she had made a mistake in the configuration of the dependencies of task 12. Task 12 is dependent upon task 11 but is not being set so. She had also decided to perform resource levelling on all the remaining tasks to address the identified
resource overallocation issues.

Question 3

Update your MS Project schedule accordingly and present the screen shots of the Gantt Chart and the project costs. In addition, evaluate the information in MS project, and answer the following questions.

(a) What is the new project end date?

(b) What is the new project duration?

(c) What is the new estimated project cost?

(d) What is the critical path of the project?

Question 4

Identify & critique the project schedule and cost estimation technique that Hui Hui has employed in question 1, 2 and 3 (Taking into consideration information presented in this You may briefly propose an alternative.

Solution Preview :

Prepared by a verified Expert
Project Management: Demonstrate your understanding on project management by
Reference No:- TGS01119808

Now Priced at $80 (50% Discount)

Recommended (96%)

Rated (4.8/5)