I hope this is the last time that I have to post this question because Im not getting enough help.

I NEED HELP FINDING THE EXCEL FORMULAS THAT I HAVE TO USE TO ANSWER THIS QUESTION.

formulas like(=E21*G21 or =G12) these are the kind of answers I need, NOT THE NUMBERS because I already know the number, not the formulas though!!! THANKS.

IF YOU ARE NOT GONNA ANSWER WITH THE CORRECT EXCEL FORMULAS REQUIRED PLEASE DON'T ANSWER MY QUESTION!

I need to write a number in each yellow box but I have to do it in an excel format, for example in order to get the number in the first yellow box I had to use the excel formula =G11, to get the first one in cost of goods sold, I used the formula =E21*G21

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 =A1*B4 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. You must enter a formula to show the purchase, minus the units sold. \begin{tabular}{|l|l|l|l|l|} \hline Ending Inventory - Perpetual LIFO: & UnitsinEndingInventory & @ & Costperunit & InventoryBalance \\ \hline & & & \\ \hline & & & \\ \hline Total Ending Inventory for January -290 units & & & \\ \hline \end{tabular} The M 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