MS project

User Generated

mvlnq187

Business Finance

Center for Technology - Essex

Description

i have task for MS project.......

please find attached 5 file .......

there is one file example pf sloution. i need same progress

Unformatted Attachment Preview

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
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

i M wo...


Anonymous
Great study resource, helped me a lot.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags