Analyze project management processes, scope, and the project management life cycle within a range of projects.

Scenario Information

You are assuming the role of the project manager for a company called SuperPacks to provide a new backpack product with a built-in refrigeration pouch and radio module. Your customer for this project is the U.S. Army, Ground Forces and Special Operations. As the project manager for your team, you will be submitting to your manager a project management report.

Instructions

Part I – Project Scope Document

You will take on the role of Project Manager. As such, you will determine the project scope and project schedule for SuperPacks. This task has two parts. In the FIRST part, you will use the Project Scope Document Template to develop your project scope document. In the SECOND part, you will use Tab 2 of the Project Schedule Template to develop your project schedule and include it with your written analysis. Tab 2 will provide you with the unexpected events information needed to complete your analysis.

Develop the project scope document to include the following information:

Project description
Project assumptions
Project goals
Project constraints (if any)
Project limitations
Project milestones
Project risks (initial assessment)

The Project Scope needs to be developed prior to any analysis of unexpected events.

Part 2 – Analysis of Unexpected Events

In this second part of your task as Project Manager, provide an analysis of unexpected events to your management using the Project Schedule Template (the unexpected events are located in Tab 2 of the document). In your analysis, you should discuss the following:

Four areas affected by these unexpected events.
Three of the areas of the project affected by the events should include changes to the budget, human capital, and impact to schedule.

Identify one additional area affected by these events.

Course Project Schedule

Project Title	Project Schedule
Start Date	Sep 1, 2015
Month	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24
Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Notes
42248.0	42278.0	42309.0	42339.0	42370.0	42401.0	42430.0	42461.0	42491.0	42522.0	42552.0	42583.0	42614.0	42644.0	42675.0	42705.0	42736.0	42767.0	42795.0	42826.0	42856.0	42887.0	42917.0	42948.0
Phase	Project Completion
One
Phase
Two
Product Design Phase
Initial Product Test
Final Test
Phase
Three

Project Award Sept. 1, 2015

First Delivery Sept. 1, 2015

Second Delivery Dec. 1, 2015

Third (Final) Delivery March 1, 2015

First Milestone Payment (from Customer) Oct. 30, 2015

Second Milestone Payment (from Customer) Jan. 30, 2017

Third Milestone Payment (from Customer) May. 30, 2017

Initial Program Review (PR) Nov. 16, 2015

Program Review (PR) May. 16, 2016

Program Review (PR) Nov. 16, 2016

Design Review

Production begins

Week

Project Title	Project Schedule
Start Week	Jan 5, 2014
Week	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
Starting	Jan	Jan	Jan	Jan	Feb	Feb	Feb	Feb	Mar	Mar	Mar	Mar	Mar	Apr	Apr	Apr	Apr	May	May	May	Notes
5	12	19	26	2	9	16	23	2	9	16	23	30	6	13	20	27	4	11	18
Phase
One
Phase
Two
Phase
Three

Help

HELP
http://www.vertex42.com/ExcelTemplates/project-schedule-template.html	© 2014 Vertex42 LLC
About this Template
This project schedule can be used to create a basic timeline for your project.
Try the Vertex42 Gantt Chart Template if you want to something more automated for creating and managing your project schedule. (See the reference below).
How to use this Template
1)	Enter your project start date in cell E3. This will automatically update the dates in rows 6 and 7.
2)	Add tasks: Choose what phase (row) and week (column) the task will start and enter the task title into that cell. Then fill in the background color of the cells to indicate how long the task will take to complete.
If you would like to show the completion status of a task, you can fill the background with a darker or different color (see the Sample worksheet for an example).
3)	Add a milestone: If you’d like to show a milestone, you can create a vertical “line” in the schedule by changing the cell borders and the background fill (see the Sample worksheet).
Note: In the sample worksheet, the Project End milestone was created by merging cells, turning on Wrap Text, and pressing Alt+Enter after each letter to force each letter onto a new line.
Additional Help
The link at the top of this worksheet will take you to the web page on vertex42.com that talks about this template.
REFERENCES
SEE ALSO	Vertex42.com: Gantt Chart Template
SEE ALSO	Vertex42.com: Project Management Templates
TIPS	Vertex42.com: Spreadsheet Tips Workbook

http://www.vertex42.com/ExcelTemplates/project-schedule-template.html http://www.vertex42.com/ExcelTips/workbook.html http://www.vertex42.com/ExcelTemplates/excel-project-management.html http://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html

©

Project Schedule Template

By Vertex42.com

http://www.vertex42.com/ExcelTemplates/project-schedule-template.html

This spreadsheet, including all worksheets and associated content is considered a copyrighted work under the United States and other copyright laws.

Do not submit copies or modifications of this template to any website or online template gallery.

Please review the following license agreement to learn how you may or may not use this template. Thank you.

See License Agreement

http://www.vertex42.com/licensing/EULA_privateuse.html

Do not delete this worksheet. If necessary, you may hide it by right-clicking on the tab and selecting Hide.

http://www.vertex42.com/licensing/EULA_privateuse.html http://www.vertex42.com/ExcelTemplates/project-schedule-template.html

Week 2 unexpected events

Date of Event
Oct. 15, 2015	1. Customer Notifies you that the first milestone payment will be three months delayed. What is your course of action?
March 15, 2016	2. The material pattern for the backpack will not be available to meet your initial production start date. What is your course of action?
May 15, 2016	3. Customer notifies you they would like to increase the initial delivery from 100 backpacks to 150. What is your course of action?

Week 5 unexpected events

Date of Event
March 1, 2016	1. The project engineering team discovers the refrigerated module is too large for the designed refrigerated backpack pouch. What is your course of action?
May 27, 2016	2. The subcontractor assigned to build the radio module for the backpack has shut down. What is your course of action?