please include formulas that are visible to me

H40 fx E 1 F G H FIFO Ending Inventory Total Units Price Cost Unit FIFO Cost of Goods Sold Unit Total Units Price Cost 150 S 15 $ 2,750 120 $ 16 $ 1920 60$ 17 $ 1,020 330 $ 5,190 100 S 100 17 $ 1,700 $ 1,700 Check El +CGS El CGS $ 430 Units 6,890 Total Cost highlighted cells input formula here Input values based on which bucket of units you chose based on B C D 1 Cost of Goods Available For Sale Unit Total Units Price Cost Beginning Inventory 150 s 15 S 2,250 5 First Purchase (cash) 120 S 16 $ 1,920 6 Second Purchase (cash) 160 s 17 s 2,720 7 Total Cost of Goods Available for Sale 430 $ 6,890 8 9 Average Cost $ 16 10 13 12 13 WEIGHTED 14 Income Statements FIFO UFO AVERAGE 15 Sale (330 units @ $30 each) (cash) $ 9,900 16 Cost of Goods Sold 5,190 17 Gross Margin 4710 18 Operating Expenses (cash) 1700 19 Income before Taxes 3010 20 Income Tax Expense (30%) 903 21. Net Income $ 2.107 22 WEIGHTED 23 Statement of Cash Flows FIFO UFO AVERAGE 24 Cash from Operating Activities: 25 Cash received from Customers $ 9,900 26 Cash paid for Inventory Purchased (4,640) 27 Cash paid for Operating Expenses (1,700) 28 Cash paid for Income Taxes (903) 29 Net Cash Flow from Operating Activities 2657 30 Beginning Cash 1000 31 Ending Cash $ 3,657 32 33 34 N R UFO Ending Inventory Unit Total Units Price Cost 0 a UFO Cost of Goods Sold Unit Total Units Cost Weighted Avg Ending Inv Unit Total Units Price Cost w Weighted Averare COGS Unit Total Units Price Cost Price Total ost 2,250 1.920 1,020 5,190 Check Check El +OGS El +CGS 0 Units Total Cost ELOGS El. OGS O Units Total Cost $ $ sed on method