FIFO & LIFO, I am having issues. It may just be the format of this. But I can not figure out where to begin. I know FIFO is first in first out.

M x Integrated Excel Tool * *Course Hero X + X C & https://ezto.mheducation.com/ext/common/excelonline/excel-tool.html?Q_13252726722834806_ans to . . . O Excel McGraw Hill Excel Question - Saved Search (Alt + Q) File Home Insert Draw Formulas Data Review View Help Editing v Comments Calibri 11 B My Av ... Ev ab General $ v . . . V L16 X V fx V O A B C D E F G H K L M N McGraw Hill X 4 Date Activities Units Acquired at Cost Units sold at Retai Units Cost Total cost Units Selling Total Sales per unit price per unit Check Answers January 01 Beginning inventory 140 $6.0 $840 January 10 Sales 100 $15.00 $1,500 Check My Work January 20 Purchase 60 $5.00 300 anuary 25 Sales 30 $15.00 $1,200 10 January 30 Purchase 180 $4.50 810 Legend 11 Total 380 $1,950 180 $2,700 Graded cell: Leave blank if no answer is 12 needed. 13 Perpetual FIFO Cost of Goods Sold - Jan 10 Cost of Goods Sold - Jan 25 Ending Inventory Units Cost Cost of Units Cost Cost of Units Cost Inventory Scratchpad: Use as a non-graded 14 Units available per unit | goods sold per unit goods sold per unit workspace 15 140 units from beginning inventory $6.0 $6.00 $0.00 $6.00 16 60 units purchased on January 20 $5.00 $5.00 $5.00 17 180 units purchased on January 30 $4.50 $4.50 $4.50 18 Totals o $0.00 o $0.00 o $0.00 19 20 21 22 tadditions salus thing mornation a & Specific Identification Weighted Average & FIFO & LIFO + Save and Return to Assignment Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% + Sunny Q Search 7:17 PM 6/23/2023M x Integrated Excel Tool X *Homework Help - Q&A from Onl x + X C & https://ezto.mheducation.com/ext/common/excelonline/excel-tool.html?Q_13252726722834806_ans to . . . Excel McGraw Hill Excel Question - Saved Search (Alt + Q) File Home Insert Draw Formulas Data Review View Help Editing v Comments Calibri 11 B Av ... Ev ab Ev General $ -20 . . . A1 X v fx Accessibility tab summary: A statement for student presentation is provided in row 2. A data table is provided in rows A4 to H11. A statement for student presentation is provided in row 12. A table for O A B C D E F G H K M N McGraw Hill X Date Activities Units Acquired at Cost Units sold at Retail Units Cost Total cost Units Selling Total Sales per unit price per unit Check Answers January 01 Beginning inventory 140 $6.0 840 January 10 Sales 100 $15 $1,500 Check My Work January 20 Purchase 60 $5.00 300 January 25 Sales 80 $15 $1,200 10 January 30 Purchase 180 $4.50 810 Legend 11 Total 380 $1,950 180 $2,700 Graded cell: Leave blank if no answer is 12 needed. 13 Perpetual LIFO Cost of Goods Sold - Jan 10 Cost of Goods Sold - Jan 25 Ending Inventory Units Cost Cost of Unit Cost Cost of Units Cost Inventory Scratchpad: Use as a non-graded 14 Units available per unit | goods sold per unit goods sold per unit workspace 15 140 units from beginning inventory $6.0 $6.00 $6.00 16 60 units purchased on January 20 $5.00 $5.00 $5.00 17 180 units purchased on January 30 $4.50 $4.50 $4.50 18 Totals o 50.0 0 $0.00 0 ;0.00 19 20 21 22 too thin mornation a & Specific Identification Weighted Average FIFO & LIFO + Save and Return to Assignment Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% + Q Search 7:18 PM Sunny 6/23/2023