Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
A detailed overview of a project management lab session conducted at the ho chi minh city university of technology. The lab focuses on the subject of project management and covers various aspects such as inputting data into microsoft excel, defining the activity-on-node (aon) diagram, setting working conditions, and addressing resource overallocation issues. Step-by-step instructions, task details, resource information, and the application of optimization techniques to manage the project effectively. It serves as a comprehensive guide for students enrolled in the project management course, covering topics like resource allocation, scheduling, and cost optimization. The lab aims to equip students with practical skills and knowledge in project management, preparing them for real-world project scenarios.
Typology: Study Guides, Projects, Research
1 / 17
This page cannot be seen from the preview
Don't miss anything!
Ho Chi Minh City, 28 st^ April 2024
CHAPTER 1: PROJECT LAB 1 Input the data to Microsoft Excel, define the AON, and set the working conditions such as not working on Saturday and Sunday, holidays, etc… 1.1. Input the data to Microsoft Excel Step 1: Input the Resources Sheet Step 2: Import the data of 5 projects in the Ms. Project Step 3: Putting constraints on the tasks with the required conditions: The required conditions: a) Some tasks of the projects cannot be split during the scheduling, which means that these tasks must be processed concurrently by the assigned employees. Giaiphapcuacuon.com:
**- Searching Keywords
c) The SEMTEK AND BIZLEADER has the latest end date. So we will have all other project end date will be before the end of SEMTEK AND BIZLEADER. Set the predecessors of task “Evaluate results and deploy mass email marketing” which is the last task of this project to have Finish to Finish relationship: 1FF (with Giaiphapcucuon.com), 11FF (with DR.Reju), 41FF (with TRAN NGUYEN PC CRM) and 49FF (MANH TUONG MEDIA WEBSITE): 1.2. Define AON AON – Activities On Notes depicts the sequence of activities required to complete a project. In an AON diagram, nodes represent activities. They are connected by arrows that show their dependencies. AON diagrams are crucial for project scheduling, resource allocation, and identifying critical paths. By identifying the critical path – the most extended sequence of dependent activities – AON diagrams help pinpoint activities that could delay the project's completion if delayed themselves. So in order to define AON we will identify the activities that are on the critical path of the project grant chart. Step 1: Show multiple critical path
Go to File -> Options -> Advanced -> Tick in the box of “Multiple critical paths” to show all the critical paths in a multiproject project. Go to Gantt Chart Format -> Bar Style -> Tick in the box of “Critical Tasks” The activities that are Critical Tasks are highlighted red:
Introduction Page Building 3 days Tue 8/22/ Thu 8/24/ 16 Technical 2
Customer Information Buidling 2 days Fri 8/25/ Mon 9/4/
Technical 1 ,Technical 3
Building the sub- functions 6 days Tue 9/5/ Tue 9/12/ 13,14,20 Technical 2 2.11 Testing Website 3 days Mon 8/21/ Wed 8/23/ Project 1 3
days Mon 7/3/ Tue 12/19/
Build and perfect the brand identity 10 days Tue 9/12/ Mon 9/25/ Marketing 1,Marketing 2,Marketing 3,Marketing 5
Develop CRM usage instruction and CRM operating procedures 14 days Tue 9/26/ Fri 10/13/ 24,25 Project 2
Develop sales content scripts for products 9 days Mon 10/16/ Fri 11/3/
Marketing 2,Sale 2,Sale 3
Evaluate results and deploy mass email marketing 14 days Thu 11/30/ Tue 12/19/
Marketing 2,Marketing 3,Project 2,Sale 1,Sale 2,Technical 1 ,Technical 3
Build 15 demo landing pages 15 days Fri 10/13/ Fri 11/3/ Technical 1 ,Technical 2,Technical 3
Build content scripts for Automation Email Marketing for course products 16 days Mon 11/6/ Tue 11/28/
Marketing 1,Marketing 3,Sale 1,Sale 2
Develop a monthly recruitment plan 5 days Tue 10/24/ Mon 10/30/ Marketing 1,Marketing 2,Marketing 3,Sale 1,Sale 2,Sale 3
Develop a Marketing plan 10 days Tue 10/31/ Mon 11/13/
Marketing 1,Marketing 2,Marketing 3,Project 1,Sale 1,Sale 2 3.15 Build a business plan 12 days Tue 11/14/ Thu 11/30/
Marketing 1,Marketing 2,Marketing 3,Project 2,Sale 1,Sale 2,Sale 3,Technical 3
Develop an income regime for business collaborators 5 days Mon 7/3/ Fri 7/7/ Project 1,Sale 1
Develop work instruction procedures for each position in charge 15 days Mon 8/21/ Tue 9/19/ Technical 1 4
59 days Fri 7/7/ Wed 9/27/
Define users and actors in the CRM system 5 days Tue 9/5/ Mon 9/11/ 42 Technical 3
Collect the requirements for the CRM platform 3 days Fri 8/25/ Tue 8/29/
Technical 2,Technical 3
Customize and configure CRM system 10 days Tue 9/12/ Mon 9/25/
Technical 2,Technical 3 4.5 Set up authority 1 day Tue 9/26/ Tue 9/26/ 45 Technical 3
Testing and validating the system 4 days Tue 9/26/ Fri 9/29/ 45 Technical 2 4.7 Initiating the system in 7 days Mon Tue 47 Project
PROJECT LAB 2 Eliminate the overallocated task. Given the solution for solving the overallocated task Problem statement: Most of Resources are overallocated in many days as below (except Project 1). Exerting excessive effort by working overtime and pushing resources beyond their limits can have harmful effects on both their physical and mental well-being. In simpler terms, it can cause harm to their bodies and minds. However, the manager also want to optimize these prices and project duration. Hence, optimal function is created to determine these criterion: Min Z = Duration * 10 +
6 (Million VND) To minimize this function, we use the Team Planner to efficiently manage tasks and ensure that resources are appropriately assigned, also increase the resources to a certain level that meet our criteria. First of all, baseline should be set to keep track our proccess. To do this, click Project -> Set Baseline -> Click OK. Then, we go straight to Team Planner funciton: Task -> Built In -> Team Planner.
From the Team Planner, we can “drag and drop” these box to optimize scheduling, also add more resources to solve the overload task which hard to change or create too long duration. Next, re-arranging other tasks, some tasks should be split as we don’t want to overload some resources, these task spilted are: Develop an income regime for business collaborators, Develop a monthly recruitment plan, Email Marketing. To sum up, we re-commend our solution:
Min Z = 6210 + 852.9 = 1472.9 (million VND). Meanwhile, the baseline is: Z = 49*10 + 505.8 = 995.8. This suggests that to prevent overloading, we can consider increasing our project budget up to 48%. However, it’s essential for the manager to propose solutions that enhance resource efficiency to improve the success rate of projects.
PROJECT LAB 3 After 1. 4 .202 4 , we have a reduction in staff as the table below. Please reallocate workers and calculate the unexpected value (time, cost) Step 1: Update the project’s progress to be all done to the date 1.4.2024: Go to Project -> Status -> Update Project -> Set “Mon 4/1/24” for Update work as complete through. Step 2: Update the reduction in staff in the resource sheet: Go to Resource Sheet and reduce the worker for the next period: Go to Resource -> Leveling options -> Change the Leveling range to Level from “Tue 4/2/2024” to a far day -> Press OK
Step 3: Check the statistics after making changes The baseline is the initial project (the scenario without reduction in resources), it would have taken us 65 days and about 876.720.000 VND to finish the project. The current is the scenario where the resource reduction happened, although the cost decreases significantly but the duration increased to 104 days.
