DNSC6262 Directed Computational Project Management

0 Download 14 Pages / 3,368 Words

10-06-2021

Question:

This report documents the approach and methodology used to determine resources, associated costs and indirect/ incidental costs needed to successfully execute the AAMC project. The various assumptions made are listed and described. It is intended that this report informs all stakeholders and be used as a reference to guide decisions on the project.

The report achieves the following objectives:

Determine all resource needs at the lowest levels of the DWBS
Identify efforts, resource intensities, durations, reliability estimates and maximum errors
Provide cost estimates and show impact of error on cost (contingency) using Monte Carlo simulation
Provide total budget estimates
Provide cost analysis based on WBS of the project
Compare cost estimated at PID with the level 4 cost estimate

The following assumptions were made to determine effort, quantities and optimal duration of tasks:

1) The project will be performed in Apex County, state of Georgia

2) Skilled workforce is available in Apex Count, state of Georgia

3) The cost does not account for Inflation or unexpected economic downturn

4) Each work package utilizes minimum of two/three human resource categories.

5) All human resources are available

6) Resource capacity is planned at 80% FTE (based on full time employee and full-time work period)

7) Time for meetings, reporting, communications, testing and other activities critical to the success of the project is considered.

8) Time for unexpected events such as sickness, supply problems, equipment failure, accidents and emergencies is considered

9) The quantities for the work packages were taken off by from Approved for Construction drawings

10) The Design consultants’ location is not affected by unforeseen weather maladies

11) There is no scope change in the design works

Answer:

Introduction

The following assignment has been developed for understanding the development of the activities and the implication of smart project development management. The project of construction of the Apex complex would require the implication of the improved management operations. The significant management would be implied with the help of project management operations and it would also be helpful for taking care of the work related to the management of the works.

Optimal Schedule and Developing Baseline

Resource Constraints

The resources have been used predominantly and there has been no usage limitation for the resources required in the project. The development of the resource limitations to usage limitation can be understood with the implication of the improved functional development. The resource usages has been limited to the effective and improved management processing. The following table would show the constrained and unconstrained project resources

Resource Name	Type	Initials	Unconstrained Max. Units	Constrained Max. Units	Std. Rate
Geotechnical Engineer	Work	G	100%	60%	$25.00/hr
Soil Lab technician	Work	S	100%	100%	$17.00/hr
Soil investigation Engineer	Work	S	100%	60%	$21.00/hr
Senior architect	Work	S	100%	100%	$35.00/hr
AutoCAD drafts man	Work	A	100%	60%	$20.00/hr
Estimator-Compiler	Work	E	100%	60%	$22.00/hr
Stuctural Engineer	Work	S	100%	100%	$35.00/hr
Snr Stuctural Engineer	Work	S	100%	60%	$40.00/hr
Mechanical systems designer	Work	M	100%	100%	$30.00/hr
Electrical systems designer	Work	E	100%	100%	$30.00/hr

Resource Constraint and Levelling

The unlevelled project resources were AutoCAD drafts man, Estimator-Compiler, and Snr Stuctural Engineer. The max values of the resources for the project had been decreased to 60% of the actual 100% due to the constraint factors. It resulted in overallocation of the work and requirement for the levelling of the work done. The constrained unlevelled project resource usage is given below,

The screenshot has clearly indicated that there is over allocation issues in the completion of the project for task ID 1.2.3 and 1.2.5. It is due to the fact that the resource constraints of AutoCAD draftsmen and estimator compiler. If the resource limitation is applied and the optimum duration of the whole project is considered, it is possible that the over allocation can be dealt with. Hence, we decreased the percentage of resource usage and modify the resource percentage for getting the optimum schedule for the project. The constrained levelled project resource usage is given below,

Table of modified activities

