On August 27, 2002, the executive steering committee received the following report indi- cating the status of the project at the end of the eighth week: Time Remaining (Weeks) Activity % Complete Actual Cost AB AC AD 100 60 87.5 50 50 $23,500 19,200 37,500 8,000 5,500 0 4 1 2 1 BC BE The steering committee could not identify the real status of the project from this brief report. Even after comparing this brief status report with the project planning budget (see Table 1518), the real status was not readily apparent. Management instructed the project manager to prepare a better status report that depicted the true status of the project, as well as the amount of profit that could be expected at project completion. Your assignment is to prepare a table such as Table 15-17. On August 27, 2002, the executive steering committee received the following report indi- cating the status of the project at the end of the eighth week: Time Remaining (Weeks) Activity % Complete Actual Cost AB AC AD 100 60 87.5 50 50 $23,500 19,200 37,500 8,000 5,500 0 4 1 2 1 BC BE The steering committee could not identify the real status of the project from this brief report. Even after comparing this brief status report with the project planning budget (see Table 1518), the real status was not readily apparent. Management instructed the project manager to prepare a better status report that depicted the true status of the project, as well as the amount of profit that could be expected at project completion. Your assignment is to prepare a table such as Table 15-17