Question

In: Accounting

The following information is available regarding Western Regional Supply Company: The company's December 2019 records showed...

The following information is available regarding Western Regional Supply Company:

The company's December 2019 records showed the following:

Cash Receipts Journal

Cash Disbursements Journal

Date

$

Date

Cheque #

$

December 1

                     9

                   12

                   21

                   23

                   30

              TOTAL

5,000

8,300

7,200

10,900

2,700

3,200

$ 37,300

December 2

                      6

                    10

                    15

                    17

                    23

                    31

47

48

49

50

51

52

53

TOTAL

     630

10,900

5,225

     325

     480

     840

     550

$18,950

GENERAL LEDGER

CASH

DATE

DESCRIPTION

PR

DR

CR

BALANCE

Nov.   30

Dec.       31

            31

Bal. Forward

CR

CD

37,300

18,950

$ 6,100

   43,400

$ 24,450

The company's December 2019 bank statement showed the following:

                                                                              Canada East Bank

Bank Statement

For: Western Regional Supply Company           Month Ended: December 31, 2019

DATE                                         CHEQUES                                             DEPOSITS BALANCE

                                                                $                                                             #                                                                $                                                                            

Nov. 30                Balance Forward                                                                                                      $6,350.00

              3                                                                                                        5,000

              4                     #47                       630

              5

              9                                                                                                        8,300

              12                   #48                  10,900

              15                                                                                                      7,200

              16                   #50                       325

              20                   #51                       480

              21                                                                                                    10,900

              22                 #102                       275

              25                 NSF                       200                                                 2,700

              28                   #52                       840                                                          

              31                   S/C                       100                                              Int   50   $26,750.00

Legend: Int - Interest earned; S/C - service charges

Additional Information:

The bank incorrectly charged our account with the December 22 cheque #102. It was not a cheque Western Regional Supply had written.

The only reconciling item appearing on the Western Regional Supply Company’s bank reconciliation as at November 30, 2019 was an outstanding cheque #21 in the amount of $250.

The NSF cheque was regarding our customer, Mike Brown.

Solutions

Expert Solution

Western Regional Supply Company
Bank Reconciliation
Dec-31
Bank Statement Balance      26,750 Book Balance      24,450
Add: Add:
Deposit in Transit         3,200
Error by bank in check #102            275 Interest Received               50
Deduct: Deduct:
Outstanding Checks(#21)            250
Outstanding Checks(#49)         5,225 NSF Check            200
Outstanding Checks(#52)            550 Bank Service Charge            100
Adjusted Bank Balance      24,200 Adjusted Book Balance      24,200
Journal Entries
General Journal Debit Credit
1) Cash               50
    Interest Revenue               50
(To record interest revenue)
2) Accounts Receivable            200
     Cash 200
(To record NSF Check)
6) Bank Service Charges            100
     Cash            100
(To record bank charges)

Related Solutions

