I need an adjusted trial balance for this question. Here are theinstructions, the journal, and the unadjusted trial balance.
Palisade Creek Co. is a merchandising business that uses theperpetual inventory system. The account balances for Palisade CreekCo. as of May 1, 2019 (unless otherwise indicated), are asfollows:
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 followingtransactions were completed:
Record the following transactions on page 20 of the journal.Refer to the Chart of Accounts for exact wording of accounttitles.
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 merchandisesold 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 returnedmerchandise from sale of May 6. The invoice amount of the returnedmerchandise was $13,500, and the cost of the returned merchandisewas $8,000. |
Record the following transactions on page 21 of the journal.Refer to the Chart of Accounts for exact wording of accounttitles.
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 ofMay 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 acredit memo from the seller for $5,000. |
| 26 | Refunded cash on sales made for cash, $7,500. The cost of themerchandise 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 May21. |
| 31 | Paid for purchase of May 21, less return of May 24 |
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 |
Adjusting Entries |
May 31 | | | |
a. | Cost of Merchandise Sold | 13,950 | |
| Merchandise Inventory | | 13,950 |
b. | Insurance Expense | 12,000 | |
| Prepaid Insurance | | 12,000 |
c. | Store Supplies Expense | 9,800 | |
| Store Supplies | | 9,800 |
d. | Depreciation Expense | 14,000 | |
| Accumulated Depreciation: Store Equipment | | 14,000 |
e. | Sales Salaries Expense | 7,000 | |
| Office Salaries Expense | 6,600 | |
| Salaries Payable | | 13,600 |
f. | Estimated Refunds Inventory | 35,000 | |
| Cost of Merchandise Sold | | 35,000 |
g. | Customer Returns and Allowances | 60,000 | |
| Customer Refunds Payable | | 60,000 |
Create an adjusting trail balance.