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
4. Selection Criteria
The steps to create the Gantt chart in excel are explained clearly in the below link of YouTube:-
For our case the implementation of the instruction in the above link will result to the following Figure:-
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
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.
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