Rootstock Software > Case Studies > Northeast Lantern: From Spreadsheets to Cloud ERP

Northeast Lantern: From Spreadsheets to Cloud ERP

Rootstock Software Logo
Company Size
11-200
Region
  • America
Country
  • United States
Product
  • Rootstock Cloud ERP
Tech Stack
  • Cloud-based ERP
  • Salesforce Platform
  • QuickBooks
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Cost Savings
  • Productivity Improvements
Technology Category
  • Functional Applications - Enterprise Resource Planning Systems (ERP)
Applicable Industries
  • Electronics
Applicable Functions
  • Discrete Manufacturing
Use Cases
  • Inventory Management
  • Manufacturing System Automation
Services
  • Cloud Planning, Design & Implementation Services
  • System Integration
About The Customer
Northeast Lantern is a company based in Exeter, New Hampshire, that has been manufacturing and selling handcrafted, solid brass and copper lighting fixtures since 1987. The company employs 45 people and produces high-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.
The Challenge
Northeast Lantern, a manufacturer of handcrafted, solid brass and copper lighting fixtures, was relying on a system of management by spreadsheet. As the company grew, the spreadsheets became more of a problem than a solution. With no formal system for inventory or engineering and no single database, the company was struggling with growth. They had no control over their inventory because they didn’t know at any one time what they had in inventory for a specific part, finished good or subassembly. Reporting was also a manual task that was time-consuming and inefficient. The company knew that further growth would require a modern ERP solution.
The Solution
Northeast Lantern chose Rootstock Cloud ERP to replace 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 to get control of inventory and production inefficiencies. Rootstock Cloud ERP offered several advantages including MRP, Sandbox, QuickBooks integration, and Salesforce Platform. The implementation process was slow due to the lack of an original database, over 25,000 individual SKUs, and limited resources. However, the company spent a lot of time preparing their data to ensure the accuracy of their data once the new system was up and running.
Operational Impact
  • Increased visibility into their data and the automation of formerly manual processes.
  • All of the company's information is now in a single database.
  • The company now has part numbers and BOMs for their entire product line.
  • The company has inventory locations and control, work order tracking, prioritization of work and the ability to track labor and inventory costs.
  • The company has increased its use of dashboards and the graphical displays that are available.
Quantitative Benefit
  • The company has over 25,000 individual SKUs in their database.
  • Over 20% of their products are customized pieces.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.