Supply-Chain-Dashboard-Template.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	SELECT MONTH	Selected Range		SUPPLIERS	Target (Delivery)		AVAILABILITY	DEFECT	DEFECT TYPE
2	janvier 2023	avril 2023	mars 2024	Supplier 1	80%		YES	YES	NO IMPACT
3	février 2023			Supplier 2	80%		NO	NO	IMPACT
4	mars 2023			Supplier 3	80%				REJECTED
5	avril 2023			Supplier 4	80%
6	mai 2023			Supplier 5	80%
7	juin 2023
8	juillet 2023
9	août 2023
10	septembre 2023
11	octobre 2023
12	novembre 2023
13	décembre 2023
14	janvier 2024
15	février 2024
16	mars 2024
17	avril 2024
18	mai 2024
19	juin 2024
20	juillet 2024
21	août 2024
22	septembre 2024
23
24
25
26		Order Number	Item	Supplier	Order Date	Availability	Lead Time	Delivered	Delivery Accuracy	Delivery Ranking	Defect	Defect Type
27		ORDER 000-0001	Item 3	Supplier 3	2/1/2023	YES	16	18/1/2023	0	On Time	NO
28		ORDER 000-0002	Item 96	Supplier 5	2/1/2023	YES	5	5/1/2023	-2	Early	NO
29		ORDER 000-0003	Item 29	Supplier 2	3/1/2023	YES	9	13/1/2023	1	On Time	YES	NO IMPACT
30		ORDER 000-0004	Item 53	Supplier 4	3/1/2023	YES	16	18/1/2023	-1	On Time	NO
31		ORDER 000-0005	Item 8	Supplier 4	4/1/2023	YES	3	7/1/2023	0	On Time	NO
32		ORDER 000-0006	Item 90	Supplier 2	4/1/2023	YES	9	10/1/2023	-3	Early	NO
33		ORDER 000-0007	Item 71	Supplier 3	4/1/2023	YES	11	15/1/2023	0	On Time	NO
34		ORDER 000-0008	Item 65	Supplier 4	4/1/2023	YES	12	16/1/2023	0	On Time	NO
35		ORDER 000-0009	Item 86	Supplier 5	5/1/2023	YES	4	9/1/2023	0	On Time	NO
36		ORDER 000-0010	Item 70	Supplier 3	6/1/2023	NO	10	18/1/2023	2	On Time	NO
37		ORDER 000-0011	Item 57	Supplier 5	6/1/2023	YES	12	17/1/2023	-1	On Time	NO
38		ORDER 000-0012	Item 12	Supplier 4	6/1/2023	YES	2	8/1/2023	0	On Time	NO
39		ORDER 000-0013	Item 85	Supplier 3	8/1/2023	YES	2	10/1/2023	0	On Time	NO
40		ORDER 000-0014	Item 35	Supplier 4	9/1/2023	YES	12	20/1/2023	-1	On Time	NO
41		ORDER 000-0015	Item 46	Supplier 5	9/1/2023	YES	9	18/1/2023	0	On Time	NO
42		ORDER 000-0016	Item 32	Supplier 1	13/1/2023	YES	10	23/1/2023	0	On Time	NO
43		ORDER 000-0017	Item 57	Supplier 1	13/1/2023	YES	3	17/1/2023	1	On Time	NO
44		ORDER 000-0018	Item 36	Supplier 2	14/1/2023	YES	8	22/1/2023	0	On Time	NO
45		ORDER 000-0019	Item 13	Supplier 4	14/1/2023	YES	6	22/1/2023	2	On Time	NO
46		ORDER 000-0020	Item 65	Supplier 5	15/1/2023	YES	25	9/2/2023	0	On Time	NO
47		ORDER 000-0021	Item 81	Supplier 5	18/1/2023	NO	6	23/1/2023	-1	On Time	NO
48		ORDER 000-0022	Item 21	Supplier 5	18/1/2023	YES	11	29/1/2023	0	On Time	NO
49		ORDER 000-0023	Item 45	Supplier 1	18/1/2023	YES	2	21/1/2023	1	On Time	NO
50		ORDER 000-0024	Item 55	Supplier 4	19/1/2023	YES	6	24/1/2023	-1	On Time	NO
51		ORDER 000-0025	Item 86	Supplier 3	19/1/2023	YES	23	11/2/2023	0	On Time	YES	NO IMPACT
52		ORDER 000-0026	Item 66	Supplier 2	20/1/2023	YES	7	26/1/2023	-1	On Time	NO
53		ORDER 000-0027	Item 83	Supplier 1	21/1/2023	YES	9	1/2/2023	2	On Time	NO
54		ORDER 000-0028	Item 9	Supplier 1	22/1/2023	YES	11	4/2/2023	2	On Time	NO
55		ORDER 000-0029	Item 9	Supplier 4	23/1/2023	YES	3	28/1/2023	2	On Time	NO
56		ORDER 000-0030	Item 52	Supplier 4	23/1/2023	YES	7	31/1/2023	1	On Time	NO
57		ORDER 000-0031	Item 55	Supplier 5	23/1/2023	YES	11	3/2/2023	0	On Time	NO
58		ORDER 000-0032	Item 40	Supplier 3	24/1/2023	YES	6	30/1/2023	0	On Time	NO
59		ORDER 000-0033	Item 33	Supplier 4	24/1/2023	YES	6	30/1/2023	0	On Time	NO
60		ORDER 000-0034	Item 78	Supplier 5	25/1/2023	YES	8	4/2/2023	2	On Time	NO
61		ORDER 000-0035	Item 68	Supplier 2	25/1/2023	NO	7	2/2/2023	1	On Time	NO
62		ORDER 000-0036	Item 59	Supplier 2	25/1/2023	YES	11	11/2/2023	6	Late	NO
63		ORDER 000-0037	Item 12	Supplier 2	26/1/2023	YES	9	2/2/2023	-2	Early	NO
64		ORDER 000-0038	Item 26	Supplier 1	26/1/2023	YES	10	6/2/2023	1	On Time	NO
65		ORDER 000-0039	Item 8	Supplier 5	26/1/2023	YES	4	30/1/2023	0	On Time	NO
66		ORDER 000-0040	Item 100	Supplier 5	26/1/2023	YES	4	30/1/2023	0	On Time	NO
67		ORDER 000-0041	Item 50	Supplier 1	27/1/2023	NO	6	3/2/2023	1	On Time	NO
68		ORDER 000-0042	Item 35	Supplier 5	27/1/2023	YES	11	7/2/2023	0	On Time	NO
69		ORDER 000-0043	Item 60	Supplier 4	28/1/2023	YES	9	8/2/2023	2	On Time	NO
70		ORDER 000-0044	Item 10	Supplier 3	29/1/2023	YES	7	7/2/2023	2	On Time	NO
71		ORDER 000-0045	Item 91	Supplier 3	29/1/2023	YES	4	2/2/2023	0	On Time	NO
72		ORDER 000-0046	Item 2	Supplier 4	29/1/2023	YES	9	7/2/2023	0	On Time	NO
73		ORDER 000-0047	Item 25	Supplier 1	31/1/2023	YES	10	11/2/2023	1	On Time	NO
74		ORDER 000-0048	Item 17	Supplier 1	31/1/2023	YES	8	7/2/2023	-1	On Time	NO
75		ORDER 000-0049	Item 45	Supplier 3	2/2/2023	YES	14	17/2/2023	1	On Time	NO
76		ORDER 000-0050	Item 52	Supplier 5	2/2/2023	NO	14	19/2/2023	3	Late	NO
77		ORDER 000-0051	Item 29	Supplier 5	2/2/2023	YES	8	11/2/2023	1	On Time	NO
78		ORDER 000-0052	Item 11	Supplier 1	3/2/2023	YES	15	20/2/2023	2	On Time	NO
79		ORDER 000-0053	Item 45	Supplier 3	3/2/2023	YES	5	8/2/2023	0	On Time	NO
80		ORDER 000-0054	Item 63	Supplier 5	5/2/2023	YES	20	25/2/2023	0	On Time	NO
81		ORDER 000-0055	Item 19	Supplier 1	5/2/2023	NO	7	13/2/2023	1	On Time	NO
82		ORDER 000-0056	Item 95	Supplier 1	5/2/2023	YES	12	17/2/2023	0	On Time	NO
83		ORDER 000-0057	Item 4	Supplier 3	5/2/2023	YES	6	11/2/2023	0	On Time	NO
84		ORDER 000-0058	Item 26	Supplier 4	6/2/2023	YES	2	9/2/2023	1	On Time	NO
85		ORDER 000-0059	Item 100	Supplier 2	6/2/2023	YES	2	13/2/2023	5	Late	NO
86		ORDER 000-0060	Item 3	Supplier 1	9/2/2023	YES	5	14/2/2023	0	On Time	YES	IMPACT
87		ORDER 000-0061	Item 50	Supplier 4	9/2/2023	NO	13	22/2/2023	0	On Time	NO
88		ORDER 000-0062	Item 83	Supplier 3	10/2/2023	YES	25	6/3/2023	-1	On Time	NO
89		ORDER 000-0063	Item 86	Supplier 2	10/2/2023	YES	7	17/2/2023	0	On Time	NO
90		ORDER 000-0064	Item 50	Supplier 4	11/2/2023	YES	5	16/2/2023	0	On Time	NO
91		ORDER 000-0065	Item 61	Supplier 2	11/2/2023	YES	9	21/2/2023	1	On Time	NO
92		ORDER 000-0066	Item 31	Supplier 4	12/2/2023	YES	9	21/2/2023	0	On Time	NO
93		ORDER 000-0067	Item 23	Supplier 1	13/2/2023	YES	25	12/3/2023	2	On Time	NO
94		ORDER 000-0068	Item 69	Supplier 5	14/2/2023	YES	15	1/3/2023	0	On Time	NO
95		ORDER 000-0069	Item 77	Supplier 3	14/2/2023	YES	9	24/2/2023	1	On Time	NO
96		ORDER 000-0070	Item 33	Supplier 2	15/2/2023	YES	6	21/2/2023	0	On Time	NO
97		ORDER 000-0071	Item 100	Supplier 5	17/2/2023	YES	11	1/3/2023	1	On Time	NO
98		ORDER 000-0072	Item 88	Supplier 5	18/2/2023	YES	4	21/2/2023	-1	On Time	NO
99		ORDER 000-0073	Item 94	Supplier 2	18/2/2023	YES	7	25/2/2023	0	On Time	NO
100		ORDER 000-0074	Item 30	Supplier 4	18/2/2023	YES	16	10/3/2023	4	Late	NO