Item Summary

Rank items by contribution, variability, and planning significance within each batch.

← Back to Reports

Executive framing

Executive Summary — Answer First

Decision rule: review this page first, then move to deeper drill-down only when the result is economically meaningful.

Use this report to identify the few SKUs that drive most of the forecast.
Separate high-volume core items from low-volume tail items before acting.
Direct planner attention to the top contributors first; they carry the largest service and working-capital exposure.

SCQA / Context

Situation: item-level demand is distributed unevenly across the portfolio. Complication: teams often spend too much time on low-value SKUs. Question: which items drive the forecast and deserve management attention? Answer: rank items by total quantity, density of forecast points, and volatility.

Issue Tree / Diagnosis

Volume concentration: which items dominate total units
Stability: average, min, max, and dispersion by item
Resource allocation: which items deserve review and supplier alignment

Analysis & Insights

The highest-volume items typically drive the majority of inventory exposure and service risk.
Items with both high volume and high volatility deserve the most review.
Low-volume tail items may be managed with lighter governance unless they are margin-critical or constrained.

Recommendations

Classify items into A/B/C tiers using total forecast quantity.
Apply tighter review cadence to the top 10 to 20 items.
Pair this report with volatility and spike detection for exception management.

KPIs

Total quantity by item
Average quantity per forecast point
Forecast point count per item
Top-item share of total forecast

Implementation Roadmap

Phase	Key action	Owner	Success metric
1. Review	Run the report and isolate the highest-value exceptions.	Planning / Operations	Material issues identified within one review cycle.
2. Validate	Confirm whether the result reflects real business change, timing shift, or data-quality issue.	Forecast owner	Exceptions explained and documented.
3. Act	Translate validated findings into supply, capacity, purchasing, or governance actions.	Cross-functional team	Action owners assigned with due dates.

Risks, Gaps, and Next Steps

Do not treat a statistical exception as a business conclusion without validating the commercial or operational driver.
Where economics are missing, pair this page with item margin, lead time, or inventory exposure before escalating.
Use the summary line above the grid to confirm row volume; unexpected row counts often indicate filter or data issues.

Run Report

This report does not require filters.

146 row(s) returned.

Analysis output

Data Table

Use the table below to validate the hypothesis, size the issue, and identify the items or periods that need action.

