Project Management

Week3HW1Spreadsheet.xlsx

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

	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.