be_ixf;ym_202412 d_27; ct_150

TGI - ERP Software Solution

Main Menu
ERP Insights
Request Online Demo

ERP Insights



ERP Implementation Critical Success Factor: The Pace of the Game Can Dictate the Odds of Success

June 8th, 2010 by admin

For those of you who are NFL sports fans, you’ve likely noticed there are some NFL teams whose offenses produce better when they play in hurry-up mode – the way in which all teams play toward the end of the game when they’re behind and need to score rapidly.  The current day Indianapolis Colts strike me as this kind of team.  With Peyton Manning calling the plays from the line of scrimmage, the Colts’ players stay focused and execute in a highly-efficient manner. Read More…

Let’s contrast this to the slow, methodical, grind-it-out NFL offenses that take long periods of time and numbers of downs to get to the end zone.  Sure, there are successful scoring drives that can take twelve to fifteen plays to completion; however, the more times a team has to snap the ball and run a play the more opportunities there are for issues to sneak in that stall or end the drive – a penalty, a turnover, or even one dropped pass or missed block can result in an unsuccessful drive.

From my perspective, ERP implementation and NFL offenses have a lot in common.  They both require a variety of players with varying skill sets and experience levels to play their respective positions for a successful outcome.  In the NFL, all of the players know their roles, and there is a sense of urgency to accomplish tasks in an expedient, highly-efficient manner, and measurable progress occurs.  The same should be the case to ensure successful ERP implementations.

Players should be educated on what their roles are and how what they do fits into the overall plans for the ERP implementation.  And, while I completely understand that personnel’s day-to-day responsibilities can get in the way of having sufficient time to devote to the implementation project, my recommendation is that by running the ERP implementation like a two-minute offense, key personnel will feel the sense of urgency to execute in a highly-efficient manner thus producing a successful outcome.  To contrast this, if there is an expectation that a project can take as long as people want or has sufficient slack time in the project plan, there is a lack of urgency that keeps most personnel from prioritizing the time to accomplish what is necessary to produce a successful result with the implementation.


Demand Forecasting within Enterprise 21 ERP: A Key Input for Successful Wholesale Distribution Inventory Management

June 1st, 2010 by admin

When small and mid-market distribution companies start considering that it might be time to evaluate and replace their existing wholesale distribution software systems, they’ll typically calculate a potential return on investment they strive to achieve.  From my experience, the one area of tangible benefits that will dwarf all others comes from an overall reduction in inventory investment and associated carrying costs.  Generally distributors can pay for the entire new distribution software system and associated ERP implementation costs based solely on the reduction in inventory.  Strong ERP systems like TGI’s Enterprise 21 provide the information and processes to enable wholesale distributors to improve overall inventory management. Read More…

There are numerous information requirements when it comes to performing time-phased inventory requirements planning (distribution requirements planning, or DRP), including customer demand, inventory statuses, inventory management business rules, and procurement and supply chain management business rules (and production-related data and business rules for manufacturers).  The area of focus for this article is on forecasting – specification of one’s best volume estimates as to the total requirements for finished goods to satisfy customer demand.

Within Enterprise 21, forecasts can be created externally and then imported into the system or can be generated within the system based on historical sales data.  A forecast can be defined as granularly as for a specific product, customer, servicing facility (i.e., warehouse or cost center), ship-to geography, and sales person; or it can be at some higher level of aggregation (i.e., all customers receiving a given product from a specified facility, etc.).

When using the system to generate a forecast, one can specify the number of periods to forecast, whether or not to apply seasonality to the forecast, one or more facilities, products, vendors, and buyers, and a range of dates to use for historical sales demand purposes.  When the forecast generation process is run, Enterprise 21 analyzes the historical sales demand data and a series of algorithms to determine the best fit formula on a product-by-product basis.  Forecast generation can be done separately for subsets of the product mix and then an overall forecast can be created by overlaying these separate sub-forecasts.

Once the system completes the forecast generation process, one can view a graph of historical and forecasted data and the associated best-fit algorithm (i.e., line, curve).  Also, the forecast can be reviewed and adjusted manually as desired.

