problem 6

problem 4

Analytics Exercise 4.2 (Algo) You work for a company that makes cell phones and 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 moming! You have been given the information in Exhibit 413. 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 413: Work Breakdown Structure and Activities for the Cell Phone Design Project es DEPENDENCY DURATION (WEEKS) P1 P2 P3 3 4 5 5 5 P4 P4 6 MAJOR SUBPROJECTS/ACTIVITIES ACTIVITY IDENTIFICATION Product Specifications (P) Market research P1 Overall product specifications P2 Hardware P3 Software P4 Supplier specifications (5) Hardware 51 Software S2 Product design (D) Battery 01 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 V1 Contract negotiation V2 1 Si si S1 D1, D2, D3 6 1 4 04 D2 12 11, 13 3 5 6 5 51 ,52 14, vi 10 5 6. 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 3 Latest Start Time P1 Latest Finish Time 0 P2 3 7 P3 7 12 P4 12 S1 17 17 22 23 S2 17 D1 D2 23 22 22 28 D3 22 23 28 32 35 SS=28 33 32 28 33 39 39 44 23 44 33 49 b. Determine the minimum number of weeks for completing the project Minimum number of weeks 49 c. Find the activities that are on the critical path for completing the project in the shortest time. P1-P2-P3-P4-S1-D2-12-13-14-V2 OP1-P2-P3-P4-S1-D3-D4-11-14-V2 O P1-P2-P3-P4-S1-01-04-11-14-V2 O P1-P2-P3-P4-S1-D2-04-11-14-V2 & Prev 6 of 15 23 Next > The following table represents a plan for a project TIMES (DAYS) PREDECESSOS JOB (S) 30B NO. 1 2 3 6 7 8 9 le 11 1 1 1 2 3 4 5, 6 8 7 9, 10 2 B 1 2 4 5 3 4 1 3 1 2 1 8 2 4 2 4 3 4 5 7 b 4 3 12 11 5 13 9 6 12 5 8 b. Indicate the critical path 1-3-6-8-9-11 1-4-7-10-11 1-2-5-8-9-11 c. What is the expected completion time for the project? (Do not round Intermediate calculations. Round your answer to 2 decimal places.) Expected completion time 26.83 days d. You can accomplish any one of the following at an additional cost of $1,500. If you will save $1,000 for each day that the earliest completion time is reduced, which of the following actions should be taken, if any? 1. Reduce job 5 by two days Yes NO 2. Reduce job 3 by two days Yes c. What is the expected completion time for the project? (Do not round Intermediate calculations. Round your answer to 2 decimal places.) Expected completion time 26.83 days d. You can accomplish any one of the following at an additional cost of $1,500. If you will save $1.000 for each day that the earliest completion time is reduced, which of the following actions should be taken, if any? 1. Reduce job 5 by two days. Yes No 2. Reduce job 3 by two days Yes No 3. Reduce job 7 by two days Yes NO e. What is the probability that the project will take more than 30 days to complete? (Use Excel's NORMSDISTO function to find the correct probability for your computed Z-value. Other than the expected completion time you entered in part c above, do not round Intermediate calculations. Round "z" value to 2 decimal places your final answer to 4 decimal places.) Probability