PERPETUAL INVENTORY SECTION

$60$ Points

Calculations must be clearly shown to justify the answers

Q#$2.$ By using the average price and the spreadsheet below, track the purchases and sales of absolute vodka for the month of April $[30$ Points$]$

$\backslash$table$[[$Date$,$Purchased,Issued$/$Sold$,$Balance,,nit Cost,Ave. cost,Per. Cost,Per. Bal$],[1,,,15,$$$,20\mathrm{.}00,,,],[2,9,,,$$$,25\mathrm{.}00,,,],[8,,5,,,,,,],[12,,9,,,,,,],[15,25,,,$$$,26\mathrm{.}00,,,],[20,,13,,,,,,],[24,,2,,,,,,],[28,6,,,$$$,23\mathrm{.}00,,,],[30,,15,,,,,,]]$

Q#$2$b By using the "First in First out" $($FIFO$)$method and the spreadsheet below, track the purchases and sales of absolute vodka for the month of April $[30$ Points$]$

$\backslash$table$[[$Date$,$Purchased,Issued$/$Sold$,$Balance,Unit Cost,Ave. cost,Per. Cost,Per. Bal$],[1,,,15,20\mathrm{.}00,,,],[2,9,,,25\mathrm{.}00,,,],[8,,5,,,,,],[12,,9,,,,,],[15,25,,,26\mathrm{.}00,,,],[20,,13,,,,,],[24,,2,,,,,],[28,6,,,$$$,23\mathrm{.}00,,,],[30,,15,,,,,]]$