or 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 budget