For Chapter 5, Question 14 on page 193, please create two separate tables following the models in Chapter 5 of the textbook (see pages 161 and 174). Solve the problem first using the planned durations, and then solve the problem using actual performance as described in the problem. For each version, create a table with the headings of ED (Estimated Duration), ES, EF, LS, LF and Slack. Please also answer the questions contained in the problem. When you are finished upload your results here. 14. Calculate the ES, EF, LS, and LF times and the slack for each activity in the figure below, and identify the critical path for the project. Can the project be completed in 30 weeks? Assume that "Systems Analysis actually finished at 8 weeks, Design Input & Output" actually finished at 15 weeks, and Design Database actually finished at 19 weeks. Recalculate the expected project completion time. Which activities would you focus on to get the project back on schedule? Develop Input Screens 8 Design Input & Output 3 3 Problem Definition System Analysis Test System Implement System Develop Output Reports 10 8 6 9 5 Design Database Develop Database 15 FIGURE 5.9 Schedule for Consumer Market Study Project, Showing Total Slack Values Earliest Latest Estim Total Slack Respon Dur. Start Finish Start Finish 1 Susan 3 0 3 -8 -5 -8 2 Susan 10 13 -5 5 -8 3 Susan 20 13 33 5 25 -8 4 Susan 5 33 38 25 30 -8 5 Steve 2 38 40 38 40 0 Consumer Market Study Project Activity Identify Target Consumers Develop Draft Questionnaire Pilot-Test Questionnaire Review Comments & Finalize Questionnaire Prepare Mailing Labels Print Questionnaire Develop Data Analysis Software Develop Software Test Data Mail Questionnaire & Get Responses Test Software Input Response Data Analyze Results 6 Steve 10 38 48 30 40 -8 7 Andy 12 38 50 88 100 50 8 Susan 2 38 40 98 100 60 9 Steve 65 48 113 40 105 -8 10 Andy 5 50 S5 100 105 50 11 Jim 7 113 120 105 112 8 12 Jim 8 120 128 112 120 8 13 Prepare Report Jim 10 128 138 120 130 8 Copyright 2018 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated in whole or in part. WCN02-200-208 Copyright 2018 pagering Autore Meyer, in whole De to commitmeid party may be used in the Il review the deemed that any podcom materia experience in the right to come dicet any time the right time. 161 174 Part 2 Planning Performing and Controlling the Project Latest Actual Finish Dur. Total Slack Start Finish Finish 1 2 Susan 11 30 4 Susan 15 30 45 25 40 -5 FIGURE 5.16 Updated Schedule for Consumer Market Study Project Consumer Market Study Project Earliest Estim. Activity Respon Start Finish Identity Target Consumers Susan 2 Develop Draft Questionnaire 3 Pilot-Test Questionnaire Susan Review Comments & Finalize Questionnaire 5 Prepare Mailing Labels Steve Print Questionnaire Steve 55 Develop Data Analysis Software Andy & Develop Software Test Data Susan Mail Questionnaire & Get Responses Test Software Andy 11 Input Response Data Jim 2 45 47 48 50 3 6 10 45 40 50 -5 7 12 45 57 88 100 43 2 45 47 98 100 53 9 Steve 55 55 110 50 105 -5 10 5 57 62 100 105 43 7 110 117 105 112 -5 12 Analyze Results Jim 8 117 125 112 120 -5 13 Prepare Report Jim 10 125 135 120 130 -5 14 Order New Database for Labels Steve 21 23 44 27 48 4