BRINGING MICROSOFT APPLICATIONS TOGETHER

This MS-Excel model is used to demonstrate the ability to read and write data from an MS-Access database for both risk management and project cost reporting and the ability to produce a report which opens a target Microsoft Project file, sets the specified date range for the project Gantt Chart and then copies that image to a consolidated report within Microsoft Excel.

FINANCIAL MODELLING

RK Consultancy Services ('RKCS')has extensive experience with financial models that evaluate Government and commercial enterprise proposals over the life of the project, with a variety of outputs including: real and current value cashflows projections, NPV, IRR, BCR and other financial performance measurements, a variety of financial charts, profit statements, balance sheets and other reports as required.  These models can be as complex or as simple as desired for each requirement.

KPI DASHBOARDS

This MS-Excel based model demonstrates the ability to automate the collection of data from disparate legacy systems and present the data collaboratively in a single dashboard style report set for analysis.

INTERFACING MS-EXCEL WITH PDF DOCUMENTS

This model demonstrates the use of advanced functions to programmatically interface with PDF files. In this example a library of PDF's are stored on a central network directory.

The MS-Excel model allows the user to navigate to a particular item within the workbook and then request the model to find a relevant PDF document from the library and open that document at a particular key index.

BUDGET & FORECAST MODELLING WITH DATABASE INTEGRATION

This advanced MS-Excel model demonstrates the ability to combine extracted historical income and expenditure data from an SAP business system, with predictive capabilities to produce budget and forecast outcomes for an enterprise-wide planning process, across multiple business units, market segments and associated cost/profit centres.

Data from the business system is re-loaded into databases, together with master-data & configuration data. Based on a variety of selection criteria, data is extracted from the database and loaded into workbooks created on the fly, VBA code modules are compiled and loaded into the external workbooks, which are then compressed and automatically attached to an e-mail and distributed to assigned recipients (budget owners).

The full cycle workflow modelling facilitates functions to assist the budget owner with creating calendarised budgets and forecast predictions, which can then be returned to a central repository for collection, processing and reporting. The verified data is then uploaded into the business system using business to business file transfer methods

KEY EXPENSE TREND ANALYSIS

This MS-Excel based model demonstrates the ability to automate the extraction of data from a business intelligence system (in this case BW attached to SAP) and extract key expense data over a given timeframe.

The charting capability is dynamic; updating x and y axis information based on multiple drop-down selection box options.

This model is further enhanced with a custom floating toolbar, e-mail functionality and ability to paste images to Microsoft Power-point presentations.

This particular model is further enhanced using a separate scheduling tool to automate the calling of functions within the VBA code modules and sending complete reports to a Microsoft Sharepoint based intranet web site.

AP RECONCILIATION MODEL

Microsoft Excel can be a very powerful tool that can be utilised to compare data from your business systems, data warehouse sources and customer data to facilitate a reconciliation tool.

In this example, national data from a large service provider is compared to general ledger accruals at a transactional level and variances outside a given tolerance are investigated.

State base reports are distributed to recipients automatically by e-mail. Once major variances are resolved, the model permits payment to the provider and an upload to the SAP business system and automated clearing.

AR REVERSE BILLING RECONCILIATION MODEL

Microsoft Excel can be a very powerful tool that can be utilised to compare data from your business systems, data warehouse sources and customer data to facilitate a reconciliation tool.

In this example, customer payment data is compared to your business systems sales data at a transactional level and variances outside a given tolerance are investigated.

State base reports are distributed to operations recipients and/or business managers to resolve rating and or service disputes automatically by e-mail for review.

FLEET PLANNING MODEL

This model was designed to facilitate planning of fleet movements for common fleet across multiple states and/or territories.

Database integration over a wide-area network and use of a simple user-friendly MS-Excel front end enables users to co-ordinate fleet movements, while allowing central control and monitoring to occur and minimising the need for spread-sheeting expertise, due to inbuilt functions, visual cues, data validation and automation.

BUSINESS SYSTEMS INTEGRATION

This MS-Excel based model demonstrates the receipt of customer payment files which have transactional detail for reverse billing trading relationships.  The customer data files can be in a variety of formats which are interpreted, converted and output to a text format for upload into SAP accounts receivable.

This type of business to business data integration can be achieved by using Microsoft Excel for almost any business systems integration requirements.

TECHNICAL WRITING - SYSTEM REQUIREMENTS SPECIFICATIONS

RKCS offers significant expertise in conducting business process reviews and creating technical documents, such as functional user requirements specifications.

Our project team can lead new systems development initiatives which begin with documenting current processes, discovery of user requirements, offering valuable advice given our experience across many industries, and preparation of necessary documents which outline system design requirements.

KPI REPORTING

The adjacent image demonstrates our ability to custom design key performance indicator (KPI) reporting dashboards and on-demand drill-down reports using a variety of business intelligence (BI) tools.

This particular example was developed using Business Warehouse (BW), which extracted data from an SAP business system.

Multiple report templates were constructed to target a variety of management levels within the organisation from a dashboard style high-level report to more detailed operational reports.

DATABASE DEVELOPMENTS

RKCS can custom design database applications to your requirements.

This MS-Access database was designed to offer the customer the ability to forecast sales revenues and gross margin; provides a wide range of reporting options and is capable of providing an output file in a format ready to process in the customer's business system.

ISSUES REGISTERS

A series of MS-Excel based models have been designed to provide a user friendly form for users to inputs project issues.

The model interfaces with an external database which can be deployed over local and wide-area networks and facilitates distribution functionality to request and update issue changes from project managers and external parties.

Files returned to the model administrator can simply update the central database with the click of a button, with issue history being recorded seamlessly. A wide variety of reporting and filtering options are available with the inbuilt custom menu.

RISK REGISTERS

A series of risk management registers have been developed using user friendly and feature rich Microsoft Excel, featuring interfaces with Crystal Ball © risk simulation application, which runs Monte Carlo analysis for a series of independent and inter-related project risks to provide the project manager total cost and schedule impacts based on user selectable probability and certainty levels.

These models are fully automated and offer a variety of on-screen user forms, reporting options and ability to report history for updated risks.  Models can be designed to perform variance analysis between pre and post mitigation scenarios.

A more advanced series of these models can be adapted to store and retrieve historical records via external databases (eg: MS-SQL, MS-Access) in a networked environment.

INTERFACING MS-EXCEL WITH SAP & OTHER BUSINESS SYSTEMS

This Microsoft Excel based model provided users over a wide-area network the ability to record expense accruals using an on-board custom form. Multiple data records are stored in the spreadsheet until the user clicks on the 'Output to SAP' button, at which time the data is output to an external text file and sent to the business system for upload/import. The files can be sent via ftp, e-mail or other transport methods as preferred. In this example, purchase orders are created and the order lines created are auto receipted.

If the ERP system is capable of running transaction events, then this model can include options to trigger those business system events, which further automates the upload process

This example highlights one of many system integration capabilities that can be achieved using MS-Excel to collect data.