Skip to content
Tutorials Center
My learning

Topics

Lesson 35 of 37 ยท Projects and Practice

Practice Set: Inventory, Receivables and Bank Reconciliation

Practice questions on FIFO, LIFO and average cost, NRV write-downs, the allowance for doubtful accounts and a bank reconciliation, each with a runnable solution.

This set covers chapter 7. Work each question on paper, then run the solution. All companies and figures are invented examples.

Questions

Q1 (cost flow). A shop has 50 units at $8, then buys 150 at $9, then 100 at $10. It sells 220 units. Find cost of goods sold and closing inventory under FIFO, LIFO (periodic) and weighted average.

Q2 (NRV). 25 units of an item cost $40 each. They can be sold for $48 each, but $10 per unit must be spent on selling. What write-down is needed?

Q3 (allowance). Receivables are $24,000. The business wants an allowance of 5% of receivables. The allowance account has a debit balance of $150, because a bad debt written off earlier exceeded the allowance. Find the bad debt expense.

Q4 (bank reconciliation). Bank statement balance $2,980; cash book balance $3,150. Outstanding checks $520, deposit in transit $310, bank charges $45 not in the cash book, and a direct debit of $335 not in the cash book. Reconcile.

Solutions

Python Solutions to Q1 and Q2

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Python Solutions to Q3 and Q4

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Answer key

  • Q1: Cost available is $2,750 for 300 units. FIFO COGS 1,950, closing 800. LIFO COGS 2,080, closing 670. Average cost is about $9.17 per unit, so COGS is about 2,016.67 and closing about 733.33.
  • Q2: NRV is $38, so the write-down is 2 ร— 25 = $50.
  • Q3: required allowance 1,200; because the account has a $150 debit balance, the expense is 1,200 + 150 = $1,350.
  • Q4: both sides reconcile to $2,770. The cash book needs entries for the bank charges (45) and the direct debit (335).

Method reminders

Topic Check
Cost flow COGS + closing inventory = cost available (see inventory valuation)
NRV Compare with cost, per item (NRV lesson)
Allowance Expense is the top-up, not the whole allowance (allowance method)
Bank rec Only bank-only items need entries (bank reconciliation)

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. In rising prices, which method gives the highest closing inventory?

    FIFO leaves the newest, highest costs in closing inventory.
  2. 2. The required allowance is $3,000 and the account currently has a credit balance of $1,100. What is the expense?

    3,000 โˆ’ 1,100 = 1,900.
  3. 3. Which item causes a journal entry in a bank reconciliation?

    Bank charges are unknown to the cash book and must be recorded.
  4. 4. Inventory costs $18 per unit, NRV is $15. At what value is each unit carried?

    Lower of cost and NRV: 15.

Summary

  • COGS + closing inventory always equals total cost available.
  • Write down inventory to NRV when NRV is lower than cost.
  • The allowance expense is the required balance minus the existing credit balance.
  • Reconcile both sides of a bank reconciliation to the same figure.

Next: Project: A Full Accounting Cycle