The following information is available for the OLIVIA Company for the month of December 2019 1....
The following information is available for the OLIVIA Company for the month of December 2019 1. On December 31, 2019 the balance in the company's Cash account has a balance of $16,297 . 2. The company's bank statement shows a balance December 31, 2019 of $19,522 . 3. Outstanding checks at December 31, 2019 total $ 2,877 . 4. A deposit placed in the bank's night depository on December 31, 2019 totaling $ 1,676 did not appear on the bank...
Alta Ski Company's inventory records contained the following information regarding its latest ski model. The company...
Alta Ski Company's inventory records contained the following information regarding its latest ski model. The company uses a periodic inventory system. Beginning inventory, January 1, 2021 650 units @ $75 each Purchases: January 15 1,400 units @ $90 each January 21 1,200 units @ $95 each Sales: January 5 600 units @ $115 each January 22 1,000 units @ $125 each January 29 450 units @ $130 each Ending inventory, January 31, 2021 1,200 units Required: 1a. Which method, FIFO...
Alta Ski Company's inventory records contained the following information regarding its latest ski model. The company...
Alta Ski Company's inventory records contained the following information regarding its latest ski model. The company uses a periodic inventory system. Beginning inventory, January 1, 2021 1,350 units @ $100 each Purchases: January 15 2,800 units @ $115 each January 21 2,600 units @ $120 each Sales: January 5 1,300 units @ $140 each January 22 1,700 units @ $150 each January 29 1,150 units @ $155 each Ending inventory, January 31, 2021 2,600 units Required: 1a. Which method, FIFO...
Alta Ski Company's inventory records contained the following information regarding its latest ski model. The company...
Alta Ski Company's inventory records contained the following information regarding its latest ski model. The company uses a periodic inventory system. Beginning inventory, January 1, 2021 1,300 units @ $95 each Purchases: January 15 2,700 units @ $110 each January 21 2,500 units @ $115 each Sales: January 5 1,250 units @ $135 each January 22 1,650 units @ $145 each January 29 1,100 units @ $150 each Ending inventory, January 31, 2021 2,500 units Required: 1a. Which method, FIFO...
Alta Ski Company's inventory records contained the following information regarding its latest ski model. The company...
Alta Ski Company's inventory records contained the following information regarding its latest ski model. The company uses a periodic inventory system. Beginning inventory, January 1, 2021 850 units @ $95 each Purchases: January 15 1,800 units @ $110 each January 21 1,600 units @ $115 each Sales: January 5 800 units @ $135 each January 22 1,200 units @ $145 each January 29 650 units @ $150 each Ending inventory, January 31, 2021 1,600 units Required: 1a. Which method, FIFO...
Alta Ski Company's inventory records contained the following information regarding its latest ski model. The company...
Alta Ski Company's inventory records contained the following information regarding its latest ski model. The company uses a periodic inventory system. Beginning inventory, January 1, 2018 1,100 units @ $75 each Purchases: January 15 2,300 units @ $90 each January 21 2,100 units @ $95 each Sales: January 5 1,050 units @ $115 each January 22 1,450 units @ $125 each January 29 900 units @ $130 each Ending inventory, January 31, 2018 2,100 units Required: 1a. Which method, FIFO...
The following information is available for the Mercy Hospital: For year ending December 31 2019 December...
The following information is available for the Mercy Hospital: For year ending December 31 2019 December 31, 2018 Revenue Net Patient Revenue $14,500,000.00 $3,165,000.00 Operating Expenses Medical/surgical $1,500,000.00 $1,000,000.00 Wages $1,200,000.00 $ 500,000.00 Purchasing $    350,000.00 $ 120,000.00 Pharmacy $1,650,000.00 $1,250,000.00 Professional Fees $3,400,000.00 $2,650,000.00 Interest $   750,000.00 $ 525,000.00 Revenue in Excess of Expense/(Loss) ?????? ?????? Analyze this statement of operations and write a paragraph on what you perceive to be the strengths and weaknesses of Mercy Hospital. There...
Sharon Lee Company was formed on December 1, 2019. The following information is available from Lee’s...
Sharon Lee Company was formed on December 1, 2019. The following information is available from Lee’s inventory records for Product BAP. Units Unit Cost January 1, 2020 (beginning inventory) 1,440 $ 8 Purchases:    January 5, 2020 2,880 9    January 25, 2020 3,120 10    February 16, 2020 1,920 11    March 26, 2020 1,440 12 A physical inventory on March 31, 2020, shows 3,840 units on hand. (c2) Compute the ending inventory at March 31, 2020, under Weighted-average inventory method. (Round answer...
Sarah Allen Company was formed on December 1, 2019. The following information is available from Allen’s...
Sarah Allen Company was formed on December 1, 2019. The following information is available from Allen’s inventory records for Product BAP. Units Unit Cost January 1, 2020 (beginning inventory) 1,620 $ 8 Purchases:    January 5, 2020 3,240 9    January 25, 2020 3,510 10    February 16, 2020 2,160 11    March 26, 2020 1,620 12 A physical inventory on March 31, 2020, shows 4,320 units on hand. a. Prepare schedule to compute the ending inventory at March 31, 2020, under FIFO inventory...
The following information was available from the January inventory records of Rich Company:
The following information was available from the January inventory records of Rich Company:                                                        Units      Unit Cost   Total Cost Balance at January 1                     800         $10.00          $8,000       Purchases:             January 6                            600         11.00             6,600             January 26                          800         12.00 9,600 Rich maintains a perpetual inventory system and costs inventory using last-in, first-out (LIFO). Sales included: 900 units on Jan 7, and 600 units on Jan 31. All units sold for $20 each. Operating expenses were $500 for the month of January. Assume a 40%...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT