1.Using MS Project, create a project schedule and align resources35 points

Please provide these two deliverables (MS Project file and MS Word document). Please refer to the course Syllabus for your due date.

To help guide you through these deliverables, please follow the three step process below.

Step 1: Update MS Project with Resource Information

The following steps should be followed when setting up your Course Project with Microsoft Project 2013.

Set the basic project information

Open MS Project.

Click on File (top left), select Save as and enter the file name as (your name) cp1. For example, SmithJanecp1.mpp.

Click on the Project area and select Project Information. In the Project Information dialogue box, set the start date of your project.

Leave other dates as is. Click on OK.

Set basic Gantt chart format (use also for tracking Gantt chart view).

Right click on the mouse in the gray area of the Gantt chart on the right side of the screen where the dates in month and days are for the menu and select Timescale.

In the Timescale dialogue box:

Select the Middle Tier tab set Units to Quarters.

Select the Bottom Tier tab set Units to Months.

Click on OK.

Setup the default task units to weeks

Click File, and then click Options.

In the Project Options dialog box, click Schedule.

Under Scheduling options in this project, set the following.

New tasks created select Auto Scheduled

Duration is entered in select Weeks

Default task type select Fixed Duration

Click OK to close the dialog box.

Set up the Resource Sheet.

Once you have set the defaults, we are ready to move on. If you have not done so already, you need to create the project's work packages and activities from the Project's WBS. Once this is done, insert your project name, deliverables, work packages, and activities in the column Task Name in MS Project.

Enter the task durations in the Duration Column.

Enter the predecessor(s) for each task in the predecessors column. If there is no duration or predecessor listed, leave the column blank. Note: If you do not see the Predecessors Column, move the vertical line between the Entry Form and the Gantt chart to the right to reveal the column. Click on the line and drag to move it. Columns can be expanded or contracted individually to accommodate information the same way column width is adjusted in MS Excel.

Analyze your Schedule and Network Diagram

To see the network diagram, click on View, then select Network Diagram. Activities on the Critical Path are outlined in red, while noncritical path activities are outlined in blue. You will need this information to answer the essay question in Step 3.

Step 2: Allocate Resources

Once you have the WBS created in MS Projects, you need to assign resources to each activity. Remember only assign resources to activities, not other items on the WBS. Before you can do this, you need to create a resources sheet in MS Projects. To create a Resource sheet, click on View, Resource Sheet. Enter the Resource name, whether it is a human resource, a cost, or a material. Once this is finished, one can tie these resources to individual activities. Don't worry about costs, as that is next week's work.

To assign your resources to the aligned tasks in MS Project, follow the steps below.

Assignhourly resourcesand costs to the tasks that you have already entered.

Choose ViewGantt Chart. Place active window on the first task.

Click on the Double Headed icon on the upper tool bar (Assign Resources), or click Alt-F10.

In the resource assignment window, select the appropriate resource for each activity.

Repeat for all resources and activities according to the Resource List above.

Analyze Your Resource Allocation and Assignments

There are several methods to check for over-allocated resources.

Click onView, Resource SheetResource(s) in red color are over-allocated.

Click onView, Resource UsageResource(s) in red color are over-allocated resource(s) by date.

Click onProject, Reports. A dialog box appears, click on Assignments then Select. Then click the report for Overallocated Resources, and then Select to print or view.

Remember with resources you need to assign how much time (by a percentage) each resource will be allocated to each activity. Simply lowering a given percentage may clear an over-allocation, but in real life this is not possible. One must come up with a better method do clear resource over-allocations.

Week 4 Update Microsoft Project

Most projects have fixed costs to account for. These are such things as mortgages and other costs that do not change with production. Fixed costs need to be accounted for in projects. If your project has fixed costs, follow the following steps.

Step1 Update Microsoft Project with Fixed Cost Information

Resource Fixed Cost List Instructions Microsoft Project 2013

The following steps should be followed when setting up your project fixed costs with Microsoft Project:

Go to the gray area at the top of the project on the Duration column and Right Click and choose Insert Column. Type in Fixed Cost and hit enter.

Enter the fixed costs above in the fixed cost column as listed adjacent to the appropriate tasks.

Step 2 Update Microsoft Project with Variable Cost Information

Variable Resource List

Most projects have variable costs. These are costs that change with the amount of work being done. These are commonly seen as dollar per hour costs. Most of your resources will be dollar per hour costs. Follow the steps below to enter this data.

Resource Variable Cost List Instructions for Microsoft 2013

Using this information, go back into the Resource Sheet to update the hourly rate for each resource.

Click on View. Click on the Resource Sheet icon under the Resource Views section. The resource sheet icon is the middle icon on the right of this view with two heads. Check to make sure the Type field is Work and enter the dollar amount above for the hourly rate for each resource in the Std. Rate column.

MY WBS

Work Breakdown Structure

1.Facility

2. Internal

a.Electrical

b.Plumbing

c.Concrete

2.External

a.Masonry work

b.Building finishes

c.Surface track finishes

3. Equipment

a.Sports Equipment

b.Office Equipment

c.Playground Furniture

d.Fencing Equipment

e)Lighting Fixtures

f)Toilet Fixtures

4.People

a.Fitness Expert

b.Kids Fitness Expert (3)

c.Adult Fitness Expert (2)

d.Grounds Man (2)

e.Marketing (2)

f.Maintenance (2)

g.Purchasing (2)

5. Advertisement

a.First Marketing advertisement

b. Second Marketing advertisement

c. Final Marketing advertisemen