Perpetual FIFO

Perpetual LIFO

Weighted

Average

Specific Id

Compute the cost assigned to ending inventory using FIFO.

$\backslash$table$[[$Perpetual FIFO:$],[$Date$,$Goods Purchased,Cost of Goods Sold,Inventory Balance$],[$# of units,$\backslash$table$[[$Cost$],[$per unit$]],\backslash$table$[[$# of units$],[$sold$]],\backslash$table$[[$Cost$],[$per unit$]],$Cost of Goods Sold,# of units,$\backslash$table$[[$Cost$],[$per unit$],[$$$50\mathrm{.}80]],\backslash$table$[[$Inventory$],[$Balance$]]],[,,,,,,90,$at$,=,$$$4,572\mathrm{.}00],[$March $5,220,$at$,$$$55\mathrm{.}80,,,,,,90,$at$,$$$50\mathrm{.}80,=,$$ $4,572\mathrm{.}00],[,,,,,,,,220,$at$,$$$55\mathrm{.}80,=,12,276\mathrm{.}00],[$Total March $5,,,,,,,,,,,,,$$$16,848\mathrm{.}00],[$March $9,,,,90,$at$,$$$50\mathrm{.}80,=,4,572\mathrm{.}00,0,$at$,$$$50\mathrm{.}80,,],[,,,160,$at$,$$$55\mathrm{.}80,=,8,928\mathrm{.}00,60,$at$,$$$55\mathrm{.}80,=,3,348\mathrm{.}00],[$Total March $9,,,,,,,,,,,,,$$$3,348\mathrm{.}00],[$March $18,80,$at$,$$$60\mathrm{.}80,,,,,,0,$at$,$$$50\mathrm{.}80,,],[,,,,,,,,60,$at$,$$$55\mathrm{.}80,=,3,348\mathrm{.}00],[,,,,,,,,80,$at$,$$$60\mathrm{.}80,=,4,884\mathrm{.}00],[$Total March $18,,,,,,,,,,,,,$$$8,212\mathrm{.}00],[$March $25,140,$at$,$$$62\mathrm{.}80,,,,,,0,$at$,$$$50\mathrm{.}80,,],[,,,,,,,,60,$at$,$$$55\mathrm{.}80,=,3,348\mathrm{.}00],[,,,,,,,,80,$at$,$$$60\mathrm{.}80,=,4,884\mathrm{.}00],[,,,,,,,,140,$at$,$$$62\mathrm{.}80,=,8,792\mathrm{.}00],[$Total March $25,,,,,,,,,,,,,$$$17,004\mathrm{.}00],[$March $29,,,,0,$at$,$$$50\mathrm{.}80,=,0\mathrm{.}00,0,$at$,$$$50\mathrm{.}80,,],[,,,60,$at$,$$$55\mathrm{.}80,=,3,348\mathrm{.}00,60,$at$,$$$55\mathrm{.}80,=,3,348\mathrm{.}00],[,,,60,$at$,$$$60\mathrm{.}80,=,3,648\mathrm{.}00,80,$at$,$$$60\mathrm{.}80,=,4,884\mathrm{.}00],[,,,0,$at$,$$$62\mathrm{.}80,=,0\mathrm{.}00,20,$at$,$$$62\mathrm{.}80,=,1,256\mathrm{.}00],[$Total March $28,,,,,,,,6,996\mathrm{.}00,,,,,$$$9,468\mathrm{.}00],[$Totals$,,,,,,,,$$$,20,486\mathrm{.}00,,,,,$$ $9,468\mathrm{.}00]]$ Compute the cost assigned to ending inventory using LIFO.

$\backslash$table$[[$Perpetual LIFO:$],[$Date$,$Goods Purchased,Cost of Goods Sold,Inventory Balance$],[$# of units,$\backslash$table$[[$Cost$],[$per unit$]],\backslash$table$[[$# of units$],[$sold$]],\backslash$table$[[$Cost$],[$per unit$]],$Cost of Goods Sold,# of units,$\backslash$table$[[$Cost$],[$per unit$],[$$$50\mathrm{.}80]],\backslash$table$[[$Inventory$],[$Balance$]]],[$March $1,,,,,,,90,$at$,=,$$$4,572\mathrm{.}00],[$March $5,220,$at$,$$$55\mathrm{.}80,,,,,,90,$at$,$$$50\mathrm{.}80,=,$$$,4,572\mathrm{.}00],[,,,,,,,,220,$at$,$$$55\mathrm{.}80,=,12,276\mathrm{.}00],[$Total March $5,,,,,,,,,,,,,$$ $16,848\mathrm{.}00],[$March $9,,,,,$at$,$$$50\mathrm{.}80,=,0\mathrm{.}00,0,$at$,$$$50\mathrm{.}80,=,],[,,,220,$at$,$$$55\mathrm{.}80,=,12,276\mathrm{.}00,130,$at$,$$$55\mathrm{.}80,=,$S $7,254\mathrm{.}00],[$Total March $9,,,,,,,,$$$12,276\mathrm{.}00,,,,,$$$,7,254\mathrm{.}00],[$March $18,80,$at$,$$$60\mathrm{.}80,,,,,,,$at$,$$$50\mathrm{.}80,,],[,,,,,,,,,$at$,$$$55\mathrm{.}80,,],[,,,,,,,,,$at$,$$$60\mathrm{.}80,,],[$Total March $18],[$March $25,140,$at$,$$$82\mathrm{.}80,,,,,,,$at$,$$$50\mathrm{.}80,,],[,,,,,,,,,$at$,$$$55\mathrm{.}80,,],[,,,,,,,,,$at$,$$$60\mathrm{.}80,,],[,,,,,,,,,$at$,$$$62\mathrm{.}80,,],[$Total March $25],[,,,,,,,,,,,,,],[$March $29],[],[$Total March $29],[],[$Totals$,,,,,,,,$$$,12,276\mathrm{.}00,,,,,]]$ Perpetual FIFO

Perpetual LIFO

Weighted

Average

Specific Id

Compute the cost assigned to ending inventory using weighted average.

Note: Round your average cost per unit to $2$ decimal places.

$\backslash$table$[[$Weighted Average Perpetual:$],[$March $1,$Goods Purchased,Cost of Goods Sold,Inventory Balance$],[$# of units,$\backslash$table$[[$Cost$],[$per unit$]],\backslash$table$[[$# of units$],[$sold$]],$Cost per unit,Cost of Goods Sold,# of units,$\backslash$table$[[$Cost per$],[$unit$]],$Inventory Balance$],[,,90,$at$,$$$,50\mathrm{.}80,=,\backslash$table$[[,4,572\mathrm{.}00]]],[$March $5],[$march $5,,,,,,,,,,,],[$Average March $5],[$March $9],[$March $18],[],[$Average March $18],[$March $25],[],[$Average March $25],[$March $29],[$Totals$,,,,,0\mathrm{.}00,,,$