How Dynamic FRM® Formula and Recipe Management Transforms Business Data Value
Sharing Our Expertise

Our consultants solve challenging business problems and love sharing their knowledge. Tap into our insights and put them to work for you.

Back to Blogs >>

Published on Tuesday, February 27, 2018

Dynamic FRM® Formula and Recipe Management solution (FRM) is a robust way to handle information surrounding products. This includes the product states ranging from raw materials all the way through finished and sellable goods. Maintaining process and procedures in the product lifecycle is core functionality in a FRM solution, but FRM can be so much more. Leveraging the Formula & Recipe Management platform for other business functions and data makes for a stronger overall solution that provides more value to the organization.

A successful Formula and Recipe Management solution utilizes this flexibility. While effective at handling data related to the products, the functional conversation quickly extends into related areas of the business, including research and development, quality, marketing, legal, vendor management, and distribution. Here are some examples how:


Updating or creating a new formula is a common process. When applying formula and recipe management to the research and development function, product testing is a central part of the research. Capturing test results and sharing the outcomes with stakeholders is key to that process. If the test results aren't as expected, the formula gets re-worked, and new tests are run, yet the old version of the formula and its tests need to be tracked and maintained. The repeated testing process produces many outputs to be managed and archived. It’s a perfect use case for the FRM solution.

Marketing & Legal

Once the final version of the formula is approved and it is ready to move to production, cost and marketing analysis is triggered. While suppliers and cost are being determined, Marketing begins the work to craft product claims and packaging artwork with the help of legal to keep it within regulatory compliance. Raw material specifications and tests are determined, as well as the formula’s ingredient and nutritional information that will be used to generate the packaging’s nutritional panel. FRM stores much of this data natively and be called on as the single source of information.

Vendor Management

Vendors are a huge piece of the sourcing operation. Selecting the right vendors as well as maintaining compliance with audits and other regulatory elements is a significant functional silo. Process and protocol around vendor sections, certification, maintenance, and replacement is critical to keeping a safe and steady flow of materials into the enterprise. Contracts and other documents related to vendors also need to be stored and readily available to both internal resources and external parties. An FRM solution performs these duties with some minor configuration. Keeping the vendor information close to the product data optimizes the entire process.

An effective formula and recipe management solution must eventually handle more than just formulas and recipes. It must be able to encompass information from all corners of the product management enterprise. Here are some other examples of how a good formula and recipe management platform can be leveraged across the business to enable success and ROI:

Quality Assurance

  • Centralized quality documentation and testing procedures
  • Link testing procedures to testable properties of the formula
  • Store test results and perform other LIMS (laboratory information management system) functions
  • Generate certificate of analysis for product batches
  • Capture Certificate of Analysis data on incoming raw materials for tracking variability
  • Provide easy access to internal compliance data for regulatory auditors

Customer Complaints / Consumer Affairs

  • Log all complaints in a centralized location
  • Record follow-up actions
  • Use official marketing and legal-approved verbiage in responses to customers
  • Show trends in complaints by product, timeframe, location, etc.
  • Track costs to resolve customer complaints
  • Automate response letters and emails
  • Root Cause Analysis

Track, Link and Manage Common Business Processes:

  • Capital allocation requests
  • Distributor claims and order exceptions
  • Sales sample requests
  • Business process changes
  • Packaging artwork
  • Business projects
  • Machinery detail for manufacturing centers
  • Customer performance
  • Documents and FAQ's
  • Help desk process for IT department
  • Preventative maintenance and service requests
  • Expose ERP, MRP, and Inventory data in one place

By using the Dynamic FRM Formula and Recipe Management solution as a platform, you can unlock new value from your data across the business and connect it in ways that can truly transform your operations and collaboration. We are helping other clients realize the benefits and can help you determine the best path to value and insight. Contact our expert team to learn more.


Return to Smart Measures 2018 Vol 1 Newsletter

Categories: Formula Recipe Management,Dynamics 365,PLM,Food & Beverage,Dynamic FRM

Recommended For You
Business cards can now be scanned into Dynamics 365 Sales via mobile phone camera interface or the web from a card image.
View More ...
The combined power of Dynamics 365 for Sales and LinkedIn empowers sellers to find and focus on the right prospects and customers.
View More ...
Dynamic FRM™ has fully enabled Dynamics 365’s new user experience, also known as the Dynamics Unified Interface.
View More ...
After years of requests, the Dynamics 365 CRM Opportunity Close entity, form, and dialog are finally configurable.
View More ...