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$[[\frac{\text{D}\text{a}\text{t}\text{e}}{1},$Purchased,Issued$/$Sold$,$Balance,Unit Cost,,Per. Cost,Per. Bal$],[\frac{1}{2},,,15,S,20\mathrm{.}00,,,],[\frac{2}{8},9,,,3,25\mathrm{.}00,,,],[12,,5,,,,,],[15,,9,,,,,],[20,25,,,S,26\mathrm{.}00,,,],[24,,13,,,,,],[28,6,2,,,,,],[30,6,,,S,23\mathrm{.}00,,,]]$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 ${?}_{\text{C}\text{o}\text{s}\text{t}},$Ave. cost,Per. Cost,Per. Bal$],[1,,,15,$$$,20\mathrm{.}00,,,],[2,9,,,\backslash$table$[[$$$,25\mathrm{.}00]],,,],[8,,5,,,,,],[12,,9,,,,,],[15,25,,,,,,],[20,,18,,,,,],[24,,2,,,,,],[28,6,,,\backslash$table$[[S,28\mathrm{.}00]],,,],[30,,15,,,,,]]$

SHOW ALL WORKING!