Project management assignment

profilejoshna
costbaseline.xls

Sheet1

Cost Estimate
Project Name: Date:
Note: Enter your WBS and costs each month. Add/delete rows and columns as needed and check all formulas (bolded below).
Month
1 2 3 4 5 6 7 8 9 10 11 12 Total Cost
WBS Categories
1. Initiating 13,000 $ 13,000
2. Planning 6,000 16,000 8,000 1,000 1,000 1,000 1,000 1,000 1,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 5,000 73,667 73,667 73,667 $ 226,000
3.1.2 Negotiating skills training 5,000 35,500 35,500 35,500 $ 111,500
3.1.3 Project management training 5,000 43,000 43,000 43,000 $ 134,000
3.1.4 Software applications training 5,000 43,000 43,000 43,000 $ 134,000
3.2 Course administration 17,000 53,333 53,333 53,333 $ 177,000
3.3.Course evaluation 3,000 3,000 3,000 7,500 $ 16,500
3.4 Stakeholder communications 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 $ 16,500
4. Monitoring and Controlling 1,000 2,000 2,000 2,000 3,000 3,500 3,000 3,000 2,000 3,000 2,000 1,000 $ 27,500
5. Closing 8,000 3,000 $ 11,000
Subtotal $ 903,000
Reserves* - 0 - 0 - 0 90,300 $ 90,300
Total 20,000 19,500 31,500 199,667 200,667 218,167 61,833 61,833 60,833 12,000 11,500 95,800 993,300
*Reserves are all entered in month 12

Sheet2

Sheet3