Assignment 6 (50 points) You've been given the following information about the Project Delts. The project started on October 23, 2017 and the project manager asks you for help on assessing its ongoing progress (as completed through November 6, 2017, the current date) by doing the following tasks: For submission, attach the completed MS Project and submit via Caras upload. Activity Duration Predecessors Resource % completo Tom Allen 100 A. Research product B. Interview customers A Liz Watts 75 C. Design survey A Rich Watkins 50 D. Collect data 4 BC Gary Sims 0 Now suppose we assign costs to each of the resources in the following amounts, Resource Cost Tom Allen S50/hour Lix Watts $55/hour Rich Watkins $18/hour Gary Sims S12.50/hour Using the above project data, enter the various tasks and create a Gantt chart using MS Project Assign the individuals responsible for each activity and enter the resource cost rate data into the project. Dony forget to save the baseline! 1.2) Create the Cash flow statement for the project baseline. What is the planned project budget per task? 1.3) Once you have completed the Baseline, update the project information with the percentage complete tool. What does the tracking Gantt Chart look like? 1.4) Originally, the human resources costs are the only planned expenditures. However, in carrying out Task A research product, a total of $1,500 extra cost was incurred to purchase some research tools. Use MS Project to create an Earned Value report of the most recent project status