for this assignment, you will create a budget using Excel. You will use the data in the chart below including;

tasks, predecessors and durations.

$1.$ Create the structure of your budget in Microsoft Excel.

$2.$ Estimate the labour and non$-$labour costs, use the duration estimates provided.

a$.$ Determine hourly rates

b$.$ Consider non$-$labour costs of this project, equipment, furniture, food and supplies.

$3.$ Create the total $($aggregate$)$ budget

a$.$ Sum up the costs of each major deliverable

b$.$ 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

$4.$ Create the time$-$phased budget

a$.$ Consider when the work will be done.

b$.$ Contingency can be spread across the project$$s duration

c$.$ Ensure your time$-$phased budget has the same total cost as your aggregate budgetMultitalented Competition Event

$\backslash$table$[[$Activity$,$Task,Predecessors,$\backslash$table$[[$Duration$],[($in days$)]]],[1,$Research,,$],[1\mathrm{.}1,$Set objectives,None,$2],[1\mathrm{.}2,$Gather information,$1\mathrm{.}1,3],[1\mathrm{.}3,$Research markets,$1\mathrm{.}2,3],[1\mathrm{.}4,$Run stakeholder meeting,$1\mathrm{.}3,0\mathrm{.}5],[1\mathrm{.}5,$Collect requirements,$1\mathrm{.}4,3],[2,$Administration,,$],[2\mathrm{.}1,$Create project charter,$1\mathrm{.}2,1],[2\mathrm{.}2,$Develop resource list,$2\mathrm{.}1,0\mathrm{.}5],[2\mathrm{.}3,$Create project budget,$2\mathrm{.}2,1],[2\mathrm{.}4,$Assign tasks to the project team,$2\mathrm{.}3,1],[3,$Partners,,$],[3\mathrm{.}1,$Contact potential partners,$2\mathrm{.}4,3],[3\mathrm{.}2,$Invite event partners,$3\mathrm{.}1,1],[3\mathrm{.}3,$Send reminders $($date$/$time$/$place$),3\mathrm{.}2,0\mathrm{.}5],[4,$Marketing,,$],[\backslash$table$[[4\mathrm{.}1,]],$Create marketing approach,$2\mathrm{.}4,1],[4\mathrm{.}2,$Advertise on the college website,$4\mathrm{.}1,1],[4\mathrm{.}3,$Advertise on social media,$4\mathrm{.}1,0\mathrm{.}5],[4\mathrm{.}4,$Create and distribute fliers$/$posters$,4\mathrm{.}1,3],[4\mathrm{.}5,$Register participants,$4\mathrm{.}2,10],[5,$Competition Preparation,,$],[5\mathrm{.}1,$Order refreshments$/$drinks$,4\mathrm{.}5,2],[5\mathrm{.}2,$Book auditorium,$2\mathrm{.}4,0\mathrm{.}5],[5\mathrm{.}3,$Purchase gifts for the winning team,$4\mathrm{.}2,1],[5\mathrm{.}4,$Purchase materials $($T$-$shirts, pens, water bottles$),4\mathrm{.}5,1],[5\mathrm{.}5,$Establish competition rules,$2\mathrm{.}4,2],[6,$Staffing,,$],[6\mathrm{.}1,$Book security,$5\mathrm{.}2,0\mathrm{.}5],[6\mathrm{.}2,$Hire janitors for post$-$event clean$-$up$,5\mathrm{.}2,3],[6\mathrm{.}3,$Select Volunteers,$2\mathrm{.}4,3]]$