// Business Case Evaluation Solution

Client:  Global aerospace manufacturer / defense contractor
Users:  Engineers, financial analysts, program managers

Project evaluation-investment analysis system based in Excel with data storage via ADO and Access:

  • Tracks a gated project management process with separate workflows for the user and the administrator.
  • Facilitates the capital budgeting process for the maintenance operations of a large jet engine fleet.
  • Features project-level and dataset-level objects for chronological data capture and historical audit views.
  • Accepts user input through an extensive MSForms UI and runs a detailed cash flow / NPV model to compute a score for each project.
  • Supports decision-making with a global ranking function and division-level reporting.