of (14 points) Consider the following project to shoot a television commercial. The following table provides for each project activity, the duration, the list of predecessors, the total budget, the earliest start time (ES), the earliest finish time (EF), and the status of completion as of the end of week 24. The project manager is worried about the budget since the actual costs (AC) at the end of week 24 have risen to $7,500 FI Ti Activity Predecessors ES EF Duration Budget % (weeks) ($) completed 6 900 100 A:Write script o 6 B:Screen actors 6 1,200 100 0 6 6 12 C:Select actors A 6 100 D:Contract studio 12 100 6 18 E:Obtain pros 1,200 1,800 1,400 1,500 14 100 12 26 B, C B,C,D DE 10 40 18 F.Schedule date G: Shoot commercial 28 16 800 0 26 42 (a) (8 points) Assume that the PV values for each activity are based on the time proportionality assumption (i.e., the task overall budget is uniformly distributed over its duration), calculate at end of week 24 the total value of PV as well as the total value of EV PV = (with no comma nor space) EV (with no comma nor space) MacBook Air commercial (a) (8 points) Assume that the PV values for each activity are based on the time proportionality assumption (i.e, the task overall budget is uniformly distributed over its duration), calculate at end of week 24 the total value of PV as well as the total value of EV. PV = (with no comma nor space) EV = (with no comma nor space) (b) (6 points) Based on your answer on question (a) above, calculate the values of CPI, and SPI. Is there a cost overage (i.e., over budget) or underage (ie., under budget)? How much is it? Is the project ahead or behind the schedule? CPI = (keep 3 decimals) EV = (keep 3 decimals) Is there a cost overage (write 1) or underage (write 0) Ainount of cost overage or underage (ignore the sign) Is the project ahead (write 1) or behind (write 0) the schedule? MacBook Air of (14 points) Consider the following project to shoot a television commercial. The following table provides for each project activity, the duration, the list of predecessors, the total budget, the earliest start time (ES), the earliest finish time (EF), and the status of completion as of the end of week 24. The project manager is worried about the budget since the actual costs (AC) at the end of week 24 have risen to $7,500 FI Ti Activity Predecessors ES EF Duration Budget % (weeks) ($) completed 6 900 100 A:Write script o 6 B:Screen actors 6 1,200 100 0 6 6 12 C:Select actors A 6 100 D:Contract studio 12 100 6 18 E:Obtain pros 1,200 1,800 1,400 1,500 14 100 12 26 B, C B,C,D DE 10 40 18 F.Schedule date G: Shoot commercial 28 16 800 0 26 42 (a) (8 points) Assume that the PV values for each activity are based on the time proportionality assumption (i.e., the task overall budget is uniformly distributed over its duration), calculate at end of week 24 the total value of PV as well as the total value of EV PV = (with no comma nor space) EV (with no comma nor space) MacBook Air commercial (a) (8 points) Assume that the PV values for each activity are based on the time proportionality assumption (i.e, the task overall budget is uniformly distributed over its duration), calculate at end of week 24 the total value of PV as well as the total value of EV. PV = (with no comma nor space) EV = (with no comma nor space) (b) (6 points) Based on your answer on question (a) above, calculate the values of CPI, and SPI. Is there a cost overage (i.e., over budget) or underage (ie., under budget)? How much is it? Is the project ahead or behind the schedule? CPI = (keep 3 decimals) EV = (keep 3 decimals) Is there a cost overage (write 1) or underage (write 0) Ainount of cost overage or underage (ignore the sign) Is the project ahead (write 1) or behind (write 0) the schedule? MacBook Air