March 11th Jurys Inn, MXI present the QUANTRIX Modeller which is ideal for use in Banking and Financial Sector as a Modelling tool for pricing and evaulating risk, Capital Planning, Cash Flow Modelling and budgeting forecasting. Financial Regulators around the world insisting that spreadsheets need to be "Managed down" and QUANTRIX fits the bill.
Registration for Jurys Inn IFSC Dublin 1 March 11th
Modelling Presentation.
Financial Modelling & Budgeting software and tools include planning, budgeting and forecasting software which help organisations manage their financial and business planning cycle.
They also use the modelling software to augment financial reporting to meet government and industry regulations. MXI Modelling tools makes business opportunities cheaper, quicker and more profitable to harvest.
In the Banking and Financial environment new modelling tools will underpin a whole new strategy for pricing risk, capital and investment management and planning. Regulators point to the need to improve the spreadsheet culture.
In the 1990s, competent financial planning, modelling tools were expensive and complex for companies with less than 1,000 employees struggling to justify the investment.Our planning tools can deliver a million dollar impact for low - mid five figures.
Many still use rudimentary technology worksheets and email for such a complex and important job as financial budgeting and planning, while inexpensive, has a number of downsides.
The capacity and costs of systems like QUANTRIX Modeller and DATANAV from MXI Software in Dublin. Fast answers are needed to adjust planning assumptions and to test "what if" scenarios as conditions change. Money and Markets move in minutes long term customer loyalty lost in minutes as well.
Finance, Planning, Sales departments and Management, need to know immediately how a tweek here or there moves Profits, Cash Flow, Margins, cost. Surely the single dimension flat file worksheet is not the right tool for enterprise capable financial modelling. Really not much of an improvement on the manual system of the 1960's.
Stories are legend of problems with flat file worksheets. Business Intelligence Cash flow planning financial modelling with integrated financial planning enables users to easily add new metrics, tweak existing ones, and react to changing market conditions.
A cross departmental low cost financial planning and integrated modelling tool using the same formats for financials and makes collaboration and communication between the finance department and the rest of the company simpler.
Financial Modelling, integrated planning software markets is growing because finance, sales departments needs financial budgeting and planning data in real time and meet the "what if" and reporting needs of other users / departments.
Most importantly, the costs and skilled personnel requirements for Finance departments are greatly reduced. Time to end of month completion is faster, budgeting and forecasting cycles times reduced. Accuracy is greatly improved and new business opportunities cheaper, quicker and easier to harvest.
As Belfast Ken Graham an independent IT and Planning consultant says "it's faster to put the stuff together and faster to redo it," he said. "It gives your budgeting and planning process real agility."
MXI Training Course Schedule for 2010.
2 days MXI office based Crystal Training Course
March 9th & 10th 2010 (Special offer E595 per attendee)
May 11th & 12th (695 per attendee)
Venue - MXI Offices Bray, Co Wicklow.
CRYSTAL REPORTS Training
You will learn How To
Develop reports using Crystal Reports to transform data into a useful management resource
Programme Calculations and logic with the Formula Workshop
Connect to data sources natively, via ODBC and OLE DB
Examine database structures and extract data required to meet your reporting needs
Deploy reports via HTML to a Web browser or desktop application via Visual Basic and .NET
Course Benefits
Crystal Reports users and developers can integrate their organization's data, making sophisticated reports readily available to support critical business decisions. In this hands-on course, you gain extensive experience using Crystal Reports to connect to databases, retrieve raw data, format data, and create and present reports for widespread distribution. You return to your organization with a detailed process to help you connect to data sources and create useful reports right away.
Who Should Attend
Anyone involved in creating reports from stored data. Windows and Spreadsheets experience will be helpful.
Hands-On Training
You gain hands-on experience using Crystal Reports. Exercises include:
Building reports from the ground up
Connecting to data sources natively, via OLE DB and ODBC
Designing a crosstab and drill-down report
Developing a summary report with drill-down capabilities
Simplifying information using charts and graphs
Adding business logic to your report with the formula language
Deploying your report to a Web server for Internet/intranet distribution
Integrating reports with Visual Basic
MXI Crystal Reports Content
Crystal Reports Overview
Format and summarise data
Group, Filter and sorting data
Develop reports with business logic
Connecting to SQL Server and Access databases
Presentation charts and sub-reports to a report
MXI Crystal Report Writer
Writing a basic report
Selecting formats
Add text and fields
Connect to remote data sources
Configuring the reports
Formatting and styling
Tailoring sections within a report
Annotating header and footers
Adding color, borders and pictures
Highlighting data with Highlighter Expert
Linking Crystal Reports to Data
Connecting to popular data sources
SQL Server
Access
XML
MXI exhibit Forecast PRO in London on Feb 1 & 2 in Heathrow Raddison hotel.
See all the benefits of Sales, Operations Planning. Use the detail and hidden intelligence from your existing data to plan for the future more accurately. Histoircal Time Series data contains a lot of information which can be used to your organisations benefit
WHY Attend
Move S&OP to Next Level: For S&OP Veterans
Forecasting heavily Promoted Goods
Revitalizing & Getting S&OP Started from Scratch
Forecasting & Planning with POS, Syndicated Data
Latest Product Forecasting & Planning: Issues, Experience, and Success
LEGO - Sr. Director of Global S&OP speaks about conference.
Fighting Back: How S&OP is Building Success for LEGO - Ole Fruekilde Madsen,
Senior Director of Global S&OP
http://bit.ly/8psVbn
Click here for more details
MXI Software announce the latest version of Manufacturing & Distribution Software for Small to Medium sized business. Technically referred to as MR26, this newest version boasts a new Quotation Module & a clean WEB 2.0 style interface for ease of use.
EFACS is used by nearly 50 companies North and South. The continued clear development path for EFACS Manufacturing software is welcomed by Eamon Irwin, Director in SMART Electonics. "We use EFACS very happily to drive efficiency, win sales and keep costs down"
The new Quotation modules takes the software further into the bespoke manufacturing marketplace. Allowing "one off" manufacturers to design and specifically quote "once off" jobs for customers. Mark Richardson Technical practice lead at MXI Software comments " This nicely extends the product feature set to support mixed mode manufacturers as they scramble to meet market conditions."
The new look software looks great reducing the time taken to effectively deploy the integrated Java based Manufacturing and Distribution application for all users. It is moving towards the common interface for all computer applications with larger graphical icons, clear concise screen styles.
We sell the market leading desktop SKU Forecasting Tool in Britain and Ireland. There are 3 versions of the product. 20,000 users world-wide including Toyota, Coca Cola, Amazon. MXI customers for Forecast PRO include Johnson & Johnson, Siemens Medical, Gowan Group, Irish Airports Authority (Aer RIANTA)
- Forecast PRO XE for 300 sku or less,
- Forecast Pro Unlimited to collaborate with colleagues handling 1000's of SKU.
- Forecast Pro TRAC. TRAC brings Forecast PRO into the realms of Sales and Operations level planning.
TIPS 1. Excel for forecasting.
Tempting, most people have Excel and a time series sheet of data that needs forecasting. However the Trend line feature in Excel is the least effective over 20 techniques for forecasting because of value it applies to older time series data ignoring the more valuable trending in recent data. Not ideal for managing the recession in consumer spending. Better to spend a little and use a proper exponential smoother.
2. Try Exponential Trending
Exponential smoothing recognises the value trend, extracts the surrounding noise in data can apply seasonality, trend and special events. Statistical results show exponential method to be one of the most reliable means of forecasting. Exponential smoother is also known to perform reasonably where there is limited historical data available.
3. Even Forecast/PRO Software can't deliver immediate results.
It takes time, trial and error is the best way forward in terms of planning. Once implemented take the time to learn your data and get to know the results. Be prepared to challenge the results. Consider separating data into 80 / 20 paretto analysis. Splitting some data into product/family (aggregating) levels and some at the SKU level can be effective.
4. Don't Automate too much.
Data needs checking all the time to improve relevancy. Even processes that are comfortably bedded need validation. Best practice and Industry leading performance can only be enhanced through regular monitoring.
Graham Mulhern, MXI, and Government Minister Billy Kelleher.
MXI Computing Ltd Director Graham Mulhern travelled as part of an EU trade delegation to China. "We were particularly keen to see what out-sourcing activity could be sourced and develop a Chinese platform for the MXI Computing forecasting, budgeting and ERP technologies."
Our Chinese hosts were particularly gracious and showed us every courtesy celebrating the Western Economic Conference and Exhibition. The Irish Ambassador and senior Government officials attended both European Union and Western Chinese Exhibitions hosted in the Chengdu Exhibition & Conference Centre.
The delegation met with Irish Government Minister Billy Kelleher from the Department of Trade Enterprise and Employment, Irish Ambassador to China and various officials from the Chinese and Irish Governments.
The delegation was the guest of the Mayor of Chengdu, Sichuan Province. The City is developing the region economically with a special focus on High Technology and IT practice. There is an excellent IT infastructure in Chengdu with many of the senior executives having returned from the US in recent years to spearhead IT Industry growth in China.
MXI will be liasing with out-source partners to develop some IT projects and introduce MXI core forecasting, budgeting and Manufacturing technologies in China.
Wang Tao, Vice Minister, Wisesoft & Graham Mulhern, MXI.
MXI DataNAV is the BI extension to the business modeling and analytics solution, Quantrix Modeler. It represents a substantial advancement for Data Navigation, Analysis, and realisation (DataNAV), allowing both business and IT professionals to easily query data sources to develop ad hoc, exploratory, as well as structured analyses. Organisations will see a greater return from existing data assets including MS SQL Server, Oracle, IBM DB2, Sybase, Vertica, MySQL, PostgreSQL, MS Access, MS Excel, Text Files, and more. The Data NAV analytical power has superior performance for querying, filtering, and aggregating data from very large databases, including those in excess of one billion rows. Dynamic, multi-dimensional comparisons and contrasting of multiple charts for enhanced visual analysis. DataNAV and Quantrix Modeler solution is an easily deployed alternative to the widespread yet highly problematic practice of pairing spreadsheets with BI tools for corporate business analysis and planning.
Quantrix DataNAV delivers benefits to both business and IT professionals:
Mark Richardson, MXI Technical Practice Lead, comments "We know that larger organisations need to connect to the existing data on the Servers. It's is big leap forward in our Budgeting and Planning offering to Customers"
20 minute DATANAV Presentation
Connecting the power of Business Intelligence to the budget plannning, Cashflow Modelling for the 2010 budgeting, planning and forecasting process reduces cost whilst improving Revenue, Margin, Cost performance. Better planning identifies profit opportunities earlier driving growth. This conncentrated approach allow management to reduce the organisational cost base.
Aer Rianta International (Irish Airports Authority) and SIEMENS have selected Demand Management solutions from MXI in recent months. Both organisations plan to grasp the challenge of forecasting customers demand Sales and Operations directly.
Freeing up Cash deployed in a business mounts a very major challenge for most organisations currently. MXI Forecast PRO forecasting technology gives the user vital extra level of intelligence when it comes to to Demand planning.
Siemens deployed Forecast PRO in their Medical Diagnostics business for Sales and Operations Planning in Manufacturing. ARI are using Forecast PRO more specifically to manage the very difficult condition pertaining to manage Airport Retailing, Promotions, Pricing and Merchantising.
Mark Richardson, Technical Practice Lead, MXI comments, "Forecastors, Logistics and Supply Chain Managers constantly struggle to intepret their data attempting to extropolate demand patterns, Forecast PRO hooks up to the data and does the forecasting piece with the attendent explanation brilliantly using its award winning forecasting technology".
"Our users are then free to manage their business, referring this new level of demand insight to Suppliers providing solid projections and numbers to them improving their Supply Chain. Internally Customer Service, Sales and Finance are much happier owing to higher level of accuracy."
Another spreadsheet bites the dust!!
MXI Forecast Pro TRAC is the perfect solution for a broad range of business forecasting needs including demand forecasting, team forecasting or forecasting and reporting in support of your organization’s S&OP process.
Businesses in the UK and Ireland particulary in retail and large scale distribution are challenged to manage cash and stock levels simultaneously against reduced demand and lack of credit. MXI Consulting has implemented demand management technology successfully in many organisations to meet this problem head-on.
Proven Track Record for Sales and Operations Forecasting.
TRAC is built on the Forecast Pro Unlimited and combines all of the forecasting, graphing, reporting and adjustment capabilities found in Forecast Pro analytic tools you need to execute a complete sector leading forecasting process.
TRAC new features :-
- Multiple Units of Measure
- "Shuffling" (on-the-fly hierarchy changes)
- Exception Reporting
- Accuracy Tracking
- Team Forecasting
Flexible forecasts viewing.
MXI TRAC allows you to view your data and forecasts in any units of measure you need. Drop-down menu switches among units of measure that are important to your business-such as Euros, units sold or pallets.
Rearrange your hierarchies.
With Forecast Pro TRAC's powerful "shuffling" capability, you can rearrange hierarchies on the fly with just a couple of clicks. Need to generate a report showing product-level forecasts broken out by customer and then create another report showing customer-level forecasts broken out by product? No problem!
Strenghen impact of your planning immediately.
Exception reporting automatically flags problem projections, items, article numbers, SKUs. The reports are flexible to reflect different performance metrics-such as forecast vs. history or whether a current forecast falls outside a pre-defined range-and give you a quick way to identify potential problem areas.