be_ixf;ym_202404 d_19; ct_150

TGI - ERP Software Solution

Main Menu
ERP Insights
Request Online Demo

ERP Insights



TGI’s Stance On Software Development and Support Outsourcing

July 21st, 2009 by admin

A rising trend in the ERP software industry is the outsourcing of development and support services to third-party companies overseas. In the last two years, virtually every prospect I have spoken to during the selection process has inquired as to who is responsible for support services and, more importantly, where such support staff is located. There seems to be a common concern among business owners, senior management, and IT directors across the United States that should they ever require software support and/or assistance that they will be directed to somebody who is not a full-time employee of the software company and that this person will not be able to communicate an adequate diagnosis and solution with customer staff effectively. Read More…

ERP vendors’ justification for third-party development and support outsourcing is fairly simple – third-party outsourcing to other companies (and countries) can provide significant cost savings for software vendors. The cost to educate, train, and staff full-time software developers in the U.S. is significantly greater than for staff in many regions internationally. Average wages for software developers and support staff are substantially lower outside the United States, and by outsourcing to other companies, software vendors are able to eliminate costs such as employee benefits and retirement contributions.

While such development and support outsourcing is quickly becoming the rule rather than the exception in the ERP software industry, TGI believes that a key to providing effective, exceptional customer service lies in the quality and knowledge of the support staff the software vendor employs. TGI has remained committed to providing direct developer support for each of its clients; when calls are placed to TGI’s customer support line, calls are answered directly by TGI software developers with an average tenure of over ten years. We believe this philosophy provides our customers with an opportunity to interact with their software developer (TGI) in a truly unique way, which in turn leads to better business relations and lasting partnerships. This philosophy also places an added pressure (and opportunity) exclusively on TGI to routinely deliver effective solutions and responses to customer requirements. It is our job to respond to and meet these customer demands on a daily basis.

When selecting an ERP software solution and provider, software functionality is certainly of the utmost importance in the selection process; however, software selection teams should also conduct a thorough analysis of the software company and the support staff that will be charged with the task of meeting customer requirements on an on-going basis.


Improving Operational Efficiency and Pricing Accuracy through Commodity Market-based Pricing

July 17th, 2009 by admin

Within numerous food industries, including the cheese market, it is a common scenario for two businesses to agree to transact business together in a buy-sell relationship with the pricing set relative to a commodity market.  For example, a given company may import cheese from another entity and then cut and pack that cheese for their retail customer base.  The cut and pack business may elect to buy a given Swiss cheese at $0.10 per pound above the Block and Barrel weekly market average based on the date of manufacture while agreeing to sell their cut and packed finished product for $0.15 per pound above this same market based on the date of shipment. Read More…

There are varying methods by which the cut and packaging company may choose to manage its business relative to these pricing methods.  One method would be that personnel could manage the vendor and customer pricing records directly for the specific vendor and customer described above.

Alternatively, by using commodity market-based pricing functionality, one could establish the specific Block and Barrel weekly market average as the basis for pricing in this example.  Then, within vendor and customer pricing records respectively, one could establish that the given Swiss cheese supplier has agreed to sell the cheese to the cut and pack organization at an overage of $0.10 per pound based on the date of manufacture of the cheese.  Likewise, within customer pricing for the specific example above, a customer pricing record would be established for a given retail customer such that they would be billed an overage of $0.15 per pound relative to the given commodity market average based on date of shipment.

In either case, the system would establish a purchase order with the supplier and a customer order with the given retail customer respectively for the proper pricing based on these agreements; however, the method by which pricing updates would be made would vary by these two methods.  In the case where the exact pricing is set up for the vendor and customer respectively, each time the commodity market pricing would change, the specific vendor and customer pricing would need to be updated directly.  On the other hand, if the pricing records were managed relative to the given commodity market pricing, only the reference market-based pricing would need to be updated – either manually or electronically – and the associated vendor and customer pricing records which reference the given commodity market price would be updated automatically.

