Hello Can Anyone help with this homework? and let me know if additional information is required to complete this assignment?

Thanks.

Homework: Cycle-stock and Safety-stock models

Revisit the ImportHome.com case study, assume the costs of the GM soymilk maker and GM cooker are \$35 per unit. The annual inventory carrying cost is 18% of th
For GM soymilk maker, calculate the annual shipping and inventory carrying costs under either full or half container. Which is better: full vs. half container?
For GM cooker, calculate the annual shipping and inventory carrying costs under either full or half container. Which is better: full vs. half container?
Please look at the case data file ?HW-data.xlsx? for the demand data of these products.

Month

JY Soy
1
1
1
1
1
2
2
2
2
3
3
3
3
4
4
4
4
4
5
5
5
5
6
6
6
6
7
7
7
7
7
8
8
8
8
9
9
9
9
9
10
10
10
10
11
11
11
11
12
12
12
12
12

41
80
97
104
123
40
39
28
34
33
66
79
35
20
25
40
32
41
13
20
14
39
16
53
36
35
43
18
31
22
48
55
51
64
73
34
35
41
21
55
47
38
35
22
36
48
54
53
56
64
66
87
98

GM Soy
32
23
13
12
15
24
35
38
45
43
32
21
26
33
21
24
29
33
32
37
42
22
23
12
14
12
13
23
27
21
25
29
26
31
34
16
21
24
17
21
28
29
25
32
23
12
16
32
28
27
29
24
21

GM Cooker Price JY Soy Price GM Soy Price GM Cooker
48
99.99
88.88
149.99
38
99.99
88.88
159.99
25
88.99
88.88
159.99
23
88.99
88.88
159.99
25
88.99
88.88
159.99
21
99.99
88.88
159.99
33
99.99
78.88
159.99
31
99.99
78.88
159.99
39
99.99
78.88
159.99
40
99.99
78.88
159.99
29
95.99
88.88
159.99
22
95.99
88.88
159.99
29
95.99
88.88
159.99
35
99.99
88.88
159.99
27
99.99
88.88
159.99
29
99.99
88.88
159.99
30
99.99
88.88
159.99
35
99.99
85.88
159.99
36
99.99
85.88
159.99
43
99.99
85.88
159.99
49
99.99
85.88
159.99
31
99.99
88.88
159.99
29
99.99
88.88
159.99
22
95.99
88.88
159.99
28
95.99
88.88
159.99
31
95.99
88.88
159.99
26
95.99
88.88
159.99
34
99.99
88.88
159.99
37
99.99
88.88
159.99
32
99.99
88.88
159.99
34
99.99
88.88
159.99
53
95.99
88.88
149.99
48
95.99
88.88
149.99
55
95.99
88.88
149.99
59
95.99
88.88
149.99
23
99.99
88.88
159.99
25
99.99
88.88
159.99
29
99.99
88.88
159.99
29
99.99
88.88
159.99
25
95.99
88.88
159.99
29
95.99
85.88
159.99
36
95.99
85.88
159.99
39
95.99
85.88
159.99
42
99.99
85.88
159.99
36
99.99
88.88
159.99
28
89.99
88.88
159.99
39
89.99
88.88
159.99
45
89.99
80.88
159.99
42
89.99
80.88
159.99
49
89.99
80.88
159.99
52
89.99
80.88
159.99
51
89.99
80.88
159.99
49
89.99
80.88
159.99

week
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
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