Gaining visibility of trends in customer demand is important for any business but for a company with lead times of up to a year, it is essential. Internationally renowned piano manufacturer Steinway & Sons is using PrecisionPoint business intelligence software to gain unprecedented insight into sales and inventory from its Microsoft Dynamics Navision (NAV) ERP solution.
PrecisionPoint enables sales to be analyzed in multiple dimensions: by product type, size, finish, dealer and customer type – domestic or institution. Indeed, Steinway & Sons is even analyzing which products are most popular for performance venues, and which for practice rooms. Combining data from disparate sources, including a dealer targets database, enables the company to track dealer performance, also by product and market.
As a result of this insight, the company has been able to reduce its inventory levels and improve its understanding of the evolving trends in customer demands.
Steinway & Sons
Founded in 1853 in a Manhattan loft, Steinway & Sons is credited with the development of the modern piano. The pianos have always been built one at a time, with skills handed down from master to apprentice. Today, the company produces around 2,500 pianos each year, and still builds its pianos in the same way, both in New York and Hamburg.
While production values remain unchanged, the market for pianos has evolved somewhat in recent years, including demands for different styles and sizes, as well as in response to the economic downturn. As Gary Conte, Director of Product Distribution, Steinway & Sons, explains, “While home ownership of pianos has declined a little, there is still a very strong institutional market demonstrating good demand for new instruments for music schools and performance venues, especially in the US.”
With manufacturing located in two of the most expensive cities in the world, Steinway & Sons needs to keep close control over production costs; while escalating distribution costs are also a concern for this truly international operation. And with products sold via a network of distributors across the globe, it is also important to keep track of trends in dealer performance against targets by territory, market type and product style.
In common with many manufacturing companies, Steinway uses the Microsoft Dynamics NAV ERP solution. However, Conte explains, “While NAV is very good at collecting data it is not good at retrieving information. NAV provides some standard canned reports but to gain any real insight demands extensive work in Microsoft Query. Trying to understand how the tables and fields are set up and how to link tables makes this process very challenging for non IT users.”
Rather than spending hours hand-crafting queries, Steinway & Sons opted to implement PrecisionPoint for Microsoft Dynamics NAV business intelligence software. “I am not an IT person, but I find PrecisionPoint very easy to use,” says Conte. “The data required is summarized in a cube and I can access that cube with no need to understand the underlying data structure.”
Steinway & Sons is primarily using PrecisionPoint for monthly sales and inventory reporting, as well as ad hoc reports in response to specific business requests. Sales are analyzed in multiple dimensions: by product type, piano size and finish, as well as geography. These reports are distributed throughout the organisation, from the overall Company President to District Sales Managers, the New York operations President and the entire marketing team.
“The monthly reports could not be simpler: I select the current month and all the reports are immediately updated. There is no need to worry about importing or reformatting data,” Conte confirms. “Using PrecisionPoint enables Steinway & Sons to reveal valuable trends in product demand – by size and between different product lines. It also reveals the way customer preferences are changing, such as the shift towards smaller pianos and the demand for black rather than natural woods.”
The company is also tracking where products are used – for example, which models are purchased by music schools for performance venues, and which for practice rooms. As Conte says, “PrecisionPoint makes it so much easier to grab that information from NAV and work with it.”
Multiple Information Sources
Steinway & Sons is also able to combine multiple sources of information – including a database holding dealer targets – to gain further business insight. Conte says, “The ability to track dealer performance over time and against target, for specific products and within both domestic and institutional markets, is invaluable. Using PrecisionPoint it is very simple to pull information from multiple sources and merge it into a single consolidated dealer performance report.”
In addition, Steinway & Sons routinely undertakes ad hoc reports to meet specific business requests – such as analysis of sales across South America, by country and product.
With each grand piano taking nearly a year to create, and lead times on even standard pianos upwards of six months, it is becoming ever more important to improve understanding of sales trends to ensure production meets customer demand down the line. Furthermore, given the changing market it is also important to avoid unwanted inventory where possible.
The use of PrecisionPoint has enabled Steinway & Sons to radically reduce the value of its US inventory, using trends in sales history to optimize inventory while still satisfying orders from dealers in a timely fashion. “Inventory analysis is incredibly straightforward using PrecisionPoint. Steinway & Sons was able to reduce inventory value significantly and has been able to track to target inventory levels year on year. Over the last three years, we have been able to reduce our finished goods inventory by over 10%” says Conte.
Throughout its use of PrecisionPoint, Steinway & Sons has retained a strong relationship with the company, embarking upon periodic training courses to ensure staff are exploiting the latest functionality and features. Looking forward, Steinway & Sons plans to further improve forecasting, combining insight into market change with additional sources such as dealer promotional activity to become more effective at predicting demand.
As Conte concludes, “PrecisionPoint is an incredibly efficient way of accessing the data within NAV to gain valuable business insight. In an evolving business, with long lead times, improving this understanding of trends in customer demand is a key component of Steinway & Sons’ on-going business planning.”