Northeast Lantern: From Spreadsheets to Cloud ERP

How Rootstock Software helped one small manufacturing firm replace manual, spreadsheet-heavy processes with Cloud ERP automation

Since 1987, Northeast Lantern has been manufacturing and selling handcrafted, solid brass and copper lighting fixtures. Like many similar small manufacturers, Northeast Lantern relied on too many spreadsheets to manage the business.

Every bit of data was entered and stored on Excel spreadsheets that didn’t link to each other.

However, as Northeast Lantern grew to become a 3.5-million-dollar company, all those spreadsheets created more problems than solutions. With no formal system for inventory or engineering and no single database, the company knew that further growth would require a modern ERP solution.

Northeast Lantern selected Rootstock Cloud ERP to give the company visibility into all of their data and to automate production processes that used to be performed manually.

About Northeast Lantern

Northeast Lantern is located in Exeter, New Hampshire, and currently employs 45 people. The company produces the highest-quality lighting fixtures for retail showrooms, online distributors, web stores, designers and the hospitality industry. Customers have a wide array of product customization options, including different finishes and glass options.

Northeast Lantern augments their standard fixtures with custom lighting fixtures, as over 20% of their products are customized pieces.

To maintain the high quality of their handcrafted products, Northeast Lantern employs skilled craftsmen who use original manufacturing methods. According to Product Development Engineer Steven Plante, “We do a lot of our production on old machines, so we don’t have the latest and greatest machining, CNC-type machines. We do things manually.”

Spreadsheets, Spreadsheets and More Spreadsheets

While traditional manufacturing methods allow Northeast Lantern to continue to provide high-quality, handcrafted lighting, old data and system management methods proved to be an increasing obstacle to growth. In fact, the company had no formal system at all. With so much customization and so many parts to build and maintain in inventory, the company didn’t have a firm grasp on engineering and inventory control, and reporting was limited.

Engineering – A Spreadsheet for Every Item

Northeast Lantern managed all their engineering records in Excel spreadsheets. Operations Manager, Dustin Almon explains:

“We had a spreadsheet for every item that we kept track of, with individual BOMs on that spreadsheet,” he says. “For example, if one part was used on multiple BOMs, it was on every spreadsheet, but there was no real connection. If we needed four parts for one SKU and four for another SKU, we would need to make eight. We had no visibility to see how demand was interconnected at a part level, so we would end up making them in two different batches. Rootstock helped us connect the sources of demand and increase our production efficiency.”

Further complicating the process were incorrect and missing part numbers and out-of-date BOMs.

They knew that managing engineering documents using spreadsheets was an impediment to growth.

No Inventory Control

The company also had no system to control inventory and no cycle counting program. “We had no control over our inventory because we didn’t know at any one time what we had in inventory for a specific part, finished good or subassembly,” says Plante.

Northeast Lantern knew they needed a modern system to help them gain control over their inventory.

Reporting

Spreadsheets also figured prominently in reporting. According to Almon, “We had some Excel spreadsheets, and we copied and pasted from that to generate performance reports, including on-time delivery and production stats.”

This very manual task of reporting critical business information was time-consuming and inefficient. Northeast Lantern needed the reporting capabilities of a modern software solution.

We had no visibility to see how demand was interconnected at a part level. Rootstock helped us connect the sources of demand and increase our production efficiency.

– DUSTIN ALMON, OPERATIONS MANAGER

Choosing Rootstock Cloud ERP

Northeast Lantern began their search for a modern solution with a consultant, who quickly helped them decide that a cloud-based ERP system offered the best solution. They liked the idea that they could access the system and their data anywhere in the world in a web browser and, as a small manufacturer, they really liked that onsite hardware investment was minimized.

Most importantly, they wanted to abandon their spreadsheet-heavy manual processes. The company was looking for a system to help them plan production and catalog all items into a single database. They wanted to see the connections between the parts and where they would be used and get control of inventory and production efficiencies.

Northeast Lantern ultimately chose Rootstock Cloud ERP. In addition to increasing visibility and automating manual processes, Rootstock had several advantages:

  • MRP – Northeast Lantern did their due diligence, investigating the calculation behind Rootstock’s They found it “highly configurable,” so they could make it work the way they needed.
  • Sandbox – Rootstock’s sandbox would allow Northeast Lantern to test changes before going live with them.
  • QuickBooks integration – Northeast Lantern plans to use QuickBooks for its financials, and Rootstock can integrate with that solution.
  • Salesforce Platform – The fact that Rootstock runs native on the Salesforce Cloud Platform was an important factor in the selection process, and the company likes the potential to integrate with other apps available on the Salesforce.

 

