Business Project Management

Deliverable2_Project_Schedule_Template.xlsx

Course Project Schedule

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

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

	Project Schedule Template
	By Vertex42.com
	http://www.vertex42.com/ExcelTemplates/project-schedule-template.html
	© 2014 Vertex42 LLC
	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.

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?

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?