• Develop a project plan integrating project management concepts and using industry standard software. (PO4)

Note: The textbook contains an example project and steps to complete the schedule at the end of Chapters 3, 7, 8 & 9. You may find it helpful to refer to or complete these exercises prior to completing this assignment. There is also a link to video tutorials in the Supplemental Resources post.

Deliverables:

• MS Project file
• MS Word file

Data File: MS Project Assignment 2022.xlsx

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 todays date. (Ch 3)
   • Copy and paste or type in the activities as listed in the Excel file.
   • Add the WBS column to the Gantt view (Ch. 7)
   • Create the WBS structure by creating summary tasks (Ch 7)
   • Add project summary task (Ch 3)
   • Add Durations per the Excel file (Ch 8) Note: Make sure you set the duration to Weeks!
   • Set the Timescale to Weeks
   • Add Predecessors per the Excel file (Ch 8)
   • Identify the critical path (Ch 8)
   • 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 (Ch 9), add a Std. Rate and an Ovt. rate for each resource. (You choose the rates.)
3. Return to the Ganttchart 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?
7. Submit both documents to the assignment link.

WBS	Activity	Immediate Predecessor	Duration in weeks	Resource
1	Operational definition
1.1	Research literature		3	Marina
1.2	Identify and define terms	1.1	1	Gelly
1.3	Obtain approval of definition	1.2	2	Anton
2	Target Selection
2.1	Solicit partners for pilot		2	Gelly
2.2	Hold brainstorming meeting	2.1	2	Marina
2.3	Identify characteristics of targets	2.2, 3.1	1	Gelly
2.4	Obtain approval of partners	2.3, 1.2, 3.4	1	Anton
3	Question set
3.1	Identify process group members		2	Anton
3.2	Develop question set	2.3	4	Gelly
3.3	Prototype and validate question set	3.2	3	Marina
3.4	Add partners	3.1, 2.1	3	Marina
4	Pilot process
4.1	Schedule with target audience	2.4	2	Marina
4.2	Conduct beta test	3.4, 2.4	2	Anton
4.3	Process feedback from target audience	4.2	2	Gelly
4.4	Conduct pilot	4.3	2	Anton
4.5	Analyze results	4.4	2	Anton