TGI - ERP Software Solution

Main Menu

Posts Tagged ‘Decision Support Systems’

ERP Systems: Effective Customer Credit and Collections Management to Ensure Strong Cash Flow – as Critical Now as Ever

Thursday, April 8th, 2010 by admin

I had a conversation with a wholesale distributor this morning with whom we’ve been talking for quite a while.  We first started some dialogue with them back in July 2009 about their initiative to evaluate and implement a new wholesale distribution software system.  We had gotten down to their short list and were scheduled to participate in a final on-site demo phase when they called to say they needed to put their project on hold due to other priorities and the economy.

During this morning’s conversation, I was told that during the recent economic slowdown they’ve had some combination of customers who have just stopped paying them to the tune of “several million dollars.”  As a result, they’ve decided they are not going to be in a position to reengage in their software evaluation efforts until at least the summer of 2011.

This story just reinforced how critical it is for all businesses, especially small to mid-market distribution and manufacturing companies, to engage in effective credit and cash flow management practices.  Companies using the Enterprise 21 system can establish a series of dashboards using the decision support functionality in the system to trend total open accounts receivable and past due accounts receivable over time.  This helps executives to spot potential issues before they become critical in nature.  Likewise, in another dashboard pane, management can review open accounts receivable by customer in total and across a series of aging buckets to see how its customers are performing relative to making their payments.  These functions allow for management personnel to take a quick view of accounts receivable overall and by customer to spot where additional interaction might be needed to keep things from spinning out of control.

From an operational perspective, Enterprise 21 also has effective credit and collections management functionality.  When a customer order is entered into Enterprise 21, the system immediately checks whether or not the customer has failed their credit check.  This is done by checking to see if the given customer’s total open orders plus outstanding receivables exceed their available credit limit and by checking to see if their accounts receivable aging has caused an exception based on specific parameters that are established on a customer-by-customer basis.  As an example, a customer could have a credit limit of $200,000, have total open orders plus outstanding receivables of $100 and could have just $1 aged into the over 60 days late aging bucket and have their next order placed on hold based on their specified credit parameters.

The same process of checking total open orders plus outstanding receivables is re-executed after the entry of each successive order line item as well.  So, the customer may not have been on credit hold at the start of the order entry process and may still have been fine through the first fifty line items of the order only to fail the credit check on the fifty-first line item.  Once an order goes on credit hold, an alert is sent to the appropriate credit manager to review the order and determine what needs to be done to be able to remove that order from credit hold.

From a collections management perspective, Enterprise 21 provides the functionality to monitor and manage the accounts receivable collections process.  Every night, the system evaluates outstanding receivables by customer to see what items have aged to past due plus a grace period (where you define what the grace period is, say 15 days), and the system automatically generates a series of collection calls to be made by the appropriate collections resource.  One can enter notes associated with the call and schedule a follow up collection call for that item based on the discussion with the customer’s accounts payable contact.  Should payment be received for that item prior to the next scheduled call, that item would automatically be removed from the collection call log so the person making the collection calls would not have to do so manually.

Through the combination of decision support dashboards to alert executives and management to trends in overall and late accounts receivable, visibility to overall accounts receivable in aggregate and by aging bucket by customer, and strong credit and collections management functionality, wholesale distributors and manufacturers using TGI’s Enterprise 21 ERP software have the tools necessary to manage customer credit and company cash flow effectively.

Enterprise 21 ERP Software with Integrated Business Intelligence Functionality Makes Decision Support Available to Executives, Management, and Individual Contributors

Wednesday, November 4th, 2009 by admin

There was a time when business intelligence solutions were reserved for very few business leaders.  Only those executives who really understood technology were willing to spend the money necessary to have a business intelligence system put in place that would take data out of their ERP software to populate a completely separate data warehouse for analytics purposes.

The time and cost to implement and make this functionality available made it cost prohibitive to nearly all small and mid-market businesses.  And for those few enterprises that were willing to invest in this technology, only a small core set of executives (read one to two players per company) would have access.

However, fully-integrated ERP software solutions, like TGI’s Enterprise 21, offer complete business intelligence functionality out of the box as part of the application’s core product offerings.  With Enterprise 21, each user can have his or her own unique series of dashboards.  Each dashboard tab can consist of up to four panes.  The data content and manner in which one views the data can vary from pane to pane.

