This is an Exercise from Engineering Project management. Please create the answer in Excel

Use the provided project data to answer the questions below. Assume the following: For determining the planned value per-week, assume that the budgeted amount for each activity is evenly distributed across each week of its planned duration. For example, assume that an activity has a budget or $15,000 and a three week duration, occurring during weeks 5,6, and 7. In that case, the planned value for that activity during weeks 5, 6, and 7 is $5,000 each week. For earned value calculations, use the percent complete method, with simple proportional earned value assignments. The actual cost amounts are incurred during the week in which they are reported. The amounts in the table ARE NOT cumulative. The percent complete values in each column ARE cumulative. . . Activity Predecessors Weeks Duration Budgeted Cost Actual Cost During* Week 1 $9,000 % Compl. End of Week 1 Actual Cost During* Week 2 0 % Compl. End of Week 2 Actual Cost During* Week 3 0 % Compl. End of Week 3 Actual Cost During* Week 4 0 % Compl. End of Week 4 A None 1.0 100 100 100 100 B A 2.0 0 0 40 75 $10,000 100 $25,000 $12,000 $25,000 0 C A 1.0 0 0 100 100 0 100 D A 3.0 0 0 $13,000 25 $15,000 50 $8,000 80 $11,000 $46,000 $12,000 $30,000 $90,000 $35,000 $56,000 $14,000 E B 0 0 0 0 0 0 0 0 3.0 5.0 F 0 0 0 0 $8,000 30 $7,000 50 D 4.0 0 0 0 0 0 0 0 0 H H 1.0 0 0 0 0 0 0 0 0 1. Solve the project network. a. Draw the activity network, using the AON method. b. Solve for the project completion time. c. Identify the critical path. d. Clearly identify each activity's early start and finish times, late start and finish times, and slack time. Use the provided project data to answer the questions below. Assume the following: For determining the planned value per-week, assume that the budgeted amount for each activity is evenly distributed across each week of its planned duration. For example, assume that an activity has a budget or $15,000 and a three week duration, occurring during weeks 5,6, and 7. In that case, the planned value for that activity during weeks 5, 6, and 7 is $5,000 each week. For earned value calculations, use the percent complete method, with simple proportional earned value assignments. The actual cost amounts are incurred during the week in which they are reported. The amounts in the table ARE NOT cumulative. The percent complete values in each column ARE cumulative. . . Activity Predecessors Weeks Duration Budgeted Cost Actual Cost During* Week 1 $9,000 % Compl. End of Week 1 Actual Cost During* Week 2 0 % Compl. End of Week 2 Actual Cost During* Week 3 0 % Compl. End of Week 3 Actual Cost During* Week 4 0 % Compl. End of Week 4 A None 1.0 100 100 100 100 B A 2.0 0 0 40 75 $10,000 100 $25,000 $12,000 $25,000 0 C A 1.0 0 0 100 100 0 100 D A 3.0 0 0 $13,000 25 $15,000 50 $8,000 80 $11,000 $46,000 $12,000 $30,000 $90,000 $35,000 $56,000 $14,000 E B 0 0 0 0 0 0 0 0 3.0 5.0 F 0 0 0 0 $8,000 30 $7,000 50 D 4.0 0 0 0 0 0 0 0 0 H H 1.0 0 0 0 0 0 0 0 0 1. Solve the project network. a. Draw the activity network, using the AON method. b. Solve for the project completion time. c. Identify the critical path. d. Clearly identify each activity's early start and finish times, late start and finish times, and slack time