Demand_Planning_System.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	📥 HISTORICAL SALES DATA — Enter actual units sold per SKU per month
2	Data Year:	2024
3	SKU Code	Product Name	Category	Unit	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Annual Total	Monthly Avg
4	SKU-001	Premium Juice 1L	Beverages	Bottle	8,200	7,800	9,100	9,500	10,200	11,500	12,000	11,800	10,500	9,800	11,200	14,000	125,600	10,466.7
5	SKU-002	Mineral Water 500ml	Beverages	Bottle	15,000	14,200	16,500	17,000	18,500	21,000	23,000	22,500	19,800	17,500	19,000	25,000	229,000	19,083.3
6	SKU-003	Energy Drink 250ml	Beverages	Can	5,500	5,200	6,000	6,500	7,200	8,100	8,800	8,600	7,500	6,800	7,200	9,500	86,900	7,241.7
7	SKU-004	Canned Sardines 155g	Food	Can	12,000	11,500	13,000	13,500	14,000	14,500	15,000	14,800	13,500	13,000	14,500	18,000	167,300	13,941.7
8	SKU-005	Instant Noodles 65g	Food	Pack	22,000	21,000	24,000	25,000	26,000	27,000	28,000	27,500	25,000	24,000	26,000	32,000	307,500	25,625.0
9	SKU-006	Cooking Oil 1L	Food	Bottle	9,500	9,000	10,500	11,000	11,500	12,000	12,500	12,200	11,000	10,500	12,000	15,000	136,700	11,391.7
10	SKU-007	Detergent Powder 1kg	Household	Pack	7,200	6,800	7,800	8,000	8,500	8,800	9,200	9,000	8,200	7,800	8,500	11,000	100,800	8,400.0
11	SKU-008	Fabric Conditioner 500ml	Household	Bottle	5,800	5,500	6,200	6,500	7,000	7,200	7,500	7,300	6,800	6,500	7,000	9,000	82,300	6,858.3
12	SKU-009	Shampoo 200ml	Personal Care	Bottle	6,500	6,200	7,000	7,200	7,800	8,000	8,500	8,300	7,500	7,000	7,800	10,000	91,800	7,650.0
13	SKU-010	Soap Bar 90g	Personal Care	Piece	18,000	17,000	19,500	20,000	21,000	22,000	23,000	22,500	20,500	19,500	21,000	27,000	251,000	20,916.7
14	TOTAL (All SKUs)				109,700	104,200	119,600	124,200	131,700	140,100	147,500	144,500	130,300	122,400	134,200	170,500	1,578,900	131,575
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100