Complete Exercises 13.1, 13.3, and 13.11 on pages 336 & 341 in Quantitative Methods in Health Care Management.
Use this template to record and submit your answers for grading: Excel template for Exercises 13.1, 13.3, and 13.11
Use these Excel automated templates for your calculations (do not submit these files, but transfer information from them to the Excel file you are submitting): CPM Deterministic for 13.3 and PERT Probabilistic for 13.11.
Any existing numbers in green cells in the automated tables are for examples, and show where you should enter the data. You must delete or overwrite these numbers to perform the calculations. The yellow cells of the automated templates are protected to prevent users from accidentally deleting or overwriting the formulas. There is no need to unprotect the templates.
The solution gives detailed steps on finding the critical path of the project, computing ES, LS, EF, LF and slack time for the activities and analyzing construction project using probabilistic method. All works are done in Excel.