Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have most of requirement a completed but I need help to finish the rest. I have included all the information I have been provided

I have most of requirement a completed but I need help to finish the rest. I have included all the information I have been provided with and am only missing some empty templates for the balance sheet, income statement, etc.

BeachTime Company uses a perpetual inventory system and both an accounts receivable and an accounts payable subsidiary ledger. Balances related to both the general ledger and the subsidiary ledger for the company are indicated in the working papers. Below are a series of transactions for BeachTime Co. for the month of January. Credit sales terms are 2/10, n/30. The cost of all merchandise sold was 57% of the sales price.

Jan.3

Sell merchandise on account to M. Knast $2,900, invoice no. 825, and to C. Ryder $1,800, invoice no. 826.

5

Purchase merchandise from R. Drifter $5,000 and N. Sova $2,200, terms n/30.

7

Receive checks from V. Arnold $4,000 and I. Tan $2,000 after discount period has lapsed.

8

Pay freight on merchandise purchased $235.

9

Send checks to K. Xerxes for balance currently due less 2% cash discount, and to T. Caper for balance currently due less 1% cash discount.

9

Issue credit of $300 to C. Ryder for merchandise returned.

10

Summary daily cash sales total $15,500.

11

Sell merchandise on account to D. Gallagher $1,600, invoice no. 827, and to V. Arnold $900, invoice no. 828.

12

Pay rent of $1,000 for January.

13

Receive payment in full from M. Knast and C. Ryder less cash discounts.

15

Withdrawal of $800 cash by J. Sandy for personal use.

15

Post all entries to the subsidiary ledgers.

16

Purchase merchandise from T. Caper $18,000, terms 1/10, n/30; K. Xerxes $14,200, terms 2/10, n/30; and R. Drifter $1,500, terms n/30.

17

Pay $400 cash for office supplies.

18

Return $450 of merchandise to K. Xerxes and receive credit.

20

Summary daily cash sales total $20,100.

21

Issue $15,000 note, maturing in 90 days, to M. Griffen in payment of balance due.

21

Receive payment in full from V. Arnold less cash discount.

22

Sell merchandise on account to M. Knast $2,700, invoice no. 829, and to D. Gallagher $1,300, invoice no. 830.

22

Post all entries to the subsidiary ledgers.

23

Send checks to T. Caper and K. Xerxes in full payment less cash discounts.

25

Sell merchandise on account to I. Tan $3,500, invoice no. 831, and to C. Ryder $6,100, invoice no. 832.

27

Purchase merchandise from T. Caper $14,500, terms 1/10, n/30; N. Sova $1,200, terms n/30; and R. Drifter $3,800, terms n/30.

27

Post all entries to the subsidiary ledgers.

28

Pay $200 cash for office supplies.

31

Summary daily cash sales total $21,300.

31

Pay salaries and wages of $8,100.

Instructions

(a)

Record the January transactions in a sales journal, a single-column purchases journal, a cash receipts journal, a cash payments journal, and a two-column general journal.

(b)

Post the journals to the general ledger.

(c)

Prepare a trial balance at January 31, 2018, in the trial balance columns of the worksheet. Complete the worksheet using the following additional information.

1.

Office supplies at January 31 total $850.

2.

Insurance coverage expires on October 31, 2018.

3.

Annual depreciation on the equipment is $1,500.

4.

Interest of $50 has accrued on the note payable.

(d)

Prepare a multiple-step income statement and an owner's equity statement for January and a classified balance sheet at the end of January.

(e)

Prepare and post adjusting and closing entries.

(f)

Prepare a post-closing trial balance and determine whether the subsidiary ledgers agree with the control accounts in the general ledger.

(g) Calculate the following ratios. Include the written formula in words in addition to your calculations and your final answers:

1. Inventory Turnover

2. Days in Inventory

3. Gross Profit Rate

Prepare a trial balance at January 31, 2018, in the trial balance columns of the worksheet. Complete the worksheet using the following additional information.image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

