Final Project Report

ARush_UnexpectedEventsWeek2_10152017.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?
	Here, as the manager of operations at AMR Defense Contractors, I will complete the milestone and proceed with the next milestome mainly because I had considered lack of fund to be a potential risk. I already have the funds issues secured. Thus, production will proceed as planned.
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?
	Since this might cause delay to the completion of the whole project, I will seek other reliable suppliers who can deliver the material for the backpack instantly.
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?
	Increase in the load required will lead to increase in the speed of production where I will be forced to adjust the time frame for activities and increase all required resources. This will automatically lead to the increase in expenditure, more orders for raw materials, more workforce requirements, the overall budget altogether. I will update them all.

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?
	Since the refrigeration system and the radio module are the main things that make this backpack has from others, both of them have to be included. I will order the design team to go back to the drawing board and redesign the refrigeration module until they come up with a satisfying product.
May 27, 2016	2. The subcontractor assigned to build the radio module for the backpack has shut down. What is your course of action?
	Since the product has to be delivered, I will consult the directors at AMR Defense Contractors to let me hire more workforce and purchase all the necessary equipment the the manufacture of the radio module. I would then speed up the manufacturing process for it to catch up with development of the other modules.