Project List:
Listed below are some of the more significant projects we have worked on recently and will give you an idea of what we can do for you.
Multiple Lease Calculation Tool - Sach & Co (Investment Bankers)
This tool enabled the client to maximise profit potential whilst meeting their clients criteria. Through VBA coding leases could be easily added or excluded from the portfolio at the click of a button. Profit & Loss and Cash Flow reports are instantly available by individual lease and portfolio level. All parameters such as interest rate, time period, payment period and holiday period are catered for. Involved the use of Excel financial functions such as FV, NPV IRR etc
Forecasting, Budgeting & Planning System - RAF Strike Command (Defence)
A comprehensive suite of workbooks that extract data from Oracle 11i into workbooks for over 50 departments. Data is entered into each individual workbook and then consolidated to give a top level result. At this level Balance Sheet, Profit & Loss, Cash Flow and Capital Expenditure reports are available in addition to numerous management reports pre-defined by the client. Approved data is then exported back to the financials database. The system allowed excellent management of a huge and diverse budget.
Output Costing System - RAF Strike Command (Defence)
Designed to take existing actual & budget data from Oracle 11i and manipulate that data through a matrix consisting of cost apportionment and cost allocation tables. The end result produced Profit & Loss reports by force (ie Tornado, Jaguar, Hercules etc) fully reconciled back to the financials database to ensure data integrity.
Management Information System - AEG Ltd (Leisure)
Excel based system drawing data from several of the clients 'in house' databases and Sage.
We have built several MIS similar to this and all of them require data to be automatically populated into the clients pre-defined reporting template which can be Excel or Word based. The benfits of such an approach is that the reporting pack always has the same look and feel and can be automatically updated when external or linked documents are changed. It is also quick and easy to operate and avoids all the cutting and pasting associated with manual collation. Excel versions include text boxes which automatically resize to accommodate the authors comments and ensures a professional finish.
