Tableau DA $5-2($Algo$)$: Exercise, Periodic: Inventory costing methods LO P$1$

ATV Co$.$ began March with NO INVENTORY and uses a periodic inventory system. It entered into purchases and sales for March as shown in the Tableau Dashboard.

For March of Year $9,$ compute the cost assigned to cost of goods sold and to ending inventory using FIFO.

For March of Year $9,$ compute the cost assigned to cost of goods sold and to ending inventory using LIFO.

For March of Year $9,$ compute the cost assigned to cost of goods sold and to ending inventory using Weighted Average. $($Round average cost per unit to $2$ decimal places.$)$

Important! Be sure to click the correct Year at the top of the dashboard.

MARCH $1$ purchases $270$ Units @ $$50$ each

MARCH $5$ purchases $1080$ Units @ $$55$ each

MARCH $9$ SOLD $1134$ Units @ $$85$ each

MARCH $18$ purchases $324$ Units @ $$60$ each

MARCH $25$ purchases $540$ at $$62$ each

MARCH $29$ SOLD $432$ Units at $$95$ each

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

Required $1$

Required $2$

Required $3$

For March of Year $9,$ compute the cost assigned to cost of goods sold and to ending inventory using FIFO.

Important! Be sure to click the correct Year at the top of the dashboard.

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline Periodic FIFO & $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Cost of Goods Available for Sale$\}$ & $\backslash$multicolumn$\{5\}\{|$c$|\}\{$Cost of Goods Sold$\}$ & $\backslash$multicolumn$\{5\}\{|$c$|\}\{$Ending Inventory$\}\backslash \backslash$

$\backslash$hline Date & $\backslash$# of units & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Cost per unit$\}$ & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Cost of Goods Available for Sale$\}$ & $\backslash$# of units sold & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Cost per unit$\}$ & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Cost of Goods Sold$\}$ & $\backslash$# of units in ending inventory & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Cost per unit$\}$ & $\backslash$multicolumn$\{2\}\{|$r$|\}\{$Ending Inventory$\}\backslash \backslash$

$\backslash$hline March $1$ & $270$ & $\backslash$$ & $50\mathrm{.}00$ & $\backslash$$ & $13,500$ & $270$ & $\backslash$$ & $50\mathrm{.}00$ & $\backslash$$ & $13,500$ & $0$ & & & $\backslash$$ & $0\backslash \backslash$

$\backslash$hline March $5$ & $1,080$ & $\backslash$$ & $55\mathrm{.}00$ & & $59,400$ & $0$ & & & & $0$ & $0$ & & & & $0\backslash \backslash$

$\backslash$hline March $18$ & $324$ & $\backslash$$ & $60\mathrm{.}00$ & & $19,440$ & $1,134$ & $\backslash$$ & $60\mathrm{.}00$ & & $68,040$ & $216$ & $\backslash$$ & $60\mathrm{.}00$ & & $12,960\backslash \backslash$

$\backslash$hline March $25$ & $540$ & $\backslash$$ & $62\mathrm{.}00$ & & $33,480$ & $432$ & $\backslash$$ & $62\mathrm{.}00$ & & $26,784$ & $648$ & $\backslash$$ & $62\mathrm{.}00$ & & $40,176\backslash \backslash$

$\backslash$hline Total & $2,214$ & & & $\backslash$$ & $125,820$ & $1,836$ & & & $\backslash$$ & $108,324$ & $864$ & & & $\backslash$$ & $53,136\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$ Complete this question by entering your answers in the tabs below.

Required $2$

Required $3$

For March of Year $9,$ compute the cost assigned to cost of goods sold and to ending inventory using LIFO.

Important! Be sure to click the correct Year at the top of the dashboard.

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline Periodic LIFO & $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Cost of Goods Available for Sale$\}$ & $\backslash$multicolumn$\{3\}\{|$c$|\}\{$Cost of Goods Sold$\}$ & $\backslash$multicolumn$\{3\}\{|$c$|\}\{$Ending Inventory$\}\backslash \backslash$

$\backslash$hline Date & $\backslash$# of units & & & & ost of oods able for Sale & $\backslash [$

$\backslash$begin$\{$array$\}\{$l$\}$

$\backslash$text $\{\backslash$# of units $\}\backslash \backslash$

$\backslash$text $\{$ sold $\}$

$\backslash$end$\{$array$\}$

$\backslash ]$ & Cost per unit & Cost of Goods Sold & $\backslash$# of units in ending inventory & Cost per unit & Ending Inventory $\backslash \backslash$

$\backslash$hline March $1$ & $270$ & $\backslash$$ & $50\mathrm{.}00$ & & $13,500$ & & & & & & $\backslash \backslash$

$\backslash$hline March $5$ & $1,080$ & $\backslash$$ & $55\mathrm{.}00$ & & $59,400$ & & & & & & $\backslash \backslash$

$\backslash$hline March $18$ & $324$ & $\backslash$$ & $60\mathrm{.}00$ & & $19,440$ & & & & & & $\backslash \backslash$

$\backslash$hline March $25$ & $540$ & $\backslash$$ & $62\mathrm{.}00$ & & $33,480$ & & & & & & $\backslash \backslash$

$\backslash$hline Total & $2,214$ & & & & $125,820$ & $0$ & & & $0$ & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$ Required $1$

Required $2$

Required $3$

For March of Year $9,$ compute the cost assigned to cost of goods sold and to ending inventory using Weighted Average. $($Round a decimal places.$)$

Important! Be sure to click the correct Year at the top of the dashboard.

$\backslash$begin$\{$tabular$\}\{|$l$|$r$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline Weighted Average & $\backslash$multicolumn$\{2\}\{|$c$|\}\{$ Cost of Goods Available for Sale $\}$ & $\backslash$multicolumn$\{3\}\{|$c$|\}\{$ Cost of Goods Sold $\}$ & $\backslash$multicolumn$\{3\}\{|$c$|\}\{$ Ending Inventory $\}\backslash \backslash$

$\backslash$hline Date & $\backslash$# of units & $\backslash$begin$\{$tabular$\}\{$c$\}$

Average $\backslash \backslash$

Cost per $\backslash \backslash$

unit

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$c$\}$

Cost of Goods $\backslash \backslash$

Available for $\backslash \backslash$

Sale

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$c$\}$

$\backslash$# of units $\backslash \backslash$

sold

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$c$\}$

Average $\backslash \backslash$

Cost per $\backslash \backslash$

Unit

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$c$\}$

Cost of $\backslash \backslash$

Goods Sold

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$c$\}$

$\backslash$# of units $\backslash \backslash$

in ending $\backslash \backslash$

inventory

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$c$\}$

Average $\backslash \backslash$

Cost per $\backslash \backslash$

unit

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$c$\}$

Ending $\backslash \backslash$

Inventory

$\backslash$end$\{$tabular$\}\backslash \backslash$

$\backslash$hline March $1$ & $270$ & & & & & & & $\backslash \backslash$

$\backslash$hline March $5$ & $1,080$ & & & & & & $\backslash \backslash$

$\backslash$hline March $18$ & $324$ & & & & & & $\backslash \backslash$

$\backslash$hline March $25$ & $540$ & & & & & & $\backslash \backslash$

$\backslash$hline Total & $2,214$ & & & & $\backslash (\backslash$$ $\backslash )$ & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$