$(30$ points$)$ Tur$-$Key Company maintains a large and varied inventory of merchandise for resale. They use a periodic inventory system for all items. The following information is for their XJr$-4622$ item:

June $1$ beginning inventory

June $5$ purchase

$\backslash$table$[[2,750$ units,$$15/$unit$],[3,200$ units,$$17/$unit$],[1,800$ units,$$\frac{20}{?}$ unit$],[900$ units,$$\frac{22}{?}$ unit$]]$

June $20$ purchase

June $30$ purchase

The data above is entered in tab $"$P $2"$ of the spreadsheet. Required:

a$.$ Calculate the Cost of Goods Available for Sale for April.

b$.$ Calculate the Cost of Goods Sold for April using EIFO, $6,000$ units were sold.

c$.$ Calculate the Cost of Goods Sold for April using LIFO. $6,000$ units were sold.

$3.(20$ points$)$ The June $30$ bank statement shows a checking account balance of $$18,411\mathrm{.}00.$ Our book balance on June $30$ was $$16,615\mathrm{.}52.$ Our employee who reconciles the bank statement noted the following reconciling items:

a$.$ After the bank closed on June $30,$ we deposited the day's cash sales, $$1,588\mathrm{.}14.$

b$.$ The bank collected a Note Receivable on our behalf on June $30.$ We had not been notified of the collection before receiving the bank statement. The amount is $$950.$

c$.$ Check $$5259$ in the amount of $$1,352\mathrm{.}71$ was properly prepared for the purchase of Merchandise Inventory. The bank processed it correctly. Unfortunately, we did not record the check in our Cash Disbursements Journal.

d$.$ Outstanding checks on June $30$ totaled $$3,811,33.$

e$.$ The bank deducted a service charge of $$25,$ which we have not yet recorded.

Required:

a$.$ Use the $"$P $3"$ tab in the spreadsheet to prepare a bank reconciliation for June $30.$

b$.$ Prepare the journal entry to update the Cash account based on the reconciliation.