You work for Nokia in their global cell phone group. You have been made project manager for the design of a new cell phone. Your supervisors have already scoped the project so you have a list showing the work breakdown structure and this includes major project activities. You must plan the project schedule and calculate project duration. Your boss wants the schedule on his desk tomorrow morning!
You have been given the information below. It includes all the activities required in the project and the duration of each activity. Also, dependencies between the activities have been identified. Remember that the preceding activity must be fully completed before work on the following activity can be started.

Work Breakdown Structure and Activities for the Cell Phone Design Project:

Major Subprojects / Activates - Activity Identification - Dependency - Duration (weeks)

Product Specifications (P)

- Market research P1 - 2

- Overall Product Specifications P2 P1 4

- Hardware P3 P2 5

- Software P4 P3 5

Supplier Specifications (S)

- Hardware S1 P4 5

- Software S2 P4 6

Product Design (D)

- Battery D1 S1 1

- Display D2 S1 2

- Camera D3 S1 1

- Outer Cover D4 D1,D2,D3 4

Product Integration (i)

- Hardware i1 D4 3

- User Interface i2 D2 4

- Software coding i3 i2 4

- Prototype Testing i4 i1,i3 4

Subcontracting (V)

- Suppliers Selection V1 S1,S2 10

- Contract Negotiation V2 i4,V1 2

Your project is divided into five major subprojects. Subproject “P” involves developing specifications for the new cell phone. Here decisions related to such things as battery life, size of the phone, and features need to be made. These details are based on how a customer uses the cell phone. These user specifications are redefined in terms that have meaning to the subcontractors that will actually make the new cell phone in subproject “S” supplier specifications. These involve engineering details for how the product will perform.
The individual components that make up the product are the focus of subproject “D.” Subproject “I” brings all the components together, and a working prototype is built and tested.
Finally in subproject “V,” suppliers are selected and contracts are negotiated.

1). Draw a project network that includes all the activities. Question 1, use shapes, lines word art, text boxes, whatever you can to make it look good in excel.
2). Calculate the Early/Late start and Early/Late finish times for each activity and determine the minimum number of weeks for completing the project. Find the activities that are on the critical path for completing the project in the shortest time. Question 2, can be done in either excel or word.
3). Identify slack in the activities not on the project critical path. Question 3, can be done in either excel or word.