WBS	Task Name	Cost	Predecessors	Duration	Start	Finish
0	Project Apex	$9,079,198.50		495 days	Mon 08-10-18	Fri 28-08-20
1	Preliminaries	$108,264.00		85 days	Mon 08-10-18	Fri 01-02-19
1.1	Planning	$0.00		25 days	Mon 08-10-18	Fri 09-11-18
1.1.1	Identify mission and Objectives, Create Project Charter	$0.00		7 days	Mon 08-10-18	Tue 16-10-18
1.1.2	Create Business Plan and Issue	$0.00	3	5 days	Wed 17-10-18	Tue 23-10-18
1.1.3	Create Project Initiation Document and Issue	$0.00	3	12 days	Wed 24-10-18	Fri 09-11-18
1.2	Design	$108,264.00		73 days	Wed 24-10-18	Fri 01-02-19
1.1	Soil Investigation	$17,496.00	4	3 days	Wed 24-10-18	Fri 26-10-18
1.2	Architectural	$25,416.00	7	60 days	Mon 29-10-18	Fri 01-02-19
1.2.3	Structural	$23,640.00	7	15 days	Mon 29-10-18	Fri 16-11-18
1.2.4	Mechanical	$18,072.00	9	10 days	Mon 19-11-18	Fri 30-11-18
1.2.5	Electrical	$23,640.00	10	15 days	Mon 03-12-18	Fri 21-12-18
2	Basement and Floors 1 - 9	$7,137,142.50		440 days	Mon 24-12-18	Fri 28-08-20
2.1	Earthworks	$98,760.00		44 days	Mon 24-12-18	Thu 21-02-19
2.1.1	Survey	$15,000.00	11	5 days	Mon 24-12-18	Fri 28-12-18
2.1.2	Excavation	$21,200.00	14	10 days	Mon 31-12-18	Fri 11-01-19
2.1.3	Groundworks	$62,560.00		44 days	Mon 24-12-18	Thu 21-02-19
2.1.3.1	Grading	$24,360.00	11	5 days	Mon 24-12-18	Fri 28-12-18
2.1.3.2	Water Control	$4,200.00	17	29 days	Mon 31-12-18	Thu 07-02-19
2.1.3.3	Erosion control	$6,000.00	17	29 days	Mon 31-12-18	Thu 07-02-19
2.1.3.4	Underground utilities	$28,000.00	18,19	10 days	Fri 08-02-19	Thu 21-02-19
2.2	Structures	$4,645,009.00		136 days	Fri 22-02-19	Fri 30-08-19
2.2.1	Reinforcements	$4,645,009.00		136 days	Fri 22-02-19	Fri 30-08-19
2.2.1.1	Piles (Precast)	$3,651,832.00	20	14 days	Fri 22-02-19	Wed 13-03-19
2.2.1.2	Columns	$570,692.00		44 days	Thu 14-03-19	Tue 14-05-19
2.2.1.2.1	Columns (Basement - Floor 2)	$212,192.00	23	28 days	Thu 14-03-19	Tue 30-04-19
2.2.1.2.2	Columns (Floor 3 - 4)	$158,200.00	23	10 days	Thu 14-03-19	Wed 27-03-19
2.2.1.2.3	Columns (Floor 5 - 6)	$111,760.00	28	20 days	Thu 11-04-19	Tue 14-05-19
2.2.1.2.4	Columns (Floor 7 - 9)	$88,540.00	26	10 days	Thu 28-03-19	Wed 10-04-19
2.2.1.3	Slab-Beams	$385,173.00		36 days	Wed 15-05-19	Wed 03-07-19
2.2.1.3.1	Slab -Beams (Basement - Floor 2)	$143,496.00	27	12 days	Wed 15-05-19	Thu 30-05-19
2.2.1.3.2	Slab-Beams (Floor 3- 4)	$105,734.00	30	8 days	Fri 31-05-19	Tue 11-06-19
2.2.1.3.3	Slab-Beams (Floor 5 - 6)	$75,524.00	25,31	8 days	Wed 12-06-19	Fri 21-06-19
2.2.1.3.4	Slab-Beams (Floor 7 - 9)	$60,419.00	32	8 days	Mon 24-06-19	Wed 03-07-19
2.2.1.4	Roofing	$37,312.00		42 days	Thu 04-07-19	Fri 30-08-19
2.2.1.4.1	Roofing Trusses	$32,000.00	33	5 days	Thu 04-07-19	Wed 10-07-19
2.2.1.4.2	Roofing Cover	$5,312.00	35	3 days	Wed 28-08-19	Fri 30-08-19
2.3	Concrete	$152,738.50		36 days	Mon 02-09-19	Mon 21-10-19
2.3.1	Columns	$66,545.00		28 days	Mon 02-09-19	Wed 09-10-19
2.3.1.1	Columns (Basement - Floor 2)	$25,565.00	21	5 days	Mon 02-09-19	Fri 06-09-19
2.3.1.2	Columns Floor( 3 - 4)	$13,060.00	39	5 days	Mon 09-09-19	Fri 13-09-19
2.3.1.3	Columns Floor( 5 - 6)	$13,060.00	40,44	5 days	Thu 26-09-19	Wed 02-10-19
2.3.1.4	Columns Floor( 7 - 9)	$14,860.00	41	5 days	Thu 03-10-19	Wed 09-10-19
2.3.2	Slab-Beams	$86,193.50		26 days	Mon 16-09-19	Mon 21-10-19
2.3.2.1	Slab-Beams (Basement - Floor 2)	$18,704.00	40,45	4 days	Fri 20-09-19	Wed 25-09-19
2.3.2.2	Slab-Beams Floor( 3 - 4)	$29,466.50	40	4 days	Mon 16-09-19	Thu 19-09-19
2.3.2.3	Slab-Beams Floor( 5 - 6)	$13,681.50	42	4 days	Thu 10-10-19	Tue 15-10-19
2.3.2.4	Slab-Beams Floor( 7 - 8)	$24,341.50	46	4 days	Wed 16-10-19	Mon 21-10-19
2.3.3	Stairway	$40,996.00		8 days	Thu 14-03-19	Mon 25-03-19
2.3.3.1	Stairway (Basement - Floor 2)	$11,991.50	23	2 days	Thu 14-03-19	Fri 15-03-19
2.3.3.2	Stairway Floor(3 - 4)	$5,021.50	49	2 days	Mon 18-03-19	Tue 19-03-19
2.3.3.3	Stairway Floor( 5 -6)	$11,991.50	50	4 days	Wed 20-03-19	Mon 25-03-19
2.3.3.4	Stairway Floor( 7 - 8)	$11,991.50	49	4 days	Mon 18-03-19	Thu 21-03-19
2.3.4	Patios	$3,101.00	52	1 day	Fri 22-03-19	Fri 22-03-19
2.3.4	Blockwall-Masonry	$1,087,280.00		120 days	Mon 18-03-19	Fri 30-08-19
2.4.1	Bockwall	$1,087,280.00		120 days	Mon 18-03-19	Fri 30-08-19
2.4.1.1	Internal wall	$375,000.00	49	30 days	Mon 18-03-19	Fri 26-04-19
2.4.1.2	External wall	$425,000.00	56	45 days	Mon 29-04-19	Fri 28-06-19
2.4.1.3	Screening	$287,280.00	56	90 days	Mon 29-04-19	Fri 30-08-19
2.5	Interior -Finishes	$657,088.00		220 days	Mon 01-07-19	Fri 01-05-20
2.5..5	Partitions	$77,223.00	57	55 days	Mon 01-07-19	Fri 13-09-19
2.5.1	Dry wall	$85,000.00	58,69	45 days	Mon 16-09-19	Fri 15-11-19
2.5.2	Insulation	$463,265.00		90 days	Mon 18-11-19	Fri 20-03-20
2.5.2.1	Interior doors	$12,460.00	60	20 days	Mon 18-11-19	Fri 13-12-19
2.5.2.2	Windows	$18,080.00	60	30 days	Mon 18-11-19	Fri 27-12-19
2.5.2.3	Security doors	$12,400.00	62	20 days	Mon 16-12-19	Fri 10-01-20
2.5.2.4	Tiles	$107,605.00	60	90 days	Mon 18-11-19	Fri 20-03-20
2.5.2.5	Glazing works	$32,720.00	60	40 days	Mon 18-11-19	Fri 10-01-20
2.5.2.6	Decoration	$280,000.00	66,64	30 days	Mon 13-01-20	Fri 21-02-20
2.5.4	Carpeting	$31,600.00	67	50 days	Mon 24-02-20	Fri 01-05-20
2.6	MEP systems	$41,120.00		55 days	Mon 02-09-19	Fri 15-11-19
2.6.1	Plumbing	$41,120.00		55 days	Mon 02-09-19	Fri 15-11-19
2.6.1.1	Plumbing systems (Main Line)	$9,760.00	36	15 days	Mon 02-09-19	Fri 20-09-19
2.6.1.2	Plumbing systems (Floor. 1-2)	$7,840.00	36	10 days	Mon 21-10-19	Fri 01-11-19
2.6.1.3	Plumbing systems (Floor. 3-4)	$7,840.00	36,73	10 days	Mon 04-11-19	Fri 15-11-19
2.6.1.4	Plumbing systems (Floor. 4-6)	$7,840.00	72	10 days	Mon 23-09-19	Fri 04-10-19
2.6.1.5	Plumbing systems (Floor. 7-9)	$7,840.00	75	10 days	Mon 07-10-19	Fri 18-10-19
2.6.2	Electrical	$103,360.00		45 days	Mon 21-10-19	Fri 20-12-19
2.6.2.1	Electrical Fixtures (Distribution)	$28,000.00	76	5 days	Mon 21-10-19	Fri 25-10-19
2.6.2.2	Electrical Fixtures (Floor. 1-2)	$18,840.00	78	10 days	Mon 28-10-19	Fri 08-11-19
2.6.2.3	Electrical Fixtures (Floor. 3-4)	$18,840.00	79	10 days	Mon 11-11-19	Fri 22-11-19
2.6.2.4	Electrical Fixtures (Floor. 5-6)	$18,840.00	74,80	10 days	Mon 25-11-19	Fri 06-12-19
2.6.2.5	Electrical Fixtures (Floor. 7-9)	$18,840.00	81	10 days	Mon 09-12-19	Fri 20-12-19
2.6.3	Sprinkler	$35,740.00		40 days	Mon 23-03-20	Fri 15-05-20
2.6.3.1	Systems Controls	$25,000.00	65,82	10 days	Mon 23-03-20	Fri 03-04-20
2.6.3.2	Fire alarms	$10,740.00	84,68	10 days	Mon 04-05-20	Fri 15-05-20
2.6.4	Mechanical Systems	$271,950.00		75 days	Mon 18-05-20	Fri 28-08-20
2.6.4.1	Mechanical Fixtures (Elevators etc)	$95,000.00	85	15 days	Mon 18-05-20	Fri 05-06-20
2.6.4.2	Mechanical Fixtures (Floor 1- 4)	$88,950.00	87	30 days	Mon 08-06-20	Fri 17-07-20
2.6.4.3	Mechanical Fixtures (Floor 5- 9)	$88,000.00	88	30 days	Mon 20-07-20	Fri 28-08-20
3	External Works	$1,707,232.00		28 days	Mon 18-05-20	Wed 24-06-20
3.1	Access roads	$877,616.00	85	14 days	Mon 18-05-20	Thu 04-06-20
3.2	Signages	$2,000.00	91	5 days	Fri 05-06-20	Thu 11-06-20
3.3	Parking lot	$827,616.00	91	14 days	Fri 05-06-20	Wed 24-06-20
4	Quality Assessment	$126,560.00		20 days	Thu 25-06-20	Wed 22-07-20
4.1	Testing	$55,920.00		20 days	Thu 25-06-20	Wed 22-07-20
4.1	Testing 1	$5,592.00	92,93	2 days	Thu 25-06-20	Fri 26-06-20
4.1	Testing 2	$5,592.00	96	2 days	Mon 29-06-20	Tue 30-06-20
4.1	Testing 3	$5,592.00	96	2 days	Wed 01-07-20	Thu 02-07-20
4.1	Testing 4	$5,592.00	96	2 days	Fri 03-07-20	Mon 06-07-20
4.1	Testing 5	$5,592.00	96	2 days	Tue 07-07-20	Wed 08-07-20
4.1	Testing 6	$5,592.00	96	2 days	Thu 09-07-20	Fri 10-07-20
4.1	Testing 7	$5,592.00	96	2 days	Mon 13-07-20	Tue 14-07-20
4.1	Testing 8	$5,592.00	96	2 days	Wed 15-07-20	Thu 16-07-20
4.1	Testing 9	$5,592.00	96	2 days	Fri 17-07-20	Mon 20-07-20
4.1	Testing 10	$5,592.00	96	2 days	Tue 21-07-20	Wed 22-07-20
4.2	Inspections	$70,640.00		8 days	Wed 01-07-20	Fri 10-07-20
4.2	Inspections 1	$7,064.00	97	1 day	Wed 01-07-20	Wed 01-07-20
4.2	Inspections 2	$7,064.00	98	1 day	Fri 03-07-20	Fri 03-07-20
4.2	Inspections 3	$7,064.00	99	1 day	Tue 07-07-20	Tue 07-07-20
4.2	Inspections 4	$7,064.00	107	1 day	Thu 02-07-20	Thu 02-07-20
4.2	Inspections 5	$7,064.00	108	1 day	Mon 06-07-20	Mon 06-07-20
4.2	Inspections 6	$7,064.00	109	1 day	Wed 08-07-20	Wed 08-07-20
4.2	Inspections 7	$7,064.00	110	1 day	Fri 03-07-20	Fri 03-07-20
4.2	Inspections 8	$7,064.00	111	1 day	Tue 07-07-20	Tue 07-07-20
4.2	Inspections 9	$7,064.00	112	1 day	Thu 09-07-20	Thu 09-07-20
4.2	Inspections 10	$7,064.00	113,114,115	1 day	Fri 10-07-20	Fri 10-07-20

