Simplifying the Complex Process of Data Integration

To keep up with all of this data, Holody and the PalmBeach Jewelry staff identified 14 key performance indicators (KPIs) that provide information they can act on when it comes to the company's merchandise. These include the following:

• initial item fill rate;
• initial order fill rate;
• final item fill rate;
• final order fill rate;
• percentage of back orders filled by week (PalmBeach Jewelry is currently measuring 32 percent of back orders filled within one week);
• inventory value by grade;
• inventory value by product category;
• inventory value by promotional type (e.g., clearance items vs. nonclearance items; web-only items vs. items that appear both in the catalog and online);
• inventory value by age of inventory — which is critical to turning over inventory properly, Holody said;
• percentage of back-order cancellations (i.e., lost sales);
• order forecast accuracy;
• item forecast accuracy;
• inventory turns by grade; and
• inventory turns by product category.

If this seems like a lot to track, consider that PalmBeach Jewelry has pared down the number of KPIs it's tracked in recent years. “We've eliminated a lot of categories that the company found out weren't actionable,” said Holody, noting that the company will likely pare back the number of KPIs to 12 by this time next year.