excel playsheets
TRANSCRIPT
-
7/25/2019 Excel Playsheets
1/16
Week Available Backorder Inventory Cost
0 15
1 5 20 5 5 0 15 7.5
2 5 20 0 0
0 20 17.53 2 22 0 0 0 22 28.5
4 2 24 0 0 0 24 40.5
5 0 24 10 10 0 14 47.5
6 0 14 5 5 0 9 52
7 5 14 5 5 0 9 56.5
8 5 14 5 5 0 9 61
9 0 9 15 9 6 0 67
10 5 5 10 5 11 0 78
11 10 10 10 10 11 0 89
12 5 5 10 5 16 0 10513 10 10 15 10 21 0 126
14 0 0 10 0 31 0 157
15 10 10 10 10 31 0 188
16 5 5 10 5 36 0 224
17 10 10 10 10 36 0 260
18 10 10 10 10 36 0 296
19 0 0 10 0 46 0 342
20 20 20 10 20 36 0 378
21 24 24 5 24
17 0 39522 29 29 5 22 0 7 398.5
23 20 27 10 10 0 17 407
24 6 23 10 10 0 13 413.5
25 0 13 5 5 0 8 417.5
26 5 13 5 5 0 8 421.5
27 10 18 10 10 0 8 425.5
28 5 13 10 10 0 3 427
29 7 10 10 10 0 0 427
30 10 10 10 10 0 0 427
31 10 10 10 10 0 0 427
32 11 11 10 10 0 1 427.5
33 5 6 5 5 0 1 428
34 10 11 10 10 0 1 428.5
35 13 14 10 10 0 4 430.5
36 10 14 5 5 0 9 435
37
38
39
4041
Incoin!#elivery
Incoin!$rder
%o&r#elivery
-
7/25/2019 Excel Playsheets
2/16
42
43
44
45
-
7/25/2019 Excel Playsheets
3/16
'lease (ill o&t )lay sli)s*
#elivery $rder
5 5 5
2
0 22 0 2
0 0 0
0 10 0
5 5 5
5 5 5
5 5 5
10 9 10
10 5 10
5 10 5
10 5 1020 10 20
25 0 25
15 10 15
15 5 15
10 10 10
10 10 10
10 0 10
10 20 10
10 24 10
5 22 5
0 10 0
5 10 5
10 5 10
5 5 5
7 10 7
10 10 10
10 10 10
15 10 15
10 10 10
10 10 10
15 5 15
5 10 5
10 10 10
0 5 0
%o&r$rder
-
7/25/2019 Excel Playsheets
4/16
-
7/25/2019 Excel Playsheets
5/16
Week Available Backorder Inventory Cost
0 15
1
23
4
5
6
7
8
9
10
11
1213
14
15
16
17
18
19
20
2122
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
4041
Incoin!#elivery
Incoin!$rder
%o&r#elivery
-
7/25/2019 Excel Playsheets
6/16
42
43
44
45
-
7/25/2019 Excel Playsheets
7/16
'lease (ill o&t )lay sli)s*
#elivery $rder%o&r$rder
-
7/25/2019 Excel Playsheets
8/16
-
7/25/2019 Excel Playsheets
9/16
Week Available Backorder Inventory Cost
0 15
1
23
4
5
6
7
8
9
10
11
1213
14
15
16
17
18
19
20
2122
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
4041
Incoin!#elivery
Incoin!$rder
%o&r#elivery
-
7/25/2019 Excel Playsheets
10/16
42
43
44
45
-
7/25/2019 Excel Playsheets
11/16
'lease (ill o&t )lay sli)s*
#elivery $rder%o&r$rder
-
7/25/2019 Excel Playsheets
12/16
-
7/25/2019 Excel Playsheets
13/16
Week Available Backorder Inventory Cost
0 15
1
23
4
5
6
7
8
9
10
11
1213
14
15
16
17
18
19
20
2122
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
4041
Incoin!#elivery
Incoin!$rder
%o&r#elivery
-
7/25/2019 Excel Playsheets
14/16
42
43
44
45
-
7/25/2019 Excel Playsheets
15/16
'lease (ill o&t )lay sli)s*
#elivery $rder%o&r$rder
-
7/25/2019 Excel Playsheets
16/16