Civil Engineering Department Project Management – (ENGG 0004)
Lab Report #2
Submitted by: Session AA Submitted to: Eman Alharrasi
Fall 2017
TABLE OF CONTENTS: TABLE OF CONTENTS …………………………………………………………….…………...I LIST OF FIGURES ………………………………………………………………………………… II CHAPTER ONE: INTRODUCTION: INTRODUCTION ……………………………………………………………. 3
CHAPTER TWO: LABORTARY DATA LABORTARY DATA ……………………………………………………... 3
CHAPTER THREE: RESULTS DISCUSSION RESULTS DISCUSSION ……………………………………………………….. 4 -12 CHAPTER FOUR: CONCLUSION CONCLUSION ……………………………………………………… 12 - 13 CHAPTER FIVE: REFRENCES REFRENCES …………………………………………………………………… 13
I 1|PAGE
LIST OF FIGURES Figure (1): The Given Data of the project. ……………… ……………………3 Figure (2 Showing the duration and the project due date ………4 Figure (3 showing the crane resources graph before leveling. …………………… 4 Figure (4) Labor graph before leveling. ………………………….. 5 Figure (5):. M1 graph before leveling. …………………………………………… 5
II
2|PAGE
INTRODUCTION :
The resources sheet in Microsoft project software is a window that the user can edit, view and create the resources and the resources information. (Ben Howard, 2013) Moreover, managing these resources in any project is really important where it enables the effectiveness of the scheduling, improving the recourse allocation and make a reliable cost planning. Thus, allocating the right project and avoiding the overload in the same time while managing. (Venkatraman , 2011) Resources levelling is an essential demand that has to be applies in any project software as it’s the process of changing the schedule by moving tasks to dates when there is available resource capacity when over-allocation happens . (Kenneth steiness, 2014) In this report there were two types of resources used which are the work type and the material type, data were added to it and they were assigned. Adding to that, the resources were levelled and each resources its cost was added and analyzed by inserting a cash flow chart. The Objectives of conducting this report is to produce a master program with the resources management for a low complexity project by following the steps that has been mentioned above starting from adding the resources data to inserting cash flow chart.
LABORTARY DATA :
3|PAGE
Figure (1): The Given Data of the project.
RESULTS / DISCUSSION :
1) The project duration is 31 days and the project due date is 18th of February 2018.
. Figure (2): Showing the duration and the project due date
2) The crane graph before leveling.
4|PAGE
Figure (3): showing the crane resources graph before leveling. -
The labor graph before leveling
Figure (4): Labor graph before leveling. -
The M1 graph before leveling.
5|PAGE
Figure (5): M1 graph before leveling. -
The M2 graph before leveling.
Figure (6): showing the M2 graph before leveling.
3) The project duration got increased after leveling all resources by 4 days as it reached 35 days, and the due date got delayed also to become 22nd February 2018.
6|PAGE
Figure (7): Showing the project duration and due date after leveling.
4) Crane graph after leveling
Figure (8): Showing the crane resources graph after leveling -
Labor graph after leveling resources
7|PAGE
Figure (9): Showing the labor graph after leveling resources. -
M1 graph after leveling
Figure (10): M1 graph after leveling -
M2 graph after leveling the resources 8|PAGE
Figure (11): Showing the M2 graph after getting levelled. 5) The levelling delay time for each activity is zero except activity c was delayed 8 days.
Figure (12): Showing the leveling delay time.
6) The total project cost is 104,350.00$. 9|PAGE
Figure (13): The total cost of the project.
7)) the cash flow is very important to be used in MS office as its predicts the money usage and how it may spent or received in any project. (Microsoft, 2016) below is graph of the project.
Figure (14) : The cash flow chart 10 | P A G E
Figure (15): The cash flow chart data.
8) The resources of the crane allocated manually.
11 | P A G E
Figure (16): Table showing the resources manually.
12 | P A G E
Figure (17): Manually drawing of project duration.
9) The duration of the project manually was 34 days, on the other hand the duration of the project by using Microsoft Project was 35 days, this difference of the duration which appeared in the manual because we levelled four resources and manually we used only one resource which is the crane.
CONCLUSION :
To conclude this report , steps has been followed by using the Microsoft project software to produce a low complexity program for a project by managing two types of resources which are the work and the material , then editing these resources by adding data to the resources for the crane , labor and the material and edit its details ( type , rate , etc. . After all these edits, the resources were levelled to meet the constraints of the project and 13 | P A G E
observe the due date of the project and the duration before and after the levelling. Finally, manual management has been done to compare the results with the software results by the duration of the project and there was a difference by one day due to the levelling command.
REFERENCES :
-
Ben Howard (2013) ‘Assigning and Managing resources in Microsoft project 2013’ [Online]Available,from:https://www.microsoftpressstore.com/articles/article.aspx ?p=2199424&seqNum=2 [7 December 2017]
-
Kenneth steiness, (2014) “Recouces levelling Best practices” [online] Available from : https://www.mpug.com/articles/resource-leveling-best-practices/
[7
December 2017]
-
Venkatraman (2011) ‘ Resources Management with Microsoft project ‘ [online] Available from : http://www.brighthubpm.com/software-reviews-tips/48745resource-management-with-microsoft-project/ [7 December 2017]
-
Microsoft ( 2016) “ Cash flow overview” [online] Available from : https://msdn.microsoft.com/en-us/library/hh168953(v=nav.90).aspx [7 December 2017]
-
dffgg
14 | P A G E