PERPETUAL INVENTORY

PLEASE SHOW ALL CALCULATIONS AND EXPLANATIONS!!

Question #$2.$ You are given the following transactions to post in the spread sheet showing the balance at the end of the month of August using the FIFO system $[31$ points$]$

$\backslash$table$[[$August$,],[1,$Opening Inventory of $6$ cases of plum juice with a unit system cost of $$20],[5,$Purchase $3$ cases at $$25$ per case$],[9,$Sold $5$ cases$],[12,$Sold $3$ cases$],[15,$Purchase $7$ cases at a cost of $$35$ per case$],[20,$Sold $2$ cases$],[24,$Sold $3$ cases$],[26,$Received $5$ cases at $$15$ each$],[30,$Sold $6$ cases$]]$

$\backslash$table$[[,,$USINC,$\frac{?}{\text{b}\text{a}\text{r}}(GFIFO),,,,],[$Date$,$Received,Issued,Balance,Unit Cost,Ave. cos$,$Per. Cost,Per. Bal$],[,,,,,,,],[,,,,,,,],[,,,,,,,],[,,,,,,,],[,,,,,,,],[,,,,,,,],[,,,,,,,],[,,,,,,,],[,,,,,,,]]$