Implementation

The combination of no database, over 25,000 individual SKUs and limited resources slowed the implementation process. Despite the delays required to address these issues, the implementation was ultimately a success.

We had some Excel spreadsheets, and we copied and pasted from that to generate performance reports, including on-time delivery and production stats.

– STEVEN PLANTE, PRODUCT DEVELOPMENT ENGINEER

Preparing the Data

During implementation, Northeast Lantern found that they had to spend a lot of time preparing their data. “That was one of the biggest challenges that we had,” says company President Chris Heal.

“For us, it was getting the data into the right format to be able to use that data. We had a lot of part numbers that were missing, parts that didn’t have numbers, obsolete part numbers and incomplete BOMs, so we had all that in front of us, and we also had to get the data in the right format.”

The company did a lot of copying and pasting from their Excel spreadsheets, checking, double-checking, and triple-checking to make sure they weren’t putting bad data into the system.

Once they completed that difficult task, the data load was “relatively painless,” according to Heal. But all that work would pay off in the long run. By focusing on data preparation before loading that data into Rootstock, Northeast Lantern ensured that once their new system was up and running, they would be confident in the accuracy of their data.

Developing a Hybrid Manufacturing Model

The company also spent a considerable amount of time trying different business models to fit their production methodology. Rootstock’s flexibility and customizability turned out to be a key differentiator for Northeast Lantern.

According to Dustin Almon, the company originally used a production model based on batches.

“When I started here, we made things in batches. We’d  make a batch and put it on the shelf and then use it in a kind of make-to- stock environment,” he says. “We transitioned to a make-to-order environment. Then, when we were considering Rootstock, we looked at keeping that strict one-to-one, make-to-order model or transitioning to a make-to-stock/assemble-to-order hybrid model with inventory at select points.”

Northeast Lantern finally settled on a subassembly/finished goods model in which inventory would be controlled at the subassembly level, and then final production would be based on that subassembly inventory.

One of the biggest obstacles to overcome was the sheer number of SKUs. As Chris Heal explains, “For a given product, there could be up to 100 different permutations: the type of glass, the type of material we make it out of, what color we finish it in. It took us quite a while to get our heads around a model that would work for that.” The company eventually decided to maintain a unique SKU for every one of those products.

For a given product, there could be up to 100 different permutations. That was one of the biggest challenges that we had.

– CHRIS HEAL, PRESIDENT

Using Rootstock Cloud ERP

Northeast Lantern currently makes daily use of several Rootstock Cloud ERP modules, including engineering, shop floor, summary-by-item-in- detail review in the forecasting MRP, scheduling and capacity planning, inventory transaction management, purchasing, requisitions, work orders, and sales order processes. These modules have automated processes that used to be manual and time-consuming.

For shop floor workers and customer service reps (who have less responsibility or administrative privileges), Northeast Lantern has tailored their views so that they only see sales order and customer service processes.

Benefits of Rootstock

The most valuable benefits of running Rootstock Cloud ERP have been increased visibility into their data and the automation of formerly manual processes.

A Single Database

“The 50,000-foot view is that, for once, we have all of our information in a single database,” says Plante. “There are a lot of intangibles that we take for granted now. We can look up a part number and see all the places it’s being used and how much we’ve consumed. Just the fact that we have all this information at our fingertips is invaluable.”

“In addition,” adds Plante, “we now have part numbers and BOMs for our entire product line. We have inventory locations and control, work order tracking, prioritization of work and the ability to track labor and inventory costs.”

Increased Visibility

Since going live with Rootstock, Northeast Lantern has enjoyed increased information visibility and are slowly working to improve their data and reporting abilities.

“For example,” says Plante, “in May of 2019, we started using the clock on/off feature to track labor costs and have begun to accumulate data to improve the accuracy of our standard operation times.

Updating these times will allow us to improve our capacity planning in the future.”

Dashboards

Northeast Lantern also likes the dashboard and reporting features of Rootstock. “We are increasing our use of dashboards and the graphical displays that are available, and we are presenting that information,” reports Dustin Almon. “We recently started sharing one of the dashboards in the break room so the employees can see orders that are scheduled that week, what has already been shipped, any overdue orders, and work orders completed by week.”

