Analytics Module 1 Comprehensive Assignment

aujam253
2-7-2019BackOrderData.xlsx
Home>Business & Finance homework help>Operations Management homework help>Analytics Module 1 Comprehensive Assignment

Sheet2

Row Labels Count of Amount BackOrdered Sum of Amount BackOrdered
0 64 0.00%
1 70 10.00%
2 149 42.57%
3 37 15.86%
4 17 9.71%
5 15 10.71%
6 13 11.14%
Grand Total 365 100.00%
most likely outcome
(expected value) 3.02

Sheet1

Date Amount BackOrdered safety stock
1/1/17 2 4 2 0 2017
1/2/17 6 4 -2 2 total backorderqtv. 700
1/3/17 2 4 2 0
1/4/17 0 4 4 0 revised 2017
1/5/17 0 4 4 0 total backorder qtv 41
1/6/17 2 4 2 0 (safety stock = 4)
1/7/17 2 4 2 0
1/8/17 2 4 2 0
1/9/17 2 4 2 0
1/10/17 2 4 2 0
1/11/17 2 4 2 0
1/12/17 0 4 4 0
1/13/17 0 4 4 0
1/14/17 2 4 2 0
1/15/17 6 4 -2 2
1/16/17 1 4 3 0
1/17/17 5 4 -1 1
1/18/17 3 4 1 0
1/19/17 2 4 2 0
1/20/17 0 4 4 0
1/21/17 1 4 3 0
1/22/17 2 4 2 0
1/23/17 3 4 1 0
1/24/17 2 4 2 0
1/25/17 2 4 2 0
1/26/17 6 4 -2 2
1/27/17 2 4 2 0
1/28/17 2 4 2 0
1/29/17 2 4 2 0
1/30/17 1 4 3 0
1/31/17 3 4 1 0
2/1/17 2 4 2 0
2/2/17 5 4 -1 1
2/3/17 6 4 -2 2
2/4/17 2 4 2 0
2/5/17 2 4 2 0
2/6/17 1 4 3 0
2/7/17 2 4 2 0
2/8/17 0 4 4 0
2/9/17 6 4 -2 2
2/10/17 2 4 2 0
2/11/17 3 4 1 0
2/12/17 3 4 1 0
2/13/17 2 4 2 0
2/14/17 2 4 2 0
2/15/17 5 4 -1 1
2/16/17 1 4 3 0
2/17/17 2 4 2 0
2/18/17 1 4 3 0
2/19/17 1 4 3 0
2/20/17 3 4 1 0
2/21/17 5 4 -1 1
2/22/17 5 4 -1 1
2/23/17 2 4 2 0
2/24/17 0 4 4 0
2/25/17 1 4 3 0
2/26/17 0 4 4 0
2/27/17 1 4 3 0
2/28/17 2 4 2 0
3/1/17 0 4 4 0
3/2/17 2 4 2 0
3/3/17 2 4 2 0
3/4/17 1 4 3 0
3/5/17 1 4 3 0
3/6/17 2 4 2 0
3/7/17 2 4 2 0
3/8/17 2 4 2 0
3/9/17 2 4 2 0
3/10/17 2 4 2 0
3/11/17 1 4 3 0
3/12/17 0 4 4 0
3/13/17 2 4 2 0
3/14/17 2 4 2 0
3/15/17 0 4 4 0
3/16/17 0 4 4 0
3/17/17 1 4 3 0
3/18/17 2 4 2 0
3/19/17 2 4 2 0
3/20/17 2 4 2 0
3/21/17 2 4 2 0
3/22/17 1 4 3 0
3/23/17 6 4 -2 2
3/24/17 1 4 3 0
3/25/17 3 4 1 0
3/26/17 2 4 2 0
3/27/17 2 4 2 0
3/28/17 2 4 2 0
3/29/17 3 4 1 0
3/30/17 0 4 4 0
3/31/17 6 4 -2 2
4/1/17 6 4 -2 2
4/2/17 1 4 3 0
4/3/17 2 4 2 0
4/4/17 4 4 0 0
4/5/17 2 4 2 0
4/6/17 2 4 2 0
4/7/17 0 4 4 0
4/8/17 4 4 0 0
4/9/17 5 4 -1 1
4/10/17 6 4 -2 2
4/11/17 1 4 3 0
4/12/17 2 4 2 0
4/13/17 2 4 2 0
4/14/17 4 4 0 0
4/15/17 6 4 -2 2
4/16/17 4 4 0 0
4/17/17 1 4 3 0
4/18/17 0 4 4 0
4/19/17 2 4 2 0
4/20/17 2 4 2 0
4/21/17 3 4 1 0
4/22/17 0 4 4 0
4/23/17 3 4 1 0
4/24/17 4 4 0 0
4/25/17 2 4 2 0
4/26/17 0 4 4 0
4/27/17 2 4 2 0
4/28/17 2 4 2 0
4/29/17 1 4 3 0
4/30/17 1 4 3 0
5/1/17 1 4 3 0
5/2/17 4 4 0 0
5/3/17 3 4 1 0
5/4/17 4 4 0 0
5/5/17 2 4 2 0
5/6/17 2 4 2 0
5/7/17 4 4 0 0
5/8/17 0 4 4 0
5/9/17 3 4 1 0
5/10/17 3 4 1 0
5/11/17 3 4 1 0
5/12/17 4 4 0 0
5/13/17 2 4 2 0
5/14/17 0 4 4 0
5/15/17 2 4 2 0
5/16/17 2 4 2 0
5/17/17 2 4 2 0
5/18/17 2 4 2 0
5/19/17 1 4 3 0
5/20/17 4 4 0 0
5/21/17 0 4 4 0
5/22/17 2 4 2 0
5/23/17 2 4 2 0
5/24/17 1 4 3 0
5/25/17 1 4 3 0
5/26/17 2 4 2 0
5/27/17 2 4 2 0
5/28/17 1 4 3 0
5/29/17 0 4 4 0
5/30/17 6 4 -2 2
5/31/17 3 4 1 0
6/1/17 2 4 2 0
6/2/17 4 4 0 0
6/3/17 2 4 2 0
6/4/17 2 4 2 0
6/5/17 2 4 2 0
6/6/17 2 4 2 0
6/7/17 2 4 2 0
6/8/17 5 4 -1 1
6/9/17 2 4 2 0
6/10/17 2 4 2 0
6/11/17 2 4 2 0
6/12/17 2 4 2 0
6/13/17 3 4 1 0
6/14/17 1 4 3 0
6/15/17 2 4 2 0
6/16/17 2 4 2 0
6/17/17 5 4 -1 1
6/18/17 0 4 4 0
6/19/17 2 4 2 0
6/20/17 1 4 3 0
6/21/17 0 4 4 0
6/22/17 2 4 2 0
6/23/17 5 4 -1 1
6/24/17 0 4 4 0
6/25/17 1 4 3 0
6/26/17 0 4 4 0
6/27/17 3 4 1 0
6/28/17 1 4 3 0
6/29/17 3 4 1 0
6/30/17 0 4 4 0
7/1/17 0 4 4 0
7/2/17 3 4 1 0
7/3/17 1 4 3 0
7/4/17 2 4 2 0
7/5/17 2 4 2 0
7/6/17 2 4 2 0
7/7/17 1 4 3 0
7/8/17 2 4 2 0
7/9/17 4 4 0 0
7/10/17 3 4 1 0
7/11/17 2 4 2 0
7/12/17 0 4 4 0
7/13/17 2 4 2 0
7/14/17 3 4 1 0
7/15/17 0 4 4 0
7/16/17 1 4 3 0
7/17/17 0 4 4 0
7/18/17 0 4 4 0
7/19/17 2 4 2 0
7/20/17 2 4 2 0
7/21/17 2 4 2 0
7/22/17 6 4 -2 2
7/23/17 0 4 4 0
7/24/17 1 4 3 0
7/25/17 0 4 4 0
7/26/17 0 4 4 0
7/27/17 0 4 4 0
7/28/17 2 4 2 0
7/29/17 2 4 2 0
7/30/17 2 4 2 0
7/31/17 1 4 3 0
8/1/17 2 4 2 0
8/2/17 2 4 2 0
8/3/17 1 4 3 0
8/4/17 2 4 2 0
8/5/17 0 4 4 0
8/6/17 3 4 1 0
8/7/17 0 4 4 0
8/8/17 0 4 4 0
8/9/17 0 4 4 0
8/10/17 2 4 2 0
8/11/17 4 4 0 0
8/12/17 2 4 2 0
8/13/17 0 4 4 0
8/14/17 1 4 3 0
8/15/17 4 4 0 0
8/16/17 2 4 2 0
8/17/17 0 4 4 0
8/18/17 2 4 2 0
8/19/17 2 4 2 0
8/20/17 2 4 2 0
8/21/17 2 4 2 0
8/22/17 3 4 1 0
8/23/17 2 4 2 0
8/24/17 0 4 4 0
8/25/17 2 4 2 0
8/26/17 1 4 3 0
8/27/17 1 4 3 0
8/28/17 1 4 3 0
8/29/17 1 4 3 0
8/30/17 0 4 4 0
8/31/17 2 4 2 0
9/1/17 1 4 3 0
9/2/17 2 4 2 0
9/3/17 1 4 3 0
9/4/17 2 4 2 0
9/5/17 6 4 -2 2
9/6/17 2 4 2 0
9/7/17 2 4 2 0
9/8/17 3 4 1 0
9/9/17 2 4 2 0
9/10/17 0 4 4 0
9/11/17 0 4 4 0
9/12/17 2 4 2 0
9/13/17 1 4 3 0
9/14/17 3 4 1 0
9/15/17 2 4 2 0
9/16/17 3 4 1 0
9/17/17 1 4 3 0
9/18/17 1 4 3 0
9/19/17 2 4 2 0
9/20/17 1 4 3 0
9/21/17 3 4 1 0
9/22/17 2 4 2 0
9/23/17 2 4 2 0
9/24/17 1 4 3 0
9/25/17 4 4 0 0
9/26/17 2 4 2 0
9/27/17 0 4 4 0
9/28/17 2 4 2 0
9/29/17 2 4 2 0
9/30/17 0 4 4 0
10/1/17 0 4 4 0
10/2/17 2 4 2 0
10/3/17 3 4 1 0
10/4/17 2 4 2 0
10/5/17 5 4 -1 1
10/6/17 2 4 2 0
10/7/17 0 4 4 0
10/8/17 2 4 2 0
10/9/17 2 4 2 0
10/10/17 2 4 2 0
10/11/17 3 4 1 0
10/12/17 1 4 3 0
10/13/17 1 4 3 0
10/14/17 2 4 2 0
10/15/17 1 4 3 0
10/16/17 1 4 3 0
10/17/17 1 4 3 0
10/18/17 5 4 -1 1
10/19/17 2 4 2 0
10/20/17 0 4 4 0
10/21/17 2 4 2 0
10/22/17 2 4 2 0
10/23/17 1 4 3 0
10/24/17 0 4 4 0
10/25/17 2 4 2 0
10/26/17 1 4 3 0
10/27/17 2 4 2 0
10/28/17 1 4 3 0
10/29/17 1 4 3 0
10/30/17 0 4 4 0
10/31/17 1 4 3 0
11/1/17 5 4 -1 1
11/2/17 2 4 2 0
11/3/17 2 4 2 0
11/4/17 0 4 4 0
11/5/17 0 4 4 0
11/6/17 0 4 4 0
11/7/17 2 4 2 0
11/8/17 5 4 -1 1
11/9/17 0 4 4 0
11/10/17 2 4 2 0
11/11/17 1 4 3 0
11/12/17 2 4 2 0
11/13/17 0 4 4 0
11/14/17 3 4 1 0
11/15/17 2 4 2 0
11/16/17 2 4 2 0
11/17/17 5 4 -1 1
11/18/17 2 4 2 0
11/19/17 1 4 3 0
11/20/17 0 4 4 0
11/21/17 2 4 2 0
11/22/17 2 4 2 0
11/23/17 1 4 3 0
11/24/17 5 4 -1 1
11/25/17 1 4 3 0
11/26/17 3 4 1 0
11/27/17 3 4 1 0
11/28/17 0 4 4 0
11/29/17 2 4 2 0
11/30/17 0 4 4 0
12/1/17 1 4 3 0
12/2/17 4 4 0 0
12/3/17 4 4 0 0
12/4/17 2 4 2 0
12/5/17 1 4 3 0
12/6/17 1 4 3 0
12/7/17 3 4 1 0
12/8/17 2 4 2 0
12/9/17 0 4 4 0
12/10/17 3 4 1 0
12/11/17 0 4 4 0
12/12/17 0 4 4 0
12/13/17 2 4 2 0
12/14/17 2 4 2 0
12/15/17 1 4 3 0
12/16/17 1 4 3 0
12/17/17 2 4 2 0
12/18/17 3 4 1 0
12/19/17 3 4 1 0
12/20/17 2 4 2 0
12/21/17 1 4 3 0
12/22/17 0 4 4 0
12/23/17 2 4 2 0
12/24/17 2 4 2 0
12/25/17 2 4 2 0
12/26/17 1 4 3 0
12/27/17 1 4 3 0
12/28/17 2 4 2 0
12/29/17 3 4 1 0
12/30/17 1 4 3 0
12/31/17 2 4 2 0