56 AutoSave OFF ACF 3110 F22 HMWK 5 Chap7A - Clark 0% Home Insert Draw Page Layout Formulas Data Review View Tell me Comments Share G X Arial 14 A A ab Wrap Text AutoSum General Fill Paste B I U A Merge & Center % 900 0 Conditional Format Cell Formatting as Table Styles Insert Delete Format Clear Sort & Filter Find & Select J83 fx A 57 58 59 60 61 C. 62 63 B Sales Price X C D Unit Sales Price = E F G Total Sales CGS H = Gross Profit Cost of Goods Sold, and Ending Inventory, Reconciliation between Beginning & ending costs and Gross Profit using the FIFO METHOD Cost of Goods Sold Total Count to CGS Units from each Lot of Inventory Units Sold to Match Total Unit Sales 64 Dates 65 1-Apr 66 4-Apr 67 8-Apr 68 13-Apr 69 21-Apr 70 29-Apr 71 Total Sales in Unit Count to Match Unit 72 73 74 Total Count Price x units = adding to Price Costs of Goods Sold CGS $ 6.00 $ 6.25 $ 6.45 $ 6.50 $ 6.60 Total Cost of Goods Sold Ending Inventory 75 Units in ending Inventory by Lot Total Units in Ending Inventory Price Price x units = Costs of Goods Sold adding to CGS 76 77 21-Apr 29-Apr 78 Total Sales in Units in Ending Inventory 79 Total Ending Inventory Value 80 81 Sales Price x Unit Sales Price = Total Sales 82 83 84 85 86 Problem #2 87 Reconciliation Total Cost CGS End In CGS = Gross Profit 88 89 90 91 Beginning Inventory Using the following information, complete the 12/31/2023 Income Statement for Michael's and Company in good form Including EPS Administrtation Expenses Note: Everyone has different numbers you will get a Zero if you had in a file with someone elses numbers $ 5,275 1,650 Enter Sheet1 Accessibility: Investigate K M 75% N