Indicadores_Demanda.xlsx

	A	B	C	D	E	F
1
2	SALES FORECAST ACCURACY
3
4	SKU	Previsão	Faturado	Desv. Abs	SFA	BIAS

5	Item 1	3.762	3.135	627	83%	20%
6	Item 2	432	0	432	0%	100%
7	Item 3	2.565	3.705	1.140	56%	-31%
8	Item 4	2.228	2.228	0	100%	0%
9	Item 5	5.508	4.860	648	88%	13%
10	Item 6	130	130	0	100%	0%
11	Item 7	7.980	11.951	3.971	50%	-33%
12	Item 8	2.625	0	2.625	0%	100%
13	Item 9	5.655	5.145	511	91%	10%
14	Item 10	760	0	760	0%	100%
15	Item 11	360	0	360	0%	100%
16	Item 12	935	680	255	73%	38%
17	Item 13	1.300	600	700	46%	117%
18	Item 14	4.800	5.200	400	92%	-8%
19	Item 15	85	85	0	100%	0%
20	Item 16	3.100	6.000	2.900	6%	-48%
21	Item 17	4.600	8.200	3.600	22%	-44%
22	Item 18	85	170	85	0%	-50%
23	Item 19	1.400	220	1.180	16%	536%
24	Item 20	400	480	80	80%	-17%
25	Item 21	1.364	341	1.023	25%	300%
26	Item 22	4.851	6.237	1.386	71%	-22%
27	Item 23	68	68	0	100%	0%
28	Item 24	432	432	0	100%	0%
29	Item 25	114	190	76	33%	-40%
30	Item 26	350	0	350	0%	100%
31	Item 27	144	216	72	50%	-33%
32	Item 28	432	432	0	100%	0%
33	Item 29	855	1.425	570	33%	-40%
34	Item 30	1.080	0	1.080	0%	100%
35	Item 31	2.556	2.412	144	94%	6%
36	Item 32	7.040	3.772	3.268	54%	87%
37	Item 33	1.600	0	1.600	0%	100%
38	Item 34	2.448	2.520	72	97%	-3%
39	Item 35	432	432	0	100%	0%
40	Item 36	380	760	380	0%	-50%
41	Item 37	304	0	304	0%	100%
42	Item 38	2.280	2.280	0	100%	0%
43	Item 39	4.655	6.983	2.328	50%	-33%
44	Item 40	2.185	3.933	1.748	20%	-44%
45	Item 41	2.841	2.856	15	99%	-1%
46	Item 42	6.251	3.572	2.679	57%	75%
47	Item 43	1.300	900	400	69%	44%
48	Item 44	9.500	13.200	3.700	61%	-28%
49	Item 45	1.020	2.380	1.360	0%	-57%
50	Item 46	21.760	23.460	1.700	92%	-7%
51	Item 47	340	680	340	0%	-50%
52	Item 48	7.210	8.910	1.700	76%	-19%
53	Item 49	7.300	2.100	5.200	29%	248%
54	Item 50	5.280	3.840	1.440	73%	38%
55	Item 51	1.440	0	1.440	0%	100%
56	Item 52	13.800	15.000	1.200	91%	-8%
57	Item 53	850	765	85	90%	11%
58	Item 54	1.920	960	960	50%	100%
59	Item 55	13.120	13.760	640	95%	-5%
60	Item 56	1.600	2.400	800	50%	-33%
61	Item 57	400	1.000	600	0%	-60%
62	Item 58	360	648	288	20%	-44%
63	Item 59	688	86	602	13%	700%
64	Item 60	843	843	0	100%	0%
65	Item 61	204	0	204	0%	100%
66	Item 62	734	0	734	0%	100%
67	Item 63	462	231	231	50%	100%
68	Item 64	428	122	306	29%	250%
69	Item 65	75	75	0	100%	0%
70	Item 66	351	351	0	100%	0%
71	Item 67	1.224	1.102	122	90%	11%
72	Item 68	3.046	3.046	0	100%	0%
73	Item 69	367	184	184	50%	100%
74	Item 70	1.632	1.224	408	75%	33%
75	Item 71	5.636	9.614	3.978	29%	-41%
76	Item 72	255	255	0	100%	0%
77	Item 73	403	454	50	88%	-11%
78	Item 74	2.375	3.800	1.425	40%	-38%
79	Item 75	5.590	5.250	340	94%	6%
80	Item 76	5.311	5.311	0	100%	0%
81	Item 77	13.042	12.844	198	98%	2%
82	Item 78	2.592	864	1.728	33%	200%
83	Item 79	1.890	2.160	270	86%	-13%
84	Item 80	2.862	2.290	572	80%	25%
85	Item 81	4.655	4.655	0	100%	0%
86	Item 82	1.397	0	1.397	0%	100%
87	Item 83	353	0	353	0%	100%
88	Item 84	5.700	5.700	0	100%	0%
89	Item 85	1.026	1.026	0	100%	0%
90	Item 86	14.877	14.877	0	100%	0%
91	Item 87	760	760	0	100%	0%
92	Item 88	18.468	18.468	0	100%	0%
93	Item 89	13.533	13.533	0	100%	0%
94	Item 90	1.224	1.224	0	100%	0%
95	Item 91	1.114	2.850	1.736	0%	-61%
96	Item 92	720	2.160	1.440	0%	-67%
97	Item 93	1.900	1.900	0	100%	0%
98	Item 94	33.516	29.047	4.469	87%	15%
99	Item 95	342	570	228	33%	-40%
100	Item 96	42.000	47.705	5.705	86%	-12%