PERPEIUAL INVENTORY SYSITM $-30$ Points

Calculations must be clearly shown to justify the answers

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 October $2020[50$ Points$]$

USING FIFO

Perpetual Inventory

Card

Item: Vodka

$\backslash$table$[[$Date$,$Purchased,Issued$/$Sold$,$Balance,$\backslash$table$[[$Unit$],[$Cost$]],$Ave. cost,Per. Cost,Per. Bal$],[1,,,3,$$$18\mathrm{.}00,,,],[2,6,,,$$$22\mathrm{.}00,,,],[8,,5,,,,,],[12,,2,,,,,],[15,15,,,,,,],[20,,10,,,,,],[24,,4,,,,,],[28,5,,,$$$25\mathrm{.}00,,,],[30,,7,,,,,]]$

$6$

$4$

$9$

$9$

$30$