You are required to do a Microsoft Project exercise. Please read the instructions below before beginning. In Assignment 1, you created a tentative project plan, outlining important tasks and their durations. Now, your manager has approved this plan and sent you back the Project 2-0 file, which builds upon your initial submission. Your task for Assignment 2 is to refine the plan by assigning resources to individual tasks and developing cost estimates. Typically, once tasks are scheduled, resources are assigned to work on them. Therefore, your next step 1is to add resources to your project before assigning them to tasks and finalizing the budget. In summary, you are required to do the following for Assignment 2: e Refine the project plan by assigning resources to tasks in Assignment 1. e Develop cost estimates for the project. Ensure that the resources added align with the tasks and their requirements, and accurately reflect the human and material resources necessary for successful completion of the project. Note- Each resource is used fully during the task to which it is assigned. Note- Each resource is used fully during the task to which it is assigned. Material resources to be added are- Material Resources Quantity required Budget (per unit) Required for task Testing equipment 2 $800 Soil contamination study Surveying instrument $1500 Survey and analysis conducted Design Software $500 Park & Playground design completed Excavators 2 $5500 Building Demolition, Removal of debris, Foundation pit backfilling Dump Trucks 2 $5000 Removal of debris, Foundation pit backfilling, Converting land into park & Playground Bulldozers 2 $4500 Converting land into park & playground Tree planting equipment | 4 $1500 Converting land into park & playground Playground Equipment 4 $1500 Converting land into park & playground Concrete $2000 Converting land into park & playground Laptops 3 $600 For all tasks Temporary Shelter 1 $2500 For all tasks+ Human Resources to be added are Human Resource Quantity | Budget for | Required for task Wages per hour Project Manager 1 $60 For all tasks Community Liaison | 1 $45 Getting Community Approval officer Regulatory Specialist 1 $45 Getting Regulatory Permits Environmental 1 $50 Soil Contamination Study consultant Data/Financial Analyst | 2 $45 Budget Planning and Approvals, Risk Assessment Completed Architect/Designers 2 $40 Park & Playground Design Completed Demolition and cleanup | 10 $30 Building Demolition, Removal of Crew Debris, Foundation Pit Backfilling Landscapers 4 $35 Converting Land into Park & Playground Legal advisor 1 $45 Sponsors Sign Off on Project Completed Questions- a. Please take a screenshot of the Project Statistics section and provide the total cost of the project. (1 mark will be awarded for the screenshot and 1 mark for mentioning the total cost, totaling 2 marks). Analyze the Gantt chart provided and submit the final Microsoft Project file in PDF format. Ensure that the Gantt chart clearly displays added resources, including material and work type resources. (This task is worth 4 marks). Utilize the Visual Reports feature and provide screenshots of two different report categories. Alongside each screenshot, describe the insights you have observed. For example, Budget Cost Report, Resource Work Summary, etc. Simply attaching a screenshot without any explanation will not receive full credit. (Each report screenshot with its corresponding description is worth 2 marks, totaling 4 marks). Questions- a. Please take a screenshot of the Project Statistics section and provide the total cost of the project. (1 mark will be awarded for the screenshot and 1 mark for mentioning the total cost, totaling 2 marks). b. Analyze the Gantt chart provided and submit the final Microsoft Project file in PDF format. Ensure that the Gantt chart clearly displays added resources, including material and work type resources. (This task is worth 4 marks). c. Utilize the Visual Reports feature and provide screenshots of two different report categories. Alongside each screenshot, describe the insights you have observed. For example, Budget Cost Report, Resource Work Summary, etc. Simply attaching a screenshot without any explanation will not receive full credit. (Each report screenshot with its corresponding description is worth 2 marks, totaling 4 marks). You need to submit two separate PDF - 1. One for your MS Project as specified in Question b) 2. Second for questions a) & c)