While this process may not appear to save any time when we’re talking about an example with only one vendor supplying one product and one customer buying one product, you can imagine how much more complex this can be when there are dozens of vendors supplying a wide variety of products which can be cut and packed to yield hundreds of finished goods for a multitude of customers.  In this case, by setting up the reference commodity markets and associated vendor and customer pricing records once and allowing the system to automatically calculate the appropriate contract pricing as the various commodity market prices move up and down, there can be tremendous gains in time efficiency by managing the pricing in this manner.  In addition, since the pricing is set up once with the movement of reference commodity markets kept in only one place in the system, the potential for errors in pricing of purchases and sales is likely to be substantially reduced.

By using strong ERP systems like TGI’s Enterprise 21, food-based businesses and organizations in other industries that leverage commodity market-based pricing as a norm can save time and money while reducing the possibility of errors through market-based pricing functionality on the procurement and customer sales sides of their businesses.


Use Your ERP Software Implementation to Clean Up Your Garbage Data

July 7th, 2009 by admin

A common concern many small business owners have when selecting a small business ERP software package is how they are going to be able to extract their existing data from their legacy software systems (QuickBooks, Excel, etc.) and transfer the data into their new ERP software solution. While migrating historical data into the new software package is important, the real question small business owners should ask is what historical data should be migrated over to the new ERP solution? Read More…

Within most small businesses, manufacturing and distribution operations use multiple software packages simultaneously, which leads to numerous instances in which data is duplicated, and, in many cases, inconsistent. Products are often times entered with one product description in one software package and a different product description in a second software package; the organization may also have a customer’s shipping address entered in one software package and the same customer’s billing address entered in a different software package. The software implementation process is an excellent opportunity for the organization to clean up its duplicated and inconsistent data and develop a single, cohesive data set for products, customers, ingredients and raw materials, suppliers, financial accounts, etc.

While the process of going through potentially hundreds or thousands of data records may be painful, it will prove to be highly beneficial to the small business during the initial system go-live and beyond. A sophisticated ERP software solution is only as good as its associated data. I recently spoke with one small business owner, and I believe his take on data migration was probably one of the most simplistic, yet most accurate statements I have heard when he said, “Garbage data in is just going to mean garbage data out.” This statement is just as true today as it has always been when using automated systems.

Establishing an accurate and consistent data set during software implementation is one of the first steps for the small business in realizing significant ROI for its software purchase and developing improved, efficient business operations.


Criteria for Selecting High Service Factor Items

July 3rd, 2009 by admin

Inventory management is a key element in any sophisticated distribution software or manufacturing software solution. In Enterprise 21, inventory levels can be maintained on a product-by-product basis using a variety of inventory control methodologies. These include a simple reorder point with minimum and maximum values, safety stock level (measured in days supply on hand), and service factor, with each methodology accounting for seasonal fluctuations in demand for a given product. Service factor, which is a number between 1 and 100, allows the organization to select a desired line item fill rate for a given product. An item with a service factor of 50, for example, means that for every 100 orders for that item, 50 orders will be able to be serviced directly out of available inventory. An item with a service factor of 95, however, means that for every 100 orders for that item, 95 orders will be able to be serviced directly out of available inventory. So, with this basic understanding of service factor, what criteria should the organization use in determining the products that should be set to have high service factors? Read More…

There are two key criteria for selecting products to have high service factors. First, items with a high order volume or high order frequency should be set to a high service factor. Items with a high order volume and high order frequency account for a significant portion of the organization’s business and revenue. Having the ability to fulfill orders for these items routinely out of available inventory will not only increase gross revenues, it will also lead to increased levels of customer service and satisfaction.

The second criteria for selecting items to have high service factors is high profit margin. Setting items that have a high profit margin to have a high service factor will result in increased bottom-line profits for the organization. Even if an item has a relatively low order volume or frequency, being able to fulfill orders for items with a high profit margin directly out of available inventory will decrease the likelihood of the customer shopping for the product elsewhere and increase the likelihood of repeat business from that customer.

For items with high order volume and frequency or high profit margin, using a service factor inventory management methodology can provide a powerful tool that can be leveraged to increase bottom line profits, improve customer service and satisfaction, and improve the likelihood of repeat business from a given customer.


The ERP Selection Process: Developing Your Initial List of Potential ERP Vendors

July 1st, 2009 by admin

