7.1 14. Freeze-Panes-Lecture - Solved.xlsx.xlsx

	B	C	D	E	F	G	H	I
1	Freeze panes
2
3	Year	Type	Product group	Producer	Code	Volume	Cost per unit	Price per unit

4	2011	Convenience stores	Meat	Lieken	\|13/12/38\|	420	6.0	8.4
5	2011	Convenience stores	Meat	Lieken	\|13/13/98\|	480	6.1	7.4
6	2011	Convenience stores	Meat	Lieken	\|13/13/99\|	528	5.4	7.6
7	2011	Convenience stores	Coffee	Lieken	\|13/01/01\|	4836	0.74	0.96
8	2011	Convenience stores	Coffee	Lieken	\|13/01/01a\|	5928	0.95	0.99
9	2011	Convenience stores	Coffee	Lieken	\|13/01/02\|	5712	0.89	0.97
10	2011	Convenience stores	Coffee	Lieken	\|13/01/03\|	4872	0.62	0.9
11	2011	Convenience stores	Coffee	Lieken	\|13/01/04\|	6228	0.65	1.07
12	2011	Convenience stores	Coffee	Lieken	\|13/01/05\|	9588	0.92	1.01
13	2011	Convenience stores	Coffee	Lieken	\|13/01/06\|	7836	1.19	0.96
14	2011	Convenience stores	Coffee	Lieken	\|13/01/07\|	7560	1.02	1.09
15	2011	Convenience stores	Coffee	Lieken	\|13/01/30\|	8556	0.99	1.1
16	2011	Convenience stores	Coffee	Lieken	\|13/11/01\|	9024	0.51	1.15
17	2011	Convenience stores	Coffee	Lieken	\|13/11/01a\|	7260	1.04	0.98
18	2011	Convenience stores	Coffee	Lieken	\|13/11/02\|	9456	0.85	1.17
19	2011	Convenience stores	Coffee	Lieken	\|13/11/03\|	7488	1.19	0.91
20	2011	Convenience stores	Coffee	Lieken	\|13/11/04\|	7176	0.56	1.13
21	2011	Convenience stores	Coffee	J&F	\|13/12/01\|	7140	0.72	0.91
22	2011	Convenience stores	Coffee	J&F	\|13/12/02\|	6996	1.2	0.94
23	2011	Convenience stores	Coffee	J&F	\|13/12/03\|	4836	1.18	0.96
24	2011	Convenience stores	Coffee	J&F	\|13/12/04\|	8868	0.5	1.01
25	2011	Convenience stores	Coffee	J&F	\|13/12/05\|	5424	0.82	1.11
26	2011	Convenience stores	Coffee	J&F	\|13/12/06\|	6864	0.86	0.95
27	2011	Convenience stores	Coffee	J&F	\|13/12/07\|	8784	1.05	0.99
28	2011	Convenience stores	Coffee	J&F	\|13/12/08\|	6780	0.55	1.02
29	2011	Convenience stores	Coffee	J&F	\|13/12/09\|	5292	0.51	1.13
30	2011	Convenience stores	Coffee	J&F	\|13/12/10\|	6768	1.12	0.94
31	2011	Convenience stores	Coffee	J&F	\|13/12/11\|	5940	0.84	1.18
32	2011	Convenience stores	Coffee	J&F	\|13/12/12\|	4932	0.48	1.15
33	2011	Convenience stores	Coffee	J&F	\|13/12/13\|	9084	0.44	0.9
34	2011	Convenience stores	Coffee	J&F	\|13/12/14\|	5580	0.63	1
35	2011	Convenience stores	Coffee	J&F	\|13/12/15\|	5460	0.71	0.95
36	2011	Convenience stores	Coffee	J&F	\|13/12/16\|	6480	0.53	1.14
37	2011	Convenience stores	Coffee	J&F	\|13/12/17\|	6660	0.74	1.08
38	2011	Convenience stores	Coffee	J&F	\|13/12/18\|	7332	0.78	1.2
39	2011	Convenience stores	Coffee	J&F	\|13/12/19\|	6480	0.68	1.07
40	2011	Convenience stores	Coffee	J&F	\|13/12/20\|	7908	0.46	0.99
41	2011	Convenience stores	Coffee	J&F	\|13/12/21\|	9348	0.5	0.98
42	2011	Convenience stores	Coffee	J&F	\|13/12/22\|	4992	0.64	0.98
43	2011	Convenience stores	Coffee	J&F	\|13/12/23\|	7956	0.88	0.94
44	2011	Convenience stores	Coffee	J&F	\|13/12/24\|	6348	0.56	1.16
45	2011	Convenience stores	Coffee	J&F	\|13/12/25\|	6456	0.67	1.19
46	2011	Convenience stores	Coffee	J&F	\|13/12/26\|	9288	1.17	1.12
47	2011	Convenience stores	Coffee	J&F	\|13/12/27\|	5352	0.51	1.2
48	2011	Convenience stores	Coffee	J&F	\|13/12/28\|	4836	0.77	1
49	2011	Convenience stores	Coffee	J&F	\|13/12/29\|	9384	1.05	1.13
50	2011	Convenience stores	Coffee	J&F	\|13/12/30\|	9264	1.13	0.99
51	2011	Convenience stores	Coffee	J&F	\|13/12/31\|	9204	1.02	1.11
52	2011	Convenience stores	Coffee	J&F	\|13/12/32\|	6396	0.44	1.05
53	2011	Convenience stores	Coffee	J&F	\|13/12/33\|	6396	0.59	1.09
54	2011	Convenience stores	Coffee	J&F	\|13/12/34\|	7116	0.42	1.12
55	2011	Convenience stores	Coffee	J&F	\|13/12/35\|	8616	0.78	0.95
56	2011	Convenience stores	Coffee	J&F	\|13/12/36\|	6768	0.9	1.08
57	2011	Convenience stores	Coffee	J&F	\|13/12/37\|	9552	1.03	1.18
58	2011	Convenience stores	Coffee	J&F	\|13/12/39\|	6612	0.63	1.12
59	2011	Convenience stores	Coffee	J&F	\|13/12/40\|	7056	0.8	1.06
60	2011	Convenience stores	Coffee	J&F	\|13/12/41\|	6108	1.17	0.99
61	2011	Convenience stores	Coffee	J&F	\|13/12/42\|	7152	0.93	1.18
62	2011	Convenience stores	Coffee	J&F	\|13/12/43\|	8988	1.12	1.01
63	2011	Convenience stores	Coffee	J&F	\|13/12/44\|	6588	1.1	1.13
64	2011	Convenience stores	Coffee	J&F	\|13/12/45\|	8280	0.85	1.03
65	2011	Convenience stores	Coffee	J&F	\|13/12/46\|	7104	0.77	1.05
66	2011	Convenience stores	Coffee	J&F	\|13/12/47\|	7920	0.46	1.07
67	2011	Convenience stores	Coffee	J&F	\|13/12/48\|	9492	1.06	0.92
68	2011	Convenience stores	Coffee	J&F	\|13/12/49\|	9288	1.19	1.18
69	2011	Convenience stores	Coffee	J&F	\|13/12/51\|	6660	1.15	1
70	2011	Convenience stores	Coffee	J&F	\|13/12/52\|	6372	0.51	1.12
71	2011	Convenience stores	Coffee	J&F	\|13/12/53\|	5508	1.17	1.19
72	2011	Convenience stores	Coffee	J&F	\|13/12/54\|	5916	0.96	1.05
73	2011	Convenience stores	Coffee	J&F	\|13/12/55\|	6228	0.85	1.03
74	2011	Convenience stores	Coffee	J&F	\|13/12/56\|	9564	0.67	1.1
75	2011	Convenience stores	Coffee	J&F	\|13/12/57\|	9264	0.78	1.13
76	2011	Convenience stores	Coffee	J&F	\|13/12/58\|	8280	0.48	0.99
77	2011	Convenience stores	Coffee	J&F	\|13/12/59\|	5172	0.61	1.05
78	2011	Convenience stores	Coffee	J&F	\|13/12/60\|	6180	0.55	1.04
79	2011	Convenience stores	Coffee	J&F	\|13/12/61\|	6072	0.93	1.16
80	2011	Convenience stores	Coffee	J&F	\|13/12/62\|	6744	1.13	1.03
81	2011	Convenience stores	Coffee	J&F	\|13/12/63\|	6540	0.74	1.13
82	2011	Convenience stores	Coffee	J&F	\|13/12/64\|	6468	0.48	1.13
83	2011	Convenience stores	Coffee	J&F	\|13/12/65\|	4824	0.58	0.99
84	2011	Convenience stores	Coffee	J&F	\|13/12/66\|	5772	0.93	1.07
85	2011	Convenience stores	Coffee	J&F	\|13/12/67\|	8340	0.82	1.01
86	2011	Convenience stores	Coffee	J&F	\|13/12/68\|	7932	0.9	0.9
87	2011	Convenience stores	Coffee	J&F	\|13/12/69\|	7992	0.75	1.19
88	2011	Convenience stores	Coffee	J&F	\|13/12/70\|	8316	0.97	1.15
89	2011	Convenience stores	Coffee	J&F	\|13/12/71\|	7332	0.92	1.14
90	2011	Convenience stores	Coffee	J&F	\|13/12/72\|	9348	1.09	0.95
91	2011	Convenience stores	Coffee	J&F	\|13/12/73\|	6288	0.52	1.14
92	2011	Convenience stores	Coffee	J&F	\|13/12/74\|	6360	0.76	0.91
93	2011	Convenience stores	Coffee	J&F	\|13/12/75\|	9492	0.49	1.18
94	2011	Convenience stores	Coffee	J&F	\|13/12/76\|	7488	0.52	0.95
95	2011	Convenience stores	Coffee	J&F	\|13/12/77\|	9264	0.95	1.16
96	2011	Convenience stores	Coffee	J&F	\|13/12/78\|	8220	0.74	1.01
97	2011	Convenience stores	Coffee	J&F	\|13/12/79\|	9156	1.03	1.02
98	2011	Convenience stores	Coffee	J&F	\|13/12/80\|	9144	0.59	1.02
99	2011	Convenience stores	Coffee	J&F	\|13/12/81\|	5724	0.93	0.93
100	2011	Convenience stores	Coffee	J&F	\|13/12/82\|	9120	1.09	1.1