The following information relates to Bridger Inc.'s inventory transactions during the month of October. \begin{tabular}{|l|r|r|rr|} \hline \multicolumn{1}{|c|}{ Date } & \multicolumn{1}{c|}{ Purchases } & \multicolumn{2}{c|}{ Units } & \multicolumn{2}{c|}{ Cost per unit } \\ \hline 1 October & Beginning Inventory & 1,060 & $ & 11.00 \\ \hline 4 October & & 6,500 & $ & 11.00 \\ \hline 18 October & & 4,890 & $ & 9.90 \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline Units Sold & Selling price per unit \\ \hline 11,440 & 20.50 \\ \hline \end{tabular} Answer the following questions about Bridger Inc.'s inventory transactions during the month in the highlighted cells. Be sure to use cell references in excel to calculate your answers. 1) How many units of inventory are remaining at the end of the month assuming that Bridger uses the FIFO cost flow assumption? 2) How many units of inventory are remaining at the end of the month assuming that Bridger uses the LIFO cost flow assumption? 3) What is the dollar value of the ending inventory under the FIFO assumption? 4) What is the cost of goods sold for the month under the FIFO assumption? 5) What is the dollar value of the ending inventory under the LIFO assumption? 6) What is the cost of goods sold for the month under the LIFO assumption