Developing your initial list of potential ERP vendors is a critical step in the ERP selection process. Your initial list of potential ERP suppliers will serve as the basis for which suppliers you will send Request for Information (RFI) documents. Suppliers’ responses to the RFI will in turn help you to eliminate some ERP vendors and move forward with others to conduct initial remote software demonstrations. The vendors’ performance during these initial demonstrations will then help you to select which suppliers you will send a Request for Proposal (RFP), invite to conduct on-site scripted software demonstrations, and ultimately make a final supplier selection. In other words, your initial list of software suppliers should (hopefully) contain the supplier you will finally select as your software supplier. To help generate an initial long list of potential ERP companies (roughly 25 companies is usually a good start), there are a number of resources available to the software selection team. Read More…

Google – Google is a great place to search for potential ERP software vendors. For broad searches, use keywords such as “ERP software,” “ERP system,” and “ERP systems.” These search phrases will provide you with a large number of companies to consider. For manufacturers, “process manufacturing software,” or “discrete manufacturing software” are great phrases to search on when looking for potential software suppliers. You can also search on phrases that are more specific to your industry. Companies in the food and beverage industry, for example, can search for phrases such as “food ERP software,” or “beverage ERP software.” Pharmaceutical distributors can search on phrases such as “pharmaceutical distribution software.” You get the idea. Google is an incredibly powerful tool and provides highly-relevant information in its search results.

Industry Publications and Associations – Various industry publications and trade associations are also a great place to find potential software vendors. Members of the National Association of Manufacturers, for example, can check out the software section of the online NAM Buyer’s Guide. Cheese and dairy processers can look at Dairy Foods Magazine’s supplier guide or the Dairy Foods website, while organizations who specialize in plumbing wholesale distribution can frequently find potential software suppliers in The Wholesaler or at www.thewholesaler.com. No matter what your industry may be, your industry’s leading associations and publications are a great place to start looking for potential ERP vendors.

Independent Consultants
– Independent consultants are a great resource for not only developing a list of potential ERP vendors but providing assistance and guidance in other steps of the software selection process as well. If you decide to use a consultant throughout the selection process, be sure to select a consultant who truly is “independent” and does not have a partnership or financial agreement with any software provider. Selecting an independent and unbiased consultant will help you select the best ERP vendor for your business.

For more software selection resources from TGI, please see the “ERP Software Selection Process” within the “Resources” section on our website.  This area provides tools to assist in the software evaluation process, as well as an option for obtaining a list of ERP vendors based on your company’s industry, revenue, and manufacturing process where applicable.


SaaS as a Viable Solution for the Small Business

June 30th, 2009 by admin

When small businesses elect to implement an ERP software solution, they have a decision to make as it relates to hardware and operating platform. They can either purchase new hardware or move to a Software as Service (Saas) ERP platform in which businesses access their software application on the software vendor’s or a third-party service provider’s servers. The Software as a Service model, which has significantly grown in popularity over the last two years, can provide substantial cost savings to the small business. Read More…

First, by selecting a SaaS ERP solution, small businesses do not need to make a capital investment in the purchase of new servers. The cost of hardware and updates to the hardware is included in the service provider’s monthly fee. In addition, since the Software as Service model is essentially a lease on the hardware, businesses can take advantage of the ability to write off the cost of the service in full as a monthly business expense rather than to depreciate the new servers’ purchase as a capital investment.

Secondly, SaaS is a form of IT outsourcing, so small businesses that lack internal IT skills can enjoy the strong benefits of an ERP without bringing on new technical personnel. When one considers the cost of bringing on a new, full-time IT employee (i.e., salary, benefits, etc.), a Software as a Service solution can deliver thousands of dollars in cost savings each year.

Lastly, the Software as a Service model can provide small businesses with features that would otherwise not be possible if small businesses were to purchase and maintain their hardware themselves. Many Software as a Service providers have 24-hour backup mechanisms in place, so even in the event of a power outage at the service provider’s location, the small business can continue running with little to no impact on daily operations.

The Software as Service model can deliver significant time and cost savings to the small business. Any small business considering the purchase of an ERP solution should examine the many benefits of Software as a Service.


