Complete the assignement within MS Project as the below instructions provide. Excel Project File
Complete the assignement within MS Project as the below instructions provide. Excel Project File will be provided.
Instructions:
1. Using the data
provided in the attached MS Excel file, create the project schedule in MS
Project.
·
Create
new project in MS Project.
·
Set
the title of the project to “Marketing Project”. Make sure you are the
author. Set the start date to today’s date.
·
Copy
and paste or type in the activities as listed in the Excel file.
·
Add
the WBS column to the Gantt view
·
Create
the WBS structure by creating summary tasks
·
Add
project summary task
·
Add
Durations per the Excel file Note: make sure that you set the duration to Weeks!
·
Set
the Timescale to Weeks
·
Add
Predecessors per the Excel file
·
Identify
the critical path
·
Add
resources per the Excel file. Chapter 9 covers this, but the easiest way
to do this is simply to type the names in the Resource Names column.
2. Using the Resource
Sheet , add a Std. Rate and an Ovt. rate for each resource.
3. Return to the
Gantt chart page.
4. Use the Split View to
show both the Gantt chart with critical path and resource graph or resource
usage.
5. Save your MS Project
file.
6. Using your own MS
Project file, create a Word document and answer the following questions:
· Which
tasks are on the critical path?
·
Which
resources are overloaded?
·
Briefly
explain two ways you might resolve the overloads.
·
What
is the estimated cost of your project?
