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!!

Workout a budget Using Excel on Construction!! Prepare the budget in Excel

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!