It is common for distributors to work with a series of forecasts such as ones that depict worst-case, best-case, and most likely-case scenarios respectively.  A forecast can be used as one of the key inputs to a time-phased inventory requirements planning process for the generation of a series of purchase requisitions for the procurement of finished goods in the case of wholesale distributors (and components and/or ingredients to support production plus a tentative production schedule which ultimately becomes the master production schedule for manufacturers).

By using Enterprise 21’s fully-integrated planning process, wholesale distributors can generate forecasts which are an essential input to the time-phased planning process which becomes a key enabler to reducing and optimizing the distributor’s overall inventory position.  Please click here to see a high-level overview demo of Enterprise 21’s forecasting and planning processes from within TGI’s Resources Library.


Visit TGI at the IDDBA 2010 Show and Expo – June 6-8, 2010 in Houston, Texas

May 3rd, 2010 by admin

We are very excited to be exhibiting at the International Dairy Deli Bake Association’s annual show and expo for the fourth consecutive year. IDDBA 2010 will be held June 6-8 in Houston, Texas. TGI representatives will be on hand at Booth #3555 to offer product demonstrations of TGI’s Enterprise 21 ERP software for show exhibitors and attendees. If you plan to exhibit at or attend IDDBA 2010 and would like to schedule a product demonstration while at the show that focuses on your business’s unique software requirements, you may complete a brief form on our IDDBA 2010 show event page or contact us directly. Read More…

Enterprise 21 ERP Software Functional Highlights for the Food and Beverage Industry:

  • Lot Tracking and Traceability
  • Shelf-life and Expiration Date Tracking
  • Inventory Management
  • Warehouse Management
  • Manufacturing
  • Scalable Batches
  • Formula and Recipe Management
  • Multiple Units of Measure and Unit of Measure Conversions
  • Catch Weight Processing
  • Compliance and Product Recall Management
  • Order Management
  • Purchasing
  • Shipping and Receiving
  • EDI
  • CRM
  • Financial Management and Accounting

Additional Resources and Links:


Enterprise 21 ERP: An Ideal Food ERP Software Solution for Producers of Gourmet Sauces, Stocks, and Concentrates

April 20th, 2010 by admin

A recent article in Bon Appétit magazine highlighted five companies’ alternatives to “homemade” chicken broth. Interestingly, two of the five food processors featured in the article run TGI’s Enterprise 21 ERP software, including More Than Gourmet, a producer of gourmet French stocks and French sauces, and Savory Creations International, maker of Savory Choice Liquid Chicken Broth Concentrate. Aside from the fact that Enterprise 21 is a fully integrated ERP system, there are a number of features in Enterprise 21 that make it an ideal food processing software solution, particularly for makers of stocks, sauces, pastes, and concentrates. Read More…

Lot Tracking and Traceability. Integrated food traceability software functionality is a must for any food processor. Enterprise 21 tracks the lot numbers of ingredients and materials received into inventory, the suppliers who provided the ingredient lots, when these lots were consumed in manufacturing, the lot numbers of finished goods produced, and all customers who were shipped a given lot of a given product.

Multiple Units of Measure. Enterprise 21 allows organizations to establish global or product specific unit of measure conversion factors. Food processors and distributors can purchase, manufacture, stock, and sell ingredients and/or products in any unit of measure.

Formula and Recipe Management. Enterprise 21 gives food processors the ability to meet their desired formula and recipe requirements. Enterprise 21 supports multi-level formulations while also providing for ingredient substitutes for a given formula. In addition, each formula can have one or multiple manufacturing routings that consist of a series of steps and instructions to be followed during batch production.

Scalable Batches. Food processors can leverage Enterprise 21’s integrated manufacturing software capabilities when producing varying batch quantities. Enterprise 21 can automatically scale required ingredients in a formula or recipe for large or small production batch sizes.

Quality Control. Enterprise 21 supports the establishment of quality control procedures for food processors and distributors to ensure the highest levels of product safety. Ingredients can be set to be placed on quality hold each time they are received into inventory. Similarly, finished goods can be set to be put on quality hold each time they are produced before they are released into available inventory for customer orders.

In addition, quality control personnel can enter test values for ingredients and finished goods directly into Enterprise 21, release ingredients and/or finished goods from quality hold, or reject ingredients and/or finished goods that do not meet desired product specifications.

