A few weeks have passed since Janet started out as project manager on the Huntsville Plant task. She has since learned that one of her tasks the Building Construction task under the Preparation Phase will take less time that originally thought, and she wanted to verify the other durations and predecessors as well. Therefore, she updated the Huntsville Task List with the revised durations and predecessors. (Huntsville Task List with Revised Durations and Predecessors) Janet has also received a resource cost list which was developed with the help of the human resources, accounting, purchasing, and finance departments (Resource Cost List). Having been given the resource cost list, Janet worked with her project team to determine how much of each resource would be needed for each task of the project. She entered this information into a resource loading list (Resource Loading List) and will use this resource loading list in conjunction with the resource cost list to update her GANTT chart with resource and cost information.Course Project Part II Expectations For the second part of the project, you will have the opportunity to work through cost planning and performance and resource consideration issues. In the Course Project Part II, you will take the GANTT chart you created and submitted for the Course Project Part I and modify it using information obtained from the revised task list, resource cost list, and resource loading list. As you work through these issues, you will learn the following concepts: Use Microsoft Project to assign resources and costs Learn how to create and analyze a summary report Learn how to create and analyze a task report Learn how to create and analyze time, budget, and resource conflict reports Unlike the first part of the course project, your Microsoft Project file and your associated reports you are asked to create in Part II are for your reference only. You will NOT submit these files in DocSharing as part of your deliverables. Rather, you will use these files to help you answer six questions that you will find under the Week 7 Course Project Part II input tab. Use the Resource Cost list table to enter Fixed Costs and to build your Resource Sheet. For the Fixed costs, you will need to associate the fixed cost with a task. A single Fixed Cost Type is only associated with one task. For example, Site Cost (SC) is a fixed cost; associate it with task Site Procurement (this example is one instance). Part of the assignment is matching the fixed costs to the appropriate tasks, it is the focus of the exercise to synthesize the information and produce a deliverable.Course Project Part II Deliverables Schedule and Reports:Update your project schedule for the Huntsville Project by entering the information from the revised task list. In addition, create a summary report, task report, and time, budget, and resource conflict reports.The following instructions will help you as you load the information to finalize your project schedule. They are designed to help you work your way through MS Project. If you already know how to use MS Project, feel free to ‘do it your way.’ Just make sure you do make ALL of the changes.Revising the Schedule and Creating Reports in MS Project Instructions:The following steps should be utilized when updating the Huntsville Plant Project Plan with Microsoft Project: Open your .MPP file from the conclusion of Project Part I Set the “Status date” to April 17, 2009, under the /Project/Project Information Click on OK In instances where you had errors in Project Part I, correct accordingly. Update predecessors & durations for ALL activities as shown in the Task List. Print or review the report “Un-started Tasks” and verify the information to the attached list. View – Reports – Current Activities – Un-started Tasks – Print. Use the information supplied on the Resource Cost List, enter variable costs; Hourly Resources and costs (NOT FIXED COSTS) by entering them on the Resource Sheet Click on “View,” “Resource Sheet,” and enter the resource name, initials, and Std. Rate per hour. Assume only one of each resource is available. Use the information supplied on the Resource Cost List, enter fixed costs for appropriate activities. Choose View – More Views. In the views box, select Task Sheet, Apply. Next select a task (e.g., “Building Design”). Display the Cost Table (View – Table: Cost). Type “32,000” in the fixed cost column. Repeat for other fixed costs. Assign Hourly Resources and costs to the tasks that you have already entered, based on the information supplied on the attached Resource Loading List. Choose “View” – “Gantt Chart.” Place active window on the first task (Select Architect). Click on the Double Headed Icon on the upper Tool Bar (Assign Resources). In the resource assignment window, click on “PM.” Enter “10” in the units column. Click on “FS”; enter “60” Click on “Assign.” Repeat for all resources and activities according to the Resource Loading List. Then print the Resource Sheet showing: Resource Name, Initials and Costs. (View – Resource Sheet “File,” “Print”) Print a project summary report (“View,” “Reports,” “Overview,” “Project Summary”) Review ALL the task durations AFTER you have completed steps 1 through 5, if any of the task durations changed, make certain to change them to match the task durations listed in the Task List. For example, if task Site Selection became 2.33 weeks, change it back to 3 weeks.Printing the reports is optional, intended to help you formulate your analysis.Additional Notes:The monthly budget report is not a standard report: click on “View,” “Reports,” “Custom,” and select Cash Flow from the list. If the monthly cash flow report is not on the list, select the Weekly Cash Report; click on “Edit”; select “Months” in the Crosstab section of Definition, and enter the report title as “Monthly cash flow”; then click on OK.There are several methods to check for overallocated resources:Click on View, Resource Sheet – resource(s) in red color are overallocated. Click on View, Resource Usage resource(s) in red color are ovearllocated resource(s) by date. Click on View, Reports, Assignments , a dialog box appears, click on Overallocated Resources