Question 4: 10 points Frustrated by the steady decline of its market share in PC industry, Dull computers is planning to spruce up its product line by investing heavily in a new line of laptops. Several changes were proposed to achieve its objective. To differentiate itself from its main competitor ComeBaq Computers. Dull wants to incorporate a new Lion technology which would provide a much longer battery life. In addition, it is also planning to incorporate a new design to ensure that its laptops are sleek and is consistent with its current advertising theme "Dude, it is no longer dull". The R&D team after discussing these significant changes came up with the following activities and tasks that are required for the launch of the new product line. Careful examination of these activities also provided them the dependencies between these activities and the time required (in weeks) for each of them as captured in the following table. Activity Job Description Immediate Predecessors Obtain initial consumer input Design development Battery technology development Market Testing Prototype Development Material Planning Production . F Product Launch Assume that there is no uncertainty associated with production (G) and product launch (H) tasks. Ump:pa>::>' IO'I'IFHUDEDD D I 1. Construct the network diagram for the project. 2. Which is/are the critical path(s) for the project for the most likely activity times? 3. Given that ComeBaq would be launching its own new product line in 130 weeks. Dull wants to ensure that it launches its product before its rival. Conduct a PERT analysis for the project and determine the probability of meeting the deadline. AutoSave . Off ) excel do.xlsx v Search Deepti Raj DR O X File Home Insert Page Layout Formulas Data Review View Automate Help Power Pivot Comments Share Times New Roman ~ 10 ~ A" A Insert ag General Ex AP O Ex Delete Paste BIUvv MVAv E = $ ~ % 9 Conditional Format as Cell Sort & Find & Analyze Sensitivity Formatting Table v Styles v Format Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity G21 X V A B C D E F G H I J K L Activity Immediate predecessors m b expected time Variance N A 4 5 7 =(C2+4*D2+E2)/6 =((E2-C2)/6)^2 B A 8 10 16 =(C3+4*D3+E3)/6 =((E3-C3)/6)^2 C A 30 40 55 =(C4+4*D4+E4)/6 =((E4-C4)/6)~2 D B, C 20 35 40 =(C5+4*D5+E5)/6 =((E5-C5)/6)^2 NETWORK D E B, C 15 120 25 =(C6+4*D6+E6)/6 =((E6-C6)/6)~2 E 15 20 25 =(C7+4*D7+E7)/6 =((E7-C7)/6)^2 G D, F 40 =D8 ((E8-C8)/6) 2 A B D I G 2 =D9 ((E9-C9)/6) 2 10 C 11 Path Most likely time Expected time Variance 12 ABDGH =D2+D3+D5+D8+D9 =F2+F3+F5+F8+F9 13 ABEFGH =D2+D3+D6+D7+D8+D9 =F2+F3+F6+F7+F8+F9 14 ACDGH =D2+D4+D5+D8+D9 =F2+F4+F5+F8+F9 15 ACEFGH =D2+D4+D6+D7+D8+D9 =F2+F4+F6+F7+F8+F9 =G2+G4+G6+G7+G8+G9 critical path 16 17 expepected Project duartion =MAX(D12:D15) weeks 18 Varince of project duration =E15 19 standard deviation of project duartion =SQRT(B18) 20 Project deadline 130 weeks 21 Probably of meaating project deadline =NORM.DIST(B20,B17,B19,TRUE) 22 Critical path for most likely time =A15 23 24 Table 1 Sheet1 | Sheet2 Sheet3 Sheet4 + Ready Accessibility: Investigate - - + 100% Type here to search O M O 3:25 PM WORLD RESOURCES X C 31.C 3/28/2023