Please show the excel formulas

and the total units on the bottom cell 210

AD AE V Avg 170 B C E F H J L M N 0 P R Y z AA AB AC 161 162 Part C Inventory Costing -- Perpetual and Periodic 163 164 Assuming the following purchase and sale transactions, and using the four tracking schedules beloy, calculate the cost of the ending inventory and cost of goods sold using both FIFO and Veighted Average under each of the 2 inventory systems. 165 Unit Date Transaction Sales Units Once your tracking schedules are complete, cell-reference your answers from the tables below here: 166 Cost Price 167 Jan. 1 Beginning inventory 180 $60 Perpetual Periodic 168 10 Purchase 700 $62 FIFO FIFO V Avg 169 15 Sale (550) $90 Cost of Goods Sold 19 Purchase 400 $64 Ending Inventory 171 25 Sale (100) $90 172 Ending Inventory 173 Enter answers in date order. Enter answers in date order 175 176 Perpetual - FIFO Periodic - FIFO 177 Purchases Cost of Goods Sold Inventory Balance Cost of Goods Available for Sale 178 Date Units Cost Total Units Cost Total Units Cost Total Date Explanation Units Unit Cost Total Cost 179 Beg Inv 180 Jan.10 181 182 183 15 184 Ending Inventor 185 Date Explanation Units Unit Cost Total Cost 186 19 174 187 188 25 189 190 191 Units Total Cost Cost of Goods Sold Cost of goods available for sale Less: ending inventory Cost of Goods Sold 192 193 194 dor CHECK: COGAS. COGS - Ending Inventory currucarri 200 201 Do not round weighted average unit cost. Use an excel formula to calculate this amount and not a calculator. 202 Periodic - Weighted Average Units Unit Cost Total Cost Perpetual - Weighted Average Purchases Date Units Cost Beg Inv Total Cost of Goods Sold Units Cost Total Inventory Balance Units Cost Tota Cost of Goods Available for Sale Ending Inventory Cost of Goods Sold 203 204 205 206 207 208 209 210 211 212 CHECK Units Unit Cost CHECK COGAS-COGS - Ending Inventory