Employee Reactions

Northeast Lantern employs both older and younger workers. While the younger workers have embraced Rootstock Cloud ERP as just another part of doing their jobs, it took a little longer and a little more training for the older workers to adapt. The company says that everyone views the new system as a positive improvement.

The company’s Customer Service department has been especially receptive to using Rootstock. Says Plante, “If you go down to customer service, they’re probably going to tell you how much they love it, because it puts everything in one spot.” Before Rootstock, Northeast Lantern customer service reps had to hop back and forth to find information in emails and manual Accounts Payable files. Now, these reps can access important customer and service information on a single screen.

The most valuable benefits of running Rootstock Cloud ERP have been increased visibility into their data and the automation of formerly manual processes.

Connecting with the Rootstock Community

The Rootstock Community is an online portal designed to connect, facilitate communication, and share information among customers, partners and Rootstock. It lets users log support cases, log and track enhancement requests, access product documentation, release information and FAQs, and most importantly, start product discussions and collaborate with other community members.

For Northeast Lantern, the Rootstock Community is a key resource. “I do like the potential of the new Rootstock Community. It’s going to play a crucial role in our use of Rootstock,” says Almon. “It’s a good resource to see who’s doing what because the system is so customizable, and it’s helpful to see how other people are using certain features.”

If you go down to customer service, they’re probably going to tell you how much they love it, because it puts everything in one spot.

– STEVEN PLANTE, PRODUCT DEVELOPMENT ENGINEER

Summary

There is no doubt that Rootstock Cloud ERP has helped Northeast Lantern abandon management by spreadsheet in favor of a more customizable, more efficient and less costly solution.

Northeast Lantern is planning to expand their use of Rootstock in the future to other areas as well.

“The more we use the system, the more familiar we become with the available features,” explains Plante. “As we become more familiar, we are looking to become more sophisticated in how we use the system.”

We recently started sharing one of the dashboards in the break room so the employees can see orders that are scheduled that week, what has already been shipped, any overdue orders, and work orders completed by week.

– DUSTIN ALMON, OPERATIONS MANAGER

Download the Case Study

Click here to download the Rootstock Software Case Study “Northeast Lantern: From Spreadsheets to Cloud ERP.”

About Northeast Lantern

Northeast Lantern exists to provide high quality solid brass and copper lighting fixtures through highly skilled and dedicated employees, excellent customer service and proficient manufacturing processes. Northeast Lantern offers a lifetime guarantee and unique ability to customize any fixtures to ensure confidence and satisfaction with customers. Northeast Lantern continually innovates and improves American made lighting fixtures to maintain a competitive edge in the industry and keep up with market demands. Over 20% of the company’s lanterns are custom. Northeast Lantern sells their finely crafted products through a network of US and Canadian authorized dealers.

To learn more about the Northeast Lantern, please visit northeastlantern.com.

More Customer Success Stories

Architectural Fabrication: The Power of Real-Time ERP Reporting & Data Visibility

Architectural Fabrication: The Power of Real-Time ERP Reporting & Data Visibility

Architectural Fabrication is an established shade solutions company located in Fort Worth, Texas. It has been around for more than two decades, providing custom solutions for canopies, sunshades, walkways, and several other architectural elements that enhance the look of buildings. The company has made the Inc. 5000 list of fastest growing private companies for three years running. It partners with general contractors, architects, and engineers to provide manufacturing, design and installation services. In fact, it works with some of the largest architectural firms, general contractors, and retailers in the U.S. If a customer can conceive it, Architectural Fabrication can deliver it, turning a drawing or idea into a custom solution.
BACA Systems, Inc.: Rootstock Cloud ERP is the De Facto Choice for Long Term Success on Salesforce

BACA Systems, Inc.: Rootstock Cloud ERP is the De Facto Choice for Long Term Success on Salesforce

BACA Systems Inc., based in Orion Township, Michigan, is known for Innovative Fabrication Solutions for Industrial Stone Automation. BACA’s dedicated team of experts provide industrial-sized solutions in Robotic Automation, System Integration, WaterJet Technology and Countertop Fabrication. BACA Systems, an industry front runner, gives seminars in how to set up a shop with the right templating, sawing, edge finishing and water treatment equipment to increase profits and to reduce labor costs.
Boston Dynamics Achieves Fundamental Business Transformations with Rootstock Cloud ERP & Salesforce

