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 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 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 MAJOR SUBPROJECTS/ACTIVITIES Product Specifications ACTIVITY IDENTIFICATION DEPENDENCY DURATION (WEEKS) Market research Overall product specifications Hardware Software Supplier specifications (5) Hardware Software Product design (D) Battery Display Camera Outer cover Product Integration (I) Hardware User interface Software coding Prototype testing Subcontracting (V) Suppliers selection Contract negotiation $ D1, D2, D3 D4 p2 11, 13 Si S2 14. Vi $1.2 11 a. Calculate the start and finish times for each activity. (Leave no cells blank - be certain to enter "0" wherever required.) Activity Earliest Start Time Earliest Finish Time Latest Start Time Latest Finish Time 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. P1-P2 P3-P4-S1-D2-2-13-14-V2 P1-P2-P3-P4-S1-D1-D4-11-14-V2 P1-P2 P3-P4-51-D3-D4-11-14-V2 P1 P2 P3 P4 S2 V1 V2