QUESTION 25 (10 points) - Critical Path Method (CPM) with Crashing The film The Lord of the Rings: The Return of the King, the last installment of The Lord of the Rings trilogy, was directed by Peter Jackson and released on December 17 2003 in the U.S. with huge successes. Eventually, the film won 11 Oscars for all of its nominations. The film's box office was $1.12 billion. In the film, there are long sequences where the main characters split up in different directions. And, there are big scenes where all the characters reunited. Reflecting upon the film making, we can hypothetically break down the entire cinematic project into the following aggregate activities: (We assume away all the complexities in shooting the three installments at the same time and other production details.) A-Plan, screenplay, finance, cast, film crew, location B - Construction of movie sets C-Shooting of sequence D-Shooting of sequence 2 E-Shooting of sequence 3 E-Shooting of the big scene sequence 3 40 - 8 allal 11 NA 6. Post-production & finalization before release We have the following hypothetical data on time in months and costs in millions of dollars: ID IP T ES EF LS LF ST NC A 6.0 2 ? ? ? 2 13.0 B 4.0 2 ? ? ? ? 9.0 ? ? ? 2 ? 12.0 5.0 2 ? ? ? ? 140 6.0 7 ? ? ? 16.0 F C,D,E 4.0 ? ? ? ? 190 G 6.0 ? ? ? 7 ? 110 Note: IP immediate Predecessor; T = Normal Time; ES - Earliest Start, EF = Earliest Finish, LS - Latest Start, LF - Latest Finish: ST Slack Time; & NC - Normal Cost (a) [1] Based on the table, draw an AON project network circlesodes for activities and arrows/ares for the precedence relationships between activities. Above each node, put a number to represent the activity's normal time. (b[1] Draw a Gantt chart in Excel to represent the project schedule with earliest times, and make a printout (c)[1] By looking at the chart in part (a), find all possible paths through the network with their corresponding path times. Based on these path times, determine the critical path and its length (d)[2] Based on part (a), draw a boxed AON project network nodes are boxes with data. By using the forward and backward passes, fill your calculations for ES, EF, LS, LF, and ST in the appropriate cells (e)(1) Based on part (d), find the critical path by going through the activities with no stack time. Compare this result with the critical path found in part (c) 1012 Independently fill in the columns ES, EF, LS, LF, and ST [the table. If you have difficulties, refer to part (d). Find the activity with the most slack time. Based on the table alone, find the critical path. Compare this result with the critical path found in part (c). (e)[2] Find the total normal cost of the film. Find the normal cost on the original critical path. Compute the cost proportion of the critical path in the film's budget. QUESTION 25 (10 points) - Critical Path Method (CPM) with Crashing The film The Lord of the Rings: The Return of the King, the last installment of The Lord of the Rings trilogy, was directed by Peter Jackson and released on December 17 2003 in the U.S. with huge successes. Eventually, the film won 11 Oscars for all of its nominations. The film's box office was $1.12 billion. In the film, there are long sequences where the main characters split up in different directions. And, there are big scenes where all the characters reunited. Reflecting upon the film making, we can hypothetically break down the entire cinematic project into the following aggregate activities: (We assume away all the complexities in shooting the three installments at the same time and other production details.) A-Plan, screenplay, finance, cast, film crew, location B - Construction of movie sets C-Shooting of sequence D-Shooting of sequence 2 E-Shooting of sequence 3 E-Shooting of the big scene sequence 3 40 - 8 allal 11 NA 6. Post-production & finalization before release We have the following hypothetical data on time in months and costs in millions of dollars: ID IP T ES EF LS LF ST NC A 6.0 2 ? ? ? 2 13.0 B 4.0 2 ? ? ? ? 9.0 ? ? ? 2 ? 12.0 5.0 2 ? ? ? ? 140 6.0 7 ? ? ? 16.0 F C,D,E 4.0 ? ? ? ? 190 G 6.0 ? ? ? 7 ? 110 Note: IP immediate Predecessor; T = Normal Time; ES - Earliest Start, EF = Earliest Finish, LS - Latest Start, LF - Latest Finish: ST Slack Time; & NC - Normal Cost (a) [1] Based on the table, draw an AON project network circlesodes for activities and arrows/ares for the precedence relationships between activities. Above each node, put a number to represent the activity's normal time. (b[1] Draw a Gantt chart in Excel to represent the project schedule with earliest times, and make a printout (c)[1] By looking at the chart in part (a), find all possible paths through the network with their corresponding path times. Based on these path times, determine the critical path and its length (d)[2] Based on part (a), draw a boxed AON project network nodes are boxes with data. By using the forward and backward passes, fill your calculations for ES, EF, LS, LF, and ST in the appropriate cells (e)(1) Based on part (d), find the critical path by going through the activities with no stack time. Compare this result with the critical path found in part (c) 1012 Independently fill in the columns ES, EF, LS, LF, and ST [the table. If you have difficulties, refer to part (d). Find the activity with the most slack time. Based on the table alone, find the critical path. Compare this result with the critical path found in part (c). (e)[2] Find the total normal cost of the film. Find the normal cost on the original critical path. Compute the cost proportion of the critical path in the film's budget