Some users, for instance, may like to see raw data in a spreadsheet-like grid format.  Others may be more visual in nature and want to see the same data in a graphical format.  For those who want to view data in graphs, there are a variety of formats that one can choose from including line charts, bar charts, pie charts, area charts, and scatter charts.

In addition to displaying graphical and tabular data, Enterprise 21’s dashboards can also display gas gauges for rapid review of key performance indicators for the organization.  Maps can also be displayed including ones consisting of prospects and customers which are color coded based on odds or size of the given business enterprise.  Finally, for those users with security permissions to do so, financial reports which are produced from within Enterprise 21 can be displayed in dashboards.

One of the key advantages of the dashboards is that users can open the underlying data for analytical purposes.  In doing so, one can perform analytical drill down of data being shown across a series of dimensions.  For example, one might be looking at a graph of sales revenue over time.  This data can be sliced-and-diced across dimensions including drilling down by customer groups to as granular a level as a specific customer and product groups as deep as a specific product.  One might also want to review specific geographic regions or states, specific facilities, and specific sales regions, branches, and territories.  Through this simple description, it should be clear that application users can analyze core business data at any level of detail necessary to make well-informed business decisions.

In addition to sales-related data, all functional areas of the business can have their own series of dashboards including inventory management, warehouse management, customer service and sales order management, manufacturing, purchasing, and accounting, including financial reporting, accounts payable, and accounts receivable.  Furthermore, key external data such as new building starts and commodity market futures prices can be pulled into the system and trended for analysis purposes.

Because business intelligence functionality is built directly into the fully-integrated Enterprise 21 ERP software, TGI’s customers don’t need to invest in totally separate software solutions which it then has to implement and manage to gain these analytical capabilities;  rather, TGI customers can take advantage of complete business intelligence functionality as part of their investment in Enterprise 21.

Executive Dashboards: Analyzing Key Business Data for Decision-Making

Friday, June 19th, 2009 by Alex Smith

Executives at organizations of all sizes require key business data to make informed decisions for future business practices, focus, and growth. As part of Enterprise 21’s decision support system, executives can readily gain visibility to key data and make informed decisions that will affect the future of their organizations by leveraging the analytical power of their personalized executive dashboards. In my experience, most executives, at a high-level, are generally concerned with similar key performance indicators (KPI’s) for analysis and decision-making purposes. It is important to note that while dashboards are an excellent way to gain visibility to key data, they are not intended for executives to get “bogged down” in detailed data; executives’ time is best-spent analyzing data and making decisions at a much higher level.

One common, useful executive dashboard is a graph providing sales margin by product or product group. This dashboard allows the executive to see margin as a percent of sales for individual products or group of products in a visual manner. If a distribution company, for example, has dedicated significant sales and marketing efforts to a given product but that product has a significantly lower margin than another product, the organization can decide to direct more sales and marketing efforts to the product with a higher margin (this assumes that both products have relatively equal order volumes, as you would not necessarily want to dedicate significant sales and marketing efforts to a product with relatively low order volumes despite a high margin).

A second executive dashboard that is commonly used by manufacturing executives is one showing manufacturing output by product by facility. This dashboard allows manufacturing executives to analyze the facilities that have the highest production output for a given product compared to other facilities producing the same product (assuming equal resources are available across each facility). Comparing production output for a given product across multiple facilities allows the executive to gain insight into what facilities are operating more efficiently than others. This information can allow the executive to initiate potential business process improvements at the lower producing facility or reallocate resources across facilities in such a way that a given product is produced only at those facilities that produce the product with the most efficiency, leading to reduced costs and increased production output for all products and facilities.

A third executive dashboard that, while not used nearly as frequently as it should be, can lead to significant growth in profitability and customer service is a gross margin by customer dashboard. If I were to ask most manufacturers or distributors who their most valuable customer is, most would reply that the most valued customer is the customer who orders the most products with the highest frequency. While high order volume, high order frequency customers are certainly important, the executive should also carefully examine those customers who are providing the business with its largest sales margins. Focusing on the customers who are responsible for the organization’s largest sales margins is important because these customers deliver the most profitability at the least expense to the business. Ensuring that the products these customers order are always available in inventory and establishing these customers as “high priority” can lead to improved customer relations and increased profitability with minimal expense to the organization.

In sum, executives who leverage key business data dashboards are armed with the necessary information to make well-informed decisions for future business growth, output, and profitability.