Question: Workout a budget Using Excel on Construction!! Prepare the budget in Excel using your project WBS. - There are many free budget templates and resources;
Workout a budget Using Excel on Construction!!

Prepare the budget in Excel using your project WBS. - There are many free budget templates and resources; two have been attached to the assignment in the course. Use one of these resources rather than creating something new. - Include two tabs in your Excel document: WBS and Budget. - Include a report name, your name, and date. - Use at least three levels with a minimum of five (5) Level 1 tasks, two (2) Level 2 tasks, with three (3) Level 3 tasks. - Continue to decompose the tasks/activities in your WBS until you have tasks which are small enough to assign to an individual and accurate estimate the cost of each activity. - Use the Excel math functions when you create your report, for instance, =sum(A:A5). - Do not hide numbers in formulas, for instance, =sum(A3,330), where 330 is a cost. - Include all project activities. Recall that we are rolling up the project Prepare the budget in Excel using your project WBS. - There are many free budget templates and resources; two have been attached to the assignment in the course. Use one of these resources rather than creating something new. - Include two tabs in your Excel document: WBS and Budget. - Include a report name, your name, and date. - Use at least three levels with a minimum of five (5) Level 1 tasks, two (2) Level 2 tasks, with three (3) Level 3 tasks. - Continue to decompose the tasks/activities in your WBS until you have tasks which are small enough to assign to an individual and accurate estimate the cost of each activity. - Use the Excel math functions when you create your report, for instance, =sum(A:A5). - Do not hide numbers in formulas, for instance, =sum(A3,330), where 330 is a cost. - Include all project activities. Recall that we are rolling up the project
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
