XI--- Proj.n.w.ste.3te (1) [Protected View] - Microsoft Excel File Home Insert Page Layout Formulas Data Review View A2 fe Data analysis: 400, 350, 250, 150, 50 liters/mo... linear downward trend... SMA A B D E F G H I 1 SMA 2 Data analysis: 400, 350, 250, 150, 50 liters/mo ... linear downw. 3 weights = 1 ... w = 1/5 = 0.2 ... sum(w) = 1 ... 4 5 6 A*w 7 time/cycle activity/cycle weight/cycle Description t w months liters/mo weight/mo month.1 month.2 8 1 400 0.2 80 9 2 350 0.2 70 10 month.3 3 250 0.2 50 11 month.4 4 150 0.2 30 12 month.5 5 50 0.2 10 13 Forecast 6X sum(w) F(6)=sum(A*w) 14 1 240 1 Example: KATC (Kuwait-Arab Traffic Contractors) is planning to build 3 overpasses; assigned to 3 specialized contractors within the Arab-World: Allam (Misr), Adnan (Syria), Bin-Habib(Yemen). KATC requested 3 phases to cover: phase-1: build project team, BPT (1, 2, 9mo; KWD1k)... phase-2: research/development, R/D (1, 3, 11mo; KWD10k); equipment transfer, EQ (1,5, 11mo; KWD20k); together with planning and design, P/D (1, 1, 7mo; KWD5k) -- simultaneously; phase-3: foundation, FND (2,6, 22mo; KWD100k); roads, RDS (1, 3, 11mo; KWD50k); then, testing , TST(1, 3, 5mo; KWD.5k) -- sequentially.... data per node (a, m, b; cost) ... (a = optimistic, m = most likely, b = pessimistic timeode; costode) Assuming KATC will provide all materials needed, it needs to calculate: 2.1. Calculate EPC Estimated Project Cost; and EPT Estimated Project Time 2.2. Probability to finish after expected project time by one month. 2.3. Probability to finish before expected project time by one month