(a) (Continuecd) Cash Receipts Joumal CR1 Sales Discounts Dr. Accounts Other Account Credited COGS D Inventory Cr Cash Receivable Sales Revenue Accounts Date Cr. Cr (e) (Continued) General Joumal 91 Date Account Titles Ref Debit Credit Closing Entries (b) and (e) General Ledger Cash No. 101 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 35,750 Accounts Receivable No. 112 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 13,000 Notes Receivable No. 115 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 39,000 Invento No. 120 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 8,000 Invento No. 120 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 8,000 Office Supplies No. 125 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 1,000 Prepaid Insurance No. 130 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 2,000 (b) and (e) (Continued) Equipment No. 157 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 6,450 Accumulated Depreciation -Equipment No. 158 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 1,500 Notes Pavable No. 200 Date Explanation Ref Debit Credit Balance Accounts Pavable No. 201 Date Explanation Ref Debit Credit Balance Jan. 1| Balance 35,000 Interest Pavable No.250 Date Explanation Ref Debit Credit Balance J. Sandy, Capital No. 301 Date Explanation Ref. Debit Credit Balance Jan. 1|Balance 68,700 J. Sandy, Drawing No. 306 Date Explanation Ref. Debit Credit Balance (b) and (e) (Continued) Income Summa No. 350 Date Explanation Ref Debit Credit Balance Sales Revenue No. 401 Date Explanation Ref Debit Credit Balance Sale s Retums and Allowances No. 412 Date Explanation Ref Debit Credit Balance Sales Discounts No. 414 Date Explanation Ref Debit Credit Balance Cost of Goods Sold No. 505 Date Explanation Ref Debit Credit Balance Salaries and Wages Expense No. 627 Date Explanation Ref Debit Credit Balance Depreciation Expense Date Explanation Ref. Debit Credit Balance (b) and (e) (Continued) Interest Expense No. 718 Date Explanation Ref Debit Credit Balance nsurance Expense No. 722 Date Explanation Ref Debit Credit Balance Office Supplies Expense No. 728 Date Explanation Ref Debit Credit Balance Rent Expense No. 729 Date Explanation Ref Debit Credit Balance T. Caper Explanation Ref Debit Credit Balance Jan. 1 Balance 11,000 R. Drifter Date Explanation Ref Debit Credit Balance Ratios Calculate the following ratios for the month of January. Include the written formula in words, as well as your calculations and final answers. 1. Inventory Turnover (beginning inventory is $8,000): Inventory Turnover: 2. Days in Inventory: 3. Gross Profit Rate: (a) (Continuecd) Cash Receipts Joumal CR1 Sales Discounts Dr. Accounts Other Account Credited COGS D Inventory Cr Cash Receivable Sales Revenue Accounts Date Cr. Cr (e) (Continued) General Joumal 91 Date Account Titles Ref Debit Credit Closing Entries (b) and (e) General Ledger Cash No. 101 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 35,750 Accounts Receivable No. 112 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 13,000 Notes Receivable No. 115 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 39,000 Invento No. 120 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 8,000 Invento No. 120 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 8,000 Office Supplies No. 125 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 1,000 Prepaid Insurance No. 130 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 2,000 (b) and (e) (Continued) Equipment No. 157 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 6,450 Accumulated Depreciation -Equipment No. 158 Date Explanation Ref Debit Credit Balance Jan. 1 Balance 1,500 Notes Pavable No. 200 Date Explanation Ref Debit Credit Balance Accounts Pavable No. 201 Date Explanation Ref Debit Credit Balance Jan. 1| Balance 35,000 Interest Pavable No.250 Date Explanation Ref Debit Credit Balance J. Sandy, Capital No. 301 Date Explanation Ref. Debit Credit Balance Jan. 1|Balance 68,700 J. Sandy, Drawing No. 306 Date Explanation Ref. Debit Credit Balance (b) and (e) (Continued) Income Summa No. 350 Date Explanation Ref Debit Credit Balance Sales Revenue No. 401 Date Explanation Ref Debit Credit Balance Sale s Retums and Allowances No. 412 Date Explanation Ref Debit Credit Balance Sales Discounts No. 414 Date Explanation Ref Debit Credit Balance Cost of Goods Sold No. 505 Date Explanation Ref Debit Credit Balance Salaries and Wages Expense No. 627 Date Explanation Ref Debit Credit Balance Depreciation Expense Date Explanation Ref. Debit Credit Balance (b) and (e) (Continued) Interest Expense No. 718 Date Explanation Ref Debit Credit Balance nsurance Expense No. 722 Date Explanation Ref Debit Credit Balance Office Supplies Expense No. 728 Date Explanation Ref Debit Credit Balance Rent Expense No. 729 Date Explanation Ref Debit Credit Balance T. Caper Explanation Ref Debit Credit Balance Jan. 1 Balance 11,000 R. Drifter Date Explanation Ref Debit Credit Balance Ratios Calculate the following ratios for the month of January. Include the written formula in words, as well as your calculations and final answers. 1. Inventory Turnover (beginning inventory is $8,000): Inventory Turnover: 2. Days in Inventory: 3. Gross Profit Rate

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting Ch 1-14

Authors: John Wild, Vernon Richardson, Ken Shaw

1st Edition

0073346896, 9780073346892

More Books

Students also viewed these Accounting questions

Question

Produce a nine-step process for conducting a literature review.

Answered: 1 week ago