PROBLEM Review Covering Chapters 5-7. (Inventory Costing, Petty Cash, Bad Debts & Notes Rec.) Includes: Journalizing and Adjusting) Rusty Crowe started Crowes Swimwear during the month of June 20X5. He leased a space in the Mid Rivers Mall and paid a part-time assistant to help him in the business. His chart of accounts is as follows:
General Ledger General Ledger Trial Balance.) (check figures: Cash- $45,943.50; Supplies= $1,580; Acets Rec.= $13,250; Sales S43,450; COGS-5,220 Totals=$84,298) Requirement #3: Use the Trial Balance you just printed to help determine the necessary adjusting journal entries required for the following: **Hint: (enter the adjusting journal entries in the general journal and enter reference "adj 1", "adj 2", etc... in the reference field right below the date field). (Click on Tasks Menu - General Journal Entry) Adj 1 ) Make adjustment for the two months of insurance that has expired Adj2) Make adjustment for the two months of rent which has expired Adj3) Supplies on hand at the end of the year is $450. Adj4) Depreciation on the Stage equipment is $100 Adj5 ) Wages owed to the part-time worker are $250. These are due to be paid next week. Adj 6) Based on an aging of Accounts Receivable it was determined that $180 would not be collected and this should be the ending balance in the Allowance account. The company uses the Allowance Method for determining bad debts so you will need to determine the correct ending credit balance Adj 7) Accrue 10 days of interest on the Note Receivable. (Face x Rate x 10/360 days) ACT110 Financial Accounting Sage Problem PROBLEM Review Covering Chapters 5-7. (Inventory Costing, Petty Cash, Bad Debts & Notes Rec.) Includes: Journalizing and Adjusting) Rusty Crowe started Crowe's Swimwear during the month of June 20X5. He leased a space in the Mid Rivers Mall and paid a part-time assistant to help him in the business. His chart of accounts is as follows: Chart of Accounts Revenues: TI 402 Sales 102 Petty Cash 1410 Interest Revenue 104 Accounts Receivable 104.1 Allowance for Doubtful Expenses: **Keep track of your Inventory! On a separate sheet of paper, you will need to keep track of the various 150 g suits that you are hunting and selling...For Accts Ple: 105 Merchandise Inventory SOR Cast of Goods Sold 110 Prepaid Rent Sil Wages Expense Mi Interest Receivable 514 Advertising Expense 112 Prepaid Insurance $16 Rent Expense 125 Note Receivable IS19 Telephone Expense 131 Supplies $20 Supplies Expense 181 Equipment 525 Depreciation Expense 181. 1 Accumulated Depreciation $27 Insurance Expense $30 Utilities Expense Liabilities: 551 Cash Over & Short 202 Accounts Payable Isso Miscellaneous Expense 209 Wages Payable 1553 Bad Debt Expense Black String Red Bathing Bikinis Suits 700 Income Summary Stockholder's Equity: Common Stock 012 Dividends BIS Retained Earnings Required #1: Using Sage accounting software Open Crowe Swimwear After company is open, Click on Maintain" at the top left comer of your screen. Click on Company Information. In the Company Name field, ADD your name at the end of the company name. Enter the following transactions for the first two months of business for Crowe's Swimwear. (Click on Tasks Menu General Journal Entry) Jun 1 Rusty invested $40,000 cash in the company in exchange for 40,000 shares of Si par, common stock. 2 Purchased Store Equipment for $3,000. Paid $1,500 immediately but put the rest on account. 3 Prepaid 6 months rent in advance, S4, 800 4 Created a $100 Petty Cash account. 4 Created a $100 Petty Cash account. 5 Purchased supplies for cash, S1,500 7 Purchased 50 black string bikinis, (model #211) for $5 each. (paid cash) 9 Purchased 100 black string bikinis, (model #211) for $8 each. (paid cash) 10 Purchased 70 red bathing suits, (model #848) for $14 cach. (paid cash) 12 Purchased 30 red bathing suits, (model #848) for $20 each. (paid cash) 13 On the first day that the store was open, it sold 60 black bikinis for $100 each and 40 red bathing suits for $150 each all sales were on store credit. (The store uses the LIFO method to account for cost of goods sold.) 14 Purchased a one year insurance policy for $1,200 15 Purchased 25 green thong bikinis, on account. (model #148) for S10 each. 18 Purchased 50 green thong bikinis, (model #148) for $12 each. (paid cash) 19 Purchased 100 floral halter bathing suits, (model #877) for $20 each. (paid cash) 22 Purchased 60 floral halter bathing suits, (model #877) for $22 each. (paid cash) 24 The company declared and paid a $200 dividend to the sole shareholder. 25 Collected $8500 of the amount owed from customers from the sales made earlier. 27 Paid the telephone bill, $95 28 Reimbursed the Petty Cash account. The fund contained: $6.00 and had the following receipts: Supplies $35.00 and Miscellaneous Expenses S58.00. 29 Paid the part-time worker, $250 30 Received the bank statement from the bank. The bank statement showed that the bank issued a credit memorandum for $33 interest earned and a debit memorandum for the $20 monthly service charge. After entering these two adjusting entries, the cash account shows S 32,224. Merch. Inv=$5,580; COGS S1,220 Hint **Since we are now moving into July transactions, let's change the accounting.period to July. Go to the TASKS menu at top left corner of your screen - System - Change Accounting Period - Choose period 19 (don't print reports) mly 2 Today the store had a swimwear fashion shows and it end 50 Hint **Since we are now moving into July transactions, let's change the accounting.period to July, Go to the TASKS menu at top left corner of your screen System - Change Accounting Period - Choose period 19 (don't print reports) July 2 Today, the store had a swimwear fashion show and it sold 50 black string bikinis for $110 each and 45 red bathing suits for $150 each-all sales were on store credit. (The store uses the LIFO method to account for cost of goods sold.) 3 The day after the fashion show, customers came in and purchased 40 green thong bikinis for $90 each and 120 floral halter bathing suits for S130 eachall sales were on store credit. (The store uses the LIFO method to account for cost of goods sold.) 6 Pamela Anterson, a customer, called and said that she had declared bankruptcy and would not be able to pay for her black string bikini for which she still owed the store. She paid $110 for it earlier and that is what the store had to write off. (The company uses the Allowance Method of accounting for Bad debts...) 10 Paid the electric bill for June, $320. 13 Received payment from customers from sales made in June and from the Fashion Show, S 13,750 14 Received the newspaper advertising bill, $160, it is due in 30 days. 15 Paid the part-time worker, $350 19 Collected $2,100 of the amount owed from customers from the sales made earlier 20 Accepted a $6,000, 9%, 120 day note dated today, in granting a time extension on a past-due account receivable. 21 Paid the advertising bill which was received earlier, $160 24 Paid $1,000 on the amount owed for the store equipment purchased last month. 29 Reimbursed the Petty Cash account. The fund contained: $14.50 and had the following receipts: Supplies $45.00 and Miscellaneous Expenses $38.00. 30 Received the bank statement from the bank. The bank statement showed that the bank issued a credit memorandum for $65 interest earned and a debit memorandum for the $20 monthly service charge. In the statement, the bank had also returned an NSF check from one of our customers for $260. Lastly, Rusty also noticed that the check issued for the store equipment, $1,000, had not yet cleared the bank. After entering the adjustments needed, the cash account shows $ 45,943.50. Requirement #2 Print the Trial Balance 7/31/X5. (Reports Menu General Ledger General Ledger Trial Balance.) (check figures: Cash- $45,943.50; Supplies= $1,580; Acets Rec.= $13,250; Sales S43,450; COGS-5,220 Totals=$84,298) Requirement #3: Use the Trial Balance you just printed to help determine the necessary adjusting journal entries required for the following: **Hint: (enter the adjusting journal entries in the general journal and enter reference "adj 1", "adj 2", etc... in the reference field right below the date field). (Click on Tasks Menu - General Journal Entry) Adj 1 ) Make adjustment for the two months of insurance that has expired Adj2) Make adjustment for the two months of rent which has expired Adj3) Supplies on hand at the end of the year is $450. Adj4) Depreciation on the Stage equipment is $100 Adj5 ) Wages owed to the part-time worker are $250. These are due to be paid next week. Adj 6) Based on an aging of Accounts Receivable it was determined that $180 would not be collected and this should be the ending balance in the Allowance account. The company uses the Allowance Method for determining bad debts so you will need to determine the correct ending credit balance Adj 7) Accrue 10 days of interest on the Note Receivable. (Face x Rate x 10/360 days) ACT110 Financial Accounting Sage Problem PROBLEM Review Covering Chapters 5-7. (Inventory Costing, Petty Cash, Bad Debts & Notes Rec.) Includes: Journalizing and Adjusting) Rusty Crowe started Crowe's Swimwear during the month of June 20X5. He leased a space in the Mid Rivers Mall and paid a part-time assistant to help him in the business. His chart of accounts is as follows: Chart of Accounts Revenues: TI 402 Sales 102 Petty Cash 1410 Interest Revenue 104 Accounts Receivable 104.1 Allowance for Doubtful Expenses: **Keep track of your Inventory! On a separate sheet of paper, you will need to keep track of the various 150 g suits that you are hunting and selling...For Accts Ple: 105 Merchandise Inventory SOR Cast of Goods Sold 110 Prepaid Rent Sil Wages Expense Mi Interest Receivable 514 Advertising Expense 112 Prepaid Insurance $16 Rent Expense 125 Note Receivable IS19 Telephone Expense 131 Supplies $20 Supplies Expense 181 Equipment 525 Depreciation Expense 181. 1 Accumulated Depreciation $27 Insurance Expense $30 Utilities Expense Liabilities: 551 Cash Over & Short 202 Accounts Payable Isso Miscellaneous Expense 209 Wages Payable 1553 Bad Debt Expense Black String Red Bathing Bikinis Suits 700 Income Summary Stockholder's Equity: Common Stock 012 Dividends BIS Retained Earnings Required #1: Using Sage accounting software Open Crowe Swimwear After company is open, Click on Maintain" at the top left comer of your screen. Click on Company Information. In the Company Name field, ADD your name at the end of the company name. Enter the following transactions for the first two months of business for Crowe's Swimwear. (Click on Tasks Menu General Journal Entry) Jun 1 Rusty invested $40,000 cash in the company in exchange for 40,000 shares of Si par, common stock. 2 Purchased Store Equipment for $3,000. Paid $1,500 immediately but put the rest on account. 3 Prepaid 6 months rent in advance, S4, 800 4 Created a $100 Petty Cash account. 4 Created a $100 Petty Cash account. 5 Purchased supplies for cash, S1,500 7 Purchased 50 black string bikinis, (model #211) for $5 each. (paid cash) 9 Purchased 100 black string bikinis, (model #211) for $8 each. (paid cash) 10 Purchased 70 red bathing suits, (model #848) for $14 cach. (paid cash) 12 Purchased 30 red bathing suits, (model #848) for $20 each. (paid cash) 13 On the first day that the store was open, it sold 60 black bikinis for $100 each and 40 red bathing suits for $150 each all sales were on store credit. (The store uses the LIFO method to account for cost of goods sold.) 14 Purchased a one year insurance policy for $1,200 15 Purchased 25 green thong bikinis, on account. (model #148) for S10 each. 18 Purchased 50 green thong bikinis, (model #148) for $12 each. (paid cash) 19 Purchased 100 floral halter bathing suits, (model #877) for $20 each. (paid cash) 22 Purchased 60 floral halter bathing suits, (model #877) for $22 each. (paid cash) 24 The company declared and paid a $200 dividend to the sole shareholder. 25 Collected $8500 of the amount owed from customers from the sales made earlier. 27 Paid the telephone bill, $95 28 Reimbursed the Petty Cash account. The fund contained: $6.00 and had the following receipts: Supplies $35.00 and Miscellaneous Expenses S58.00. 29 Paid the part-time worker, $250 30 Received the bank statement from the bank. The bank statement showed that the bank issued a credit memorandum for $33 interest earned and a debit memorandum for the $20 monthly service charge. After entering these two adjusting entries, the cash account shows S 32,224. Merch. Inv=$5,580; COGS S1,220 Hint **Since we are now moving into July transactions, let's change the accounting.period to July. Go to the TASKS menu at top left corner of your screen - System - Change Accounting Period - Choose period 19 (don't print reports) mly 2 Today the store had a swimwear fashion shows and it end 50 Hint **Since we are now moving into July transactions, let's change the accounting.period to July, Go to the TASKS menu at top left corner of your screen System - Change Accounting Period - Choose period 19 (don't print reports) July 2 Today, the store had a swimwear fashion show and it sold 50 black string bikinis for $110 each and 45 red bathing suits for $150 each-all sales were on store credit. (The store uses the LIFO method to account for cost of goods sold.) 3 The day after the fashion show, customers came in and purchased 40 green thong bikinis for $90 each and 120 floral halter bathing suits for S130 eachall sales were on store credit. (The store uses the LIFO method to account for cost of goods sold.) 6 Pamela Anterson, a customer, called and said that she had declared bankruptcy and would not be able to pay for her black string bikini for which she still owed the store. She paid $110 for it earlier and that is what the store had to write off. (The company uses the Allowance Method of accounting for Bad debts...) 10 Paid the electric bill for June, $320. 13 Received payment from customers from sales made in June and from the Fashion Show, S 13,750 14 Received the newspaper advertising bill, $160, it is due in 30 days. 15 Paid the part-time worker, $350 19 Collected $2,100 of the amount owed from customers from the sales made earlier 20 Accepted a $6,000, 9%, 120 day note dated today, in granting a time extension on a past-due account receivable. 21 Paid the advertising bill which was received earlier, $160 24 Paid $1,000 on the amount owed for the store equipment purchased last month. 29 Reimbursed the Petty Cash account. The fund contained: $14.50 and had the following receipts: Supplies $45.00 and Miscellaneous Expenses $38.00. 30 Received the bank statement from the bank. The bank statement showed that the bank issued a credit memorandum for $65 interest earned and a debit memorandum for the $20 monthly service charge. In the statement, the bank had also returned an NSF check from one of our customers for $260. Lastly, Rusty also noticed that the check issued for the store equipment, $1,000, had not yet cleared the bank. After entering the adjustments needed, the cash account shows $ 45,943.50. Requirement #2 Print the Trial Balance 7/31/X5. (Reports Menu
