As a project management professional, it is important for you to be able to review numbers and report on what they are saying. It is also important for you to be able to use software that helps you keep timelines and keep the project running on time and smoothly. This assignment will continue to help prepare you for your responsibilities. For this assignment, you are to build upon your completed Microsoft Project schedule for the “Technology Refresh Project” from Topic 2 by adding resources and resolving any resource over-allocations. You will then determine the display project cost information and will also show the updated (if any) critical path. Open “Topic 3 Project Resources Information” (a Microsoft Excel file). You will notice in column H that resource names have been added. These resources were already included in the Resource Sheet in the Microsoft Project template file that you worked on during Week 2.Open the Microsoft Project file that you completed during Week 2 and perform the following.
Ensure that the “Type” field contains “Fixed Duration” for all tasks.
For each lowest-level task, enter the resource names from “Topic 3, Project Resources Information” (a Microsoft Excel file) into the Resources Names field in your Microsoft Project file. Note that you can simply select the resource(s) using the pull-down menu.
You will notice in the “i” column (i.e., the column with white “i” and blue circle) that certain tasks have a red person displayed. That means that the task has resources that are over-allocated (a resource is assigned more than 8 hours per day on one or more days for that task). These resource over-allocation need to be resolved. To resolve these over-allocations, perform the following:
Again, ensure that the “Type” field contains “Fixed Duration” for all tasks. This ensures when you change the assigned hours for the tasks, the task durations, and associated dates will not change.
In the VIEW ribbon, check the “Details” box in the “Split View” group.
In the right bottom of the screen (in the gray area), right-click and select “Work.”
Go to the first task that has the resource over-allocation. Reduce the hours in the “Work” field and/or assign a different applicable resource in order to resolve the resource over-allocation. Be sure to not alter task durations, start, or finish dates. Also, ensure that your project end date does not change.
You may optionally go to the VIEW ribbon, and select “Resource Graph” in the “Other Views” pull-down menu. This will provide a graph that will specifically show what days a resource is over-allocated.
Repeat item (4) for each task that has a resource over-allocation. Your final Microsoft Project schedule should have no tasks with over-allocated resources. Be sure to take notes that summarize the changes you made.
Display the project cost information and critical path:
Remove the split task screen by double-clicking on the split-task border.
Display cost information by left-clicking on the “Add New Column” field. Select the “Cost” field. Note that since a WBS hierarchy exists, you can see cost information for each summary task, along with the total project cost at the top of the schedule.
Display the critical path: Go to the FORMAT ribbon and check the “Critical Tasks” box in the BAR STYLES group. Note that the critical path taskbars will turn red. Also, take note that the Total Slack column contains 0 days for the critical path tasks.
Submit your updated Microsoft Project file by the end of Week 3. Ensure that your last name is in the file name.
Submit your updated Word document by the end of Week 3 (ensure that your last name is in the file name) that includes responses to the following:
In summary, what steps did you take to resolve the resource over-allocation?
Did your critical path change? If so, how?
What series of tasks represent the highest cost (as indicated by their summary task)?
What does the total project cost?
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more