Leveraging Wholesale Distribution Software for Competitive Advantage – Delivering Value-Added Services

June 30th, 2009 by admin

Businesses across all industries strive to gain and sustain a competitive advantage in their respective marketplaces. And, this is certainly just as true for wholesale distributors. One of the ways in which wholesale distributors strive to gain a competitive advantage is to deliver value-added services in conjunction with the products they source for their customers. Strong wholesale distribution software must enable distributors to perform and record these activities just as they do purchasing, warehousing, picking, packing, shipping, and invoicing the products they distribute. Read More…

There are a variety of methods by which distributors strive to differentiate themselves to their customer base. Distributors may allow their customers to buy products as a kit, where by a series of items can be specified and ordered via one SKU or item number. Wholesale distribution software like TGI’s Enterprise 21 can enable distributors to sell both predefined kits to their customers and configurable kits where the customer can select those items which are included in the given kit being ordered. Distributors can elect to price these kits to their customers at the parent kit SKU level or by a combination of prices for those items making up the kit. The latter method is especially good for configurable kits. Furthermore, distributors may elect to perform kitting via simple picking operations or as a work order-based process when they desire to capture the costs associated with their kitting operations.

Another value-added service which distributors commonly perform is repacking. In this case, distributors may buy a given product in bulk quantities and repack it into smaller quantities for their customers to purchase. As was the case with kitting operations, some distributors will elect to capture the labor costs associated with these operations while others would not.

For wholesale distribution software that includes strong manufacturing functionality, distributors can perform assembly or light manufacturing operations. In these cases, the system’s traditional manufacturing bill of materials and routings (or bill of operations) can be used to define and execute the series of operations and associated components being consumed in assembly or manufacturing. As was true above with the kitting operations being performed via work orders, wholesale distributors can capture the associated costs of these operations. The actual material, labor, and overhead consumed at each point in the routing can be recorded with the associated costs rolled up across the various operations to produce an overall product cost in the system. Alternatively, the distributor may elect to record material, labor, and overhead at a standard rate of consumption via a simple backflushing method. Furthermore, distributors can elect to reflect product costs via their preferred costing methods including actual LIFO, actual FIFO, standard, or average.

In addition, distributors may have outside, third-party companies perform outsourced operations on their behalf. Strong wholesale distribution software will enable the distributors to source the components to be consumed for the outside processor, purchase and track the shipment of these components to the third-party, cut purchase orders for the performance of the outside operation’s services, receive the completed products back from the third-party, and pay the respective vendors for their products and services. Taking advantage of the manufacturing functionality within a strong wholesale distribution system, the material, labor, and overhead associated with the outside operations can be recorded just as it would be if the assembly or manufacturing were performed in-house by the distributor. These outside operations can also be daisy-chained in a manner that one third-party may receive certain components and perform specific operations, then ship the subassemblies to another third-party for secondary processing, and so forth, until the finished product is either delivered to the distributor or direct-shipped by the last third-party in the chain to the distributor’s customer.

Wholesale distributors may also elect to place consignment inventory at a customer location. In this case, the inventory is owned by the distributor until the customer consumes the given inventory. Strong wholesale distribution software will enable the distributors to place and manage the inventory at the customer location, receive the appropriate signal that the inventory has been consumed, trigger the appropriate customer invoice processing, and manage the level of consigned inventory based on the preferred replenishment methodology for that inventory at that customer location. Consignment inventory can also be used with third-party operations for managing component inventory until it is consumed in production runs.

Through leveraging strong wholesale distribution systems like TGI’s Enterprise 21, wholesale distributors can gain and maintain a strong competitive advantage in their industries by delivering value-added services to their customers.


Creating Certificates Of Analysis And Pedigree Documents For Process Manufacturing

June 26th, 2009 by admin

Safety and control – these are two words that are commonly heard when discussing key elements in today’s life sciences and food and beverage industries. Public and private sector entities alike are taking more action to make sure companies who do business in these industries are adhering to strong safety and control practices. Read More…

