Project management assignment

costestimate.xls

Sheet1

Cost Estimate
Project Name:	Date:
Note: Enter your WBS, hours, labor rates, etc. Add/delete rows and columns as needed and check all formulas (bolded below).
	Internal	$/hour	Internal	External	$/hour	External	Total	Non-labor $	Total Cost
WBS Categories	Labor		$ Total	Labor		$ Total	Labor
1. Initiating	200	$ 65	$ 13,000			$ - 0	$ 13,000		$ 13,000
2. Planning	600	$ 60	$ 36,000			$ - 0	$ 36,000		$ 36,000
3. Executing			$ - 0			$ - 0	$ - 0		$ - 0
3.1 Course design and development			$ - 0			$ - 0	$ - 0		$ - 0
3.1.1 Supplier management training	600	$ 60	$ 36,000	600	$ 150	$ 90,000	$ 126,000	$ 100,000	$ 226,000
3.1.2 Negotiating skills training	300	$ 55	$ 16,500	300	$ 150	$ 45,000	$ 61,500	$ 50,000	$ 111,500
3.1.3 Project management training	400	$ 60	$ 24,000	400	$ 150	$ 60,000	$ 84,000	$ 50,000	$ 134,000
3.1.4 Software applications training	400	$ 60	$ 24,000	400	$ 150	$ 60,000	$ 84,000	$ 50,000	$ 134,000
3.2 Course administration	400	$ 55	$ 22,000	300	$ 250	$ 75,000	$ 97,000	$ 80,000	$ 177,000
3.3.Course evaluation	300	$ 55	$ 16,500			$ - 0	$ 16,500		$ 16,500
3.4 Stakeholder communications	300	$ 55	$ 16,500			$ - 0	$ 16,500		$ 16,500
4. Monitoring and Controlling	500	$ 55	$ 27,500			$ - 0	$ 27,500		$ 27,500
5. Closing	200	$ 55	$ 11,000			$ - 0	$ 11,000		$ 11,000
Subtotal									$ 903,000
Reserves			$ - 0			$ - 0	$ - 0		90,300.0
Total	4,200		243,000	2,000	850	330,000	573,000	330,000	$ 993,300
Assumptions