Effective Software Project Estimation: An Excel Based Approach

Effective Software Project Estimation: An Excel Based Approach

Gopinath SahaRachita Ghoshhajra 

CSE Department, MCKV Institute of Engineering, India

Corresponding Author Email: 
25 September 2017
29 September 2017
30 June 2017
| Citation



The most essential factor for completion of project is the accurate Software Project Estimation in term of Cost, Effort, Schedule and Resources. As the size and complexity of project increases, it becomes a challenge for project manager to accurately predict the cost and effort with achievable scheduling. Each and every stakeholder of concern program wants to find out accurate estimation. Software industry is changing in lightning speed, so it is extremely difficult to develop parametric models that yield high accuracy for software development in all domains. This paper provides an overall overview on available cost estimation technique along with excel based cost estimation method which is more inclined towards expert judgment. Authors have analyzed different cost estimation techniques and came to a conclusion that no available techniques singly provide correct measurement for cost & schedule and is best for all situations. Authors have done a comparative study of the results of several approaches which in terms provide an overall accurate estimate. This paper reviews the different estimation techniques and illustrates an Excel based cost estimation model.


PV – project value, TC – total cost, RC – resource cost, person man-day(PD), FP – fixed price.

1. Introduction
2. Reason for Requirement of Proper Estimation
3. Factors for Cost Consideration
4. Comparative study of cost estimation models
5. Cost Estimation through Excel Based Model: A Different Approach
6. Output of the Proposed Software
7. Conclusions

1. Software Engineering – A Practitioner’s Approach by Roger S. Pressman 5th Edition, McGraw-Hill International Edition

2. Software Requirements 3rd Edition by Karl. E. Wiegers, 

3. https://arxiv.org/ftp/arxiv/papers/1202/1202.2511.pdf

4. https://www.pmi.org/about/learn-about-pmi/what-is-project-management

5. Handbook for Software Cost Estimation, Jet Propulsion Laboratory Pasadena, California, 2003.

6. H. Yaman, Elçin Taş, A building cost estimation model based on functional elements, 2007, ITU A|Z, vol. 4, no. 1, pp. 73-87.

7. T. Rekha, P.K. Rai, Comparative study of software cost estimation techniques, 2016, Int. J. Adv. Res. Comp. Sc. Software Eng., vol. 6, no. 1.

8. M. Nadeem, M.R. Asim, M.R.J. Qureshi, A step forward to component-based software cost estimation in object-oriented environment, 2010, Pak J. of Sc., vol. 62, no. 4.

9. http://www.careerride.com/pmp-disadvantages-cocomo-estimating-model.aspx.