Executive Summary

  • This is the Brightwork Research & Analysis software rating series.
  • We rate both the software and estimate the risk of implementing each application.

MUFI Rating & Risk for Hamilton Grant Recipe Management

MUFI: Maintainability, Usability, Functionality, Implement ability

Vendor: Hamilton Grant Recipe Management (Select For Vendor Profile)


Hamilton Grant Recipe Management is a solution for managing product management.

The paper What Makes Process Process? makes the excellent point that the classic BOM tends to assume discrete or repetitive manufacturing. In the discrete or repetitive BOM, many parts are combined to make a single item. However, this is only one configuration. For instance with a poultry processor on chicken (the raw material), multiple finished goods result. Frequently the BOMs for the process industry are multi-level and can be one to two levels deep or up to fifteen or more levels deep. A multi-level BOM is explained well in the article Managing Multi-

Level BOMs, by Arena Solutions.

A multi-level BOM, also referred to as an indented BOM, depicts parent-child relationships and shows the hierarchical structure of assemblies and their related parts and components. A multi-level BOM is essentially a nested list whose parts or items are listed in two or more levels of detail to illustrate multiple assemblies within a product’s BOM. In contrast, a single-level BOM depicts one level of children in an assembly and only the components needed to make the assembly are listed.

Most of the recipe management applications that currently exist are directed towards the food and beverage industry. This is thought to be because of their stringent requirements, many of which were described above. Change is a constant feature of food and beverage product information as these companies will frequently reformulate their recipes for every production batch. Hamilton Grant’s software can greatly reduce the effort involved in doing this because they have functionality that can optimize the reformulation process – such that the objectives are set for the application and the application will meet these objectives at the lowest cost. Therefore, the optimizer determines what the new formula will be.

Recipe management software can be found outside of the food industry, but the selection quickly narrows. The differentiation between a BOM and a recipe is most easily seen inside of an application like Hamilton Grant. This is because their application provides the type of information that show ingredient aggregation as the food designers are building a new recipe, they must know how various indicators are changing and whether they have exceeded the specification as food must increasingly meet certain nutritional and other various compositional targets.

Hamilton Grant Codes-1

To begin, the icons that show up in the application can be set by the system configurator.

Hamilton Grant Ingredients

As with all useful recipe/BOM management applications, designers use them intensively, and many of the iterations that they create will never find their way to the production planning system. However, the sub-portion of the overall recipes that are created can be sent to ERP systems (and from there to planning systems) in a complete form. Recipe/BOM management systems allow for the natural duplication of recipes by using a template before developing a new design or product. In the case above, a food designer is adding a series of ingredients (which are only approved ingredients) that will make up a new mincemeat pie. As the food designer combines components, the characteristics of the product are totaled below. The Hamilton Grant Recipe Management application can hold a wide variety of ingredient characteristic, but only a few are shown in this view. A right mouseclick allows the designers to add and delete the components that will show in the user interface so they can see the summation of the ones that interest them.

Hamilton Grant Product Attributes

New windows can be opened which show more a detailed analysis of the new product that is being designed. In this screenshot, you can see the costs, intolerance, nutritional content and the ingredient list. These perspectives on the product help the designer make adjustments to the products that meet the design objectives. For instance, food companies very much design their products in a way that result in a marketable food label. By viewing the label each time a new ingredient is added or removed, the food designer can make the adjustments to result in the desired food label.

Hamilton Grant Flow

The strength of these types of applications is that the information that is created in them is shared with many other applications. They serve as a hub for product data— a far superior approach to the poor design of using ERP systems as the hub of product data. In fact, the ERP-centered approach to being the product data hub has been attempted extensively and has been proven not to work well. Even so, it is still the dominant approach employed in companies. When companies follow this approach, ERP systems end up being a bottleneck to the implementation of other systems that rely on product information. 

Hamilton Grant’s software is used first by product design before anyone from supply chain touches the recipe or formula. Product design makes numerous revisions (copies of new recipes and formulas) before a production recipe is created. Even after the production recipe is created, there are still more copies that are made as the product is changed through its lifecycle or as other copies of the recipe are created. Hamilton Grant’s ability to manage large numbers of revisions and to store them all—and to allow anyone with the access rights to see them—is a major strength of the application.

Once the interaction between various software applications and the recipe are understood, the next step is to learn how to leverage applications that use the recipe. I believe that individuals have difficulty understanding the recipe in its comprehensive form because existing literature does not include application screenshots to show how the recipe looks in different applications. While some product manuals produced by the recipe management vendors come close and are quite good, the manuals focus exclusively on a particular vendor’s application and do not show how the recipe looks in competing applications. As a result, few people receive the benefit of a comprehensive education in this area, which is a primary reason why the recipe tends to be so poorly managed generally.

Hamilton Grant Recipe Management is an easy decision for companies looking for recipe management in the food industry. However, an interesting question for other process industry buyers is whether this application could also help them with their recipe management. We would suggest that other process industries manufacturing companies, outside of food and beverage give Hamilton Grant Recipe Management a look. There are really few solutions in this area, and we estimate this category of enterprise software to have the highest ROI of any of the categories that we cover.

MUFI Scores

All scores out of a possible 10.

MUFI Scores

Search for the vendor in this table using the search bar in the upper right of the table. Shortening Key: 
  • Ma. = Maintainability
  • Us. = Usability
  • Fu. = Functionality
  • Im. = Implementability
