Salt and Mineral $($SAM$)$ began $2024$ with $320$ units of its one product. These units were purchased near the end of $2023$ for $$24$ each. During the month of January, $160$ units were purchased on January $8$ for $$27$ each and another $320$ units were purchased on January $19$ for $$29$ each. Sales of $215$ units and $180$ units were made on January $10$ and January $25,$ respectively. There were $405$ 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 average cost Note: Round cost per unit to $2$ decimal places. Enter inventory reductions from sales as negative numbers.

$\backslash$table$[[\backslash$table$[[$Perpetual Average$],[$Beginning Inventory$]],$Inventory on hand,Cost of Goods Sold$],[\backslash$table$[[\backslash$table$[[$Number of$],[$units$]]],[320]],\backslash$table$[[$Cost per$],[$unit$]],\backslash$table$[[$Inventory$],[$Value$]],\backslash$table$[[$Number of$],[$units sold$]],\backslash$table$[[$Average Cost per$],[$unit$]],\backslash$table$[[$Cost of$],[$Goods Sold$]]],[24\mathrm{.}00,7,680,],[$Purchase $-$ January $8,0,0\mathrm{.}00,0,,,],[$Subtotal Average Cost,$320,,7,680,,,],[$Sale $-$ January $10,,,0,,,],[$Subtotal Average Cost,$320,,7,680,,,],[$Purchase $-$ January $19,,,0,,,],[$Subtotal Average Cost,$320,,7,680,,,],[$Sale $-$ January $25,,,0,,,],[$Total$,320,,7,680,0,,$$