Exhibit 14.13 The Following Questions Use the Information Below

Exhibit 14.13
The following questions use the information below.
A student wants to buy a new car. She has three cars to choose from, A, B and C. The cars differ with respect to price, performance and looks. The student has developed the following AHP tables for price and summary. The other tables are not shown due to space limitations.
-A company wants to use PERT to manage a project. They have developed the following spreadsheet for the problem. If The Analytic Solver Platform (ASP) is used, what formula should go in cell F3 of the spreadsheet to compute the Activity Time when simulating a PERT analysis?

A) =IF(E3≤(C3-E3) /(D3-B3) ,D3-SQRT((D3-B3) *(D3-C3) *(1-E3) ) ,B3+SQRT((D3-E3) *(C3-B3) *E3) )
B) =IF(E3≤(D3-B3) /(C3-E3) ,B3+SQRT((D3-E3) *(C3-B3) *E3) ,D3-SQRT((D3-B3) *(D3-C3) *(1-E3) ) )
C) =IF(E3≤(C3-E3) /(D3-B3) ,B3-SQRT((D3-E3) *(C3-B3) *E3) ,D3+SQRT((D3-B3) *(D3-C3) *(1-E3) ) )
D) =PsiTriangular(B3,C3,D3)