One of the ways in which businesses work to protect themselves and those with whom they do business is by receiving and making readily available certificates of analysis (commonly referred to as COA’s) from suppliers along with the ingredients they buy for use in manufacturing operations. COA’s are documents which provide a quantitative analysis across a series of properties for the associated item. For example, a COA for soya lecithin powder or ginger extract would generally include microbiology results for properties such as total plate count, E.coli, and salmonella levels, as well as a variety of other properties.

Life sciences and food and beverage companies will typically receive ingredients and automatically place them on quality hold upon receipt. Then, these businesses will alert quality control (QC) specialists that there are items that need to be inspected prior to their release for use.

The QC department will run a series of tests on samples of the given product received and verify that the properties on the COA match up with the properties of the product being tested. Assuming these tests pass muster, the product is then released for further consumption in a manufacturing process. Should the product not pass the QC tests, laboratory personnel will then run further tests while involving the supplier’s QC personnel to help evaluate potential issues with the ingredients before determining what to do next.

These same types of QC tests are performed on finished goods which are manufactured by life sciences and food and beverage companies prior to their release for shipment to their customer base. Again, a COA is created to accompany the specific lot of produced product to the manufacturing company’s customers.

Another document which is becoming more prevalent in the life sciences industry is a pedigree document. A pedigree document traces the complete chain of custody of the given end item from original manufacturer through various distributors until it finally reaches a retailer for sale. State governments such as Florida have a predefined prescription drug pedigree document which must be passed along the supply chain with each associated company adding its information and signing off on the document throughout the channel.

Strong business management systems like TGI’s Enterprise 21 ERP system can be used by life sciences and food and beverage companies to automate and maintain strong product safety and control procedures including the creation of certificates of analysis and drug pedigree documents.


The Specifics of Available and Capable to Promise Order Management for the Wholesale Distributor

June 23rd, 2009 by admin

A key functional element to any wholesale distribution software solution is order management. One’s ability to enter orders quickly and in an efficient manner can dramatically improve customer relations and service. As part of the order management process, a sophisticated distribution software solution should include both available-to-promise (ATP) and capable-to-promise (CTP) order management processes to ensure accurate commitment of shipment and delivery dates for customers at the time of order entry. Read More…

Available to promise means that when a customer places an order for a given item, the item is available in inventory (taking into account items that have already been allocated to previous orders). Available to promise functionality can go one step further to include a “commit to planned inventory” feature. This functionality is utilized when a sales order is placed for an item that is not currently in inventory, or is in inventory in insufficient quantity to satisfy the requirements of the customer. If there is already an existing open purchase order for that given item, the system can commit items on that purchase order to the existing open sales order based on the vendor’s delivery promise dates. Such a feature can dramatically improve anticipated shipping and delivery dates for the organization’s customers while simultaneously increasing inventory turns and lowering on-hand inventory levels.

In contrast to available to promise, capable to promise defines the ability of the organization to execute against a given customer requirement. For example, consider the situation when a customer places an order for a given item and the item is not in available inventory and there are no existing open purchase orders for the given item. In Enterprise 21, the system will alert the customer service representative in real-time that while the item is not in available inventory and that there are no open purchase orders for that item, the item is capable of being ordered, received into inventory, and shipped to the customer within a specific time frame based on the item’s lead time from a given supplier. While accounting for the item’s lead time, Enterprise 21 will immediately suggest an expected receipt date of the item into the warehouse, an expected ship date to the customer, and a final receipt date at the customer’s facility. In other words, at the time of order entry, the organization has the ability to identify its capability to fulfill the given customer order and provide an accurate shipping and delivery date for that order to the customer. Enterprise 21 can then generate a purchasing requirement and alert employees in the purchasing department that such a purchase requirement exists in the system. The purchasing manager can then analyze potential suppliers and look for discount opportunities from each supplier, submit requests for quotes to suppliers, generate purchase requisitions, and convert quotes into final purchases orders, all directly from within Enterprise 21.

By implementing available to promise, commit to planned inventory, and capable to promise functionality within the sales order management process, wholesale distributors can dramatically improve customer satisfaction, increase order and line item fill rates and inventory turns, and realize significant cost savings due to reduced inventory carrying costs.


Executive Dashboards: Analyzing Key Business Data for Decision-Making

June 19th, 2009 by admin

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. Read More…

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.