Exercise $5-5$A $($Algo$)$ Perpetual: Inventory costing LO P$3$ Complete this question by entering your answers in the tabs below.

Weighted

Average

FIFO

Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. Determine the cost assigned to ending inventory and to cost of goods sold using weighted average.

Note: Round cost per unit to $2$ decimal places. $\backslash$table$[[\backslash$table$[[$Date$],[$January $1]],$Goods Purchased,Cost of Goods Sold,Inventory Balance$],[\backslash$table$[[$# of$],[$units$]],\backslash$table$[[$Cost per$],[$unit$]],\backslash$table$[[$# of units$],[$sold$]],\backslash$table$[[$Cost per$],[$unit$]],\backslash$table$[[$Cost of Goods$],[$Sold$]],$# of units,$\backslash$table$[[$Cost per$],[$unit$]],$Inventory Balance$],[,,146,$@$,$$$6\mathrm{.}00,=,$$$,876\mathrm{.}00],[$January $10],[$January $20],[$January $25],[$January $30],[],[$Totals$,,,,,,,,,,,]]$

Assume the perpetual inventory system is used.

Required:

Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification.

Determine the cost assigned to ending inventory and to cost of goods sold using weighted average.

Determine the cost assigned to ending inventory and to cost of goods sold using FIFO.

Determine the cost assigned to ending inventory and to cost of goods sold using LIFO.