$\backslash$table$[[2,$A company provides the following inwentory records.$],[4,$Number of units rold $=,8,500,,,],[5,$Selinf price per unt $=,$$$30\mathrm{.}00,,,],[6,,,,,],[7,$Date,Transaction,Number of Units,Unit Cost,Total Cost$],[8,$January $1,$Beginning Invertory,$1\mathrm{.}200,$$$10\mathrm{.}75,$$$12,300],[9,$March $12,$Purchase,$2\mathrm{.}200,$$$10\mathrm{.}3,$$$22,660],[10,$lune $5,$Purchase,$2\mathrm{.}700,$$$10\mathrm{.}4,578,080],[11,$October $22,$Purchare,$(3)1,900,$$$10\mathrm{.}6,541,40],[12,,$Totals,$19\mathrm{.}000,,$S$104,860],[13,,,,,],[14,$Bequired:,,,,$]]$

Based on the information given above, colculate cost of goods sold and ending imentory whing the firo method.

Caloulute cort of goods sold and ending inventory uning the LIfO method.

Calculabe cont of goods sold and ending imentory using the Weighted Average Method.Aequirement $1$: Cost of Goods Sold and Ending livemtory under FIFO

$[$Use cells A$2$ to E$12$ from the given information above to complete thlis question. To calculate the number of units sold within each batch, use the MiN function.$)$Requirement $2$: Cost of Goods Sold and Ending Irvemtory under $1$ IFO

Use cells A $2$ to $112$ from the given information above to comptebe thls question. To calculabe the number of uniti told within each batch, uie the MiN function$)$

Requirement $3$: Cost of Goods Sold and Ending Inventory under Weighted Average

$($a$)$ Calculate the weighted$-$average unit cost.

$($Uie cells A$2$ to from the given information above to complete thly quertion.$)$

Weighted$-$average unit cost $=$ F$($b$)$ Calculate cost of goods sold and ending imventory using the weighted average method.

$($Use cells A$2$ to E$12$ from the given information above to complete this question. In your formula, use cell $844$ for the weighted$-$average unit cost.$)$

$\backslash$table$[[,,$Units $5$old,,Cont of Goods Sold,,,Ending Inventory$],[$Total:$,,,,,,$F$,]]$

Requirement $4$: Gross Profit

$($Use cells A$2$ to from the given information above to complete this question. All values should be Input and displayed as positive amounts.$)$

$\backslash$table$[[,,$FFO,,$150,\backslash$table$[[$Weighted$-],[$Average$]]],[,$F$,,$F$,,],[$Cost of goods sold,,,$r,,],[$Grows profit,F$,,$T$,,F$