Project management assignment

joshna
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

Sheet2

Sheet3