1. Describe perpetual system and periodic system [1 point] 2.Describe the Four Methods of Inventory Valuation [1 point] 3. Thetrial balance before adjustment of XYZ Company reports thefollowing balances: Dr. Cr. Accounts receivable $100,000 Allowancefor doubtful accounts $ 2,500 Sales (all on credit) 750,000 Salesreturns and allowances 40,000 Instructions Prepare the entries forestimated bad debts assuming that doubtful accounts are estimatedto be (1) 6% of gross accounts receivable and (2) 1% of net sales.[1 point] 4. During June, the following changes in inventory item29 took place: June 1 Balance 1,400 units @ $24 14 Purchased 900units @ $36 24 Purchased 700 units @ $30 8 Sold 400 units @ $50 10Sold 1,000 units @ $40 29 Sold 500 units @ $44 Perpetualinventories are maintained in units only. Instructions What is thecost of the ending inventory for item 29 under the followingmethods? (Show calculations.) (a) FIFO. [1.5 points] (b) AverageCost. [1.5 points] 5. Calculate the Cost of Goods Sold underperiodic method from the following information: [2 points] Sales58450 Sales Return 395 Purchases 35975 Purchase Discount 3590Beginning Inventory 18780 Gross Margin 25 % on Cost EndingInventory 4721 6. Sales and purchases of company XYZ for the year2010 had been $1,400,000 and $980,000, respectively. The beginninginventory (Jan. 1, 2010) was $170,000; XYZ's gross profit is 40% ofselling price. Instructions Compute the cost of ending inventory.[2 points]
1. Describe perpetual system and periodic system [1 point] 2.Describe the Four Methods of Inventory Valuation [1 point] 3. Thetrial balance before adjustment of XYZ Company reports thefollowing balances: Dr. Cr. Accounts receivable $100,000 Allowancefor doubtful accounts $ 2,500 Sales (all on credit) 750,000 Salesreturns and allowances 40,000 Instructions Prepare the entries forestimated bad debts assuming that doubtful accounts are estimatedto be (1) 6% of gross accounts receivable and (2) 1% of net sales.[1 point] 4. During June, the following changes in inventory item29 took place: June 1 Balance 1,400 units @ $24 14 Purchased 900units @ $36 24 Purchased 700 units @ $30 8 Sold 400 units @ $50 10Sold 1,000 units @ $40 29 Sold 500 units @ $44 Perpetualinventories are maintained in units only. Instructions What is thecost of the ending inventory for item 29 under the followingmethods? (Show calculations.) (a) FIFO. [1.5 points] (b) AverageCost. [1.5 points] 5. Calculate the Cost of Goods Sold underperiodic method from the following information: [2 points] Sales58450 Sales Return 395 Purchases 35975 Purchase Discount 3590Beginning Inventory 18780 Gross Margin 25 % on Cost EndingInventory 4721 6. Sales and purchases of company XYZ for the year2010 had been $1,400,000 and $980,000, respectively. The beginninginventory (Jan. 1, 2010) was $170,000; XYZ's gross profit is 40% ofselling price. Instructions Compute the cost of ending inventory.[2 points]
For unlimited access to Homework Help, a Homework+ subscription is required.
Related questions
Palisade Creek Co. is a merchandising business that uses theperpetual inventory system. The account balances for Palisade CreekCo. as of May 1, 2016 (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 | Salaries Payable | â |
212 | Customers Refunds Payable | 50,000 |
310 | Lynn Tolley, Capital, June 1, 2015 | 685,300 |
311 | Lynn Tolley, Drawing | 135,000 |
312 | Income Summary | â |
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 of damaged merchandise purchased on May 21, receivinga credit 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. |
Required: | |||||||||||||||||||
1. | Download the spreadsheet in the Ledger panel and save the Excelfile to your computer. Use the spreadsheet to post the Maytransactions from the journal to a ledger of four-column accounts.Be sure to save your work in Excel as it will be used to completethe following steps in Part 1 of this problem as well as steps inPart 2 of this problem. Your input into the spreadsheet will not beincluded in your grade in CengageNOW on this problem.
| ||||||||||||||||||
2. | Post the journal to the general ledger, extending the month-endbalances to the appropriate balance columns after all posting iscompleted. In this problem, you are not required to update or postto the accounts receivable and accounts payable subsidiary ledgers.Add the appropriate posting reference to the journal. | ||||||||||||||||||
3. | Prepare an unadjusted trial balance. Accounts with zerobalances can be left blank. | ||||||||||||||||||
4. | At the end of May, the following adjustment data wereassembled. Analyze and use these data to complete (5) and (6).
| ||||||||||||||||||
5. | (Optional) On your own paper or spreadsheet, enter theunadjusted trial balance on a 10-column end-of-period spreadsheet(work sheet), and complete the spreadsheet. Find a blankend-of-period work sheet in the Excel spreadsheet you previouslydownloaded. | ||||||||||||||||||
6. |
| ||||||||||||||||||
7. | Prepare an adjusted trial balance. Accounts with zero balancescan be left blank.
|
Billâs Lawn Care Mini Practice Part 4
In June, Bill commented to you that he could never figure outhis bank statement, âit never matches the
balance in my accounting recordsâ he tells you. So you explainthat a bank reconciliation is a tool used
to balance the bank statement to the accounting books. He givesyou his bank statement for June, 2014
(shown below). The general ledger shows a balance for theaccount cash of $14,319.00 on June 30,
2014 (detail transactions below). Billâs business only has onechecking account and no other cash
accounts.
Bill has begun to have problems collecting some of his creditaccounts and is considering writing off a
couple of customer account balances. He asks you how these baddebts should be recorded and has
asked you to begin recording bad debt using the allowance methodfor June, 2014. Selected account
balances at the end of June, 2014 are:
Sales $7,200
Sales on Credit $2,900
Accounts Receivable $3,200
As a result of increased focus on collecting accountsreceivable, Bill has decided to extend credit for one
customer, Alan Jones, who owes Billâs Lawn Care $500. Bill andAlan have agreed to a 90-day 6% note
for $500 issued on June 5, 2014.
Instructions:
1. Using the bank statement and the general ledger, prepare abank reconciliation for Billâs Lawn
Care as of June 30, 2014. Record the necessary journal entriesto adjust the books for the
appropriate reconciling items. Start with Page 6 for the journalentries. Explanations are
optional.
2. Using the information given above, calculate the amount ofbad debt using:
Using the chart of accounts, record the journal entry for baddebt expense for Billâs Lawn Care
using the percentage of sales on credit method.
3. Using the note receivable information above and the chart ofaccounts, record the following
entries in the general journal (continue these entries on Page6):
a. Percentage of Sales on Credit = 1.5%
b. Percentage of Accounts Receivable = 1%
a. Receipt of the note in payment of the accounts receivablebalance.
b. Adjusting entry at the end of June, 2014 for the notereceivable. (Round interest
calculations to two decimals)
c. Assume that Alan pays the note and interest in full on thedue date, record the necessary
journal entry. Assume that interest has been accrued at the endof each month.
d. Assume that Alan defaults on the note and interest on the duedate, record the necessary
journal entry. Assume that interest has been accrued at the endof each month.
CHECKING ACCOUNT DETAIL:
DATE | TRANSACTION TYPE & NUMBER | AMOUNT | BALANCE |
BEGINNING BALANCE | $12,850.00 | ||
6/2/2014 | CHECK #1570 | 226.00 | 12,624.00 |
6/5/2014 | CHECK #1571 | 83.00 | 12,541.00 |
6/6/2014 | EFT #43 | 127.00 | 12,414.00 |
6/10/2014 | DEPOSIT #104 | 1,550.00 | 13,964.00 |
6/15/2014 | CHECK #1572 | 145.00 | 13,819.00 |
6/15/2014 | CHECK #1573 | 185.00 | 13,634.00 |
6/20/2014 | DEPOSIT #105 | 885.00 | 14,519.00 |
6/24/2014 | EFT #44 | 143.00 | 14,376.00 |
6/28/2014 | CHECK #1574 | 87.00 | 14,289.00 |
6/28/2014 | CHECK #1575 | 95.00 | 14,194.00 |
6/30/2014 | DEPOSIT #106 | 425.00 | 14,619.00 |
6/30/2014 | CHECK #1576 | 155.00 | 14,464.00 |
6/30/2014 | CHECK #1577 | 145.00 | $14,319.00 |
BANK STATEMENT:
FIRST NATIONAL BANK | ||
ACCOUNT SUMMARY JUNE 30, 2014 | ||
BEGINNING BALANCE | $12,850.00 | |
PAYMENTS | $1,021.00 | |
DEPOSITS | 2,440.00 | |
FEES | 20.00 | |
ENDING BALANCE | $14,249.00 | |
PAYMENTS | ||
DATE | REFERENCE | AMOUNT |
6/5/2014 | 1570 | $266.00 |
6/9/2014 | 1571 | 83.00 |
6/10/2014 | 43 | 127.00 |
6/19/2014 | 1572 | 145.00 |
6/28/2014 | 1573 | 185.00 |
6/28/2014 | NSF | 120.00 |
6/30/2014 | 1575 | 95.00 |
TOTAL PAYMENTS | $1,021.00 | |
DEPOSITS | ||
DATE | REFERENCE | AMOUNT |
6/11/2014 | 104 | $1,550.00 |
6/23/2014 | 105 | 885.00 |
6/30/2014 | INTEREST | 5.00 |
TOTAL DEPOSITS | $2,440.00 | |
FEES | ||
6/30/2014 | SVC CHG | $20.00 |
TOTAL FEES | $20.00 |
Additional Information: Check #1570 waswritten for $266.00, but was recorded incorrectlyin the general ledger. The check was for fuel.
Billâs Lawn Care
Chart of Accounts
Classification | Account Number | Account Name |
ASSETS | 101 | Cash |
110 | Accounts Receivable | |
112 | Allowance for Doubtful Accounts | |
115 | Notes Receivable | |
116 | Interest Receivable | |
120 | Supplies | |
130 | Prepaid Insurance | |
140 | Inventory | |
150 | Equipment | |
155 | Accumulated Depreciation â Equipment | |
LIABILITIES | 201 | Accounts Payable |
220 | Notes Payable | |
225 | Interest Payable | |
OWNERâS EQUITY | 301 | Ownerâs Capital |
305 | Ownerâs Drawings | |
310 | Income Summary | |
REVENUES | 401 | Lawn Service Revenue |
410 | Sales Revenue | |
415 | Sales Returns and Allowances | |
420 | Interest Income | |
COST OF GOODS SOLD | 501 | Purchases |
505 | Purchase Returns and Allowances | |
EXPENSES | 620 | Supplies Expense |
630 | Fuel Expense | |
640 | Repair and Maintenance Expense | |
650 | Advertising Expense | |
660 | Insurance Expense | |
670 | Depreciation Expense | |
680 | Interest Expense | |
690 | Bad Debt Expense | |
695 | Miscellaneous Expense |
Please answer for the following
Bank reconciliation
Cash balanceper bank statement | ||||
Adjusted cashbalance per bank | ||||
Cash balanceper books | ||||
Adjusted cashbalance per books | ||||
General Ledger
GENERALJOURNAL | Page | |||
DATE | DESCRIPTION | POST. REF. | DEBIT | CREDIT |
Bad Debt Calculations
Term ofNote |
TotalInterest on Note |
AccruedInterest June 30, 2014 |
Notes Receivable Calculation
Percentage ofSales on Credit | |||
Percentage ofAccounts Receivable | |||
Expert Answer