05 Sep For Week 2 Discussion 2, you created a WBS.? Now that you have an understanding of the work your project involves, let’s start to list your project’s acti
Watch video for more instructions: https://youtu.be/gYAcHFroJ6k?si=GEX-Bl99SckHRBaP
For Week 2 Discussion 2, you created a WBS. Now that you have an understanding of the work your project involves, let's start to list your project's activities/tasks. Your list of activities/tasks should be at least 50 activities/tasks (Feel free to provide more than 50 activities). Add your activities to the attached Project Budget Worksheet. You will use Column A to add your activities/tasks. Make sure your activities are added to the appropriate Phase (Please Note: Even though the category is an option, I want you to focus on adding tasks/activities to the proper phase). In addition, add your resource.
Now that you have your tasks/activities completed, begin to add your labor, materials, and fixed costs. If you had an idea of what you wanted to spend for the different activities/tasks add them to your budget column. Your Actual Column should automatically populate. If it doesn't you just need to follow the rules of excel as you add in rows.
After you complete the spreadsheet, complete a write-up in APA format explaining what steps can be taken to make controlling budgets easier (Focus on technique and thinking). Can these steps also be used to control other project parameters, such as scope, behavior, etc…? Additionally:
- Which tools do you feel are most effective and could help you with your project (Use M&M Ch 7 reading to help you)
- What about content from PMI Reading? Anything there that could help your budgeting effort?
- What part does risk management play in the budget you created?
Additional criteria for this assignment:
1. 50 activities/tasks (Feel free to provide more than 50 activities). Add your activities to the attached Project Budget Worksheet. You will use Column A to add your activities/tasks. Make sure your activities are added to the appropriate Phase (Please Note: Even though category is an option, I want you to focus on adding tasks/activities to the proper phase). In addition add your resource. Now that you have your tasks/activities completed, begin to add your labor, materials and fixed costs. If you had an idea of what you wanted to spend for the different activities/tasks add them to your budget column. Your Actual Column should automatically populate. If it doesn't you just need to follow the rules of excel as you add in rows.
2. Complete a write up in APA format explaining what steps can be taken to make controlling budgets easier (Focus on technique and thinking)? Can these steps also be used to control other project parameters, such as scope, behavior, etc…? Additionally,: Which tools do you feel are most effective and could help you with your project (Use M&M Ch 7 reading to help you) What about content from Part 1 Chapter 7 of the PMBOK? Anything there that could help your budgeting effort?
3. This criterion is linked to a Learning OutcomeWhat part does risk management play in the budget you created?
Don't forget to add references to support the writeup
Project Budget
| Project Name | |||||||||||||
| Project Budget | Project Info | Budget Summary | |||||||||||
| Project Lead: | Name | [42] | Budget | Actual | Under(Over) | ||||||||
| Start Date: | 1/22/42 | $ 1,100 | $ 1,359 | $ (259) | |||||||||
| Labor | Materials | Fixed Costs | |||||||||||
| Tasks | Resources | Hrs | Rate | Units | $/Unit | Material | Travel | Other | Budget | Actual | Under(Over) | ||
| Phase or Category Title | (Name, title, or other identifying factor) | $ 1,100 | $ 1,263 | $ (163) | |||||||||
| Task | 8 | $12.50 | 300.00 | 200.00 | 400.00 | (200.00) | |||||||
| Task | 25 | $4.50 | 400.00 | 112.50 | 287.50 | ||||||||
| Task | 250.00 | 200.00 | 250.00 | (50.00) | |||||||||
| Sub Task | – 0 | – 0 | |||||||||||
| Sub Task | – 0 | – 0 | |||||||||||
| Sub Task | – 0 | – 0 | |||||||||||
| Task | 500.00 | 300.00 | 500.00 | (200.00) | |||||||||
| Task | – 0 | – 0 | |||||||||||
| Phase or Category Title | $ – 0 | $ – 0 | $ – 0 | ||||||||||
| Task | – 0 | – 0 | |||||||||||
| Task | – 0 | – 0 | |||||||||||
| Task | – 0 | – 0 | |||||||||||
| Task | – 0 | – 0 | |||||||||||
| Task | – 0 | – 0 | |||||||||||
| Phase or Category Title | $ – 0 | $ – 0 | $ – 0 | ||||||||||
| Task | – 0 | – 0 | |||||||||||
| Task | – 0 | – 0 | |||||||||||
| Task | – 0 | – 0 | |||||||||||
| Task | – 0 | – 0 | |||||||||||
| Task | – 0 | – 0 | |||||||||||
| Phase or Category Title | $ – 0 | $ – 0 | $ – 0 | ||||||||||
| Task | – 0 | – 0 | |||||||||||
| Task | – 0 | – 0 | |||||||||||
| Task | – 0 | – 0 | |||||||||||
| Task | – 0 | – 0 | |||||||||||
| Task | – 0 | – 0 | |||||||||||
| Phase or Category Title | $ – 0 | $ 96 | $ (96) | ||||||||||
| Task | 8 | $12.00 | 96.00 | (96.00) | |||||||||
| Task | – 0 | – 0 | |||||||||||
| Task | – 0 | – 0 | |||||||||||
| Task | – 0 | – 0 | |||||||||||
| Task | – 0 | – 0 | |||||||||||
&"Arial,Regular"&8&K01+048https://www.vertex42.com/ExcelTemplates/project-budget.html &9Page &P of &N &"Arial,Regular"&8&K01+047Project Budget Template © 2019 by Vertex42.com
Help
| Template Help | |
| Visit the Project Budget Template Page > | |
| About This Template | |
| This version of the project budget template was designed with a new look and it provides multiple columns for fixed costs. Also, instead of using the Labor, Materials, and Fixed Costs columns to calculate the Budgeted amount, these columns are used to calculate the Actual amount. | |
| Entering Budget and Actual Amounts | |
| In this worksheet, the Actual amount is calculated from the Labor, Materials, and Fixed Costs columns. This means that you manually enter the Budget value and you use the Labor, Materials, and Fixed Costs columns to enter actual spent amounts. | |
| When Adding New Rows | |
| The Phase/Category Title rows contain SUBTOTAL(9,…) formulas in the Budget and Actual columns that should be verified for accuracy after inserting new rows. Check these formulas to ensure that they reference the correct range of cells. | |
| Note: The SUBTOTAL(9,…) function is the same as the SUM(…) function except that using SUBTOTAL() ignores cells containing other SUBTOTAL() formulas. This allows the grand-total at the top to sum all budget values while ignoring the subtotals. | |
| Cell containing "#####" | |
| If you see "#####" in a cell, it means you need to widen the column to see the value, or reduce the font size for that cell. | |
©
| Project Budget Template | |
| By Vertex42.com | |
| https://www.vertex42.com/ExcelTemplates/project-budget.html | |
| © 2019 Vertex42 LLC | |
| This spreadsheet, including all worksheets and associated content is a copyrighted work under the United States and other copyright laws. | |
| Do not submit copies or modifications of this template to any website or online template gallery. | |
| Please review the following license agreement to learn how you may or may not use this template. Thank you. | |
| License Agreement | |
| https://www.vertex42.com/licensing/EULA_privateuse.html | |
| Do not delete this worksheet. |
https://www.vertex42.com/licensing/EULA_privateuse.html https://www.vertex42.com/ExcelTemplates/project-budget.html
image1.png