Shelf-life and expiration date tracking. Food processors and distributors can leverage Enterprise 21 ERP software for both first-in, first out (FIFO) and first expiry, first out (FEFO) inventory management. Under a FEFO inventory management methodology, Enterprise 21 can automatically allocate specific ingredients and/or finished goods in inventory for production or customer shipments that are nearest to their expiration date to prevent ingredients and finished goods from expiring while in inventory.

Furthermore, should an organization’s customers have guaranteed minimum shelf -life requirements, Enterprise 21 can automatically allocate those items in inventory that will meet each customer’s unique shelf-life requirements on a product-by-product basis.

Production Scheduling and Reporting. In the Enterprise 21 ERP system, production schedules can be created manually or generated automatically. Production schedules can also be re-sequenced with a drag and drop user interface with the system automatically checking for machine and labor availability.

Following production, production quantities can be recorded and measured against their standard (or anticipated) production quantities. Enterprise 21 then monitors actual vs. standard production output to provide the organization with sophisticated material planning capabilities.


ERP Selection and TGI’s No Maintenance Fee Increase Guarantee

April 15th, 2010 by admin

In addition to functional requirements, there are a number of cost-related questions to ask potential software vendors during the ERP selection process, such as: Read More…

1. What is the cost of software licenses? Are software licenses sold on a named user or concurrent user basis?
2. What is your average implementation services-to-software cost ratio?
3. Is the software sold on a module-by-module basis, or is it sold as an all-inclusive ERP software product?

A few important questions that are often missed or overlooked during the ERP selection process, however, are:

4. When do you start to charge new customers for annual maintenance?
5. What is your annual maintenance fee, and how is this maintenance fee calculated?
6. What was your annual maintenance fee five years ago?
7. Are software upgrades and future software releases included in your annual maintenance fee?

Questions 4-7 are crucial to the selection process because they can serve as a basis for the selection team to determine not only the most cost-effective short-term ERP solution but the most cost-effective long-term ERP software solution as well. The selection team must have a reasonable understanding of the future costs associated with purchasing the ERP product for the years following ERP implementation.

At TGI, we offer one year of free ERP maintenance from the date of software installation. Given that an ERP implementation may take between three and nine months to complete, we believe our customers should not have to pay maintenance on a software product when they are not using the software in a live transaction environment.

Perhaps more importantly, TGI provides a No Maintenance Fee Increase Guarantee.  We guarantee, in contract writing, that we will never increase the annual maintenance fees charged to each of our customers. This guarantee is designed to provide our customers with a consistent, expected yearly software maintenance expenditure that is free from unanticipated increased fees associated with their software maintenance agreement. We are very proud of the fact that we have never increased our customers’ annual maintenance fees since TGI was founded in 1990.

Why is this guarantee important?

Referring to questions 5 and 6 above, should there be a difference in the maintenance fees an ERP vendor charges its customer today versus five years ago, and the vendor does not provide price protection on their software maintenance agreement, a manufacturing or distribution organization may be subject to escalated software maintenance fees over time. The end result of these unexpected maintenance fee increases could mean that the organization will be forced to allocate funds to their annual software budget that would have otherwise been used for investment in other potential business endeavors.

At TGI, we believe increasing our customers’ annual maintenance fees over time is not the right way to establish long-term partnerships with our customers. As such, we have not and will not increase the maintenance fees we charge our customers over any period of time. Guaranteed.

For a complete listing of questions to ask potential ERP vendors, click here to download TGI’s “50 Questions for Every ERP Software Suppler” white paper.


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

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

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.


Using Enterprise 21 ERP’s Integrated Workbenches for USDOT Audits

April 5th, 2010 by admin

TGI’s Enterprise 21 ERP software features a built-in Workbench Designer that allows end users to design their own inquiry screens, graphical reports, and productivity gauges without any programming knowledge and without any modification to the application’s source code. These screens can be added to the Enterprise 21 menu structure and shared with other users throughout the organization with appropriate security privileges. Given the fact that virtually any data field in Enterprise 21 can be added to a workbench, the Workbench Designer has literally hundreds of applications for use in sales, marketing, customer service, manufacturing, shipping, receiving, finance and accounting, warehousing, and procurement. Read More…