Boston Dynamics Achieves Fundamental Business Transformations with Rootstock Cloud ERP & Salesforce

Boston Dynamics is an American engineering and robotics design company founded in 1992 out of MIT (Massachusetts Institute of Technology.) Once owned by Google, they are still located in Massachusetts. Boston Dynamics offers a highly advanced robotic line; their engineers design robotics nimble enough to climb stairs, master a multitude of warehouse tasks, and traverse remote areas and terrain using a 360-degree view.
Equipter shows 30% growth year over year since implementing Rootstock

Equipter shows 30% growth year over year since implementing Rootstock

Equipter/New Heights LLC (Paradise, PA) is an American-owned, family-run business that designs and manufactures state of the art equipment to help businesses in construction, general contracting, residential roofing, commercial roofing and more improve debris removal and in turn improve efficiency. Their flagship product is the Equipter RB4000 (The Roof Buggy), a drive-able, raise-able, tow-able and dump-able construction and roofing vehicle that can fit into tight areas, streamlines the removal of roofing debris and makes jobsite cleanup faster and easier.
Northeast Lantern: From Spreadsheets to Cloud ERP

Northeast Lantern: From Spreadsheets to Cloud ERP

Northeast Lantern exists to provide high quality solid brass and copper lighting fixtures through highly skilled and dedicated employees, excellent customer service and proficient manufacturing processes. Northeast Lantern offers a lifetime guarantee and unique ability to customize any fixtures to ensure confidence and satisfaction with customers. Northeast Lantern continually innovates and improves American made lighting fixtures to maintain a competitive edge in the industry and keep up with market demands. Over 20% of the company’s lanterns are custom. Northeast Lantern sells their finely crafted products through a network of US and Canadian authorized dealers.
OSI – A Modern Foundation for High Quality Pharmaceutical Manufacturing

OSI – A Modern Foundation for High Quality Pharmaceutical Manufacturing

Osoth Inter Laboratories Co., Ltd. (OSI), headquartered in Thailand, is a high-quality manufacturer of pharmaceutical and dietary supplements and a subsidiary of the SAHA group, a multi-business/cosmetics and consumer product manufacturer.
When Planning for Its New Manufacturing ERP, Pacer Group Planned for Success

When Planning for Its New Manufacturing ERP, Pacer Group Planned for Success

Established in 1979, Pacer Group (Sarasota, Fla.), is a leading wire and electrical cable manufacturer that offers custom electrical products, value-added solutions and parts distribution. The Pacer group of companies has expanded beyond its traditional marine industry focus at its 42,000 square-foot manufacturing, assembly and warehouse complex in Sarasota. Our array of capabilities begins with wire and cable manufacturing and progresses with customer focused solutions such as battery cable assembly, wire harness assembly, instrument and dash panel design, and complete electrical system integration.
Perpetua Advisors: Next Gen ERP Platform Advice for the Next Generation of your Business

Perpetua Advisors: Next Gen ERP Platform Advice for the Next Generation of your Business

Perpetua Advisors helps manufacturers digitally transform their business eco-systems through the effective expansion of reliable data. Core to their success is helping clients pivot away from traditional technology solutions that deliver siloed and fragmented data and move towards achieving long-term digital transformation success using unified data. Hear from Chief Digital Officer & Co-Founding Partner, Mike Wind, to learn how Perpetua advises their customers on the selection of a proven cloud platform with Salesforce and Rootstock to deliver one common data model that empowers customers and suppliers with timely, high-quality data.
Pioneer’s CRM and ERP now roll smoother on one cloud platform

Pioneer’s CRM and ERP now roll smoother on one cloud platform

Pioneer Motor Bearing provides original equipment manufacturers (OEMs) and end users with first-class bearing engineering, manufacturing and repair expertise. Its mission is to help them design, build, maintain and upgrade large rotating equipment to operate more efficiently and reliably over an extended life. Products include turbine and generator bearings operating in nuclear power stations, very large vertical guide and thrust bearing assemblies operating in some of the largest hydroelectric plants in North America, patented designs for small tilting pad radial bearings for high speed lightly loaded rotating machinery, and new and repaired bearings for the U.S. Navy.
Pro-Tech Cleans Up Software System with Cloud ERP

Pro-Tech Cleans Up Software System with Cloud ERP

