Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a) Prepare the journal entries for the following transactions for the month of February. You will also need to update the inventory in the table
a) Prepare the journal entries for the following transactions for the month of February. You will also need to update the inventory in the table for each purchase and sale, return or allowance, found under the Inventory Valuation tab of this workbook.
b)Enter the opening balances of the accounts from the January 31, 2021 Balance Sheet and post the above journal entries to the accounts.
c) & d)Complete the bank reconciliation report and record/post journal entries
e 10
f
Case: Tees R Us - Solutions Tees R Us, set up as a privately held corporation, operating as a t-shirt retailer, of which 100% of the Common Shares are owned by Tamara Green. You were hired to account for transactions for the month of February 2021, complete month endprocessing, prepare the financial statements and perform a financial ratio analysis as of the end of that month. They use perpetual inventory system and use the weigted average method to determine value for the inventory. Its balance sheet as at January 31, 2021, is presented below. Tees R Us Classified Balance Sheet As at January 31, 2021 Assets Cash $35,600 Accounts Receivable 16,870 Merchandise Inventory 12,500 Prepaid Insurance Total Current Assets Long-Term Assets Equipment 162,000 Accumulated Depreciation -52,000 Total Assets 4,400 69,370 110,000 $179,370 Liabilities Current Liabilities Accounts Payable Unearned Revenue Salaries Payable Current Portion of Bank Loan Total Current Liabilities Non-Current Liabilities Non-Current Portion of Bank Loan Total Liabilities $12,000 $9,000 $5,700 11.160 $37,860 23.840 $61,700 Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity Total Liabilities & Equity 81,000 36,670 117,670 $179,370 Notes Relating to Balances: Als $0 $7,500 $4,500 $12,000 Customers and balances Suppliers and Balances Columbia $3,200 Henley Arrow $6,400 Dickies $4,250 Fabrica Martin $2,100 Total Short $920 $16,870 The bank loan has an annual interest rate of 5% and has monthly principal payment of $930. The inventory figure includes 500 units purchased at $25.00 each. Total Papr Account # 400 405 410 420 430 The Chart of Accounts (Gl no.) is shown below: Account Description Account # ASSETS Cash 101 Petty Cash 105 Accounts Receivable 110 Merchandise Inventory 120 Prepaid Insurance 125 Equipment 140 Accumulated Depreciation 145 LIABILITIES Accounts Payable 200 Interest Payable 205 CPP Payable 220 EI Payable 225 Income Tax Payable 230 Salaries Payable 235 Unearned Revenue 240 Bank Loan 245 SHAREHOLDERS' EQUITY Common Shares 300 Retained Earnings 305 Account Description REVENUE Sales Revenue Sales Discounts Sales Returns and Allowances Interest Revenue Other Income EXPENSES Cost of Goods Sold Employee Benefits Expense Depreciation Expense Insurance Expense Interest Expense Office Supplies Expense Rent Expense Salaries Expense Bank Charges Expense Maintenance Expense Entertainment Expense Shipping Expense Cash Over and Short 500 510 515 520 525 530 535 540 545 550 555 560 565 Transactions for the month of February Feb 1 Feb 1 Instructions: a) Prepare the journal entries for the following transactions for the month of February. You will also need to update the inventory in the table for each purchase and sale, return or allowance, found under the Inventory Valuation tab of this workbook Paid rent for February amounting to $660, Cheque #3354 Tees R Us decided to establish a petty cash fund for the office. A cheque #3355 of $500 was issued and cashed. Purchased merchandise from Henley on account, invoice #425; 1100 units at $28 each. Terms of Feb 5 the purchase were 4/10, net 30, FOB Destination. The seller paid the shipping cost amounting to $55. Note: Update the Inventory Valuation table after each purchase. Sold mechandise on accout to Arrow, 800 units at $75 each with invoice #2341. The invoice terms Feb 7 were 3/10, net 30, FOB Destination. Note: Update the Inventory Valuation table after each sale. some of goods purchased from Henley were defective. Henley agreed to a 5% allowance on the total purchased Feb 9 Note: You will need to update the Inventory Valuation table to reflect the allowance as it reduces the value of the inventory. Paid total liability with a cheque #3356 to Henley for the February 5 purchase less the allowance from Feb. 9. Feb 12 Note: You will need to update the Merchandise Inventory account to reflect any discount for early payment to supplier. The employees are paid bi-weekly. Paid the payroll for the first half of February, cheque #3357. Feb 15 Gross pay is $12,500, CPP is $638, El is $235 and income tax is $2,500. Use the general journal to record this. Feb 15 Record the employer's share of CPP (100%) and El (140%) of what was deducted from employees. Feb 17 Feb 18 Feb 20 Feb 20 Arrow paid invoice #2341 on time and took advantage of the early payment discount. Bought inventory from Fabrica with cheque #3358, 1400 units at $30 per unit. Note: Update Inventory Valuation table to reflect purchase Sold 600 units on account at $90 each with invoice #2342 to Martin. The invoice term 3/10, net 30, FOB shipping point. Note: Update Inventory Valuation table. Received $3,200 from Columbia for a sale on account last month. The remaining balance of the petty cash account was $150. Total expenses incurred using the petty cash fund this month amounting to $345. In this amount, it includes the shipping cost incurred on Feb / in the amount of $55 and the other costs are for the office supplies expense. Prepare the entry to replenish the potty cash fund with Ch#3359 Made monthly bank loan payment of $1,076 which includes $930 principal and $146 interest. Note: You need to debit the non-current portion of the bank loan for the principal payment. The current portion due will remain the same as the due date for the loan is greater than 12 months from balance sheet date. Feb 25 Feb 28 b)Enter the opening balances of the accounts from the January 31, 2021 Balance Sheet and post the above journal entries to the accounts. c) & d)Complete the bank reconciliation report and record/post journal entries. e) Complete the 10-column worksheet (using information for adjustments shown below) The following information needs to be used first to record the adjustments on the worksheet Prepared the payroll for the second half of February to be paid on March 5. Gross pay is $15,000, Feb 28 CPP is $765, El is $282 and income tax is $3,000. The cheque will be prepared later. Feb 28 Record the employer's share of CPP (100%) and El (140%) of what was deducted from employees. Feb 28 For Prepaid Insurance, record the adjustment of $440 for the current month expense. 28 For Unearned Revenue, $2,700 still remains unearned at the end of February. Feb 28 Monthly depreciation on the equipment was $1,500. f) Record the adjustments in the General Journal and then post to the General Ledger accounts. g) Prepare the multistep income statement, calculation of retained earnings, classified balance sheet h)Answer the analysis questions from 'a' to 'i' (found at bottom on Financial Statements tab) Case: Tees R Us - Solutions Tees R Us, set up as a privately held corporation, operating as a t-shirt retailer, of which 100% of the Common Shares are owned by Tamara Green. You were hired to account for transactions for the month of February 2021, complete month endprocessing, prepare the financial statements and perform a financial ratio analysis as of the end of that month. They use perpetual inventory system and use the weigted average method to determine value for the inventory. Its balance sheet as at January 31, 2021, is presented below. Tees R Us Classified Balance Sheet As at January 31, 2021 Assets Cash $35,600 Accounts Receivable 16,870 Merchandise Inventory 12,500 Prepaid Insurance Total Current Assets Long-Term Assets Equipment 162,000 Accumulated Depreciation -52,000 Total Assets 4,400 69,370 110,000 $179,370 Liabilities Current Liabilities Accounts Payable Unearned Revenue Salaries Payable Current Portion of Bank Loan Total Current Liabilities Non-Current Liabilities Non-Current Portion of Bank Loan Total Liabilities $12,000 $9,000 $5,700 11.160 $37,860 23.840 $61,700 Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity Total Liabilities & Equity 81,000 36,670 117,670 $179,370 Notes Relating to Balances: Als $0 $7,500 $4,500 $12,000 Customers and balances Suppliers and Balances Columbia $3,200 Henley Arrow $6,400 Dickies $4,250 Fabrica Martin $2,100 Total Short $920 $16,870 The bank loan has an annual interest rate of 5% and has monthly principal payment of $930. The inventory figure includes 500 units purchased at $25.00 each. Total Papr Account # 400 405 410 420 430 The Chart of Accounts (Gl no.) is shown below: Account Description Account # ASSETS Cash 101 Petty Cash 105 Accounts Receivable 110 Merchandise Inventory 120 Prepaid Insurance 125 Equipment 140 Accumulated Depreciation 145 LIABILITIES Accounts Payable 200 Interest Payable 205 CPP Payable 220 EI Payable 225 Income Tax Payable 230 Salaries Payable 235 Unearned Revenue 240 Bank Loan 245 SHAREHOLDERS' EQUITY Common Shares 300 Retained Earnings 305 Account Description REVENUE Sales Revenue Sales Discounts Sales Returns and Allowances Interest Revenue Other Income EXPENSES Cost of Goods Sold Employee Benefits Expense Depreciation Expense Insurance Expense Interest Expense Office Supplies Expense Rent Expense Salaries Expense Bank Charges Expense Maintenance Expense Entertainment Expense Shipping Expense Cash Over and Short 500 510 515 520 525 530 535 540 545 550 555 560 565 Transactions for the month of February Feb 1 Feb 1 Instructions: a) Prepare the journal entries for the following transactions for the month of February. You will also need to update the inventory in the table for each purchase and sale, return or allowance, found under the Inventory Valuation tab of this workbook Paid rent for February amounting to $660, Cheque #3354 Tees R Us decided to establish a petty cash fund for the office. A cheque #3355 of $500 was issued and cashed. Purchased merchandise from Henley on account, invoice #425; 1100 units at $28 each. Terms of Feb 5 the purchase were 4/10, net 30, FOB Destination. The seller paid the shipping cost amounting to $55. Note: Update the Inventory Valuation table after each purchase. Sold mechandise on accout to Arrow, 800 units at $75 each with invoice #2341. The invoice terms Feb 7 were 3/10, net 30, FOB Destination. Note: Update the Inventory Valuation table after each sale. some of goods purchased from Henley were defective. Henley agreed to a 5% allowance on the total purchased Feb 9 Note: You will need to update the Inventory Valuation table to reflect the allowance as it reduces the value of the inventory. Paid total liability with a cheque #3356 to Henley for the February 5 purchase less the allowance from Feb. 9. Feb 12 Note: You will need to update the Merchandise Inventory account to reflect any discount for early payment to supplier. The employees are paid bi-weekly. Paid the payroll for the first half of February, cheque #3357. Feb 15 Gross pay is $12,500, CPP is $638, El is $235 and income tax is $2,500. Use the general journal to record this. Feb 15 Record the employer's share of CPP (100%) and El (140%) of what was deducted from employees. Feb 17 Feb 18 Feb 20 Feb 20 Arrow paid invoice #2341 on time and took advantage of the early payment discount. Bought inventory from Fabrica with cheque #3358, 1400 units at $30 per unit. Note: Update Inventory Valuation table to reflect purchase Sold 600 units on account at $90 each with invoice #2342 to Martin. The invoice term 3/10, net 30, FOB shipping point. Note: Update Inventory Valuation table. Received $3,200 from Columbia for a sale on account last month. The remaining balance of the petty cash account was $150. Total expenses incurred using the petty cash fund this month amounting to $345. In this amount, it includes the shipping cost incurred on Feb / in the amount of $55 and the other costs are for the office supplies expense. Prepare the entry to replenish the potty cash fund with Ch#3359 Made monthly bank loan payment of $1,076 which includes $930 principal and $146 interest. Note: You need to debit the non-current portion of the bank loan for the principal payment. The current portion due will remain the same as the due date for the loan is greater than 12 months from balance sheet date. Feb 25 Feb 28 b)Enter the opening balances of the accounts from the January 31, 2021 Balance Sheet and post the above journal entries to the accounts. c) & d)Complete the bank reconciliation report and record/post journal entries. e) Complete the 10-column worksheet (using information for adjustments shown below) The following information needs to be used first to record the adjustments on the worksheet Prepared the payroll for the second half of February to be paid on March 5. Gross pay is $15,000, Feb 28 CPP is $765, El is $282 and income tax is $3,000. The cheque will be prepared later. Feb 28 Record the employer's share of CPP (100%) and El (140%) of what was deducted from employees. Feb 28 For Prepaid Insurance, record the adjustment of $440 for the current month expense. 28 For Unearned Revenue, $2,700 still remains unearned at the end of February. Feb 28 Monthly depreciation on the equipment was $1,500. f) Record the adjustments in the General Journal and then post to the General Ledger accounts. g) Prepare the multistep income statement, calculation of retained earnings, classified balance sheet h)Answer the analysis questions from 'a' to 'i' (found at bottom on Financial Statements tab)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started