(In Excel 2007 format)
Comprehensive Problem 2 (CP2)
Comprehensive Problem 2 (CP2)
Ocean Atlantic Co. is a merchandising business. the account balances for Ocean Atlantic co. as of July 1, 2012 (unless otherwise indicated), are as follows:
110 Cash 63,600
112 Accounts Receivable 153,900
115 Merchandise Inventory 602,400
116 Prepaid Insurance 16,800
117 Store Supplies 11,400
123 Store Equipment 469,500
124 Accumulated Depreciation-Store Equipment 56,700
210 Accounts Payable 96,600
211 Salaries Payable -
310 Capital stock 75,000
311 Retained earnings, Aug 1 2011 480,300
312 Dividends 135,000
313 Income summary
410 Sales 3,221,100
411 Sales Returns and Allowances 92,700
412 Sales Discounts 59,400
510 Cost of Merchandise Sold 1,623,000
520 Sales Salaries Expense 334,800
521 Advertising Expense 81,000
522 Depreciation Expense -
523 Store Supplies Expense -
529 Miscellaneous Selling Expense 12,600
530 Office Salaries Expense 182,100
531 Rent Expense 83,700
532 Insurance Expense -
539 Miscellaneous Administrative Expense 7,800
During July, the last month of the fiscal year, the following transactions were completed:
July 1, Paid rent for July, $4000.
3, Purchased merchandise on account from Lingard Co., Terms 2/10,n/30,FOB shipping point, $25,000.
4, Paid freight on purchase of July 3, $1000.
6, Sold merchandise on account to Holt Co., terms 2/10,n/30, FOB shipping point, $40,000. The cost of the merchandise sold was $24,000.
7, Received $18000 cash from Flat Co. on account, no discount.
10, sold merchandise for cash $90,000. The cost of the merchandise sold was $50,000.
13, Paid for merchandise purchased on July 3, less discount.
14, Received merchandise returned on sale of July 6, $7000. The cost of the merchandise returned was $4500.
15, Paid advertising expense for last half of July, $9000
16, received cash from sale of July 6, less return of July 14 and discount.
19, purchased merchandise for cash, $22000.
19, Paid $23,100 to Corino Co. on account, no discount
Record the following transactions on page 21 of the journal
20, sold merchandise on account to Reedley Co., terms 1/10,n/30, FOB shipping point, $40000. The cost of the merchandise sold was $25000.
21, for the convenience of the customer, paid freight on sale of July 20, $1100.
21, received $17600 cash from Owen co. on account, no discount.
21, purchased merchandise on account from Munson Co., terms 1/10, n/30, FOB Destination, $32000.
24, Returned $5000 of damaged merchandise purchased on July21, receiving credit from the seller.
26, Refunded cash on sales made for cash, $12000. The cost of the merchandise returned was $7200.
28, paid sales salaries of $22800 and office salaries of $15200.
29, purchased store supplies for cash, $2400.
30, Sold merchandise on account to Dix co., terms 2/10, n/30, FOB shipping point, $18,750. The cost of the merchandise sold was $11,250.
30, received cash from sale of July 20, less discount, plus freight paid on July 21.
31, Paid for purchase of July 21, less return of July 24 and discount.
Instructions
1. Enter the balances of each of the accounts in the appropriate balance column of a four-column account. Write Balance in the item section, and place a check mark (?) in the posting reference column. Journalize the transactions for July.
2. Post the journal to the general ledger, extending the month-end balances to the appropriate balance columns after all posting is completed. In this problem, you are no required to update or post to the accounts receivable and accounts payable subsidiary ledgers.
3. Prepare and unadjusted trial balance.
4. At the end of July, the following adjustment data were assembled. Analyze and use these data to complete (5) and (6).
a) Merchandise inventory on July 31 $ 565000
b) Insurance expired during the year $ 13400
c) Store supplies on hand on July 31 $3900
d) Depreciation for the current year $11500
e) Accrued salaries on July 31: Sale salaries $3200 Office salaries $1300 ($4500)
5. Enter the unadjusted trial balance on a 10-column end-of-period spreadsheet (work Sheet), and complete the spreadsheet.
6. Journalize and post the adjusting entries. Record the adjusting entries on page 22 of the journal.
7. Prepare an adjusted trial balance
8. Prepare an income statement, a retained earnings statement, and a balance sheet.
9. Prepare and post the closing entries. Record the closing entries on page 23 of the journal. Indicate closed accounts by inserting a line in both the Balance columns opposite the closing entry. Insert the new balance in the retained earnings account.
10. Prepare a post-closing trial balance.
Tutorial: CP2 - Ocean Atlantic Co.
