Glenday Sieve Report

The Glenday Sieve Report helps you understand which products contribute the most to your sales or stock movement.

It highlights the “vital few” SKUs that drive the majority of your business activity, while also showing the long tail of items that add less value.

This approach is based on the Glenday Sieve method, which is similar to the Pareto principle (80/20 rule) but provides sharper insight into SKU importance. It is commonly used to focus resources, simplify operations, and make smarter stock management decisions.

---

🔎 Running the Report

To generate the report, the user must select:

• Date Range – the period for which sales or movement data should be analyzed.

---

📋 Report Columns Explained

The Glenday Sieve Report includes the following fields:

🏅 Rank

• The position of the SKU based on its contribution (highest to lowest).

---

🔖 SKU

• The unique identifier for the product being analyzed.

---

📝 Description

• A readable name or description of the product.

---

💵 Total Value

• The total sales value generated by the SKU in the selected date range.

---

📦 Total Qty

• The total quantity of the SKU sold or moved in the period.

---

📊 % of Volume Total

• The percentage of the SKU’s quantity relative to the total volume of all SKUs.

---

📈 Cumulative Volume %

• The running total percentage as SKUs are ranked from highest to lowest.

• Used to identify which products are top contributors and which fall into lower-impact groups.

---

🏷️ Volume Category

• The classification assigned to the SKU based on its cumulative contribution.

• This category helps identify which SKUs to prioritize (high impact) and which may be candidates for reduced focus or rationalization.

---

✅ How to Use the Glenday Sieve Report

• Focus on Key Products: Identify and prioritize the small set of SKUs that generate the majority of volume or value.

• Optimize Inventory: Ensure your highest-impact products are always in stock and supported with strong forecasting.

• Simplify Operations: Reduce complexity by managing lower-volume SKUs differently (e.g., special order only, lower stock levels).

• Strategic Planning: Use the Volume Category to guide business decisions, ensuring resources are aligned with your most important products.