need help with filling this out. we are doing a project for a class. this is the budget and i just need some numbee to be filled in for me plz help.
Cost Estimate 2 Project Name: 3 Note: Enter your WBS, hours, labor rates, etc. Add/delete rows and columns as needed and check all formulas (bolded below). Date: 5 6 WBS Categories 7 1. Initiating 8 2 Planning 9 3. Executing 10 3.1 Course design and deelopment 11 Internal $/hour Internal External $/hour External Total Non-labor S Total Cost Labor S Total 200 $ 65 $13,000 600 S 60 $ 36,000 $ Labor $ Total Labor $13,000 $ 36,000 $ 13,000 S 36,000 S S $ 3.1.1 Supplier management training 600 $ 60 $36,000 300 $ 55 $16,500 400 S 60 $24,000 400 $ 60 $24,000 400 S 55 $ 22,000 300 $ 55 $16,500 300 $ 55 $16,500 500 S 55 $27,500 200 S 55 $11,000 600 S 150 $90,000 $126,000 S 100,000 $ 226,000 50,000 $111,500 50,000 $ 134,000 50,000 $ 134.000 80,000 $177,000 S 16,500 S 16,500 S 27,500 S 11,000 $ 903,000 12 3.1.2 Negotiating skills training 300 $150 $45,000 61,500 S 400 $ 150 $ 60,000 $ 84,000 S 400 $ 150 $60,000 $ 84,000 S 300 $ 250 $75,000 $97,000 $16,500 $ 16,500 $ 27,500 $ 11.000 3.1.3 Project management training 3.14 Software applications training 3.2 Course administration 13 14 15 16 3.3.Course evaluation 17 3.4 Stakeholder communications 18 4 Monitoring and Controlling 19 5 Closing 20 Subtotal 21 Reserves 22 Total 23 24 Assumotions $ $ 90 300.0 Reserves are 10 % of Subtotal 4.200 243,000 2.000 850 330,000 330.000 $ 993,300 573,000 Sheet1 Sheet2 Sheet3 Cost Estimate 2 Project Name: 3 Note: Enter your WBS, hours, labor rates, etc. Add/delete rows and columns as needed and check all formulas (bolded below). Date: 5 6 WBS Categories 7 1. Initiating 8 2 Planning 9 3. Executing 10 3.1 Course design and deelopment 11 Internal $/hour Internal External $/hour External Total Non-labor S Total Cost Labor S Total 200 $ 65 $13,000 600 S 60 $ 36,000 $ Labor $ Total Labor $13,000 $ 36,000 $ 13,000 S 36,000 S S $ 3.1.1 Supplier management training 600 $ 60 $36,000 300 $ 55 $16,500 400 S 60 $24,000 400 $ 60 $24,000 400 S 55 $ 22,000 300 $ 55 $16,500 300 $ 55 $16,500 500 S 55 $27,500 200 S 55 $11,000 600 S 150 $90,000 $126,000 S 100,000 $ 226,000 50,000 $111,500 50,000 $ 134,000 50,000 $ 134.000 80,000 $177,000 S 16,500 S 16,500 S 27,500 S 11,000 $ 903,000 12 3.1.2 Negotiating skills training 300 $150 $45,000 61,500 S 400 $ 150 $ 60,000 $ 84,000 S 400 $ 150 $60,000 $ 84,000 S 300 $ 250 $75,000 $97,000 $16,500 $ 16,500 $ 27,500 $ 11.000 3.1.3 Project management training 3.14 Software applications training 3.2 Course administration 13 14 15 16 3.3.Course evaluation 17 3.4 Stakeholder communications 18 4 Monitoring and Controlling 19 5 Closing 20 Subtotal 21 Reserves 22 Total 23 24 Assumotions $ $ 90 300.0 Reserves are 10 % of Subtotal 4.200 243,000 2.000 850 330,000 330.000 $ 993,300 573,000 Sheet1 Sheet2 Sheet3
