For this assignment, you will create a budget using Excel. Please refer to the Group Assignment $2-$Budget Example Template document as an example of the format. Your group will first come to a consensus of which student's schedule to use as a foundation, then incorporate the additional elements in the list below$\mathrm{.}1.$Create the structure of your budget in Microsoft Excel $($use the template as a guide$/$example$)\mathrm{.}2.$ Estimate the labour and non$-$labour costs, use the duration estimates provided.a$.$ Determine hourly rates for the resources that you assigned in the individual schedule assignment.b$.$ Consider the non$-$labour costs of this project, e$.$g$.,$ computer equipment, permit fees, furniture, and supplies$\mathrm{.}3.$ Create the total $($aggregate$)$ budget.a$.$ Sum up the costs of each major deliverableb. Create subtotals at the major deliverable level.c$.$ Create subtotals for the labour and non$-$labour costs.d$.$ Use formulas whenever possible so you fully harness the power of Microsoft Excel.e$.$ Establish a reasonable contingency for this project.f$.$ You are free to make any assumptions you like; simply ensure they are well documented.Create a time$-$phased budget.a$.$ Consider when the work will be done.b$.$ Cantingency can be spread across the project's duration.c$.$ Ensure your time$-$phased budget has the same total cost as your aggregate budget$\mathrm{.}5.$ Create aggregated $($total$)$ budget on first sheet$/$tab of excel$\mathrm{.}6.$ Create time phase budget on the second sheet$/$tab of excel.