60.1K

Verified Solution

Link Copied!

Trey Monson starts a merchandising business on December I and enters into the following three inventory purchases. Monson uses a perpetual inventory system. Also, on December $15,$ Monson sells $15$ units for $$32$ each.

Purchases on Decimber $7$

Rurchases on December $14$

Purchases on December $21$

$10$ units $$18,00$ cost

$20$ units e $$24\mathrm{.}00$ cost

$15$ units $9$$$26\mathrm{.}00$ cost

QS $5-13($Algo$)$ Perpetual: Inventory costing with weighted average LO P$1$

Determine the costs assigned to ending inventory when costs are assigned based on the weighted average method: $($Round your per unit costs to $2$ decimal places.$)$

Answer is complete but not entirely correct.

$\backslash$table$[[$Weighted Areroge$-$Peipetinat:$],[\backslash$table$[[$Dste$],[$December $7]],$Goods nurchased,Cost of Goods Sold,Inventory Bslance$],[\backslash$table$[[\backslash$table$[[$I of$],[$units$]]],[100]],$Cost per unit,Inventory Value,$\backslash$table$[[$of$],[$units$],[$sold$]],\backslash$table$[[$Cost$],[$pet$],[$unit$]],\backslash$table$[[$Cost of Goods$],[$Sold$]],$of units,$\backslash$table$[[$Cost per$],[$Unit$]],\backslash$table$[[$Impentory$],[$Balance$]]],[$at$,$$$,18\mathrm{.}000,=,180\mathrm{.}00,,,,100,$at$,5,18000,=,5,1800],[$December $14,200,$at$,5,24\mathrm{.}000,=,5,480\mathrm{.}00,,,,,100,$at$,$$$,16\mathrm{.}00,=,$s$,18000],[,,,,,,,,,,200,$at$,,2400,=,,48000],[\backslash$table$[[$Average cost December$],[14]],,,,,,,,,,,30,$at$,s,26\mathrm{.}000,=,s,660\mathrm{.}00],[$December $15,,,,,,,150,$at$,$$${?}_{2400}0,5360\mathrm{.}00,150,$at$,5,24000,=,s,36000],[$December $21,150,$al$,5,26\mathrm{.}000,=,$$$,390\mathrm{.}00,,,,,150,$al$,5,24\mathrm{.}00,=,5,360\mathrm{.}00],[,,,,,,,,,,150,$at$,5,26,00,=,,350\mathrm{.}00],[\backslash$table$[[$Average cost December$],[21]],,,,,,,,,,,30,$at$,5,28,000,=,s,84000],[$Totals$,,,,,,,,,,5360\mathrm{.}00,,,,,,5,84000]]$

questtioquesttion: cantt figure out the red x$\text{'}$s help.

Answer & Explanation Solved by verified expert

See Answer