W9.1 – Ahmed AL-Abri- Create a Basic Gantt chart in Excel


1. Problem Definition

A consultant company wants to present their Schedule for the client in the kick of meeting and it does not have a planner and the company does not want spend money in the training of any of their staff or hiring professional planner . Moreover the consultant company dose want to advanced program in planning and scheduling

2. Identify the Feasible Alternative

The project manager of the consultant company decided to create the Gantt chart in excel. This selection based on the following criteria:-

  • Less cost.
  • Required Unprofessional staff to create the chart.
  • Only five tasks in the project as shown in figure-1
  • Training time for the program should be short.
  • The purpose of the chart is only a presentation.

3. Development of the Outcome for Alternative

The table below summarizes the task, start date, duration and finish date

Figure 1- Task Data

Figure 1- Task Data

 

 

 

 

4. Selection Criteria

 The steps to create the Gantt chart in excel are explained clearly in the below link of YouTube:-

http://www.youtube.com/watch?v=sA67g6zaKOE

For our case the implementation of the instruction in the above link will result to the following Figure:-

Figure 2- Gantt Chart in excel

Figure 2- Gantt Chart in excel

 Another option is to use Microsoft project programand the comparison will be shown in the next step based on the requirement of the consultant and not based on the efficiency of the program

5. Analysis and Comparison of the Alternative

Figure 3 below is self-explanatory of the comparisons between using Gantt chart in excel 2010 and Microsoft project

 

Figure3- Comparison table

Figure3- Comparison table

 6. Selection of the Preferred Alternative

From figure 3 it is clear that creating Gantt chart in excel is the best choice for the consultant company because it meets their selection requirement and it does not mean that Microsoft program is not a good program but it is not required for this company.

Gantt charts are most commonly used for tracking project schedules. It is useful to show information about the various tasks or phases of the project, the tasks relate to each other, how far each task has progressed, what resources are being used for each task and so on. For quick events such a presentation or small assignments and with less spend pf money Gantt chart in excel will be sufficed.

 7. Performance Monitoring and the Post Evaluation of Result

A Gantt chart, commonly used in project management, is one of the most popular and useful ways of showing activities (tasks or events) displayed against time. Each activity is represented by a bar; the position and length of the bar reflects the start date, duration and end date of the activity. This allows you to see at a glance:

  • What the various activities are
  • When each activity begins and ends
  • How long each activity is scheduled to last
  • Where activities overlap with other activities, and by how much
  • The start and end date of the whole project

To summarize, a Gantt chart shows you what has to be done (the activities) and when (the schedule).

For presentation and small assignment a Gantt chart might be presented in excel. For big project a Gantt chart should be presented in primavera or Microsoft project. At the end it depends on the requirement of the user.

8. Reference:

1. Jodi Sorensen (2013, July). How to Create a Gantt chart in Excel Retrieved July 06, 2014, from http://www.smartsheet.com/blog/gantt-chart-excel?page=27

2. Chart Director (2008, December). Simple Gantt Chart. Retrieved July 06, 2014, from http://www.qrb-bw.de/pdf_pool/pythondemo/cdpydoc/gantt.htm

3. Project smart. (2013, August). How to Create a Gantt Chart Using Microsoft Excel. Retrieved July 06, 2014, from http://www.projectsmart.co.uk/creating-a-gantt-chart-using-excel.php

 

 

Advertisements

One thought on “W9.1 – Ahmed AL-Abri- Create a Basic Gantt chart in Excel

  1. Sorry Ahmed, you still are missing a several important points….

    You stated above “The project manager of the consultant company decided to create the Gantt chart in excel. This selection based on the following criteria:-”

    What I am looking for here is the project manager decided to create a Gantt Chart from WHAT OPTIONS? (i.e. Primavera, MS Project….)

    What you have written in the “Feasible Alternatives” section is good stuff but that is not where it belongs….. That needs to be moved to Step 4, Selection Criteria.

    Also, you only looked at the POSITIVES of using a Gantt Chart. What about the NEGATIVES?

    Try these for references to see what this post SHOULD look like if you wanted to get 5 stars-
    http://www.pmhut.com/advantages-and-disadvantages-of-gantt-charts

    http://it.toolbox.com/blogs/enterprise-solutions/pros-cons-of-gantt-charts-22233

    http://www.brighthubpm.com/templates-forms/2434-top-ten-benefits-of-a-gantt-chart/

    http://creately.com/blog/diagrams/5-reasons-to-use-gantt-charts/

    Bottom line, most of the pieces are there but you need to set your analysis up correctly……. Take a look at the two examples above and then rewrite this blog in a way that convinces us that your choice of using a Gantt Chart was justified for this particular application. Be sure to analyze both the FAVORABLE and the UNFAVORABLE aspects.

    BR,
    Dr. PDG, Jakarta

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s