Goodman Company plans a project which is proposed to be completed in a year, and which consists of 6 activities. The work and budget are uniformly scheduled for each activity. At the end of Quarter 3, the manager reports the progress as shown in Figure 1. Prototype is scheduled to be finished 4/7 and Test is scheduled to be finished 1/3, as to date. Activity Survey Design Layout Quarter 1 Quarter 2 Quarter 3 Quarter 4 $15,000 100% / $12,000 $56,000 80% / $50,000 $30,000 75% / $20,000 $125,000 50% / $80,000 $32,000 0% / $0 $17,000 0% / 30 Prototype Test Document Scheduled Budget Completed Percentage / Actual Spending Figure 1 (a) Calculate the total budget of project, the current BCWS, BCWP, and ACWP. (4 marks) (1) Determine the Schedule Variance, Cost Variance, CPI and SPI at this stage. Describe the status of the project as to-date. (6 marks) (C) If the project manager plans to apply extra funding, how much more is expected to complete the project? Assume that the past usage of budget can reflect the situation of the whole project. (2 marks) (d) If the project manager also decides to apply an extension of the project, how long is the expected extension (in months) to complete the project? Assume that the overall work progress keeps the same. (3 marks) Goodman Company plans a project which is proposed to be completed in a year, and which consists of 6 activities. The work and budget are uniformly scheduled for each activity. At the end of Quarter 3, the manager reports the progress as shown in Figure 1. Prototype is scheduled to be finished 4/7 and Test is scheduled to be finished 1/3, as to date. Activity Survey Design Layout Quarter 1 Quarter 2 Quarter 3 Quarter 4 $15,000 100% / $12,000 $56,000 80% / $50,000 $30,000 75% / $20,000 $125,000 50% / $80,000 $32,000 0% / $0 $17,000 0% / 30 Prototype Test Document Scheduled Budget Completed Percentage / Actual Spending Figure 1 (a) Calculate the total budget of project, the current BCWS, BCWP, and ACWP. (4 marks) (1) Determine the Schedule Variance, Cost Variance, CPI and SPI at this stage. Describe the status of the project as to-date. (6 marks) (C) If the project manager plans to apply extra funding, how much more is expected to complete the project? Assume that the past usage of budget can reflect the situation of the whole project. (2 marks) (d) If the project manager also decides to apply an extension of the project, how long is the expected extension (in months) to complete the project? Assume that the overall work progress keeps the same