Pro-Tech Manufacturing and Distribution, Inc. (Rochester, NY) revolutionized the snow and ice management industry when they launched the Rubber Edge Sno Pusher in 1994, which has helped thousands of snow and ice companies across North America move more snow faster, thereby increasing efficiency and profitability. Since then, they have never stopped working to craft the perfect containment plow, striving to increase the already extreme durability and functionality of their product line.
SPR Therapeutics Revolutionizes Customer Excellence with Next-Gen Cloud Platform

SPR Therapeutics Revolutionizes Customer Excellence with Next-Gen Cloud Platform

SPR Therapeutics is committed to improving the lives of millions of pain sufferers with its peripheral nerve stimulation (PNS) platform technology poised to be the standard of care and ultimately, the treatment of choice for pain management.

Led by a world-class team of scientists, physicians, and business professionals with a track record of commercializing innovative neurostimulation products, SPR’s PNS therapy for acute and chronic pain management provides a non-narcotic, reversible, safe, effective and more affordable alternative to addictive opioid medications and invasive surgeries.
Summit Imaging - Removing Obstacles to Growth with Rootstock and Salesforce

Summit Imaging - Removing Obstacles to Growth with Rootstock and Salesforce

Summit Imaging (Woodinville, WA) is a technology-focused ultrasound medical equipment support company. It offers end-to-end customer support, including hands-on training courses, fast repairs, high quality parts replacement, free 24/7 technical support, the longest warranty on parts and services in the industry and the ability to diagnose most problems over the phone in under 7 minutes. Summit Imaging constantly strives to improve the customer experience and because of their outstanding reputation, has grown by over 60% year over year to become the very best in their industry. The company recently received ISO 13485:2003 and ISO 9001:2008 certifications from The National Standards Authority of Ireland (NSAI) for its repair and support services of ultrasound medical equipment.
Swift Straw - Using Native Cloud ERP Technology to Scale Rapid Business Growth

Swift Straw - Using Native Cloud ERP Technology to Scale Rapid Business Growth

Swift Straw has earned its reputation as “the ground cover specialists” in the American Southeast. With a focus on pine straw and mulch products, the largest beautification components for landscaping nationwide, Swift Straw has created a method to package pine straw in compact easy-to-handle bales that allow for new market expansion across the country.

Headquartered in Atlanta, GA, Swift Straw is the largest pine straw distributor in America. They ship and install pine straw and mulch products to a diverse client list of landscapers, private and commercial real estate projects, hotels, homeowner associations, schools, parks, and more.
Supporting Explosive Growth with Rootstock Cloud ERP

Supporting Explosive Growth with Rootstock Cloud ERP

Tilray, Inc. is a leading global cannabis-lifestyle and consumer packaged goods company with operations in Canada, the United States, Europe, Australia, and Latin America that is changing people’s lives for the better – one person at a time – by inspiring and empowering the worldwide community to live their very best life by providing them with products that meet the needs of their mind, body, and soul and invoke a sense of wellbeing.
Unionwear Improves Production Capacity Planning with Rootstock & Salesforce

Unionwear Improves Production Capacity Planning with Rootstock & Salesforce

Unionwear is the trade name, URL and DBA of New Jersey Headwear Corp., which manufactures and embroiders headwear, bags, accessories, work wear and safety gear. Unionwear currently operates a 45,000 sq. ft. manufacturing facility in Newark. Unionwear sells through a nationwide network of several hundred promotional products distributors. As the premium paid for domestic production shrinks, more and more markets are enforcing labor standards in their procurement, such as colleges, federal, state, and local governments, as well as corporations with strong union workforces – for employee gear, and non-profits. For the past ten years, Unionwear has focused on providing products to clients requiring products to be made in the USA and is not forced to compete with imports on price. The US military and federal government accounts for half of the business with clients like labor unions and presidential campaigns representing much of the balance.
UTG Mixing Group stirs up ERP from scratch

UTG Mixing Group stirs up ERP from scratch

Uutechnic OY - founded in 1993 and headquartered in Finland - specializes in the demanding technology of mixing solutions. Specially manufactured to meet almost any specific heavy industrial need, Uutechnic’s equipment-solutions serve a variety of large capacity conditions. Uutechnic has developed into a respected global brand for mixing technology and serves mining, fertilizing, pulp/paper processing, and chemical industry clients.