Click on the "FIFO" tab and enter your name in Cell C1. If Cell C1 is left blank, you will not be able to see your score. Each graded cell is highlighted in yellow. Enter formulas for all dollar amounts. The formula must only contain cell addresses. Each correct formula will begin with =,+, or . After completing the FIFO tab, proceed to the LIFO tab. The basic mathematical operators are +,, and / Addition: To add the values in cells A1 and B4, the formula is =A1+B4 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is =A1-B4 Multiplication: To multiply the values in cells A1 and B4, the formula is =A1B4 Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4 Each cell requires a formula, and you will not earn credit for entering a number or text. For example, even if you know that a layer of inventory has been completely used, you can't enter a 0 . You must enter a formula to show the purchase, minus the units sold. The Uber Company reported the following January purchases and sales data for its only product. The company uses a perpetual inventory system. REQUIRED: Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. Each yellow cell must include a formula using cell references, EVEN IF THE FORMULA RESULT IS ZERO. \begin{tabular}{|l|l|l|l|l|l|} \hline Ending Inventory - Perpetual LIFO: & Units in Ending Inventory & \multirow{2}{*}{ Cost per unit } & Inventory Balance \\ \hline \multirow{2}{*}{} & & & \\ \hline \end{tabular}