Reasoning has been provided for choosing the technologies that are used to develop the system. As future enhancement is possible, the report aims to list out the activities and features that could be enhanced for future innovation and functionalities.
The primacy of all the requirements was given to the user interface that is provided through the Excel software. Then the business related functionalities such as forecasting, detailed analysis of data, Net Present Value calculation, scenario creations with ratio based investment on two businesses were required. These requirements were analyzed, prioritized and possible set of functionalities were listed. All these requirements led to the view that system needs to be built on a step by step basis as each of these requirements are interdependent on one another. The software model that has been followed is the Prototyping model. It is an exact choice of model to follow due to this requirement structure. (HeathCote 2000)
The possible risk factors are those which could arise if the requirements were not followed properly. As per the deadline issues, obviously the risk are always eminent as any spot of misunderstanding would draw a picture of missing the deadlines. Since a top down approach is followed with this project, the disadvantages of it have to be nullified. Another risk would arise if proper user test plan and user test evaluation is not done. This would ultimately lead to a catastrophe, since it is the only way to find out response from one end to the other. Based on all the identifications, the complexity of compounded requirements was individualized and appropriate modularity was brought into the functionalities of the system. (HeathCote 2000)
The user flexibility can be given only with a better user interface design, as it is the principle requirement of the system. The integration of different functionalities is directly attributed to how well the design is created. The importance of the user interface design is that the system cannot let the user to search for what next is to be done to achieve their required goal. Appropriate directions have to be given for any particular action that the user could do. For example, if you click on forecasting, the user must get to know how to get back to the main screen to test the other functionalities. If it is not given, then the user is left at sea, all alone (HeathCote 2000)
Once the design was completed, the implementation was done through Microsoft Excel software using Microsoft Excel VBA. Also, the pre defined macros that were present in the software helped in performing calculations in an easy way. The user interface design was implemented through forms and control buttons. Several other techniques were also used to implement the design components. For e.g. Calculation of Net Present Value can be calculated with the pre defined formulas that were present in the software.
The user test plan was designed and appropriate test cases were developed for each of the functionalities and user actions. The test cases were designed in such a way to test the compliance of the system to the requirements that were asked from it. Several other kinds of testing such as the regression testing, load