Analytics Exercise 4-2 You work for Microsoft 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 in Exhibit 5.13. 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, 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 "T" brings all the components together, and a working prototype is built and tested. Finally in subproject "V" suppliers are selected and contracts are negotiated. Exhibit 5.13: Work Breakdown Structure and Activities for the Cell Phone Design Project DEPENDENCY DURATION (WEEKS) 5 MAJOR SUBPROJECTS/ACTIVITIES ACTIVITY IDENTIPICATION Product Specifications (P) Market research P1 Overall product specifications P2 Hardware P3 Software P4 Supplier specifications (S) Hardware 81 Software S2 Product design (D) Battery Di Display D2 Camera D3 Outer cover 04 Product integration (1) Hardware Il User Interface 12 na D1, D2, D3 04 D2 DEPENDENCY DURATION (WEEKS) P1 P2 P3 3 5 5 5 P4 P4 5 MAJOR SUBPROJECTS/ACTIVITIES ACTIVITY IDENTIFICATION Product Specifications (P) Market research P1 Overall product specifications P2 Hardware P3 Software P4 Supplier specifications (s) Hardware 51 Software S2 Product design (D) Battery D1 Display D2 Camera D3 Outer cover 04 Product integration (1) Hardware 11 User Interface 12 Software coding 13 Prototype testing 14 Subcontracting (V) Suppliers selection Vi Contract negotiation V2 51 51 51 D1, D2, D3 04 D2 12 11, 13 S1 ,52 14, Vi a. Calculate the start and finish times for each activity. (Leave no cells blank.be certain to enter "0" wherever required.) Earliest Start Time Earliest Finish Time Latest Start Time Latest Finish Time Activity P1 P2 P3 P4 S1 S2 D1 1 D3 D4 11 12 13 14 pped V1 V2 Book Print b. Determine the minimum number of weeks for completing the project rences Minimum number of weeks c. Find the activities that are on the critical path for completing the project in the shortest time. OP1-P2-P3-P4-S1-D3-D4-11-14-12 OP1-P2-P3-P4-S2-V1-V2 OP1-P2-P3-P4-S1-D2-12-13-14-V2 P1-P2 P3-P4-S1-D1-D4-11-14-V2 Analytics Exercise 4-2 You work for Microsoft 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 in Exhibit 5.13. 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. 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. Exhibit 5.13: Work Breakdown Structure and Activities for the Cell Phone Design Project DEPENDENCY DURATION (WEEKS) P1 P2 P3 3 5 5 MAJOR SUBPROJECTS/ACTIVITIES ACTIVITY IDENTIFICATION Product Specifications (P) Market research P1 Overall product specifications P2 Hardware P3 Software P4 Supplier specifications (5) Hardware si Software 52 Product design (D) Battery Di Display DZ Camera DJ Outer cover D4 Product integration (I) HAPA P4 P4 SI SI 51 D1, D2, D3 1 3 1 5 4 DEPENDENCY DURATION (WEEKS) P1 P2 P3 3 5 5 5 P4 P4 5 8 MAJOR SUBPROJECTS/ACTIVITIES ACTIVITY IDENTIFICATION Product Specifications (P) Market research P1 Overall product specifications P2 Hardware P3 Software P4 Supplier specifications (S) Hardware Si Software S2 Product design (D) Battery DI Display D2 Camera D3 Outer cover D4 Product integration (I) Hardware 11 User interface 12 Software coding 13 Prototype testing Subcontracting (V) Suppliers selection vi Contract negotiation V2 1 3 Si Si Si D1, D2, D3 D4 D2 12 11, 13 4 5 5 5 si S2 14, Vi 8 3 a. Calculate the start and finish times for each activity. (Leave no cells blank - be certain to enter "0" wherever require Earliest Start Time Activity P1 Earliest Finish Time Latest Start Time Latest Finish Time P2 P3 P4 S1 S2 D1 D2 D3 D4 11 12 13 14 V1 V2 b. Determine the minimum number of weeks for completing the project. Minimum number of weeks b. Determine the minimum number of weeks for completing the project. Minimum number of weeks c. Find the activities that are on the critical path for completing the project in the shortest time, OP1-P2-P3-P4-S1-D3-D4-11-14-V2 O P1-P2-P3-P4-S2-V1-V2 P1-P2-P3-P4-S1-D2-12-13-14-V2 O P1-P2-P3-P4-S1-D1-D4-11-14-V2