Average Score for Big ERP5. ERP
Average Score for CRM6.
Average Score for Small and Medium ERP8.386.78.5Small and Medium ERP
Average Score for Finance8.88.888.8Finance
Average Score for Demand Planning7.67.277.1Demand Planning
Average Score for Supply Planning6.76.976.8Supply Planning
Average Score for Production Planning6.86.976.9Production Planning
Average Score for BI Heavy5. Heavy
Average Score for PLM77.26.87.3PLM
Average Score for BI Light7.78.798.3BI Light
Arena Solutions Arena PLM 10101010PLM
AspenTech AspenOne48107Production Planning
Birst 88.5108BI Light
ERPNext10107.510Small and Medium ERP
Delfoi Planner866.57Production Planning
Demand Works Smoothie SP910710Supply Planning
Hamilton Grant RM1098.59PLM
IBM Cognos2.731.53BI Heavy
Infor Epiphany7865CRM
Infor Lawson8767Big ERP
Intuit QuickBooks Enterprise Solutions9959Finance
JDA DM97.588Demand Planning
Microsoft Dynamics CRM2322CRM
NetSuite CRM6433CRM
Netsuite OneWorld7788Big ERP
Oracle BI4436BI Heavy
Oracle CRM On Demand4535CRM
Oracle Demantra533.54.5Demand Planning
Oracle JD Edwards World4136Big ERP
Oracle RightNow6745CRM
PlanetTogether Galaxy APS10101010Production Planning
Preactor8737Production Planning
QlikTech QlikView99109BI Light
Rootstock9899Small and Medium ERP
Sage X38878Big ERP
Salesforce Enterprise88.597.5CRM
SAP APO DP3432Demand Planning
SAP APO PP/DS2243Production Planning
SAP APO SNP3484Supply Planning
SAP BI/BW1.5242BI Heavy
SAP Business Objects32.573BI Heavy
SAP ECC336.53Big ERP
SAP SmartOps4475.5Supply Planning
SAS BI6.5796BI Heavy
SAS Demand Driven Forecasting7897Demand Planning
Tableau (BI)9101010BI Light
Tableau (Forecasting)10859Demand Planning
Teradata86.39.76BI Heavy
ToolsGroup SO99 (Forecasting)7897Demand Planning
ToolsGroup SO99 (Supply)56107Supply Planning

Vendor and Application Risk

Buyers of Hamilton Grant Recipe Management have the advantages working their direction. Hamilton Grant Recipe Management is one of highest rated application in PLM/recipe management for food and beverage. It is a rare situation where a buyer has the opportunity to purchase software that is both the functionality leader in its category, along with being highly implementable and user-friendly. Because Hamilton Grant has such a high combined application and software vendor risk rating, the vast majority of the risk comes from the buyer’s environment, not from Arena PLM. User adoption with Grant Hamilton Recipe Management should be high, and with the ability to quick revisions to recipes to create new products, post goes live the overall satisfaction should also be high.

Likelihood of Implementation Success

This accounts for both the application and vendor-specific risk. In our formula, the total implementation risk is application + vendor + buyer risk. The buyer specific risk could increase or decrease this overall likelihood and adjust the values that you see below.

Likelihood of Application Implementation Success and Failure

Estimates are for a typical project. A specific implementation requires details from the project to make a project-specific estimate.

Search for the application in this table using the search bar in the upper right of the table.
ApplicationProb of Implementation SuccessProb of Implementation Failure
SAP Smartops0.390.61
NetSuite CRM0.460.54
Sugar CRM0.620.48
Base CRM0.910.09
SAP CRM0.350.65
Salesforce Enterprise0.720.28
QlikTech QlikView0.820.18
Tableau (BI)0.980.02
SAP Crystal Reports0.460.54
SAS BI0.760.24
Oracle BI0.350.65
IBM Cognos0.230.77
Infor Epiphany0.580.42
Microsoft Dynamics CRM0.260.74
Oracle RightNow CRM0.410.59
Oracle CRM On Demand0.360.64
SAP Business Objects0.320.68
SAP BI/BW0.250.75
SAP PLM0.290.71
Hamilton Grant RM0.890.11
Arena Solutions0.960.04
Delfoi Planner0.70.3
PlanetTogether Galaxy APS0.960.04
AspenTech AspenOne0.550.45
SAP APO PP/DS0.270.73
Demand Works Smoothie SP0.930.07
ToolsGroup SO99 (Supply)0.820.18
Demand Works Smoothie0.960.04
Tableau (Forecasting)0.90.1
SAS Demand Driven Forecasting0.820.18
ToolsGroup SO99 (Forecasting)0.860.14
JDA DM0.570.43
Oracle Demantra0.330.67
SAP APO DP0.280.72
Intuit QB Enterprise0.80.2
Microsoft Dynamics AX0.40.6
SAP Business One0.490.51
Sage X30.620.38
Infor Lawson0.580.42
Epicor ERP0.40.6
Oracle JD Edwards World0.310.69
Oracle JD Edwards EnterpriseOne0.360.64
SAP ERP ECC/R/30.320.68
NetSuite OneWorld0.650.35

Risk Definition

See this link for more on our categorizations of risk. We also offer a Buyer Specific Risk Estimation as a service for those that want a comprehensive analysis.

Risk Management Approach

The only implementation issues that a buyer of Arena PLM can expect to the fact are the traditional issues that face PLM/recipe management implementation projects. Buyers and product managers should look forward to a Hamilton Grant Recipe Management implementation.

Finished With Your Analysis?

To go back to the Software Selection Package page for the BI Light software category. Or go to this link to see other analytical products for Hamilton Grant Recipe Management.