ForecastBatchID	ItemCode	ForecastPoints	TotalForecastQty	AvgForecastQty	MinForecastQty	MaxForecastQty
7	V20255AX	10	142,003	14,200.3	4,000	20,000
7	VS25255X	9	113,156	12,572.9	5,156	16,000
7	V25255AX	10	94,090	9,409.0	4,000	12,000
7	VX10155	10	69,000	6,900.0	1,000	9,000
7	UVX07255	9	53,000	5,888.9	3,000	8,000
7	VS20255X	10	50,000	5,000.0	5,000	5,000
7	VX07155	10	49,000	4,900.0	2,000	7,000
7	UVX10255	9	44,000	4,888.9	4,000	6,000
7	300FX	13	36,002	2,769.4	502	4,000
7	VX30255	8	32,000	4,000.0	1,000	11,000
7	300XPL	11	24,345	2,213.2	845	3,000
7	VSF30264X	10	19,900	1,990.0	1,400	2,400
7	VX25355B	18	19,800	1,100.0	500	1,700
7	300EX	11	18,800	1,709.1	1,100	2,500
7	UVX20255	10	17,000	1,700.0	1,000	2,500
7	M300AX	4	15,200	3,800.0	2,000	4,800
7	WSF20264X	14	15,000	1,071.4	1,000	2,000
7	VFT25254X	4	11,042	2,760.5	1,000	4,000
7	DM20254MX	2	7,000	3,500.0	3,000	4,000
7	V20255BX	1	6,200	6,200.0	6,200	6,200
7	300FBX	2	2,800	1,400.0	1,400	1,400
7	SWX102	7	2,700	385.7	200	500
7	UV20257FDX	5	2,500	500.0	500	500
7	VF25356X	2	1,400	700.0	400	1,000
7	MV20354SX	1	100	100.0	100	100
8	V20255AX	8	148,000	18,500.0	16,000	20,000
8	VS25255X	10	124,000	12,400.0	8,000	16,000
8	V25255AX	11	96,051	8,731.9	51	12,000
8	VX10155	9	64,000	7,111.1	5,000	9,000
8	UVX07255	10	62,000	6,200.0	2,000	9,000
8	VS20255X	11	55,074	5,006.7	5,000	5,074
8	VX07155	9	54,000	6,000.0	1,000	8,000
8	UVX10255	10	51,000	5,100.0	1,000	9,000
8	300FX	14	42,002	3,000.1	2	4,300
8	300XPL	12	29,972	2,497.7	1,500	3,500
8	VX30255	8	28,000	3,500.0	2,000	10,000
8	VX25355B	18	21,100	1,172.2	500	2,800
8	WSF20264X	17	19,000	1,117.6	1,000	2,000
8	M300AX	4	18,400	4,600.0	3,000	5,500
8	VSF30264X	10	16,700	1,670.0	500	2,100
8	300EX	11	16,524	1,502.2	1,000	2,300
8	VFT25254X	4	15,000	3,750.0	2,000	5,000
8	V20255BX	2	12,400	6,200.0	6,200	6,200
8	UVX20255	5	11,464	2,292.8	2,000	3,464
8	DM20254MX	2	9,400	4,700.0	4,600	4,800
8	SWX102	7	3,100	442.9	300	600
8	UV20257FDX	5	2,500	500.0	500	500
8	VF25356X	2	1,600	800.0	400	1,200
8	MV20354SX	1	400	400.0	400	400
8	300FBX	1	100	100.0	100	100
9	V20255AX	12	133,516	11,126.3	4,000	20,000
9	VS25255X	9	100,000	11,111.1	4,000	16,000
9	V25255AX	9	84,000	9,333.3	4,000	12,000
9	VX07155	10	57,000	5,700.0	3,000	7,000
9	VX10155	10	57,000	5,700.0	4,000	8,000
9	VS20255X	11	50,068	4,551.6	68	5,000
9	UVX07255	9	48,299	5,366.6	299	7,000
9	UVX10255	8	42,000	5,250.0	4,000	6,000
9	300FX	12	32,511	2,709.3	1,000	3,800
9	VX30255	8	27,000	3,375.0	1,000	9,000
9	300EX	10	18,700	1,870.0	1,300	2,800
9	VX25355B	18	18,491	1,027.3	500	1,400
9	VSF30264X	11	17,356	1,577.8	56	2,100
9	WSF20264X	17	17,000	1,000.0	1,000	1,000
9	M300AX	5	15,707	3,141.4	7	5,400
9	VFT25254X	4	14,000	3,500.0	3,000	4,000
9	UVX20255	7	13,500	1,928.6	1,000	2,500
9	300XPL	7	12,500	1,785.7	1,000	2,000
9	V20255BX	2	12,400	6,200.0	6,200	6,200
9	DM20254MX	2	8,600	4,300.0	4,100	4,500
9	SWX102	7	3,000	428.6	400	500
9	UV20257FDX	5	2,340	468.0	340	500
9	VF25356X	2	1,700	850.0	700	1,000
9	MV20354SX	1	600	600.0	600	600
9	300FBX	1	400	400.0	400	400
10	V20255AX	8	124,000	15,500.0	8,000	20,000
10	VS25255X	10	96,000	9,600.0	8,000	12,000
10	V25255AX	8	80,000	10,000.0	8,000	12,000
10	VX10155	9	57,000	6,333.3	3,000	10,000
10	VX07155	9	49,000	5,444.4	1,000	7,000
10	UVX07255	8	47,000	5,875.0	2,000	8,000
10	VS20255X	9	45,068	5,007.6	5,000	5,068
10	UVX10255	8	42,000	5,250.0	2,000	7,000
10	300FX	10	28,100	2,810.0	1,500	3,800
10	VX30255	7	28,000	4,000.0	2,000	10,000
10	300EX	10	18,600	1,860.0	1,400	2,800
10	VX25355B	16	16,354	1,022.1	500	1,400
10	VSF30264X	9	15,500	1,722.2	1,100	2,100
10	M300AX	4	15,300	3,825.0	1,900	4,900
10	WSF20264X	15	15,048	1,003.2	48	2,000
10	VFT25254X	4	14,000	3,500.0	3,000	4,000
10	UVX20255	6	13,000	2,166.7	2,000	2,500
10	300XPL	6	12,000	2,000.0	2,000	2,000
10	DM20254MX	2	8,700	4,350.0	4,000	4,700
10	V20255BX	1	6,200	6,200.0	6,200	6,200
10	SWX102	7	2,800	400.0	200	500
10	VF25356X	2	1,700	850.0	600	1,100
10	300FBX	1	700	700.0	700	700
10	MV20354SX	1	600	600.0	600	600
11	V20255AX	9	120,000	13,333.3	4,000	16,000
11	VS25255X	9	96,000	10,666.7	4,000	12,000
11	V25255AX	12	88,000	7,333.3	4,000	12,000
11	VX07155	11	50,896	4,626.9	3,000	7,000
11	VS20255X	9	50,068	5,563.1	3,068	12,000
11	VX10155	11	48,347	4,395.2	451	7,000
11	UVX07255	8	43,000	5,375.0	2,000	7,000
11	UVX10255	8	34,000	4,250.0	2,000	5,000
11	VX30255	10	33,000	3,300.0	1,000	8,000
11	300FX	10	27,500	2,750.0	2,000	3,500
11	300EX	12	20,600	1,716.7	1,000	3,000
11	300XPL	8	17,500	2,187.5	1,000	3,000
11	WSF20264X	17	17,048	1,002.8	48	2,000
11	VSF30264X	8	16,900	2,112.5	1,300	5,000
11	VX25355B	18	15,653	869.6	246	1,300
11	M300AX	3	13,562	4,520.7	3,700	5,862
11	V20255BX	2	12,400	6,200.0	6,200	6,200
11	VFT25254X	5	12,000	2,400.0	1,000	3,000
11	UVX20255	6	11,000	1,833.3	1,000	2,000
11	DM20254MX	3	6,068	2,022.7	68	4,000
11	SWX102	8	3,000	375.0	100	500
11	VF25356X	2	2,700	1,350.0	1,200	1,500
11	MV20354SX	1	600	600.0	600	600
12	V20255AX	9	116,000	12,888.9	4,000	20,000
12	VS25255X	9	100,000	11,111.1	8,000	12,000
12	V25255AX	10	84,726	8,472.6	726	12,000
12	VX07155	10	50,000	5,000.0	1,000	6,000
12	UVX07255	8	46,000	5,750.0	5,000	7,000
12	VX10155	9	44,977	4,997.4	1,977	7,000
12	VS20255X	9	42,046	4,671.8	2,046	5,000
12	UVX10255	8	39,000	4,875.0	4,000	6,000
12	300FX	11	29,500	2,681.8	2,000	3,200
12	VX25355B	19	20,153	1,060.7	500	1,600
12	300XPL	8	17,000	2,125.0	1,500	3,000
12	300EX	10	15,500	1,550.0	1,100	2,500
12	M300AX	4	15,062	3,765.5	1,400	5,862
12	V20255BX	2	12,400	6,200.0	6,200	6,200
12	VSF30264X	8	12,400	1,550.0	1,100	2,100
12	WSF20264X	12	12,394	1,032.8	394	2,000
12	VFT25254X	4	12,000	3,000.0	1,000	4,000
12	UVX20255	6	10,000	1,666.7	1,000	2,000
12	DM20254MX	3	8,043	2,681.0	500	4,100
12	VX30255	1	2,904	2,904.0	2,904	2,904
12	SWX102	8	2,800	350.0	200	400
12	300FBX	2	2,100	1,050.0	500	1,600
12	MV20354SX	2	1,600	800.0	100	1,500
12	VF25356X	1	320	320.0	320	320