Using the FIFO 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. Date. Activity Units Purchase Pice (aer unit) Sale Price \begin{tabular}{|c|c|c|} \hline 1feb & Beginning Inventory & 100 \\ \hline 15. Feb & Purchase & 700 \\ \hline 9-Aor & Sole 1 & 600 \\ \hline 29Mor & Purchase & 500 \\ \hline 10-Jul & Sole 2 & 600 \\ \hline 10-5ep & Putchase & 400 \\ \hline 150t & Salle 3 & 400 \\ \hline S.Mor & Rutchase & 900 \\ \hline 18. Des & Sale 4 & 200 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline & Beginning Inventory & 100 \\ \hline 15. Feb & Purchase & 700 \\ \hline 9Aor & Sole 1 & 600 \\ \hline 29-Mar & Purchase & 500 \\ \hline 10-Jul & Sole 2 & 600 \\ \hline 10-Sep & Puchase & 400 \\ \hline 150t & Salle 3 & 400 \\ \hline S. Nor & Rutchase & 900 \\ \hline 13. Dec & 5ale 4 & 200 \\ \hline \end{tabular} 1. Compute the Cost of Goods Sold and ending imentory (units and value) after Sale 1. Must show each component of the calculation on a separate line. Refer to the Excef examples, ( 1 peints total. For all cakculations, rou must use a formula in the cell to get full credit) Cost of Goods Seld (units) Total coos ather Sale 1 Irwentory Memaining (units) Total Imventory Balance after 5 ale 1 Totols: 2. Compute the Cost of Goods Sold and ending imventory (units and value) after Sale 2. Must thow each component of the calculation on a separate line. Refer to the frcei examples, (3 points total. For al! caltulations, rou must use a formula in the cell to get full eredit? Cost of Goods feld (units) Total cocs after Sale 2 imentary Remainine (units) Total Balance after Sale 2 Tetoh: 3. Compute the Cost of Goods Seld and endine inventory (units and value) after Sale 3. Most thow each component of the cakculation on a separne line. Refer to the txcel examplec. (3) points tital. For alf caltulations, yeu mas use a formula in the cell to get full cendit? Cost of Goods seld (units) Total coos aher sale, Imentory Memainine (unis) Fotal Balance ahter Sale 3 Totah: 4. Compule the Cost of Goods Sold and ending inventory (units and value) after Sale 4. Must thow each compenent of the cakculation en a separate line. Fefer to the Excet examples. (3 points tefal. For al! calculations, reu must use a formula in the cell to get full credit! Cost of Goods Seld (units) Totai coos after Sale 4 Inventory Remuinine (units) Total Balance after Sale 4 Totah: 5. Caloubte the values below 13 coints total. For all calculations, must une a formuls in the cell to get full crodit) Ending inventory units: Ending inventory account balance: Cost of Goods 5old account balance
