Tag Archives: integrity

Using Spreadsheets as Your ERP? Your Supply Chain Could Take a Hit

By Tom Brennan
3 Comments

The cannabis supply chain – from seed to sale – is rife with intricacies including regulations and compliance. It requires coordination from multiple vendors responsible for different aspects of the end product. And as the industry either grows or retracts, use of data is vital to right-size supply to demand, enhance operational efficiencies and boost cost effectiveness.

However, there’s an industry-wide, data-management vulnerability among many cannabis companies, and it’s this: many are using spreadsheets in different aspects of data collection, management and analysis. This becomes a shaky foundation on which to manage processes, especially for applications like quality management. And to be fair, it’s not just this industry, but arguably cannabusinesses have more on the line in light of the ever-changing regulatory environment.

Many cannabis companies have some systems in place for order processing, inventory management, production management and the like, but they often still use spreadsheets to fill the intelligence gaps among various systems that don’t talk to one another. Managing supplier quality often falls into one those gaps.

The Problem with Spreadsheets

Most businesspeople understand spreadsheets. They know how to build and use them. Spreadsheets are incredibly powerful tools that are used to run more business processes than perhaps any other software product in the world. When a cannabis business first starts out, spreadsheets offer an affordable data management capability. But there comes a time when the business will need a more sophisticated, end-to-end enterprise solution.

Consider a recent incident in which the use of spreadsheets went terribly wrong. The British Government recently misplaced nearly 16,000 COVID-19 test results due to an Excel spreadsheet error. As a result, potentially infectious people may not have been notified by contact tracers that they should self-quarantine.

Companies can outgrow spreadsheets quickly as their business grows

In the ERP space, spreadsheets have been an issue since the 90’s, but this recent incident serves as a reminder that an overreliance on spreadsheets is still alive and kicking. One of the problems is that spreadsheets are often pushed beyond their intended use. Microsoft Excel has become the software Swiss Army Knife. There’s a development environment inside the software, and the system is often used as a database, not just as a calculation engine.

Companies outgrow spreadsheets when the volume of data fields increase, multiple users need access to the data, iron-clad audit trails are needed and when processes become more complex.

There’s also a breaking point. Cannabis companies may enter a dangerous zone of “too many spreadsheets,” when data security and integrity are at risk. Interestingly enough, this also happens in large companies, as they often have a mish-mash of on-premises legacy systems, acquired systems and new cloud-based systems – and spreadsheets are then used as the data consolidation tool for all these applications.

Applicability to the Cannabis Supply Chain

Visibility into the cannabis supply chain requires detailed track and trace capabilities across many suppliers. Anything left out means guesswork and more opportunities for mistakes. In other words, cobbled-together spreadsheets are the last thing cannabis businesses should rely on. Aggregating data into a spreadsheet from various systems and paper-based processes invites errors and can result in insights that are weeks or months out of date. Worse yet, there’s no drilldown capability when questions arise and no easy roll-up of information for decision-making.

Modern cloud ERP software can integrate an entire supply chain with ease

When supply chain quality must be sustained, the role of a common and integrated cloud platform for quality and ERP cannot be understated. Such a platform can capture sales, operations, inventory and purchasing data, and also integrate with production and quality control. This makes your quality processes and data integral to ERP and eliminates the data fragmentation, control and auditability issues associated with spreadsheets. In addition, companies can leverage operational insights from data reporting and analytics to find areas where they can enhance productivity, optimize inventory, improve planning accuracy and build better forecasts.

Moving to the Cloud

Modern cloud ERP provides this type of seamless platform. It’s easier to implement and does not consume as many IT resources as traditional on-premise ERP systems. Better yet, the more recent versions of cloud ERP are built using low-code technology which enables business users to customize screens, modify workflow processes, build their own apps and embed AI without needing expensive IT consultants or waiting for busy IT staff.

