Using the cost estimation template and Actuals in Figure 7-5, compare the model in the figure with the following estimates derived from amultiplicativemodel.Base your comparison on the mean bias, the MAR, and the tracking signal. Comment. Period: 1 2 3 4 5 6 7 8 Estimated: 179 217 91 51 76 438 64 170 Table 7-5 Three-Point Estimates of Cash Flows and Inflation Rate for PsychoCeramic Sciences, Inc. All Assumptions and Forecast Cells Defined Net Present Inflation Year Inflow Outflow Net Flow Factor Value Rate 125,000.00 100,000.00 90,000.00 0.00 15,000.00 0.00 15,000.00 0.00 15,000.00 -125,000.00 -100,000.00 -90,000.00 50,000.00 105,000.00 115,000.00 90,000.00 97,000.00 75,000.00 82,000.00 65,000.00 35,000.00 0.02 0.02 0.02 0.02 0.02 0.02 -125,000.00 50,000.00 120,000.00 115,000.00 105,000.00 97,000.00 90,000.00 82,000.00 65,000.00 35,000.00 0.86957 0.75614 0.65752 0.57175 0.49718 0.43233 0.37594 0.32690 0.28426 0.24718 0.24718 -86,956.52 -68,052.93 32,875.81 60,034.09 57,175.32 38,909.48 36,465.89 24,517.6 23,309.52 16,067.01 8,651.46 2020 2021 2022 2022 0.00 0.00 Total 759,000.00 360,000.00 399,000.00 17,996.77 0 at the beginning of 2013 Formulae Cell B17 Cell D4 Cell E4 Cell E5 Cell E6 Cell E15 Cell F4 - Sum(B4:B15) copy to C17, D17, F17 = (B4-C4) copy to D&D 15 = 1/(1 +.13+G4n0 = 1/(1 +.13+G5r1 = 1/(1+ .134 G6yYA6-2012) copy to E7:E15 23 25 27 28 = D4*E4 copy to F5:F15 probability of a $10,000 or greater outcome can be read in the Certainty box. One can also find the same answer by deleting the -Infinity in the box in the lower left corner of the Frequency View and entering $10,000 in it, almost .74 in this simulation. Even in this simple example, the power of including uncertainty in project budgets should be obvious. Because a manager is always uncertain about the amount of uncertainty, it is also possible to examine various levels of uncertainty quite easily using CB. We could, for instance, alter the Show transcribed image text View comments (1) Expert Answerinformation icon An expert answer will be posted here Questions viewed by other students Q: NOTE: Use MS Excel to complete this assignment. Using the cost estimation template and Actuals in Figure 7-5 of the text book, compare the model in the figure with the following estimates derived from a multiplicative model. Base your comparison on the mean bias, the MAR and the tracking signal. Comment on your results.