\begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F \\ \hline 1 & Date & Barley Demand & & Order Cost & $18 & per order \\ \hline 2 & 12/1/20 & 37 & & Holding Cost & 20% & of item value \\ \hline 3 & 12/2/20 & 34 & & Average Lead Time & 5 & days \\ \hline 4 & 12/3/20 & 45 & & Standard Deviation of Lead Time & 0.3 & days \\ \hline 5 & 12/4/20 & 74 & & Value of Bag of Barley & $11 & \\ \hline 6 & 12/5/20 & 25 & & \multicolumn{2}{|l|}{ Assume 300 Operating Days Per Year } & \\ \hline 7 & 12/6/20 & 24 & & & & \\ \hline 8 & 12/7/20 & 35 & & & & \\ \hline 9 & 12/8/20 & 27 & & & & \\ \hline 10 & 12/9/20 & 37 & & & & \\ \hline 11 & 12/10/20 & 30 & & & & \\ \hline 12 & 12/11/20 & 23 & & & & \\ \hline 13 & 12/12/20 & 33 & & & & \\ \hline 14 & 12/13/20 & 35 & & & & \\ \hline 15 & 12/14/20 & 27 & & & & \\ \hline 16 & 12/15/20 & 36 & & & & \\ \hline 17 & 12/16/20 & 37 & & & & \\ \hline 18 & 12/17/20 & 32 & & & & \\ \hline 19 & 12/18/20 & 38 & & & & \\ \hline 20 & 12/19/20 & 24 & & & & \\ \hline 21 & 12/20/20 & 27 & & & & \\ \hline 22 & 12/21/20 & 36 & & & & \\ \hline 23 & 12/22/20 & 29 & & & & \\ \hline 24 & 12/23/20 & 32 & & & & \\ \hline 25 & 12/24/20 & 31 & & & & \\ \hline 26 & 12/25/20 & 27 & & & & \\ \hline 27 & 12/26/20 & 33 & & & & \\ \hline 28 & 12/27/20 & 28 & & & & \\ \hline 29 & 12/28/20 & 31 & & & & \\ \hline 30 & 12/29/20 & 26 & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline 31 & 12/30/20 & 23 \\ \hline 32 & 12/31/20 & 41 \\ \hline 33 & 1/1/21 & 33 \\ \hline 34 & 1/2/21 & 20 \\ \hline 35 & 1/3/21 & 33 \\ \hline 36 & 1/4/21 & 42 \\ \hline 37 & 1/5/21 & 31 \\ \hline 38 & 1/6/21 & 25 \\ \hline 39 & 1/7/21 & 32 \\ \hline 40 & 1/8/21 & 26 \\ \hline 41 & 1/9/21 & 31 \\ \hline 42 & 1/10/21 & 28 \\ \hline 43 & 1/11/21 & 37 \\ \hline 44 & 1/12/21 & 20 \\ \hline 45 & 1/13/21 & 26 \\ \hline 46 & 1/14/21 & 34 \\ \hline 47 & 1/15/21 & 32 \\ \hline 48 & 1/16/21 & 29 \\ \hline 49 & 1/17/21 & 27 \\ \hline 50 & 1/18/21 & 18 \\ \hline 51 & 1/19/21 & 42 \\ \hline 52 & 1/20/21 & 27 \\ \hline 53 & 1/21/21 & 33 \\ \hline 54 & 1/22/21 & 33 \\ \hline 55 & 1/23/21 & 23 \\ \hline 56 & 1/24/21 & 29 \\ \hline 57 & 1/25/21 & 28 \\ \hline 58 & 1/26/21 & 18 \\ \hline 59 & 1/27/21 & 27 \\ \hline 60 & 1/28/21 & 36 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline & A & B \\ \hline 61 & 1/29/21 & 38 \\ \hline 62 & 1/30/21 & 36 \\ \hline 63 & 1/31/21 & 29 \\ \hline 64 & 2/1/21 & 32 \\ \hline 65 & 2/2/21 & 25 \\ \hline 66 & 2/3/21 & 30 \\ \hline 67 & 2/4/21 & 37 \\ \hline 68 & 2/5/21 & 31 \\ \hline 69 & 2/6/21 & 33 \\ \hline 70 & 2/7/21 & 34 \\ \hline 71 & 2/8/21 & 21 \\ \hline 72 & 2/9/21 & 33 \\ \hline 73 & 2/10/21 & 31 \\ \hline 74 & 2/11/21 & 23 \\ \hline 75 & 2/12/21 & 33 \\ \hline 76 & 2/13/21 & 45 \\ \hline 77 & 2/14/21 & 35 \\ \hline 78 & 2/15/21 & 25 \\ \hline 79 & 2/16/21 & 27 \\ \hline 80 & 2/17/21 & 17 \\ \hline 81 & 2/18/21 & 26 \\ \hline 82 & 2/19/21 & 7 \\ \hline 83 & 2/20/21 & 29 \\ \hline 84 & 2/21/21 & 27 \\ \hline 85 & 2/22/21 & 35 \\ \hline 86 & 2/23/21 & 37 \\ \hline 87 & 2/24/21 & 29 \\ \hline 88 & 2/25/21 & 31 \\ \hline 89 & 2/26/21 & 39 \\ \hline 90 & 2/27/21 & 37 \\ \hline \end{tabular} \begin{tabular}{l|l|l} 91 & 2/28/21 & 34 \end{tabular} What is the average daily demand of barley in your brewing process? Round your answer to two decimal places*** Question 13 7 pts What is the average demand during the lead time period from your supplier? *** Use the average daily demand from \#12 rounded to two decimal places. Average DDLT should also be rounded to two decimal places*** \begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F \\ \hline 1 & Date & Barley Demand & & Order Cost & $18 & per order \\ \hline 2 & 12/1/20 & 37 & & Holding Cost & 20% & of item value \\ \hline 3 & 12/2/20 & 34 & & Average Lead Time & 5 & days \\ \hline 4 & 12/3/20 & 45 & & Standard Deviation of Lead Time & 0.3 & days \\ \hline 5 & 12/4/20 & 74 & & Value of Bag of Barley & $11 & \\ \hline 6 & 12/5/20 & 25 & & \multicolumn{2}{|l|}{ Assume 300 Operating Days Per Year } & \\ \hline 7 & 12/6/20 & 24 & & & & \\ \hline 8 & 12/7/20 & 35 & & & & \\ \hline 9 & 12/8/20 & 27 & & & & \\ \hline 10 & 12/9/20 & 37 & & & & \\ \hline 11 & 12/10/20 & 30 & & & & \\ \hline 12 & 12/11/20 & 23 & & & & \\ \hline 13 & 12/12/20 & 33 & & & & \\ \hline 14 & 12/13/20 & 35 & & & & \\ \hline 15 & 12/14/20 & 27 & & & & \\ \hline 16 & 12/15/20 & 36 & & & & \\ \hline 17 & 12/16/20 & 37 & & & & \\ \hline 18 & 12/17/20 & 32 & & & & \\ \hline 19 & 12/18/20 & 38 & & & & \\ \hline 20 & 12/19/20 & 24 & & & & \\ \hline 21 & 12/20/20 & 27 & & & & \\ \hline 22 & 12/21/20 & 36 & & & & \\ \hline 23 & 12/22/20 & 29 & & & & \\ \hline 24 & 12/23/20 & 32 & & & & \\ \hline 25 & 12/24/20 & 31 & & & & \\ \hline 26 & 12/25/20 & 27 & & & & \\ \hline 27 & 12/26/20 & 33 & & & & \\ \hline 28 & 12/27/20 & 28 & & & & \\ \hline 29 & 12/28/20 & 31 & & & & \\ \hline 30 & 12/29/20 & 26 & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline 31 & 12/30/20 & 23 \\ \hline 32 & 12/31/20 & 41 \\ \hline 33 & 1/1/21 & 33 \\ \hline 34 & 1/2/21 & 20 \\ \hline 35 & 1/3/21 & 33 \\ \hline 36 & 1/4/21 & 42 \\ \hline 37 & 1/5/21 & 31 \\ \hline 38 & 1/6/21 & 25 \\ \hline 39 & 1/7/21 & 32 \\ \hline 40 & 1/8/21 & 26 \\ \hline 41 & 1/9/21 & 31 \\ \hline 42 & 1/10/21 & 28 \\ \hline 43 & 1/11/21 & 37 \\ \hline 44 & 1/12/21 & 20 \\ \hline 45 & 1/13/21 & 26 \\ \hline 46 & 1/14/21 & 34 \\ \hline 47 & 1/15/21 & 32 \\ \hline 48 & 1/16/21 & 29 \\ \hline 49 & 1/17/21 & 27 \\ \hline 50 & 1/18/21 & 18 \\ \hline 51 & 1/19/21 & 42 \\ \hline 52 & 1/20/21 & 27 \\ \hline 53 & 1/21/21 & 33 \\ \hline 54 & 1/22/21 & 33 \\ \hline 55 & 1/23/21 & 23 \\ \hline 56 & 1/24/21 & 29 \\ \hline 57 & 1/25/21 & 28 \\ \hline 58 & 1/26/21 & 18 \\ \hline 59 & 1/27/21 & 27 \\ \hline 60 & 1/28/21 & 36 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline & A & B \\ \hline 61 & 1/29/21 & 38 \\ \hline 62 & 1/30/21 & 36 \\ \hline 63 & 1/31/21 & 29 \\ \hline 64 & 2/1/21 & 32 \\ \hline 65 & 2/2/21 & 25 \\ \hline 66 & 2/3/21 & 30 \\ \hline 67 & 2/4/21 & 37 \\ \hline 68 & 2/5/21 & 31 \\ \hline 69 & 2/6/21 & 33 \\ \hline 70 & 2/7/21 & 34 \\ \hline 71 & 2/8/21 & 21 \\ \hline 72 & 2/9/21 & 33 \\ \hline 73 & 2/10/21 & 31 \\ \hline 74 & 2/11/21 & 23 \\ \hline 75 & 2/12/21 & 33 \\ \hline 76 & 2/13/21 & 45 \\ \hline 77 & 2/14/21 & 35 \\ \hline 78 & 2/15/21 & 25 \\ \hline 79 & 2/16/21 & 27 \\ \hline 80 & 2/17/21 & 17 \\ \hline 81 & 2/18/21 & 26 \\ \hline 82 & 2/19/21 & 7 \\ \hline 83 & 2/20/21 & 29 \\ \hline 84 & 2/21/21 & 27 \\ \hline 85 & 2/22/21 & 35 \\ \hline 86 & 2/23/21 & 37 \\ \hline 87 & 2/24/21 & 29 \\ \hline 88 & 2/25/21 & 31 \\ \hline 89 & 2/26/21 & 39 \\ \hline 90 & 2/27/21 & 37 \\ \hline \end{tabular} \begin{tabular}{l|l|l} 91 & 2/28/21 & 34 \end{tabular} What is the average daily demand of barley in your brewing process? Round your answer to two decimal places*** Question 13 7 pts What is the average demand during the lead time period from your supplier? *** Use the average daily demand from \#12 rounded to two decimal places. Average DDLT should also be rounded to two decimal places***