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,,Cost,Ave. cost,Per. Cost,Per. Bal$],[1,,,15,S,20\mathrm{.}00,,,],[2,9,,,S,25\mathrm{.}00,,,],[8,,5,,,,,,],[12,2,9,,,,,,],[15,25,,,S,26\mathrm{.}00,,,],[20,,13,,,,,,],[24,,2,,,,,,],[28,6,,,$S$,23\mathrm{.}00,,,],[30,$M$,15,,,,,,]]$

SHOW HOW YOU OBTAIN ALL ANSWERS. break down all working out into steps.