- Access the Excel file,HW CPM.xlsx. Do all 4 problems in this workbook.
1 a) b) c) d) Activity Activity Time, t (wks) A5CH B3A C7 D6DF E7StartFinish F3 G10 H8BEG e) ActivityStart Activity Time, t (wks) A5 B3 C7 D6 E7 F3 G10 H8 Consider the following network and activity times (in weeks). a) Fill in the nodes with the activity schedule (ES, EF, LS, LF). Identify the critical path. b) How much time will be needed to complete the project? c) Can activity C be delayed without delaying the entire project? If so, by how many weeks? d) Can activity D be delayed without delaying the entire project? If so, by how many weeks? e) Create a Gantt Chart for this project, using a stacked bar chart. The picture of Gantt chart is given in the last tab so you can check yours against it. 2 b) c) d) ActivityImmd. Pred. t (wks)a) A---3 B---1AE C---2 DA, B, C4 EC, D5StartBF FA3 GD, F6 HE4FinishCG DH Mariott Condominium, located near San Diego, California, plans to renovate its main building. The project will begin April 1, and the goal is to complete by August 1 (in 17 weeks). The condominium manager identifed the renovation activities and their estimated time below. a) Draw a project network. You may want to draw on paper then do it here by connecting the given nodes with arcs (i.e., arrows). You might not use all of the given arcs. b) What are the critical activities? c) What activity has the most slack time? d) Will the project be completed by August 1? 3 c) d) ActivityDescriptionImmd. Pred. t (wks)a) & b) ASurvey building site---6 BDevelop initial design---8AE CObtain board approvalA, B12 DSelect architectC4 EEstablish budgetC6StartBF FFinalize designD, E15 GObtain financingE12 HHire contractorF, G8FinishCG DH e) ActivityDescriptionStart Activity Time, t (wks) ASurvey building site6 BDevelop initial design8 CObtain board approval12 DSelect architect4 EEstablish budget6 FFinalize design15 GObtain financing12 HHire contractor8 Rowan College in New Jersey plans to build a new campus center. Below are the activities that need to be completed prior to the construction. a) Draw a project network. b) Find the activity schedule (ES/EF/LS/LF). c) What is the critical path? d) Does it appear feasible that construction of the campus center could begin one year after the decision to begin the project with the site survey and initial design plans? What is the expected completion time for the project? e) Create a Gantt chart with stacked bar chart. Label the vertical axis with description of the activities (survey building site, etc.). The picture of Gantt chart is given in the last tab so you can check yours against it. 4 c) ActivityImmd. Pred. t (wks)a) & b) A---9 B---6AE CA6 DA3 EB, C0StartBF FB, C3 GF2 HD, E6FinishCG IG, H3 DH I Colonial County is planning a new park and recreational area on a recently purchased 250-acre tract. Project development activities include clearing areas for picnic areas, constructing parking lot, building the playground, etc. Below, you are given a list of activities, activity duration (in weeks) and their predecessors. a) Draw the project network. b) Find the activity schedule (ES/EF/LS/LF). What is the critical path for this network? How many weeks is this project expected to take? c) The park commissioner would like to open the park to the public within six months from the time the work on the project is started. Does this opening date appear to be feasible? Explain. 1 and 3 Gantt Charts Your Gantt charts in #1 and #3 should look like these. #1 #3