This homework is based on Problems from Chapter 3 page 99 \#18 from the textbook: - Eor convenience, See the second page below for the data and the questions. - Please ensure that you answer questions a, b, c, d, e, fof Problem \#18 only. To help you start with answering Problem II18 questions, I designed the table you need to complete for question a. It is very similar to what we did in the lecture for Weeki7 using Figure 3.24. Therefore, for this problem \#18, first you need to complete the table below. Complete the columns in red font. The answers for questions b,c,d,e, and f are based on your answers for question a in the table below. Start your work with the following table. That will be your answer to question a. (It is besed on the data for problem A18. Also shown on the second page below). After completing the thble above, for the two columns in red, start your computations for questions b,c,d,e, and f. These questions are shown on the second page below. Show your computations to get full credit, the same way I did in the lecture for Weekif. Use thils document to complete and submit your answer to questions a, b, c, d, e, and f At the top of the page, insert your name. Save this file as HW2. See the pare below for the euetions b. a, d. a and fof Problem 118. 18. Using the data in the table from the previous problem: a. Create a table similar to the one in Figure 3.24 if you haven't done so already. b. Calculate the budget at completion (BAC), planned value (PV), actual cost (AC), and earned value (EV) at Week 4. c. For Week 4, calculate the performance measures of cost variance (CV), schedule variance (SV). the cost performance index (CPI), and the schedule performance index (SPI). d. What can you say about the budget in Week 4 by using these performance measures? e. What can you say about the schedule in Week 4 by using these performance measures? f. For Week 4, calculate the estimated time to complete (ETC) and estimate at completion (EAC). This homework is based on Problems from Chapter 3 page 99 \#18 from the textbook: - Eor convenience, See the second page below for the data and the questions. - Please ensure that you answer questions a, b, c, d, e, fof Problem \#18 only. To help you start with answering Problem II18 questions, I designed the table you need to complete for question a. It is very similar to what we did in the lecture for Weeki7 using Figure 3.24. Therefore, for this problem \#18, first you need to complete the table below. Complete the columns in red font. The answers for questions b,c,d,e, and f are based on your answers for question a in the table below. Start your work with the following table. That will be your answer to question a. (It is besed on the data for problem A18. Also shown on the second page below). After completing the thble above, for the two columns in red, start your computations for questions b,c,d,e, and f. These questions are shown on the second page below. Show your computations to get full credit, the same way I did in the lecture for Weekif. Use thils document to complete and submit your answer to questions a, b, c, d, e, and f At the top of the page, insert your name. Save this file as HW2. See the pare below for the euetions b. a, d. a and fof Problem 118. 18. Using the data in the table from the previous problem: a. Create a table similar to the one in Figure 3.24 if you haven't done so already. b. Calculate the budget at completion (BAC), planned value (PV), actual cost (AC), and earned value (EV) at Week 4. c. For Week 4, calculate the performance measures of cost variance (CV), schedule variance (SV). the cost performance index (CPI), and the schedule performance index (SPI). d. What can you say about the budget in Week 4 by using these performance measures? e. What can you say about the schedule in Week 4 by using these performance measures? f. For Week 4, calculate the estimated time to complete (ETC) and estimate at completion (EAC)