Contingency calculation

Total Estimated Cost	$ 9,079,198.50
Total Actual Cost	$ 9,533,158.42
Remaining Money	$ (453,959.92)
Contingency	$ 1,361,879.78

Scope change calculation

Total Estimated Cost	$ 9,079,198.50
Total estimated days	1213.00
Total Actual Cost	$ 9,176,290.60
total actual days	$ 1,256.35
Remaining days	$ (97,092.10)
remaining days	$ (43.35)
Contingency for cost	$ 1,361,879.78
Contingency for days	181.95

Scope change

The following assignment has been made for the implication of the scope change management and the utilization of the project management concept. For the project we have increased and reduced the project scope (days and cost).

In the assignment the project had a duration of 495 days and the budget of $9,079,198.50. However the activities were requested to be changed and the changes done in the project were:

WBS	Task Name	Duration	Cost	New duration	New cost
1.1.3	Create Project Initiation Document and Issue	12	$ -	14.4	$ -	scope increased by 20%
1.1	Soil Investigation	3	$ 17,496.00	2.55	$ 14,871.60	scope reduced by 15%
1.2.4	Mechanical	10	$ 18,072.00	12.5	$ 22,590.00	scope increased by 25%
2.1.3.3	Erosion control	29	$ 6,000.00	34.8	$ 7,200.00	scope increased by 20%
2.1.3.4	Underground utilities	10	$ 28,000.00	8.5	$ 23,800.00	scope reduced by 15%
2.2.1.2.2	Columns (Floor 3 - 4)	10	$ 158,200.00	12.5	$ 197,750.00	scope increased by 25%
2.2.1.3.4	Slab-Beams (Floor 7 - 9)	8	$ 60,419.00	9.6	$ 72,502.80	scope increased by 20%
2.2.1.4.1	Roofing Trusses	5	$ 32,000.00	4.25	$ 27,200.00	scope reduced by 15%
2.3.1.2	Columns Floor( 3 - 4)	5	$ 13,060.00	6.25	$ 16,325.00	scope increased by 25%
2.3.2.4	Slab-Beams Floor( 7 - 8)	4	$ 24,341.50	4.8	$ 29,209.80	scope increased by 20%
2.3.3.1	Stairway (Basement - Floor 2)	2	$ 11,991.50	1.7	$ 10,192.78	scope reduced by 15%
2.3.3.4	Stairway Floor( 7 - 8)	4	$ 11,991.50	5	$ 14,989.38	scope increased by 25%
2.5.1	Dry wall	45	$ 85,000.00	54	$ 102,000.00	scope increased by 20%
2.5.2.1	Interior doors	20	$ 12,460.00	17	$ 10,591.00	scope reduced by 15%
2.5.2.4	Tiles	90	$ 107,605.00	112.5	$ 134,506.25	scope increased by 25%

