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.© BrainMass Inc. brainmass.com October 25, 2018, 10:09 am ad1c9bdddf
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.
Combination of Project Management and Earned Value Management
Research resource estimation techniques necessary to generate a high level budget for a re-carpeting project. Formulate the resource estimates and budget for the re-carpeting project, preferably in a spreadsheet. Include in the spreadsheet:
-Integrating scope with costs and schedules
-Methods used to plan Earned Value and control account plans