Student ID:
Family Name(s):
Forename(s):
Declaration: I declare that this Coursework is my own work.
Cheating is a serious academic
offence. I have read and agree to abide by the University guidance on Academic Honesty.
I consent to appropriate storage of our work for plagiarism checking.
Signature(s):
Time taken to complete assignment (hrs.):
Department: Civil Engineering
Module Title: Project Management
Module Code: ENGG 0004
Lecturer: Ms. Eman Al Harrasi
Ms. Siham Farrag
Assignment Title: Course Work # 2
Assignment Type: Individual
Estimated Time (hrs.): 15 hours
th
Date of Submission: 18 December, 2019
Learning Outcomes Assessed (or on separate sheet)
As on the assignment
Assessment Criteria (or on separate sheet)
Max
Awarded
100
Penalty
Assessor’s signature:
Note
Date:
Final Mark
1. If you are unable to submit your work due to extenuating circumstances you may apply for an extension.
2. The MEC policy on Assessed Coursework applies to this coursework. You are advised to read the guidelines in
the student handbook.
Project Management (ENGG 0004)_FALL 19_ CW2
Project Management - ENGG 0004
Course Work Assignment # 2 – FALL 2019
(Individual Assignment)
Date of submission: 18th Dec, 2019
Total Marks: 100
INTRODUCTION:
The purpose of the manual is to highlight the objectives and deliverables for students doing their
course work project in Project Management module.
Learning Outcomes
1. Apply basic principles of management to the use of materials, plant and labour on
construction projects.
2. Identify the issues involved in securing productivity gains in construction.
3. Produce programmes for low complexity projects using appropriate manual techniques.
4. Use project planning software to generate master programmes for simple construction
or design projects.
TASK:
The following project case is exercise that can be solved individually. In the project, students will
have hands-on experience in developing an integrated framework for the resource management,
project costs, and project control.
Data:
In the following project (Figure 1), a simple warehouse is to be constructed. The building consists
of a receiving area, shipping, order picking, order assembly area, storage, miscellaneous area and
office. After 10 weeks of starting the construction, the project planner has reviewed the work
progress of the activities in the project. The objectives are to follow the project plan, monitor
actual site execution and keep track of resources, compare actual versus planned progress and
take corrective actions at any stage. The resource bank involves crane, excavator, material, and
2|Page
Project Management (ENGG 0004)_FALL 19_ CW2
labor resources are given in the attached “ENGG 0004_Coursework 2-Data_Fall 19” Excel sheet.
List of project activities, durations, logical relationships, and list of required resources are given
in Table 1. On the other hand, the actual data obtained from the site is given in Table 2.
Receiving
Shipping
Order
picking
Storage
Miscellaneous
Order
Assem
bly
Office
Figure 1: Warehouse Plan
Requirements:
1. Use Microsoft Project to construct Gantt chart and observe the project duration and project
due date (If the project duration (according to the contract) more than the Microsoft Output,
Discuss the benefits for the contractor from that gap).
2. After assigning resources to all tasks with required quantities, discuss the project duration
before and after levelling, and identify in details the main problems associated with
resources.
3. According to the project data, only 8 cranes are available for the work and each activity has
to be completed without break. Manually allocate resources and find the minimum project
duration (for crane resource only and neglect others).
4. Discuss and print the Earned Value Table and the Tracking Gantt Chart by using Ms Project.
5. It is required to calculate BCWS, BCWP, ACWP, CV, and SV for the project manually,
comment on the progress of the project and compare it with Ms Project results.
6. You are the project manager for a project and have just complied all of the design work
packages and found that the costs exceed the approved budget. What are your options to
manage the discrepancy?
3|Page
Project Management (ENGG 0004)_FALL 19_ CW2
Notes:
The project start date must be 2nd January, 2020.
Make all days are working days in the Standard calendar.
Update the information of the project resources as follows:
Resource
Crane
Labor
Excavator
Material
Type
Work
Work
Work
Material
Max.
8
12
2
-
Project tracking date is 7th March 2020.
Any missing data can be reasonably assumed.
Rate
$ 350/day
$ 40/day
$ 400/day
$ 250
Tips:
1. Proofread! Check spelling and punctuation.
2. Be clear. Be concise.
3. Remember your goals and audience. Managers look for cost-effectiveness. Engineers
look at feasibility.
Please keep in mind following facts while writing your report:
The report is often used to present, analyze and summarize your data.
You will find in the following some basic instructions on how to prepare the report.
Report Format
The size limit: Normally, contain your report max. 15 pages of written text plus additional
pages for Figures (index).
Follow specified spacing. Generally use 1.5 x line spacing unless advised.
Start with the title page (including your name) or student number as requested.
Include your own field photographs. It is generally better to position figures within the text
rather than group them at the end of the report.
Give a sequential number to all figures and tables (Fig. 1, Fig. 2, Fig. 3, Table 1, Table 2, etc.)
Add a brief, informative caption to the figures and to the tables as well.
Sections of the Report
The Report should contain the following sections:
Introduction
4|Page
Project Management (ENGG 0004)_FALL 19_ CW2
Your Deliverables
Conclusions
References
1. Introduction (maximum 2 page)
Summarize the brief history and theory on that topic.
Outline the case and focus on its significance (problem statement).
Introduce the project
How has the work been done?
Give the general plan of the report.
2. Your Deliverables (maximum 12 page)
Constructing the Gantt chart and finding requirements.
Assigning the required resources (materials, labor, crane, and excavator).
Leveling the resources and solve the problem associated with a limited resource.
Tracking the progress of the project during the construction.
The output of the Microsoft Project (Bar chart, Earned Value Table, etc.)
Manual calculations
Discussion
3. Conclusions (maximum 1 page)
State briefly what are the major achievements of your work?
4. References
Use CU-Harvard referencing system as per our college rules.
Here is an example of what a Reference List looks like in the CU-Harvard Style:
Moriarty, D. (2012) Funding models for Irish film makers. Dublin: Collins Press.
Hayes, B. C., McAllister, I. and Dowds, L. (2011) 'Depicting Ireland on Film, what are
we really saying?', Social Cinema Journal, 54(4), pp. 454-482.
An example of referencing a web-page in the CU-Harvard Style:
Middle East College (2018) MEC Campus [online] available from
[7 October 2018]
5|Page
Project Management (ENGG 0004)_FALL 19_ CW2
5. Appendix
For any additional figures, tables, and photos.
A report not exceeding 20 pages.
GUIDELINES:
Follow the guidelines mentioned below for your assignment.
Assignment should have a Title Page. Title Page should contain the following
information.
Assignment Name
Class
Student name
Student ID
Use page numbers
Assignment should be typed in your own words and computer typed using Times
New Roman font size 12.
Heading should be with Font Size 14, Bold, Underline
Use Diagrams and Examples to explain your topic.
Copy and paste from the Internet sources is strictly not acceptable and will be
treated as a plagiarism and will be dealt with as per polices given below.
Your report should be submitted as soft copy (.doc formats) through the Moodle.
All assessments should be marked out of 100 marks and scaled down to the corresponding
assessment weightage as given in the assessment matrix; however the complexity of the
assessment shall remain as per that weightage. For e.g. coursework have a weightage of 25 will be
set out of 100 and the corresponding answers will be evaluated out of 100 marks. If the student
scores 80 marks for this test, then his/her actual mark component for this assessment will be 20 out
of 25.
The course work (Internal Assessment) marks are provisional until the Exam Board has approved the
same at the end of the semester.
6|Page
Project Management (ENGG 0004)_FALL 19_ CW2
Rules & Regulations
If any content or diagram of the assignment is found copied from the other students then
marks will be deducted from both assignments.
The purpose of assignment is to do some research work so you can consult books in Library
or use internet or computer magazines or any other source.
Late Submission
The recommended practice at MEC is to set the cutoff time to 23:59 on the due date for all
assessment submissions. As per the Assessment Policy at MEC, late submissions are allowed
for one week (5 working days) for all UG modules with a penalty. In such cases, a deduction
of 5% of the marks obtained for the submitted work shall be imposed for each working day
following the last date of submission till the date of actual submission. Assessment
documents submitted beyond a period of one week (5 working days) after the last date of
submission will not be accepted and will be awarded a zero for that assessment. In cases
where the submission has been delayed due to extenuating circumstances, the student may
be permitted to submit the work without imposing the late submission policy stated above.
The extended period of submission will be one week from the original last date of
submission. In such cases, the student is expected to submit the supporting certificates on
or before the original last date of submission of the assessment and the decision of
extension rests with faculty responsible for the assessment .The late submission policy shall
be applied if the student fails to submit the work within one week of the original last date of
submission.
Students may contact their teachers for clarification on specific details of the submission
time if required.
Academic Integrity Violations-Plagiarism/Malpractice/Collusion/Ghostwriting/Other cases
As per MEC policy, any form of violation of academic integrity will invite severe penalty.
Plagiarized documents, in part or in whole, submitted by the students will be subject to this
policy.
1. Plagiarism
A. First offence of plagiarism
a. If a student is caught first time in an act of plagiarism during his/her course of study in any
assignment other than project work, the student will be allowed to re-submit the
7|Page
Project Management (ENGG 0004)_FALL 19_ CW2
assignment once, within a maximum period of one week. However, a penalty of deduction
of 25% of the marks obtained for the resubmitted work will be imposed.
b. Period of re-submission: The student will have to re-submit the work one week from the
date he or she is advised to re-submit.
If the re-submitted work is also found to be plagiarized, then the assessment will be
awarded a zero mark
d. Re-submission of the work beyond the maximum period of one week will not be accepted
and the assessment will be awarded a zero mark.
e. If plagiarism is detected in Project work (Project 1, Project Planning and Project Design
and Implementation) the above clauses (a,b,c,d) do not apply and the work will be
summarily rejected. In these cases the student will be awarded a fail (F) grade and is
required to re-register the module
f. If the student fails the module and has a proven case of academic integrity violation in this
module, the student is required to reregister the module
B. Second offence of plagiarism
a. If any student is caught second time in an act of plagiarism during his/her course of study
(in a subsequent semester), the student will directly be awarded zero for the work in which
plagiarism is detected. In such cases, the student will not be allowed to resubmit the work.
b. If the student fails the module and has a proven case of academic integrity violation in
this module, the student is required to re-register the module
C. Third Offence of plagiarism
If any student is caught for the third time in an act of plagiarism during his/her course of
study (in a subsequent semester), the student will be penalized with a fail in the module and
shall be required to re-register the module.
D. Fourth Offence of plagiarism
If any student is caught for the fourth time in an act of plagiarism during his/her course of
study (in a subsequent semester), the student shall be suspended from the College for a
period of one semester.
E. Fifth offence of plagiarism
If any student is caught for the fifth time in an act of plagiarism during his/her course of
study (in a subsequent semester), the student shall be expelled from the College
Types/Variations of cases of Plagiarism and associated actions
A. Type 1: In case plagiarism is detected in any component or part submission
(submitted at different times) of one assessment (assignment), the deduction in
marks will be applicable for the whole assessment (assignment), even if only the
component or part submission alone needs to be resubmitted.
8|Page
Project Management (ENGG 0004)_FALL 19_ CW2
B. Type 2: In case plagiarism is detected in a group assessment, all students of the
group will be considered as having committed an act of plagiarism irrespective of
whether plagiarism is on account of the act of all or a few or only one member. The
policy will then be applied to all students.
C. Type 3: Combination of Type 1 and Type 2: In case plagiarism is detected in any
component or part submission (submitted at different times) of a group assessment
(assignment), the deduction in marks will be applicable for the whole assessment
(assignment), even if only the component or part submission alone needs to be
resubmitted. All students of the group would be considered as having committed an
act of plagiarism irrespective of whether plagiarism is on account of the act of all or a
few or only one member. The policy will then be applied to all the students of the
group.
D. Type 4: Variation of Type 1 and Type 2: In cases where the assessment consists of
components or part submissions that could be a group assessment component (e.g.
group assignment) and an individual assessment component (e.g. individual
reflection), the following will be applicable:
a. If plagiarism is detected in the group assessment component, all students of
the group will be considered as having committed an act of plagiarism,
irrespective of whether plagiarism is on account of the act of all or a few or
only one member. The policy will then be applied to all students of the group.
In such cases the group assessment component will be resubmitted as per
the policy.
b. If plagiarism is detected in the individual assessment component, the
individual assessment component will be resubmitted as per the policy. The
policy will then be applied to that student alone.
c. In both cases (a) and/or (b), the deduction in marks will be applicable for the
whole assessment (assignment).
2. Malpractice/Ghostwriting/Collusion
A. First offence of Malpractice/Ghostwriting/Collusion
If a student is caught in an act of Malpractice/Ghostwriting/Collusion for an assessment
component irrespective of coursework or end semester, the student shall fail the module
and shall be required to reregister the module.
B. Second Offence of Malpractice/Ghostwriting/Collusion
If a student is caught a second time in an act of Malpractice/Ghostwriting/Collusion for an
assessment component irrespective of coursework or end semester (in a subsequent
semester), the student shall be suspended for one semester from the College.
C. Third Offence of Malpractice/Ghostwriting/Collusion
If a student is caught a third time in an act of Malpractice/Ghostwriting/Collusion for an
assessment component irrespective of coursework or end semester (in a subsequent
semester), the student shall be expelled from the College.
9|Page
Project Management (ENGG 0004)_FALL 19_ CW2
3. Other cases
If a student commits an act of academic integrity violation as per the definition of “other
cases” mentioned in the previous section or of a different nature, those cases shall also be
forwarded to a departmental level committee set for the purpose .The committee shall
investigate the case by means of a viva and/or a disciplinary hearing and shall take
appropriate decision. The minimum penalty that can be granted to a proven case of
academic integrity violation which falls in this category of “other cases” is a fail in the
module. For further offences in this category, the penalty can range from suspension to
expulsion from the college depending on the nature and gravity of the offence. The
guidelines given below should be followed for undertaking the viva/disciplinary hearing for
such cases.
Types/Variation of Cases of Multiple Offences
If a student is caught in a subsequent offence of academic integrity violation which is of a
different nature than the previous offences, then the penalty shall be applied as per the
penalty detailed for the subsequent offence of the current violation.
For example, a student was found to have plagiarized during a semester and was penalized
with deduction of 25 percent marks in his resubmitted mark as per the policy on Plagiarism.
During a subsequent semester, if the same student is caught in malpractice, then the
student will be suspended from college for a semester as detailed in the penalty for second
offence of Malpractice.
As per MEC policy, the minimum penalty that can be granted to a proven case of academic
integrity violation which falls in the category of “malpractice”, “ghostwriting” , “collusion
“ or “other cases” is a fail in the module. The student shall be required to re-register the
module.
Assessment Sheet – Basic Assignment Analysis:
Introduction
Outstanding
(≥ 91%)
(84-90%)
Excellent
(77-83%)
Very Good
(70-76%)
Good
(Acceptable)
(50-69%)
Adequate/
Satisfactory
Information is
engaging;
clearly
state
the main idea
covering major
concepts with
supporting
details,
wellconstructive
paragraphs
with
outset
introduction.
Highly
competent
Information
is
fairly formulaic,
very
well
organized with
key
scientific
concepts, wellconstructive
paragraphs.
Information
is
very
clear,
organized
with
well-constructed
paragraphs.
Objectives
of
assignment and
structure
of
report are clearly
provided.
General
introduction with
some
related
details
are
provided.
Objectives and
structure of the
report evidently
mentioned.
Information is
organized,
but
paragraphs
are not wellconstructed.
Strong
analytical skills
Good use of
analytical skills
Acceptable use
of
analytical
Adequate use
of analytical
(< 50%)
Weak /Poor
(all
learning
outcomes
not
adequately met)
The
information
appears to be
disorganized.
Efforts have been
made
to
give
objectives
and
structure of the
report.
Insufficient/no use
of analytical skills
10 | P a g e
Project Management (ENGG 0004)_FALL 19_ CW2
Reflection and
critical
analysis
of
report
Conclusion
Reference
General
analytical skills
and reflective
practice,
demonstrating
personal
learning
and
growth, insight
into
required
professional
values
and
principles
related
to
using
Ms
project
and
comparing
results
between
Ms
project and the
manual part.
and reflective,
demonstrating
personal
learning
and
growth, insight
into
required
professional
values,
principles
related to using
Ms project and
comparing
results between
Ms project and
the manual part.
and
reflective
practice
demonstrating
personal learning
and
growth,
insight
into
required
professional
values, principles
related to using
Ms project and
comparing
results between
Ms project and
the manual part.
skills
and
reflective
practice
demonstrating
personal
learning
and
growth, insight
into
required
professional
values,
principles
related to using
Ms project and
comparing
results between
Ms project and
the manual part.
skills
and
reflective
practice
demonstratin
g
personal
learning and
growth,
insight
into
required
professional
values,
principles
related
to
using
Ms
project
and
comparing
results
between Ms
project
and
the
manual
part.
Conclusion
reflects
on
findings of the
study
and
involves
some
information
related
to
findings.
and
reflective
practice
demonstrating
personal learning
and
growth,
insight
into
required
competencies and
professional
related to using
Ms project and
comparing results
between
Ms
project and the
manual part.
Conclusion
should
summaries the
significant idea
you
have
discussed.
Make
new
connections
and elaborate
the key points
of
your
findings.
Conclusion very
clearly reflects
on main findings
of the study and
involves critical
thinking; reflect
the
most
appropriate
issues
or
findings
and
significance
points of the
report.
Conclusion
clearly reflects
on main findings
of the study and
involves
required
information
related to issues
or findings and
significance
points of the
report.
No errors in
citations with
right format of
listing the CU
Harvard Style.
Includes
websites,
journals,
reference
books,
magazines etc.
No
obvious
errors
in
referencing or
grammar
or
syntax
as
appropriate.
Correctly using
the
CU
Harvard
Style.
Conclusion
clearly reflects on
main findings of
the study and
involves
arguments that
reflect the most
appropriate
issues or findings
and covers the
major
significance
points of the
report.
Very few errors
in
citation/referenci
ng
list
or
grammar
or
syntax
as
appropriate.
Correctly using
the
CU
Harvard
Style.
Few errors in
citation/referenc
ing or grammar
or syntax as
appropriate.
Generally
accurate
use
of
CU
Harvard
Style.
Some
repeated
errors
in
referencing or
grammar or
syntax
as
appropriate.
Contain some
inaccuracies
in CU
Harvard
Style.
Some sources are
not
accurately
documented.
Incorrect style of
CU Harvard style.
Outstanding
write-up,
logically
structured,
using correct
objectives,
neatness,
accuracy,
grammar,
spelling,
accurate
citations,
include proper
headings and
subheadings,
correctly using
the
CU
Harvard
Style.
Obvious
write-up,
logically
structured,
using
correct
objectives,
grammar and
spelling,
accurate
referencing and
correctly using
the
CU
Harvard
Style.
Good write-up,
well
structured,
acceptable
grammar
and spelling,
generally well
referenced with
correct use of the
CU
Harvard Style.
Acceptable
Write-up and
structure,
acceptable
grammar,
spelling and
acceptable
referencing.
Generally
accurate
use
of
CU
Harvard
Style.
Adequate
Write-up and
structure,
grammar
and spelling
and
adequate
referencing.
CU
Harvard Style
used
but
may
contain
some
inaccuracies.
Poor/weak
Write-up,
Grammar,
spelling, little or no
referencing,
incorrect style, or
very
inaccurate
use
of CU Harvard
style.
Conclusion does
not
reflect
on
findings of the
study
and
information related
to findings is not
up
to
the
requirements.
11 | P a g e
Project Management (ENGG 0004)_FALL 19_ CW2
Student ID:
Student Name:
Report Grading
S.
N
o
1
Task*
Outstan
ding
(≥ 91%)
Excellent
(84-90%)
Very
Good
(7783%)
Good
(7076%)
Satisfactory
(50-69%)
Weak
/Poor
(< 50%)
Marks
Report Format and
Structure
Introduction
5
Constructing Gantt
chart using Ms Project
Discussing benefits for
the contractor
5
5
Assigning resources
correctly
6
6
Problem associated
with resources
7
7
20
13
Manually allocating
resources & finding
minimum duration
Earned Value Table &
Tracking Gantt chart
(Using Ms Project)
Procedures
implemented in MsProject
Earned Value Table &
Tracking Gantt chart
(Manual)
Comment on the
progress of the project
Project schedule
exceeds the due date
Conclusion
14
References
5
2
3
4
8
9
10
11
12
Marks
allotted
5
5
6
5
15
5
6
5
Total Mark
Penalty
Final Mark (…./100)
Out of 20
*Note total mark obtained by students will be converted out of 20.
Student Signature:
12 | P a g e
Module: Project Management – (ENGG 0004)
Lab Activity # 2
Aim:
Fall 2019
Produce a Master Programme with Resources Management
produce a master programme for a low complexity project with:
Adding resources data
Assignment of resources
Resources leveling
Cost Analysis and cash flow reports
Print
Data: apply the following data to your project
Change the default task type to Fixed Duration (File-Options-Schedule- Default Task Type: Fixed
Duration) as shown in Figure 1.
You may Change the show assignment units as Decimal if you want (File-Options-Schedule- show
assignment units as a: Decimal) as shown in Figure 1.
1
4
3
5
6
2
Figure 1: Initial Settings
Page 1 of 2
Project start date is: 18th December, 2019. (Project tab – Project Information- Start Date area)
Friday and Saturday are nonworking days in the Standard calendar. (Project tab - Change Working
Times-Work Week – Details-Customize)
Change scheduling for the inserted tasks from Manually to Auto. (Use Status bar, or use Options
shown in Figure 1).
Insert the Task Name, duration, and the predecessors are given in the attached Lab Activity_2_Data
Excel sheet.
Display the Project Summary Task by checking the Format, Show/Hide group, Project Summary Task
(check the box).
To show all the project bar chart, View – Entire Project.
Insert the project resources. (View tab - Resources Sheet), and update the information as follows:
o For Crane:
Type: Work,
Max: 2 Cranes.
Crane Rate: $ 300/day.
o For Labor:
Type: Work,
Max: 8 Labors.
Labor Rate: $ 40/day.
o For Materials:
Type: Material
Unit: Each
Rate: $150 for M1 and $250 for M2.
Assign the resources to the tasks. (Resource tab – Assign Resources), and identify the required
quantities (units).
Requirements: After adjusting the project by applying the given data, it is required to
1. Observe the calculated finish date of the project. (What is the project duration and project due date?)
2. After assigning resources, print the Resources Graphs (profiles) before leveling (figure for each
resource).
o Notes:
Before printing show the entire project by View – Entire Project.
To view the resources profiles, select row 0 then go to (Resource – Assign Resource –
select the resources name to view)
3. Use Microsoft Project to leveling all resources (Resources – Level All) to meet the resource constraints.
(What is the project duration and due date?)
4. Print the Resources Graphs (profiles) after Leveling (figure for each resource). Follow the notes in
question 2.
5. What is the leveling delay time for each activity? (Insert the Leveling Delay Column).
6. What is the total project cost? (Insert the Cost Column)
7. Print the cash flow report? (Project tab – Visual Reports – Cash Flow Report excel file)
8. Manually allocate resources and find the minimum project duration (for crane resource only and
neglect others)
9. Compare between manual and Ms Project results for resource allocation problem.
Page 2 of 2
Module: Project Management – (ENGG 0004)
Lab Activity# 3
Aim:
Fall 2019
Project Control and Progress Reports
produce a master programme for a low complexity project with:
Measuring actual progress,
Updating,
Earned Value Analysis,
Printing progress reports
Data: apply the following data to your project
Change the default task type to Fixed Duration (File-Options-Schedule- Default Task Type: Fixed
Duration) as shown in Figure 1.
You may Change the show assignment units as Decimal if you want (File-Options-Schedule- show
assignment units as a: Decimal) as shown in Figure 1.
Uncheck the Actual costs are always calculated by project option (File-Options-Schedule- uncheck
Actual costs are always calculated by project)
Figure 1: Initial Settings
Page 1 of 3
Project start date is: 7rd January, 2020. (Project tab – Project Information- Start Date area)
Make all days are working days in the Standard calendar. (Project tab - Change Working Times-Work
Week – Details-Customize)
Insert the Task Name, duration, and the predecessors are given in the attached Lab Report_3_Data
Excel sheet.
Display the Project Summary Task by checking the Format, Show/Hide group, Project Summary Task
(check the box).
To show all the project bar chart, View – Entire Project.
Insert the material resource and assume the rate is $1000/unit. (View tab - Resources Sheet).
Assign the resources to the tasks. (Resource tab – Assign Resources), and identify the required quantity
for each task.
Create the project baseline (Project tab-Set Baseline).
Change status date to 22-January-2020 (Project tab-Status Date).
Update the project (Project tab-Update Project).
View Earned Value table (View-Tables-More Tables-Earned Value).
Insert the % complete; Physical % columns (right click over the table header-Insert columns one by
one).
Change the earned value method to Physical % for all tasks. (double click over each task-Advanced
Tab-in the Earned Value Method-change it to Physical % as shown in Figure 2).
Change the physical % according to the data given in the attached Lab Activity_3_Data Excel sheet.
Change the actual cost for each task according to the data given in the attached Lab Activity_3_Data
Excel sheet. (View-Details “Task Form” - right click over the task form – select Cost).
Figure 2: Earned Value Method
Figure 3: Actual Cost Data
Page 2 of 3
Requirements:
1. Observe the project duration, due date and cost.
2. Print the Earned Value Table. (Project-Reports-Costs- Earned Value).
3. Use MS Project to print Tracking Gantt Chart (similar to Figure 4).
4. Manually calculate BCWS, BCWP, ACWP, CV, and SV for the project.
5. According to cost and schedule variance, comment on the progress of the project.
Figure 4: Tracking Gantt Chart
Page 3 of 3
Course Work Assessmnet # 2
Module:
Code:
Semester:
Couse Work
Note:
Click the Yellow area to select your name
and to find your data.
Project Management
ENGG 0004
FALL 19
CW 2
MOHAMMED AHMED ABDULLAH AL GHASSANI
Full Name of Student
Student ID
Session
19F19637
Session-B
Click to Select your Name
Required Data (Each student has to use his own data otherwise his report will not be marked)
Table 1: List of Activities, Duration, Predecessors and Required Resources
ID
Description
Duration (days)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
20
8
13
13
13
20
13
10
14
10
10
12
12
12
7
Predecessor
1
3
3,5
2,4
6
2
9
6
10
12
13
9,13
Crane ≤ 8
Resources
Labour ≤ 12
Material
1
3
4
5
2
4
3
none
3
6
none
5
1
4
2
3
6
4
6
4
none
4
4
5
6
3
2
none
4
3
5 units
11 units
22 units
10 units
3 units
25 units
30 units
17 units
8 units
12 units
33 units
21 units
18 units
30 units
42 units
Material
Excavator
%
1800
3000
6500
1100
882
8097
7091
4710
2532
39017
9257
4490
4603
8746
11969
6900
4900
3500
3200
5281
0
5247
4799
8042
0
6471
5858
4034
6025
0
100%
80%
100%
70%
100%
80%
40%
100%
20%
100%
50%
70%
0%
0%
0%
Table 2: Actual Data
Act.
Crane
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
6900
8100
89500
18100
7779
16644
14454
0
11958
15367
0
26288
3823
27300
4858
Actual Data
Labour
2500
2600
1400
3400
1392
0
2262
1093
2764
2653
2030
1197
0
2156
721
Excavator ≤ 2
1
1
1
1
1
none
1
1
1
none
1
1
1
1
none
Department of civil engineering
Project management – ENGG 0004
Course work assignment
Individual assignment
Submitted by:
Zakaria Khadim Almamari
16f16265
Session: A
Submitted to:
Ms. Siham Fraag
Summer 2018
1
Table of contents
Content
Page number
Introduction
3-4
Deliverables
5 - 17
Conclusion
18
References
18 - 19
Table of figures
Figure name
Page number
Figure 1: List of activates, duration,
5
predecessor and required resources
Figure 2: Actual data
5
Figure3: Duration of the project, start date, due date and critical task
6
Figure 4: Gantt chart
6
Figure 5: Activity on node networks
7
Figure 6: Project duration
7
Figure 7: Critical path
8
Figure 8: Activity times
8
Figure 9: Critical tasks
9
figure 10: Crane graph before Leveling
10
figure 11: Labor graph before Leveling
10
figure 12: Material graph before Leveling
10
figure 13: Excavator graph before Leveling
10
Figure 14: Gantt chart after leveling
11
figure 15: Crane graph after Leveling
11
figure 16: labor graph after Leveling
12
figure 17: Material graph after Leveling
12
figure 18: Excavator graph after Leveling
12
Figure 19: Earned value table
13
Figure 20: BCWS, BCWP & ACWP
14
2
Introduction
Projects are one of the means of developing societies and organizations in a balanced
manner, whether these projects are profitable or service oriented. The philosophy of
the project comes from the comprehensive development of individuals with capacities
and organizations to upgrade. Project personnel, whether in their assessment,
management or supervision of their affairs, must have basic skills in project selection,
management and resource orientation. In addition, the role of project management has
become more important, as it helps in the success and follow-up of projects and
activates the use of resources and access to optimal use cases (Project management
institute, 2017).
Therefore, construction project management is the nucleus of modern engineering
work, since successful management ensures the implementation of the project without
Violation of the financial and temporal budgets allocated to it in addition to the
required quality assurance. The documentation of administrative processes helps to
determine the actual state of the project and update the plan, which ensures Maintain
the project path within the required data (cost, time, quality).
Management is also one of the clearest indicators that distinguish between developed
and developing societies. Experience has shown that good plans can fail under bad
management, and that weak plans can be improved and enhanced through successful
management. The good management may compensate for its efficiency and efficiency
due to the lack of resources and capabilities while also addressing the weaknesses and
shortcomings in the plan. Management is the function of implementing the work
through others through the use of planning, organization, direction and control in
order to achieve the objectives of the organization efficiently and effectively taking
into account the internal and external influences on the working environment.
3
The importance of project management has increased significantly because of the
development of companies and organizations and their complexity, so that the
supervision of the activities that accompanied this development and complexity
greater than the capacity and capabilities of the individual, the need to use the
management levels of these projects to be controlled (Pavel, 2016).
The main objectives of this course are to apply the basic principles of management to
the use of materials, plant and labor in construction projects. Moreover, it is to
identify the issues involved in securing productivity gains in construction. Another
goal is to produce programs that use manual techniques suitable for simple projects.
In addition, the Microsoft Project program has been used to create major programs for
construction projects. The plan of the work contains (Office blog, 2017):
1. Project resource data have been added.
2. The Gantt chart and AON have been implemented manually and using MS Project.
3. The structure of the scheduling of production for the project has been discussed.
4. All available resources to complete work on the project before and after leveling
have been discussed.
5. Cost of work has been analyzed .
6. The cash flow report has been printed.
7. The factors that effect to crew productivity have been discussed with the producers
to improve productivity.
8. The appropriate measures shall be taken to reduce the duration of the project.
4
Deliverables
Laboratory data
This project has been performed according to the data in figure (1) which consists of
15 activities (tasks) with its duration and predecessor. Moreover, it is contain the
required resources (crane, labor, material and excavator) with their actual data as
shown in figure (2).
Figure 2: Actual data
Figure 1: List of activates, duration,
predecessor and required resources
Results and discussions
1. Some changes have been performed to the schedule of the project which is change
the assignment unit to decimal, the task created has been changed to auto schedule
and the task types has been changed to fixed duration.
2. The project has been begun at 2 September 2018.
3. The stander calendar has been changed to make all days as working days and the
working time from 8:00 AM to 12: PM and from 1:00 PM to 5:00 PM.
4. The data (Tasks, duration and predecessor) has been copied from excel sheet to
Microsoft project program.
5
5. The project summary has been done and the project chart has been shown
completely from entire project.
6. The critical tasks have been appeared.
Figure3: Duration of the project, start date, due date and critical task
7. Gantt chart and activity on node networks have been applied manually.
Figure 4: Gantt chart
6
Figure 5: Activity on node networks
8. Project duration, critical path and critical tasks have been performed.
Figure 6: Project duration
7
Figure 7: Critical path
Figure 8: Activity times
8
Figure 9: Critical tasks
9
9. Recourses graphs have been appeared for each recourse before leveling.
Figure 10: Crane graph before Leveling
Figure 8: Critical tasks
11
Figure 11: Labor graph before leveling
Figure 12: Material graph before leveling
Figure 13: Excavator graph before leveling
10. Recourses leveling
Leveling all recourses have been done. An increase has been observed in project
duration and due date of the project. The duration become 92 days and the due date is
( 2 Dec 2018) due to the resources leveling which is extend the time of the project to
achieve the demand for recourses by the available supply. Leveling in Microsoft
project program aims to resolve the conflict of over distribution in the project plan to
make delays and update to some tasks until the availability of resources (Yaman
Badaiwi, 2017).
Figure 14: Gantt chart after leveling
11
Figure 15: Crane graph after leveling
Figure 16: Labor graph after leveling
Figure 17: Material graph after leveling
12
Figure 18: Excavator graph after leveling
11. Earned values
The management of the earned value of any project is considered a fundamental and
important process as it determines whether the project is on track or not beside its role
of determining the cost and schedule of the project (Humphreys associates, 2017).
The objectives of the earned values are:
- Link time to budget execution to a specific contract task and work statement.
- Make a basis for capturing progress in the assessment of work against the baseline
plan.
- Combine between schedule, cost and technical performance.
- Provide timely, reliable and valid data for proactive analysis and project
management.
13
- Provide managers with a practical level of summation of the tragic decision.
Figure 19: Earned value table
Figure (19) illustrates Budgeted cost of work schedules (BCWP), Budgeted cost of
work performed (BCWP) Actual cost of work performed (ACWP). Through these
three basic elements, it is possible to determine the status of the project through the
cost and schedule of the project. If the actual cost (ACWP) is more than the (BCWP),
the cost of the project will be more than the budget, requiring more money to
complete the project. If the planned value (BCWS) is more than the earned value
(BCWP), the project will be behind the schedule.
14
The figure (19) also shows the variance of the schedule (SV) and cost variance (CV).
If the value of the CV is negative, it means that the project is over the cost, but if the
project is positive it will be under cost while at the expense of the variance is zero in
cost. In the value of (SV), if it is a negative that means the project behind the schedule
and a positive header of the schedule. When (SV) is zero, the project on schedule.
Figure 20: BCWS, BCWP & ACWP
Calculations of BCWS, BCWP, ACWP, SV and CV:
Budgeted cost of work schedules (BCWS) = Planned percent x Budget cost
= (1× 2120) + (1× 4440) + (1× 7460) + (1× 4890) + (1× 2010) + (1× 7650) + (1×
9110) + (1× 4810) + (1× 3650) + (1× 5340) + (1× 8770) + (1× 7480) + (0.67× 5250)
+ (0× 9460) + (0 × 11320) = 71247.5 $
15
Budgeted cost of work performed (BCWP) = Actual percent x Budget cost
= (1× 2120) + (0.8× 4440) + (1× 7460) + (0.7× 4890) + (1× 2010) + (0.8× 7650) +
(0.4× 9110) + (1× 4810) + (0.2× 3650) + (1× 5340) + (0.5× 8770) + (0.7× 7480) +
(0× 5250) + (0× 9460) + (0× 11320) = 48830 $
Actual cost of work performed (ACWP) = summation of ACWP values
=16600 + 17400 + 47900 + 26100 + 15553 + 27345 + 29084 + 10918 + 25260 +
52692 + 18234 + 38641 + 12427 + 46581 + 24505 = 409238 $
Schedule variance (SV) = BCWP + BCWS
= 48830 – 71247.5 = - 22410.5 $ (Behind schedule)
Cost variance (CV) = BCWP – ACWP
= 48830 – 409238 = - 360408 $ (Over cost)
The progress of the project
Schedule variance (SV) has been calculated manually and it is (- 22410.5 $). The
(SV) value is negative which means the project behind schedule and require more
time to complete it. Cost variance (CV) of the project is (- 360408 $) which is
negative value. So, the project is over the cost of the project and need for more money
to complete it.
Comparison of the results of the manual and MS program
There is a difference in the results obtained from the program and the results
of the calculations and it is normal. For example, the value of the (BCWS)
in MS program equals to (249,495.83$) while the manual value is equal to
(71247.5 $). In addition, the (BCWP) value of program is (197,189$) and
the manual value of the (BCWP) is (48830 $). Moreover, the manual value
of (ACWP) is (409238 $) while its value in program is (309,070.00$). SV
value in program which is (52,309.82$) indicate that the project in a head of
schedule compared to SV of manual value that shows the project behind the
16
schedule. Moreover, the value of CV in program is (111,881.00$) that
means the project under the cost while the manual value signs that the
project over the cost.
12. The reasons of lowering of crew’s production rate
There are many factors that affect the productivity of the crew, which may often cause
delay in the duration of the project and increase the cost, and the factors are:
productivity and less efficient work.
reduced productivity.
ticking to trades: When there are many contractors in a particular project site, this
leads to the accumulation of staff and the lack of tools and materials and increase the
risk to the labor and other damage that causes poor productivity.
to a lack of concern supervision and thus a lack of productivity works.
s high temperatures,
rain and snow, which cause a decrease in labor productivity.
stop the work and return to start it will lead to delay the date
of completion of work and increase its cost in addition to its impact in the
organization of other activities and thus weak productivity at work.
(Intergraph, 2012).
The procedure to improve the production rate
There are a lot of things to do to reduce productivity at the workplace, including:
and proper materials and equipment should be available at site.
17
Availability of work crew appropriately
13. The options, if the project schedule exceeds the required completion date
No doubt that you heard this phrase “Time is money” when we are talking about the
duration of the project. Less time taking to complete the project with good or even better
work is a challenge that many people have to do it in order to finish earlier and get
started on another project. Finishing the project in less time is very important in order
to get more client and more completed activities as well as more pay. If the overall
duration of the project exceeds the required duration, there is a chance to reduce it by
changing the critical activities from finish to start to start to start. Also, if it’s possible
to order more cranes and excavators so that the work will finish earlier as well as
starting with many activities in one time. Moreover, spend the time in a good way and
eliminate wasting of time also in turn taking rest time is important to restore the
creativity. In addition, it’s an essential part in the project to create system or an agenda
to follow while working on a project (Exforsys Inc, 2014). Also, sorting priorities by
importance to see the activities which already finished and which need to be completed.
This idea will manage the project in a good manner and will help to complete the project
earlier (Miranda Morley, 2018).
Conclusion
Project management is the main component of any project through the planning,
design and organization of activities that meet project requirements. Microsoft Project
helps to start projects quickly and easily with embedded templates and familiar
scheduling tools that make it easy to support project managers and work teams to
maintain productivity. In this work, data was scheduled and managed to reduce the
18
duration and cost of the project. In addition, all project tasks were controlled. There
are many reasons that lead to poor productivity, including lack of labor experience
and changes in weather and extra work, which necessitates finding appropriate
solutions to raise the level of productivity, including good supervision of staff and
create a workforce with high experience and others. In addition, the Microsoft Project
is a very important role in the management of project resources through the
organization and settlement of the request for resources for each task and this
facilitates the operation of the project more effectively and less cost. In this work, the
earned value, planned value and cost of the project were carried out. The earned value
is an effective tracking and budgeting feature for the project, through which you can
see the amount of work done so far in this project, the amount that was supposed to be
spent and the possibility of completing work on time.
References:
- Project management institute (2017) what is project management? [Online] available
from < https://www.pmi.org/about/learn-about-pmi/what-is-project-management > (8
Sep 2018).
- Intergraph (2012) Factor affecting construction labor productivity managing
efficiency in work planning [Online] available from <
https://www.intergraph.com/assets/global/documents/SPC_LaborFactors_WhitePaper
.pdf > (5 Sep 2018).
- Exforsys Inc (2014) MS Project – Reduce Overall Project duration [Online]
available from < http://www.exforsys.com/tutorials/ms-project/ms-project-reduceoverall-project.html > (7 Sep 2018).
- Office blog (2017) Micrsoft project [Online] available from <
https://products.office.com/en/project/project-and-portfolio-managementsoftware?tab=tabs-1 > (9 Sep 2018).
- Humphreys associates (2017) Basic Concepts of Earned Value Management
[Online] available from < https://www.humphreys-assoc.com/evms/basic-conceptsearned-value-management-evm-ta-a-74.html > (5 Sep 2018).
19
- IBM knowledge centre (2017) Tracking Gantt chart [Online] available from <
https://www.ibm.com/support/knowledgecenter/en/SS8S5A_6.0.5/com.ibm.curam.co
ntent.doc/ServicePlans/c_Service_ManagementGanttChart.html > (10 Sep 2018).
- Pavel, A.(2016) What are project control? [Online] available from <
https://explore.easyprojects.net/blog/what-are-project-controls-why-are-they-soimportant-in-project-management-and-how-to-deal-with-them > (9 Sep 2018).
- Bisiness Directory (2017) Recourses Management [Online] available from <
http://www.businessdictionary.com/definition/resource-management.html > (8 Sep
2018).
- Yaman Badaiwi (2017) Resources levelling [Online] available from <
https://www.projectmanagement.com/wikis/351458/Resource-leveling > (7 Sep
2018).
- shopify (2017) Recourses management [Online] available from <
https://www.shopify.com/encyclopedia/resource-management > (10 Sep 2018).
- Project management (2005) Labor productivety [Online] anailable from <
https://www.cmu.edu/cee/projects/PMbook/04_Labor,_Material,_And_Equipment_Ut
ilization.html > (8 Sep 2018).
- Miranda Morley (2018) How to reduce project duration? [Online] available from <
https://smallbusiness.chron.com/reduce-project-duration-25320.html > (9 Sep. 2019).
21
Purchase answer to see full
attachment