AI-Driven Budget Estimation in End-User Software Engineering: An Excel-Python Approach
- 1 Software Engineering Department, Faculty of Graduate Studies for Statistical Research, Cairo University, Cairo, Egypt
- 2 Software Engineering Department, Faculty of Graduate Studies for Statistical Research, Cairo University, Cairo, Egypt
Abstract
Artificial Intelligence (AI) is rapidly transforming the landscape of project management by enhancing the accuracy, efficiency, and responsiveness of key operations such as budget estimation, resource allocation, and scheduling. This research introduces an AI-driven model that leverages machine learning techniques within an integrated Excel-Python framework to predict software project budgets. Utilizing historical data from completed projects, the model delivers precise cost estimations, enabling project managers to plan effectively and allocate resources efficiently. In contrast to traditional estimation approaches, this method supports real-time decision-making, predictive analysis, and dynamic adjustments throughout the project lifecycle. The approach incorporates AI techniques such as linear regression, genetic algorithms, and neural networks to optimize budget forecasting and personnel distribution. Designed to be accessible to end users with minimal technical expertise, the model provides a practical, data-driven tool that enhances the operational and financial performance of software development initiatives. This work not only extends prior research on AI-enabled resource management but also contributes a user-friendly solution for the modern demands of intelligent project planning.
- Dahanayake, N. and Sol, J. (2018) AI-Assisted Resource Allocation in Project Management. Journal of Artificial Intelligence Research , 63, 34-56.
- McKinney, A. (2019) Artificial Intelligence Enabled Project Management: Predictive Analytics and Decision-Making. International Journal of Project Management , 36, 512-526.
- Khan, M. (2020) AI-Assisted Resource Allocation for Improved Business Efficiency and Profitability. Business and Information Systems Engineering , 61, 517-532.
- Verbraeck, A., Wainer, G.L. and Bisset, K.G. (2019) Integrating Data Analytics into Project Management Software. Simulation Modelling Practice and Theory , 93, 234-248.
- Chou, J.S., Pham, C.C. and Wang, D.D. (2017) Predicting Project Costs with Artificial Neural Networks: Construction Application. Automation in Construction , 78, 426-436.
- Mansour, M.F. (2024) A Seamless Framework for Excel-Python-Django Integration: Empowering End-User Applications. International Journal of Advanced Computer Science and Applications , 15, 112-122.
- Mitchell, T. (1997) Machine Learning. McGraw-Hill Education.
- Goodfellow, I., Bengio, Y. and Courville, A. (2016) Deep Learning. MIT Press.
- Haykin, S. (2009) Neural Networks and Learning Machines. 3rd Edition, Pearson.
- Jurafsky, D. and Martin, J.H. (2008) Speech and Language Processing. 2nd Edition, Prentice Hall.
- Zadeh, L.A. (1965) Fuzzy Sets. Information and Control , 8, 338-353. https://doi.org/10.1016/s0019-9958(65)90241-x
- Dorigo, M. and Stützle, T. (2004) Ant Colony Optimization. The MIT Press. https://doi.org/10.7551/mitpress/1290.001.0001
- Project Management Institute (PMI) (2021) The Project Economy and PMTQ: How the Technology Quotient Is Driving Success. PMI Report.
- Project Management Institute (PMI) (2021) A Guide to the Project Management Body of Knowledge (PMBOK® Guide)—Seventh Edition. PMI.