Salt and Mineral $($SAM$)$ began $2024$ with $330$ units of its one product. These units were purchased near the end of $2023$ for $$20$ each. During the month of January, $165$ units were purchased on January $8$ for $$23$ each and another $330$ units were purchased on January $10$ for $$25$ each Sales of $170$ units and $200$ units were made on January $10$ and January $25,$ respectively. There were $455$ units on hand at the end of the month. SAM uses a perpetual inventory system.

Required:

Complete the below table to calculate ending inventory and cost of goods sold for January using FIFO.

Complete the below table to calculate ending inventory and cost of goods sold for January using average cost.

Complete this question by entering your answers in the tabs below.

Complete the below table to calculate ending inventory and cost of goods sold for January using FIFO.

$\backslash$table$[[\backslash$table$[[$Perpetual FIFO$],[$Begirning Invenlory$]],$Cost of Goods Available for Sale,Cost of Goods Sold $-$ January $10,$Cost of Goods Sold $-$ January $25,$Inventory Balance$],[\backslash$table$[[$Number of$],[$units$]],\backslash$table$[[$Cost per$],[$unit$]],\backslash$table$[[$Cost of Goods$],[$Available for Sale$]],\backslash$table$[[$Number of$],[$units sold$]],\backslash$table$[[$Cost per$],[$unit$]],\backslash$table$[[$Cost of$],[$Goods$],[$Sold$]],\backslash$table$[[$Number of units$],[$sold$]],\backslash$table$[[$Cost per$],[$unit$]],\backslash$table$[[$Cost of$],[$Goods$],[$Sold$]],\backslash$table$[[$Number of$],[$units in ending$],[$inventory$]],\backslash$table$[[$Cost per$],[$unit$]],\backslash$table$[[$Ending$],[$Inventory$]]],[330,20\mathrm{.}00,6,600,20\mathrm{.}00,0,20\mathrm{.}00,$s$,20\mathrm{.}00,$$$],[$Purchases:$,\sqrt[\phantom{2}]{20},,,,,,,,,,,],[$January $8,\backslash$table$[[165],[-,16$