Use activity costs & overhead provided (see Excel) to you to calculate total project cost. Project overhead is 20% of total WBS activity cost.

Using WBS Outline, AON, and the rules listed below, create a schedule (use dates) in Excel with the below column headings.

WBS Task ID

Task Name

Start Date

Finish Date

Late Start Date

Late Finish Date

Free Slack Days

Slack Days total

			Activity Cost
WBS Item
R&D Project Development
Need Survey	$ 64,000
Set Product Specs	$ 57,600
Shelf life Report	$ 19,200
Nutrition Report	$ 9,600
Select Fruit Suppliers	$ 9,600
Initial Production
Equipment Rehab	$ 528,000
Production Trials	$ 235,200
Quality Trials	$ 86,400
Quality Metrics	$ 12,000
Quality Training	$ 136,800
Distribution
Market Testing	$ 96,000
Package Design	$ 31,200
Select Distributors	$ 80,000
Legal
Complete FDA Certification	$ 43,200
Register Trademark	$ 14,400
Prepare Product Launch	$ 325,000

#*	Activity	Predecessor(s)	Duration
3	Need survey	None	20
4	Set product specs	3	15
5	Shelf life report	4	10
6	Nutrition report	4	5
7	Select fruit suppliers	5, 6	20
9	Equipment rehab	4	30
10	Production trials	7, 9	15
11	Quality trials	10	20
12	Quality metrics	11	5
13	Quality training	12	15
15	Market testing	5, 6	30
16	Package design	15	15
17	Select distributors	5, 6	25
19	Complete FDA certification	7, 15	15
20	Register trademark	7, 15	5
21	Prepare product launch	13, 16, 17, 19FS + 25 days, 20FS + 15 days	15

AON

The critical path is activities 3, 4, 5, 7, 10, 11, 12, 13, 21
#	Days
3	20
4	15
5	10
7	20
10	15
11	20
12	5
13	15
21	15
	135

Use the information provided below to create a project schedule.

The following days are observed January 1, Martin Luther King day, (third Monday in January), Memorial Day (last Monday in May), July 4^th Labor Day (first Monday in September), Thanksgiving Day (4^th Thursday in November), December 25 and 26

If a holiday falls on Saturday then Friday will be given as an extra day off, and if it falls on as Sunday then Monday will be given off.

The project team works eight hour days, Monday through Friday.

The project will begin on January 3, 2012