References

Eskerod, P., & Jepsen, A. L. (2016). Project stakeholder management. Routledge.

Fleming, Q. W., & Koppelman, J. M. (2016, December). Earned value project management. Project Management Institute.

Harrison, F., & Lock, D. (2017). Advanced project management: a structured approach. Routledge.

Heagney, J. (2016). Fundamentals of project management. Amacom.

Kerzner, H. (2017). Project management metrics, KPIs, and dashboards: a guide to measuring and monitoring project performance. John Wiley & Sons.

Kerzner, H. (2018). Project management best practices: Achieving global excellence. John Wiley & Sons.

Kerzner, H., & Kerzner, H. R. (2017). Project management: a systems approach to planning, scheduling, and controlling. John Wiley & Sons.

Lock, D. (2017). The essentials of project management. Routledge.

Marchewka, J. T. (2014). Information technology project management. John Wiley & Sons.

Martinelli, R. J., & Milosevic, D. Z. (2016). Project management toolbox: tools and techniques for the practicing project manager. John Wiley & Sons.

Mir, F. A., & Pinnington, A. H. (2014). Exploring the value of project management: linking project management performance and project success. International journal of project management, 32(2), 202-217.

Nicholas, J. M., & Steyn, H. (2017). Project management for engineering, business and technology. Routledge.