In other words, the flexibility that’s been the lure of spreadsheets is now available in cloud ERP, but the system utilizes proverbial governance guardrails that keep business users from swerving off the road and completely wrecking the system. For example, templates for apps and workflows are provided as a starting point. Business rules and “drag and drop” customization capabilities offer guided options, clearly defining what can and cannot be changed.Rootstock will be presenting during the Cannabis Quality Virtual Conference episode, Supply Chain Quality, on October 27. Click here to learn more

And as a result, quality steps aren’t skipped; audit trails remain intact and data is protected with rock-solid security permissions and data backups. And unlike spreadsheets, new ERP systems are designed for multiple users and remote access via mobile devices. In short, with the latest generation of ERP, companies can leverage the best of both worlds – an end-to-end cloud platform that provides data integration across an organization’s operation and the flexibility and ease-of-use of spreadsheets.

Supply Chain Case in Point

One customer we worked with previously coordinated its supply chain via email and Excel spreadsheets. It cut and pasted requisitions into individual supplier spreadsheets and emailed those out, and it kept a master spreadsheet to keep track of all supplier performance. Team members had to sift through spreadsheet columns and rows to find information they needed.

Today with a cloud platform, the company built an online community so processes could be automated and conducted via real-time connection and communications. Another immediate benefit was the customized supply chain dashboard. All relevant data across their entire supply chain was displayed in one place and in a user-friendly manner.

The dashboard showed production forecasts over a certain period of time. The company could detect whether the supply chain was on track or having issues with certain suppliers. It could see planned requisitions and monitor them until fulfillment was complete. It could also monitor the performance of various suppliers, whether they had on-time deliveries or not – and trace back items received. The company essentially has a snapshot of the overall health of its supply chain and all the underlying activity.

Let’s face it. 2020 has been a difficult year, but perhaps it’s the year that companies finally forego spreadsheets and enlist an industrial-strength cloud platform.

Supplier Quality Audits: A Critical Factor in Ensuring GMP Compliance

By Amy Scanlin
1 Comment

Editor’s Note: This is an article submission from the EAS Consulting Group, LLC team.


To Audit, or not to audit? Not even a question! Audits play a crucial role in verifying and validating business practices, ensuring suppliers are meeting their requirements for Good Manufacturing Practices (GMPs), and most importantly, protecting your interests by ensuring that you consistently receive a compliant and quality product. Audits can help ensure sound business procedures and quality systems, including well-established SOPs, verification and documentation of batch records, appropriate sanitation practices and safe storage and use of ingredients. Audits can also identify deficiencies, putting into motion a corrective action plan to mitigate any further challenges. While a detailed audit scheme is commonplace for established industries such as food, pharmaceuticals and dietary supplements, it is equally important for the cannabis industry to ensure the same quality and safety measures are applied to this budding industry.

If the question then is not whether to audit, perhaps the question is how and when to audit, particularly in the case of a company’s suppliers.This is an opportunity to strengthen the working relationship with each side demonstrating a commitment to the end product.

Supplier audits ensure first and foremost that the company with which you have chosen to work is operating in a manner that meets or exceeds your quality expectations – and you should have expectations because ultimately your product is your responsibility. Any issues that arise, even if they are technically the fault of a supplier, become your issue, meaning any enforcement action taken by your state regulators will directly impact your business. Yes, your supplier may provide you with a batch Certificate of Analysis but you should certify their results as well.

Audits are a snapshot of a moment in time and therefore should be conducted on a regular basis, perhaps biennially or even annually, if they are a critical supplier. In some cases, companies choose to bring in third-party auditors to provide an objective assessment of suppliers. This is especially helpful when the manufacturer or customer does not have the manufacturing, compliance and analytical background to accurately interpret data gathered as part of the audit. With the responsibility for ensuring ingredient identity and product integrity falling on the manufacturer, gaining an unbiased and accurate assessment is imperative to reducing the risk to your business.

