anent D trimetor? nestien 2. Explain how conditional logic is used in this spreadsheet and how it might be done differently. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & & & D & E & F & 6 & H & 1 & 1 & K & L \\ \hline 1 & Date & \begin{tabular}{l} Purchase \\ /Sale \end{tabular} & Units & & \begin{tabular}{l} Pur \\ Uni \end{tabular} & \begin{tabular}{l} rchase \\ t Cost \end{tabular} & \begin{tabular}{l} Sign \\ (purchase = \\ +1 , sale = - \\ 1) \end{tabular} & \begin{tabular}{l} Sign for \\ Cost of \\ Purchase \\ (purchase = \\ 1 , sale =0 ) \end{tabular} & \begin{tabular}{l} Sign for \\ Cost of \\ Sales (sale = \\ 1, purchase \\ =0 ) \end{tabular} & \begin{tabular}{l} Units on \\ Hand \end{tabular} & \begin{tabular}{l} Cost of \\ Purchase \end{tabular} & Cost of Sales & \begin{tabular}{l} Inventory \\ Total Cost \end{tabular} & \begin{tabular}{l} Weighted \\ Average \\ Cost \end{tabular} \\ \hline 2 & & & & & & & & & & 150 & & & $18,000.00 & $$120.0 \\ \hline 3 & 1-Oct & Purchase & & 100 & $ & 125.00 & & & & & & & & \\ \hline 4 & 1-Oct & Sale & & 60 & & & & & & & & & & \\ \hline 5 & 3.0ct & Putchase & & 50 & $ & 126.00 & & & & & & & & \\ \hline 6 & 4.OCt & Purchase & & 60 & s & 131.00 & & & & & & & & \\ \hline 7 & 4.0ct & Sale & & 50 & & & & & & & & & & \\ \hline 8 & 4-Oct & Purchase & & 60 & $ & 133.00 & & & & & & & & \\ \hline 9 & 7.0ct & Sale & & 120 & & & & & & & & & & \\ \hline 10 & 7-Oct & Purchase & & 80 & $ & 133.00 & & & & & & & & \\ \hline 11 & 8.0ct & Purchase & & 20 & S & 133.00 & & & & & & & & \\ \hline 12 & 8.0ct & Sale & & 30 & & & & & & & & & & \\ \hline 13 & 80ct & Purchase & & 40 & $ & 134.00 & & & & & & & & \\ \hline 14 & 90ct & Sale & & 20 & & & & & & & & & & \\ \hline 15 & 90ct & Purchase & & 50 & 5 & 136.00 & & & & & & & & \\ \hline 16 & 90ct & Sale & & 10 & & & & & & & & & & \\ \hline 17 & 9.0ct & Sale & & 20 & & & & & & & & & & \\ \hline 18 & 100kt & Purchase & & 50 & $ & 136.00 & & & & & & & & \\ \hline 19 & 10Oct & Purchase & & 20 & $ & 138.00 & & & & & & & & \\ \hline 20 & 11.0ct & Sale & & 40 & & & & & & & & & & \\ \hline 21 & 11. Oct & Sale & & 30 & & & & & & & & & & \\ \hline 22. & 14.0ct & t. Purchase & & 40 & $ & 145.00 & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline A & B & C & & D & E & F \\ \hline 14-Oct S & Sale & 10 & & & & \\ \hline 150ct & Sale & 30 & & & & \\ \hline 15 -Oct & Sale & 10 & & & & \\ \hline 16-Oct & Purchase & 80 & $ & 145.00 & & \\ \hline 17-Oct & Sale & 50 & & & & \\ \hline 17-Oct & Sale & 10 & & & & \\ \hline 18-Oct & Sale & 50 & & & & \\ \hline 18-Oct & Sale & 30 & & & & \\ \hline 21-Oct & Sale & 30 & & & & \\ \hline 21-Oct & Purchase & 100 & $ & 145.00 & & \\ \hline 22-Oct & Sale & 70 & & & & \\ \hline 23-Oct & Purchase & 10 & $ & 143.00 & & \\ \hline 24-Oct & Sale & 100 & & & & \\ \hline 25-Oct & Sale & 30 & & & & \\ \hline 250ct & Sale & 20 & & & & \\ \hline 28-Oct & Purchase & 70 & $ & 145.00 & & \\ \hline 28-Oct & Purchase & 30 & $ & 148.00 & & \\ \hline 29.0ct & Sale & 130 & & & & \\ \hline 30-Oct & Purchase & 20 & $ & 148.00 & & \\ \hline 300ct & Sale & 70 & & & & \\ \hline 31 - Oct & Purchase & 50 & $ & 151.00 & & \\ \hline 31. Oct & Purchase & 20 & $ & 153.00 & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} anent D trimetor? nestien 2. Explain how conditional logic is used in this spreadsheet and how it might be done differently. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & & & D & E & F & 6 & H & 1 & 1 & K & L \\ \hline 1 & Date & \begin{tabular}{l} Purchase \\ /Sale \end{tabular} & Units & & \begin{tabular}{l} Pur \\ Uni \end{tabular} & \begin{tabular}{l} rchase \\ t Cost \end{tabular} & \begin{tabular}{l} Sign \\ (purchase = \\ +1 , sale = - \\ 1) \end{tabular} & \begin{tabular}{l} Sign for \\ Cost of \\ Purchase \\ (purchase = \\ 1 , sale =0 ) \end{tabular} & \begin{tabular}{l} Sign for \\ Cost of \\ Sales (sale = \\ 1, purchase \\ =0 ) \end{tabular} & \begin{tabular}{l} Units on \\ Hand \end{tabular} & \begin{tabular}{l} Cost of \\ Purchase \end{tabular} & Cost of Sales & \begin{tabular}{l} Inventory \\ Total Cost \end{tabular} & \begin{tabular}{l} Weighted \\ Average \\ Cost \end{tabular} \\ \hline 2 & & & & & & & & & & 150 & & & $18,000.00 & $$120.0 \\ \hline 3 & 1-Oct & Purchase & & 100 & $ & 125.00 & & & & & & & & \\ \hline 4 & 1-Oct & Sale & & 60 & & & & & & & & & & \\ \hline 5 & 3.0ct & Putchase & & 50 & $ & 126.00 & & & & & & & & \\ \hline 6 & 4.OCt & Purchase & & 60 & s & 131.00 & & & & & & & & \\ \hline 7 & 4.0ct & Sale & & 50 & & & & & & & & & & \\ \hline 8 & 4-Oct & Purchase & & 60 & $ & 133.00 & & & & & & & & \\ \hline 9 & 7.0ct & Sale & & 120 & & & & & & & & & & \\ \hline 10 & 7-Oct & Purchase & & 80 & $ & 133.00 & & & & & & & & \\ \hline 11 & 8.0ct & Purchase & & 20 & S & 133.00 & & & & & & & & \\ \hline 12 & 8.0ct & Sale & & 30 & & & & & & & & & & \\ \hline 13 & 80ct & Purchase & & 40 & $ & 134.00 & & & & & & & & \\ \hline 14 & 90ct & Sale & & 20 & & & & & & & & & & \\ \hline 15 & 90ct & Purchase & & 50 & 5 & 136.00 & & & & & & & & \\ \hline 16 & 90ct & Sale & & 10 & & & & & & & & & & \\ \hline 17 & 9.0ct & Sale & & 20 & & & & & & & & & & \\ \hline 18 & 100kt & Purchase & & 50 & $ & 136.00 & & & & & & & & \\ \hline 19 & 10Oct & Purchase & & 20 & $ & 138.00 & & & & & & & & \\ \hline 20 & 11.0ct & Sale & & 40 & & & & & & & & & & \\ \hline 21 & 11. Oct & Sale & & 30 & & & & & & & & & & \\ \hline 22. & 14.0ct & t. Purchase & & 40 & $ & 145.00 & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline A & B & C & & D & E & F \\ \hline 14-Oct S & Sale & 10 & & & & \\ \hline 150ct & Sale & 30 & & & & \\ \hline 15 -Oct & Sale & 10 & & & & \\ \hline 16-Oct & Purchase & 80 & $ & 145.00 & & \\ \hline 17-Oct & Sale & 50 & & & & \\ \hline 17-Oct & Sale & 10 & & & & \\ \hline 18-Oct & Sale & 50 & & & & \\ \hline 18-Oct & Sale & 30 & & & & \\ \hline 21-Oct & Sale & 30 & & & & \\ \hline 21-Oct & Purchase & 100 & $ & 145.00 & & \\ \hline 22-Oct & Sale & 70 & & & & \\ \hline 23-Oct & Purchase & 10 & $ & 143.00 & & \\ \hline 24-Oct & Sale & 100 & & & & \\ \hline 25-Oct & Sale & 30 & & & & \\ \hline 250ct & Sale & 20 & & & & \\ \hline 28-Oct & Purchase & 70 & $ & 145.00 & & \\ \hline 28-Oct & Purchase & 30 & $ & 148.00 & & \\ \hline 29.0ct & Sale & 130 & & & & \\ \hline 30-Oct & Purchase & 20 & $ & 148.00 & & \\ \hline 300ct & Sale & 70 & & & & \\ \hline 31 - Oct & Purchase & 50 & $ & 151.00 & & \\ \hline 31. Oct & Purchase & 20 & $ & 153.00 & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular}