Team B_result.xlsx

	A	B	C	D	E	F	G	H	I	J
1		incoming	available (incoming+inventory)	new order received	to ship (back order+new order)	actual delivery	back order (to ship-actual deliverty)	inventory (available-actual delivery)	your order	COST
2	Week 1		12	4	4	4		8	4	40
3	Week 2		8	5	5	5	0	3	3	15
4	Week 3	4	7	4	4	4	0	3	5	15
5	Week 4	3	6	7	7	6	1	0	15	10
6	Week 5	5	5	12	13	5	8	0	2	80
7	Week 6	15	15	0	8	8	0	7	0	35
8	Week 7	2	9	3	3	3	0	6	1	30
9	Week 8	0	6	0	0	0	0	6	0	30
10	Week 9	1	7	0	0	0	0	7	1	35
11	Week 10	0	7	5	5	5	0	2	10	10
12	Week 11	1	3	20	20	3	17	0	10	170
13	Week 12	10	10	30	47	10	37	0	30	370
14	Week 13	10	10	15	52	10	42	0	15	420
15	Week 14	30	30	5	47	30	17	0	10	170
16	Week 15	15	15	10	27	15	12	0	20	120
17	Week 16	10	10	5	17	10	7	0	5	70
18	Week 17	20	20	3	10	10	0	10	5	50
19	Week 18	5	15	0	0	0	0	15	0	75
20	Week 19	0	15	0	0	0	0	15	0	75
21	Week 20	0	15	0	0	0	0	15	0	75
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