Conducting a supplier audit should be well planned in advance to ensure both sides are ready. The audit team must be prepared and able to perform their duties via a combination of education, training and experience. A lead auditor will oversee the team and ultimately will also oversee the results, verifying all nonconformities have been properly identified. They will also work with the supplier to conduct a root cause analysis for those nonconformities and develop a corrective action plan to eliminate them from occurring in the future. The audit lead will also verify follow-up results.

Auditors should discuss with the supplier in advance what areas will be observed, what documentation will need to be ready for review and they should conduct their assessments with professionalism. After all, this is an opportunity to strengthen the working relationship with each side demonstrating a commitment to the end product.This is your chance to ensure your suppliers are performing and will meet your business, quality and product expectations.

Auditors must document that ingredient identity and finished product specifications are verified by test methods appropriate for the intended purpose (such as a whole compound versus a powder). State regulations vary so be certain to understand the number and types of required tests. Once the audit is complete and results are analyzed, you, the manufacturer, have an opportunity to determine if the results are acceptable. Remember, it is your product, so ultimately it is your responsibility to review the available data and release the product to market, you cannot put that responsibility on your supplier.

Quality Agreements as Part of a Business Agreement

There are opportunities to strengthen a partnership at every turn, and one way to set a relationship on the right path is to include a quality agreement as part of a business agreement. A quality agreement lays out your expectations for your suppliers, what you are responsible for and is a living document that, once signed, demonstrates their commitment to upholding the standards you expect. Just as with a business agreement, have any quality agreements reviewed by an outside expert to ensure the wording is sound and that your interests are protected. This is just another step in the development of a well-executed business plan and one that solidifies expectations and provides consequences when those expectations are not met.

Supplier audits must be taken seriously as they are opportunities to protect your brand, your business and your consumers. Enter into an audit as you would with any business endeavor – prepared. This is your chance to ensure your suppliers are performing and will meet your business, quality and product expectations.

incredibles chocolate

Manufacturing Edibles With Integrity

By Aaron G. Biros
No Comments
incredibles chocolate

Without federal guidance on food products containing marijuana (a result of the plant remaining a Schedule I narcotic), state regulators and manufacturers are fighting to keep the market safe for consumers. Manufacturers of marijuana edibles are not only trying to ensure consumer safety, but are also attempting to advance industry and legalization efforts nationwide.

Recent investigations in Colorado revealed that certain marijuana edibles, along with some extracts, tested positive for illegal pesticides. Many cannabis businesses are looking to the industry leaders in edibles manufacturing for advice. Marijuana edibles are a food product, so they must first enlist standard food sanitation procedures and then comply with state regulations for cannabis to ensure safety. Some of the product consumers are patients with weakened immune systems, thus highlighting the need for consistent and accurate dosing in products.incredibles logo

Maureen McNamara, founder of Cannabis Trainers, recently sat on a panel with Bob Eschino, co-founder of incredibles and Krystal Kiathara, CEO of Yummi Karma at the Cannabis World Congress and Business Expo, hosted by the International Cannabis Association in Los Angeles. The panelists discussed the need for integrity in manufacturing edibles.

The regulations are not quite there yet and states are adjusting legislation to help promote safety. “It is our job to educate legislators and make sure that our products are accurate and consistent,” said Bob Eschino, co-founder of incredibles.

incredibles chocolate
An infused chocolate bar, manufactured by incredibles, separated into 10mg of THC doses

Maureen McNamara says there are four criteria for producing edibles with integrity: Compliance, training, research and product testing.

“Starting with the foundation of compliance, utilizing strategies involving HACCP plans and FDA guidance, the first pillar is training,” says McNamara. “Food safety training is essential to ensure your team is aware and making a wholesome product.” She also stressed the importance of shelf-life testing and R&D before the product goes onto shelves.

Because food laboratories often will not test products that contain cannabis, many companies work with food scientists and in-house testing. “Moving forward, we need to ensure that we achieve consistent results from the various testing labs,” said McNamara. “But to make edibles with integrity, laboratory testing is paramount.”