In a recent conversation with a seafood distributor looking to migrate from their existing legacy system to a fully-integrated food distribution software system, the company’s GM informed me that they are subject to U.S. Department of Transportation (USDOT) audits. The GM told me that each time they are audited by the USDOT, she has to compile data from a variety of systems into a consolidated Excel spreadsheet. From start to finish, her process of retrieving and consolidating the data the USDOT wanted to see would last some two to three weeks, as she had to take the time to find the data in their existing system and a series of unorganized Excel documents. I then asked her what specific information the USDOT auditors wanted to see in her reports. According to the GM, the USDOT wanted to be able to see the country of origin of their products, when they received the product, what entity specifically supplied the product(s), the lot numbers assigned to the products upon their receipt, when the products were shipped to the distributor’s customers, the customers who were shipped the product, the method of shipment that was used for each customer order, and the freight carrier that was used for each customer order over a specific range of dates. She then asked, “Is this something Enterprise 21 can do?” My response – “Let’s build a workbench!”

By building a workbench, the seafood distributor can retrieve the data required by USDOT auditors with relative ease and efficiency. The GM’s formerly tedious process of retrieving information for USDOT audits would be reduced from two to three weeks to a matter of minutes. Furthermore, the GM would be able to export the data retrieved in her workbench directly to an Excel spreadsheet to then pass along to the auditors in their preferred data format.

While using Enterprise 21’s Workbench Designer for USDOT audits is just one example, workbenches have literally hundreds (if not thousands) of applicable uses for system users in any department of an organization.


Using Enterprise 21 ERP’s Integrated Training System to Train New Employees

March 30th, 2010 by admin

Virtually every business with whom we speak during the ERP selection process asks about Enterprise 21’s help files and how end-user training is conducted as part ERP implementation. The Enterprise 21 ERP system features help files built directly into the application, as well as an online users manual. These help files exist at the screen level and at the individual field level. In addition, when manufacturers or distributors purchase the Enterprise 21 ERP system, they receive the complete application source code at no additional cost. This enables end users (with the appropriate security permissions) to modify Enterprise 21’s existing help files to meet the specific needs of their organization. Read More…

In terms of functional training, TGI conducts end-user training onsite at the customer facility and provides online, Internet-based training throughout the ERP implementation process. In addition, the Enterprise 21 ERP system features an “Integrated Training System.” This system, which is built into Enterprise 21, serves as the foundation for initial end-user training and features answers to hundreds of frequently asked questions, training courses and certification exams, and “How-To” help. The Integrated Training System also includes a series of multimedia demonstrations that show end-users how to perform hundreds of different functions and process various transactions within Enterprise 21.

Perhaps one of the most important benefits of Enterprise 21’s Integrated Training System, however, is that it can be used to train new employees in the months and years following ERP implementation. Often times, new employees are trained by existing members of the organization who were previously trained by TGI personnel during implementation. A person who is added to the organization’s customer service department, for example, would more than likely be trained by one of the company’s existing customer service representatives. The problem with this approach is that it can lead to a declining level of ERP system knowledge throughout the organization over time as employees are added.  Using Enterprise 21’s Integrated Training System to begin training new employees ensures that each Enterprise 21 user receives the same, base level of functional training regardless of whether they have been with the organization for two years or two days. New employees can then take the organization’s certification exams to determine whether or not they are ready to begin processing transactions in a live production instance of Enterprise 21.


Two Key Questions Process Manufacturers Should Ask Themselves when Implementing New Process Manufacturing Software

March 29th, 2010 by admin

Many process manufacturers with whom we enter into discussions have a similar make up prior to implementing new process manufacturing software like TGI’s Enterprise 21 system.  Currently, their production reporting exists only on paper.  They also want to do system-enabled production scheduling but don’t have production standards documented, such as the duration of the setup and run times respectively for each product within each production process step. Read More…

So, they wonder where to start for their implementation of new process manufacturing software.  Two key elements to be considered to be able to answer these questions are what metrics the process manufacturer wants to be able to track and what they want to accomplish relative to system-enabled production scheduling.

Regarding the question about metrics, it is very common for companies to want to be able to measure and analyze a variety of things.  What is my throughput rate?  How much product is scrapped during production?  What is the yield of various ingredients going into each product?  Do we consistently have to add additional ingredients to the production of some products so they ultimately meet a customer’s specifications when completed?

