A B c E F G M Using the UFO method, complete the steps below to calculate the ending inventory units, inventory account balance, and cost of goods sold account balance at the end of the period. formula in the cell to get full arditl. Cost of Goods Sold Total coss after 5 alle 1 Imvenkory Remaining Total lwentory Balance after Sale 1 Terals. formula in the tell to get full gedit]. Cost of Goods Sold Total coGs after sale 2 Total Balance after Sale 2 Torak: a farmula in the cell to get ful crodti, Cost of Goods Sald Total cots after Sale 3 Imventory Remaining Total talance after Sale 3 Totals: formula in the cell to net full aredit). Cest of Goods Sold Total COGS after 5ale 4 Imventory Remaining Tocal Ralanoe after Sale 4 7etals. 5. Cala.late the values beltoe (3 pairts toeal. For all aleulatians, muvt ush a formala in tha eell ta got full aradit) Ending inveritory units: A B c E F G M Using the UFO method, complete the steps below to calculate the ending inventory units, inventory account balance, and cost of goods sold account balance at the end of the period. formula in the cell to get full arditl. Cost of Goods Sold Total coss after 5 alle 1 Imvenkory Remaining Total lwentory Balance after Sale 1 Terals. formula in the tell to get full gedit]. Cost of Goods Sold Total coGs after sale 2 Total Balance after Sale 2 Torak: a farmula in the cell to get ful crodti, Cost of Goods Sald Total cots after Sale 3 Imventory Remaining Total talance after Sale 3 Totals: formula in the cell to net full aredit). Cest of Goods Sold Total COGS after 5ale 4 Imventory Remaining Tocal Ralanoe after Sale 4 7etals. 5. Cala.late the values beltoe (3 pairts toeal. For all aleulatians, muvt ush a formala in tha eell ta got full aradit) Ending inveritory units