PJM 6025 – Project Scheduling & Cost PlanningInstructions Assignment No. 3: Duration vs. Resources Page 1 of 2Instructions Assignment No. 3: Duration vs ResourcesIndividual students will complete the following steps to show an understanding of theconcepts covered in the text, lectures and discussion board for this week. You will submityour XLS File with the answers to the questions on each spreadsheet of the Excelworkbook.Due by End of Day (EOD) Sunday of week three.Turn in your Excel file with your name at the end of the shortened file name. Use file:PJM6025 Assign 3 Duration vs Resources.XLS which you can download from theAssignments Folder. Example submitted file name: No 3 Assignment J.Branden.General Instructions:1. There are three Steps on three tabs in this Excel workbook; Step #1 = 2 points, Steps#2 & #3 each = 3 points for a total of 8 points.2. Each tab has specific directions for the changes you will make. You can only enterinformation in the yellow cells. The rest of them are protected to avoid inadvertentchanges to formulas, format, etc.3. The whole file is also protected. I know you can crack the password. I also knowthat some versions of Excel (particularly those sold in counties other than the U.S.A.)often either void the password or corrupt it. As long as I can read your results I willnot count off for unprotected submittals.4. If I cannot open or read a file, I will send you a new blank file and you may try again.The penalty for trying again is one point deduction per day, starting on the day Ireturn it and counting the day you resubmit. That means if you return it on thesame day, the penalty is a minimum of two points. I do this to encourage you to besure you are submitting acceptable deliverables. Submitting assignments to aninstructor is no different than submitting deliverables to a Sponsor. Your work isjudged on the quality metrics established before you begin to execute the project (orexecute the assignment).5. Each step begins with the same scenario. You will make changes to demonstrate theeffects of the dynamic interaction of the variables that affect the duration of aproject; namely the number of resources assigned to tasks and the amount ofcontingency / reserve associated with the work package / hammock.6. When you look at the first tab you will see a section of a project plan that looks verymuch like MS Project. Ive used Excel because it is much more flexible in formattingand demonstrating the learning objectives for the assignment.PJM 6025 – Project Scheduling & Cost PlanningInstructions Assignment No. 3: Duration vs. Resources Page 2 of 27. This small piece of a project shows a waterfall series of tasks in a single hammockto produce a sub-deliverable. Notice how the predecessors and successors flowfrom one hammock to the next (both at the top and bottom of Hammock Y).8. Next notice the column: Resource Names (Team leaders + team members). Thenumber after the plus sign + is the number of persons the team leader may ask toparticipate on this project. The instructions will tell you how many to use in each ofthe three scenarios.9. The Effort Hours are given as a fixed estimate and you cannot change them. Thatis one of the reasons we have row 14 Murphys and Parkinsons Contingency.While your team leaders gave you their best estimates, you as the PM may want toadd your own contingency to deal with Murphys Law and Parkinsons Law!10. As always, if you have any questions about the instructions or the assignment,please post them on the Ask the Prof DB.Step #1 Adding a contingency to a hammock. On this sheet we will see what changes as weadd a contingency as an undesignated block of time and then as shared by severalpeople.Step #2 Same changes for contingency; change number of resources to half the team plusteam leader (round down for odd numbers of team members). Ex #1: Jan + 9 teammembers = 1 (for Jan) + 4 (team of 9/2=4.5 ? round down to 4) = 5 total. Ex #2: Bev + 10team members = 1 (for Bev) + 5 (team of 10/2=5) = 6 total in Column D.Step #3 Same changes for contingency and use all available resources for each task!PJM 6025 – Project Scheduling & Cost PlanningInstructions Assignment No. 3: Duration vs. Resources Page 1 of 2Instructions Assignment No. 3: Duration vs ResourcesIndividual students will complete the following steps to show an understanding of theconcepts covered in the text, lectures and discussion board for this week. You will submityour XLS File with the answers to the questions on each spreadsheet of the Excelworkbook.Due by End of Day (EOD) Sunday of week three.Turn in your Excel file with your name at the end of the shortened file name. Use file:PJM6025 Assign 3 Duration vs Resources.XLS which you can download from theAssignments Folder. Example submitted file name: No 3 Assignment J.Branden.General Instructions:1. There are three Steps on three tabs in this Excel workbook; Step #1 = 2 points, Steps#2 & #3 each = 3 points for a total of 8 points.2. Each tab has specific directions for the changes you will make. You can only enterinformation in the yellow cells. The rest of them are protected to avoid inadvertentchanges to formulas, format, etc.3. The whole file is also protected. I know you can crack the password. I also knowthat some versions of Excel (particularly those sold in counties other than the U.S.A.)often either void the password or corrupt it. As long as I can read your results I willnot count off for unprotected submittals.4. If I cannot open or read a file, I will send you a new blank file and you may try again.The penalty for trying again is one point deduction per day, starting on the day Ireturn it and counting the day you resubmit. That means if you return it on thesame day, the penalty is a minimum of two points. I do this to encourage you to besure you are submitting acceptable deliverables. Submitting assignments to aninstructor is no different than submitting deliverables to a Sponsor. Your work isjudged on the quality metrics established before you begin to execute the project (orexecute the assignment).5. Each step begins with the same scenario. You will make changes to demonstrate theeffects of the dynamic interaction of the variables that affect the duration of aproject; namely the number of resources assigned to tasks and the amount ofcontingency / reserve associated with the work package / hammock.6. When you look at the first tab you will see a section of a project plan that looks verymuch like MS Project. Ive used Excel because it is much more flexible in formattingand demonstrating the learning objectives for the assignment.PJM 6025 – Project Scheduling & Cost PlanningInstructions Assignment No. 3: Duration vs. Resources Page 2 of 27. This small piece of a project shows a waterfall series of tasks in a single hammockto produce a sub-deliverable. Notice how the predecessors and successors flowfrom one hammock to the next (both at the top and bottom of Hammock Y).8. Next notice the column: Resource Names (Team leaders + team members). Thenumber after the plus sign + is the number of persons the team leader may ask toparticipate on this project. The instructions will tell you how many to use in each ofthe three scenarios.9. The Effort Hours are given as a fixed estimate and you cannot change them. Thatis one of the reasons we have row 14 Murphys and Parkinsons Contingency.While your team leaders gave you their best estimates, you as the PM may want toadd your own contingency to deal with Murphys Law and Parkinsons Law!10. As always, if you have any questions about the instructions or the assignment,please post them on the Ask the Prof DB.Step #1 Adding a contingency to a hammock. On this sheet we will see what changes as weadd a contingency as an undesignated block of time and then as shared by severalpeople.Step #2 Same changes for contingency; change number of resources to half the team plusteam leader (round down for odd numbers of team members). Ex #1: Jan + 9 teammembers = 1 (for Jan) + 4 (team of 9/2=4.5 ? round down to 4) = 5 total. Ex #2: Bev + 10team members = 1 (for Bev) + 5 (team of 10/2=5) = 6 total in Column D.Step #3 Same changes for contingency and use all available resources for each task!