In: Accounting
I need an unadjusted and adjusted trial balance for this problem please and thank you!
Palisade Creek Co. is a merchandising business that uses the perpetual inventory system. The account balances for Palisade Creek Co. as of May 1, 2019 (unless otherwise indicated), are as follows:
| 110 | Cash | $ 83,600 |
| 112 | Accounts Receivable | 233,900 |
| 115 | Merchandise Inventory | 624,400 |
| 116 | Estimated Returns Inventory | 28,000 |
| 117 | Prepaid Insurance | 16,800 |
| 118 | Store Supplies | 11,400 |
| 123 | Store Equipment | 569,500 |
| 124 | Accumulated Depreciation-Store Equipment | 56,700 |
| 210 | Accounts Payable | 96,600 |
| 211 | Customers Refunds Payable | 50,000 |
| 212 | Salaries Payable | — |
| 310 | Lynn Tolley, Capital, June 1, 2018 | 685,300 |
| 311 | Lynn Tolley, Drawing | 135,000 |
| 410 | Sales | 5,069,000 |
| 510 | Cost of Merchandise Sold | 2,823,000 |
| 520 | Sales Salaries Expense | 664,800 |
| 521 | Advertising Expense | 281,000 |
| 522 | Depreciation Expense | — |
| 523 | Store Supplies Expense | — |
| 529 | Miscellaneous Selling Expense | 12,600 |
| 530 | Office Salaries Expense | 382,100 |
| 531 | Rent Expense | 83,700 |
| 532 | Insurance Expense | — |
| 539 | Miscellaneous Administrative Expense | 7,800 |
During May, the last month of the fiscal year, the following transactions were completed:
Record the following transactions on page 20 of the journal. Refer to the Chart of Accounts for exact wording of account titles.
| May | 1 | Paid rent for May, $5,000. |
| 3 | Purchased merchandise on account from Martin Co., terms 2/10, n/30, FOB shipping point, $36,000. | |
| 4 | Paid freight on purchase of May 3, $600. | |
| 6 | Sold merchandise on account to Korman Co., terms 2/10, n/30, FOB shipping point, $68,500. The cost of the merchandise sold was $41,000. | |
| 7 | Received $22,300 cash from Halstad Co. on account. | |
| 10 | Sold merchandise for cash, $54,000. The cost of the merchandise sold was $32,000. | |
| 13 | Paid for merchandise purchased on May 3. | |
| 15 | Paid advertising expense for last half of May, $11,000. | |
| 16 | Received cash from sale of May 6. | |
| 19 | Purchased merchandise for cash, $18,700. | |
| 19 | Paid $33,450 to Buttons Co. on account. | |
| 20 | Paid Korman Co. a cash refund of $13,230 for returned merchandise from sale of May 6. The invoice amount of the returned merchandise was $13,500, and the cost of the returned merchandise was $8,000. |
Record the following transactions on page 21 of the journal. Refer to the Chart of Accounts for exact wording of account titles.
| May | 20 | Sold merchandise on account to Crescent Co., terms 1/10, n/30, FOB shipping point, $110,000. The cost of the merchandise sold was $70,000. |
| 21 | For the convenience of Crescent Co., paid freight on sale of May 20, $2,300. | |
| 21 | Received $42,900 cash from Gee Co. on account. | |
| 21 | Purchased merchandise on account from Osterman Co., terms 1/10, n/30, FOB destination, $88,000. | |
| 24 | Returned damaged merchandise purchased on May 21, receiving a credit memo from the seller for $5,000. | |
| 26 | Refunded cash on sales made for cash, $7,500. The cost of the merchandise returned was $4,800. | |
| 28 | Paid sales salaries of $56,000 and office salaries of $29,000. | |
| 29 | Purchased store supplies for cash, $2,400. | |
| 30 | Sold merchandise on account to Turner Co., terms 2/10, n/30, FOB shipping point, $78,750. The cost of the merchandise sold was $47,000. | |
| 30 | Received cash from sale of May 20 plus freight paid on May 21. | |
| 31 | Paid for purchase of May 21, less return of May 24 |
| Unadjusted Trial Balance | ||
| Cash | 84500 | |
| Accounts Receivable | 245,875 | |
| Merchandise Inventory | 583,950 | |
| Estimated Returns Inventory | 15,200 | |
| Prepaid Insurance | 16,800 | |
| Store Supplies | 13,800 | |
| Store Equipment | 569,500 | |
| Accumulated Depreciation-Store Equipment | 56700 | |
| Accounts Payable | 63150 | |
| Customers Refunds Payable | 29270 | |
| Salaries Payable | ||
| Lynn Tolley, Capital, June 1, 2018 | 685300 | |
| Lynn Tolley, Drawing | 135,000 | |
| Sales | 5376205 | |
| Cost of Merchandise Sold | 3,013,000 | |
| Sales Salaries Expense | 720,800 | |
| Advertising Expense | 292000 | |
| Depreciation Expense | ||
| Store Supplies Expense | ||
| Miscellaneous Selling Expense | 12,600 | |
| Office Salaries Expense | 411,100 | |
| Rent Expense | 88,700 | |
| Insurance Expense | ||
| Miscellaneous Administrative Expense | 7,800 | |
| 6210625 | 6210625 | |
Working
| Date | Accounts | debit | Credit |
| May-01 | Rent expense | 5000 | |
| cash | 5000 | ||
| May-03 | Inventory | 35280 | |
| Accounts Payable-Martin Co. | 35280 | ||
| May-04 | Inventory | 600 | |
| Cash | 600 | ||
| May-06 | Accounts receivable | 67130 | |
| Sales | 67130 | ||
| Cost of goods sold | 41000 | ||
| Inventory | 41000 | ||
| May-07 | Cash | 22300 | |
| Accounts Receivable-Halstad co. | 22300 | ||
| May-10 | Cash | 54000 | |
| sales | 54000 | ||
| Cost of goods sold | 32000 | ||
| inventory | 32000 | ||
| May-13 | Accounts payable-Martin Co. | 35280 | |
| cash | 35280 | ||
| May-15 | Advertising expense | 11000 | |
| cash | 11000 | ||
| May-16 | Cash | 67130 | |
| Accounts receivable-Korman Co. | 67130 | ||
| May-19 | Inventory | 18700 | |
| cash | 18700 | ||
| May-19 | Accounts payable-Buttons Co. | 33450 | |
| cash | 33450 | ||
| May-20 | Customers refunds payable | 13230 | |
| cash | 13230 | ||
| Inventory | 8000 | ||
| Estimated returns inventory | 8000 | ||
| May-20 | Accounts receivable-Crescent Co. | 108900 | |
| sales | 108900 | ||
| Cost of goods sold | 70000 | ||
| inventory | 70000 | ||
| May-21 | Accounts receivable-Crescent Co. | 2300 | |
| cash | 2300 | ||
| May-21 | Cash | 42900 | |
| Accounts receivable-gee Co. | 42900 | ||
| May-21 | inventory | 87120 | |
| accounts payable-Osterman Co. | 87120 | ||
| May-24 | Accounts payable-Osterman Co. | 4950 | |
| inventory | 4950 | ||
| May-26 | Customers refunds payable | 7500 | |
| cash | 7500 | ||
| Inventory | 4800 | ||
| Estimated returns inventory | 4800 | ||
| May-28 | Sales Salaries Expense | 56000 | |
| Office Salaries Expense | 29000 | ||
| cash | 85000 | ||
| May-29 | Store Supplies | 2400 | |
| cash | 2400 | ||
| May-30 | Accounts receivable-Turner Co. | 77175 | |
| sales | 77175 | ||
| Cost of goods sold | 47000 | ||
| inventory | 47000 | ||
| May-30 | Cash | 111200 | |
| Accounts receivable-Crescent Co. | 111200 | ||
| May-31 | Accounts payable-Osterman Co. | 82170 | |
| Cash | 82170 |