A. Given the following data about a project: 1. Prepare a table in Excel showing the time-phased budget for the project. Assume the budgeted cost is linearly distributed over the duration of the activity, e.g., if the budgeted cost of a Task is $100 and the duration of the Task is 2 weeks, then budgeted cost/week=100/2= $50. All calculations should be done within the Excel spreadsheet. Do not copy and paste answers into Excel (as much as possible). 2. Use graphs to illustrate the weekly budget as well as the cumulative budget for the project. 3. Your name should be part of the file name that you submit in Canvas. Task Predecessor Budgeted cost ($) Duration (weeks) A 1500 4 B 1350 2 C 1260 3 D A 950 N E C,D 1650 F BE 1200 4 G E 700 2 H F G 1770 3