The only way to be able to analyze and track these metrics is to measure and record data during the production process.  It is often comical to have discussions with potential new clients who want to be able to analyze and track key data – such as lot traceability – who in the same breath argue that they can’t possibly take the time in their operations to record such data.  It’s as if they believe a new process manufacturing system will somehow discern this information without anyone or anything recording the data.  Again, to be able to analyze and track data from a production process requires that data to be measured and recorded – either by human intervention via a keyboard, touch screen, or scanning process or directly from a production manufacturing machine via a data interface.

As for production scheduling, every process manufacturer’s business has certain idiosyncrasies or business rules by which it lives.  First, a given product must go through a series of steps or processes to be produced.  Similarly, each work center in a given production facility has a maximum production capacity or throughput rate.  Next, the amount of time to setup (the preparation time required for a given process step), run time (the actual time to perform the production of a given quantity of a product), and queue time (the amount of time a product must be delayed for cooling or other purposes before it is permitted to move to the next step in the process) needs to be known and documented for each product at each step in the process.

At a deeper level, one must know what products can be run together in a sequence (called scheduling groups) in a given work center so adverse results aren’t produced by running two products through the same work center in succession, and what scheduling groups should be run in what sequences through various work centers to minimize setup time, thus yielding a higher total throughput.  And finally, what classes of products cannot be run simultaneously on two adjacent production work centers as there will be a reaction between the two products causing resulting quality issues.

While there are a number of other details beyond the ones documented above, these items are intended to help depict the process necessary to create a series of business rules required to enable the creation of a system-generated production schedule that can be used by a process manufacturer for the scheduling of their production facilities.

By asking themselves what metrics do I want to be able to track and analyze, and to what extent do I want to be able to perform system-enabled production scheduling, process manufacturers will help define the scope and ultimate success of their implementations of strong process manufacturing systems like Enterprise 21.


Recent HVP Recall: How Food ERP Software Can Help with the HVP Recall and other Food Recalls

March 18th, 2010 by admin

Food products containing HVP (hydrolyzed vegetable protein), an ingredient used in the manufacture of a number of processed foods, such as soups, hot dogs, and frozen dinners, have recently been recalled by the FDA due to salmonella contamination in one company’s products containing HVP. The HVP recall is yet another recent event that demonstrates how food processing software solutions with integrated food traceability software functionality can help both food processors and ingredient suppliers in the event of a product recall. Read More…

For food manufacturers who produce finished goods containing HVP, a food processing software solution with forward and backward lot tracking and traceability features can track the lot numbers of HVP received into inventory, the suppliers who provided the HVP, when the HVP was received into inventory, the HVP lot numbers consumed in manufacturing, all of the finished goods (and the associated finished good lot numbers) that were produced with a particular lot of the HVP ingredient, and all of the food processor’s customers who were shipped a finished good that contained a particular lot of HVP. In the event of a product recall, such as the current HVP recall, a food processor would simply use the organization’s ERP software system to identify all of its finished goods that were produced with a contaminated ingredient lot and all of its customers who received finished goods that were produced with a contaminated lot. For example, if a food processor received HVP with lots 123 and 456 from Supplier A and lots 789 and 012 from Supplier B, and Supplier A were to initiate a recall for HVP lot 123, the food processor would, more than likely, have to recall only its finished goods that were produced with HVP lot 123 from Supplier A rather than all of its finished goods that were produced with HVP. This can result in significant cost savings for the food processor should a recall need to be initiated.

Similarly, HVP ingredient suppliers can benefit from food ERP systems with integrated lot traceability features. Should an HVP ingredient supplier discover that one of its HVP lots was contaminated, the supplier would be able to identify all of its customers that received the contaminated HVP lot and notify them that a recall for that particular lot has been initiated. Again, assuming the ingredient supplier has the necessary lot traceability and quality control mechanisms in place, the supplier would only have to recall the contaminated lot of HVP, rather than all HVP lots that were shipped to customers over a period of time.

TGI Traceability Resources

For a demonstration of Enterprise 21’s forward and backward lot traceability features, please click here.

To download TGI’s Five Critical Software Requirements for Improved Product Safety and Traceability white paper from the TGI Resources Library, please click here.